type=’UNKNOWN’ level=’16’ host_id=’-i’ , Oracle Enterprise Manager Express 12c configuration
I am trying to configure Oracle Enterprise Manager Express 12c in sun solaris. When I try to execute below commands to configure.
SQL> exec DBMS_XDB_CONFIG.SETHTTPSPORT(5500);
SQL> exec DBMS_XDB_CONFIG.SETHTTPPORT(5510);
I the listener is not getting configured to listen on this ports and configuration is not working even though I am getting successful message after the commands. When I check the error log of listener I have seen below messages.
<msg time='2018-05-02T00:34:11.819-04:00' org_id='oracle' comp_id='tnslsnr'
type=’UNKNOWN’ level=’16’ host_id=’-i’
host_addr=’UNKNOWN’>
02-MAY-2018 00:34:11 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=root))(SID=******)) * (ADDRESS=(PROTOCOL=tcp)(HOST=**.**.**.**)(PORT=44853)) * establish * M
5O11204 * 12505
<msg time='2018-05-02T00:34:11.820-04:00' org_id='oracle' comp_id='tnslsnr'
type=’UNKNOWN’ level=’16’ host_id=’-i’
host_addr=’UNKNOWN’>
TNS-12505: TNS:listener does not currently know of SID given in connect descriptor
<msg time='2018-05-02T00:34:15.044-04:00' org_id='oracle' comp_id='tnslsnr'
type=’UNKNOWN’ level=’16’ host_id=’-i’
host_addr=’UNKNOWN’>
02-MAY-2018 00:34:15 * service_update * M50Ora121 * 0
<msg time='2018-05-02T00:34:21.044-04:00' org_id='oracle' comp_id='tnslsnr'
type=’UNKNOWN’ level=’16’ host_id=’-i’
host_addr=’UNKNOWN’>
02-MAY-2018 00:34:21 * service_update * M50Ora121 * 0
You can see the host_id is “-i” which is wrong. I have checked the hostname at os level it is showing “-i”.
I changed the hostname using below command
login as root
hostname
login as oracle
restart listener
lsnrctl stop
lsnrctl start
sqlplus / as sysdba
SQL> exec DBMS_XDB_CONFIG.SETHTTPSPORT(5500);
SQL> exec DBMS_XDB_CONFIG.SETHTTPPORT(5510);
Now the Oracle Enterprise Manager Express configured successfully.
SQL> exec DBMS_XDB_CONFIG.SETHTTPSPORT(5500);
SQL> exec DBMS_XDB_CONFIG.SETHTTPPORT(5510);
I the listener is not getting configured to listen on this ports and configuration is not working even though I am getting successful message after the commands. When I check the error log of listener I have seen below messages.
<msg time='2018-05-02T00:34:11.819-04:00' org_id='oracle' comp_id='tnslsnr'
type=’UNKNOWN’ level=’16’ host_id=’-i’
host_addr=’UNKNOWN’>
02-MAY-2018 00:34:11 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=root))(SID=******)) * (ADDRESS=(PROTOCOL=tcp)(HOST=**.**.**.**)(PORT=44853)) * establish * M
5O11204 * 12505
<msg time='2018-05-02T00:34:11.820-04:00' org_id='oracle' comp_id='tnslsnr'
type=’UNKNOWN’ level=’16’ host_id=’-i’
host_addr=’UNKNOWN’>
TNS-12505: TNS:listener does not currently know of SID given in connect descriptor
<msg time='2018-05-02T00:34:15.044-04:00' org_id='oracle' comp_id='tnslsnr'
type=’UNKNOWN’ level=’16’ host_id=’-i’
host_addr=’UNKNOWN’>
02-MAY-2018 00:34:15 * service_update * M50Ora121 * 0
<msg time='2018-05-02T00:34:21.044-04:00' org_id='oracle' comp_id='tnslsnr'
type=’UNKNOWN’ level=’16’ host_id=’-i’
host_addr=’UNKNOWN’>
02-MAY-2018 00:34:21 * service_update * M50Ora121 * 0
You can see the host_id is “-i” which is wrong. I have checked the hostname at os level it is showing “-i”.
I changed the hostname using below command
login as root
hostname
login as oracle
restart listener
lsnrctl stop
lsnrctl start
sqlplus / as sysdba
SQL> exec DBMS_XDB_CONFIG.SETHTTPSPORT(5500);
SQL> exec DBMS_XDB_CONFIG.SETHTTPPORT(5510);
Now the Oracle Enterprise Manager Express configured successfully.
Viswamitra's blog 