While starting listener getting error
ora12c@Server1 admin]$ lsnrctl start LISTENER
LSNRCTL for Linux: Version 12.1.0.2.0 - Production on 03-AUG-2017 11:11:45
Copyright (c) 1991, 2014, Oracle. All rights reserved.
Starting /rdbms/app/12.1.0/grid/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 12.1.0.2.0 - Production
System parameter file is /rdbms/app/12.1.0/grid/network/admin/listener.ora
Log messages written to /rdbms/app/12.1.0/grid_base/diag/tnslsnr/Server1 /listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=Server1 .vsnl.co.in)(PORT=1527)))
TNS-01192: Missing SID_LIST_ value left of equation for SID description in LISTENER.ORA
Listener failed to start. See the error message(s) above...
Solution :
If you look into log.xml file , you get to know below message
<msg time='2017-08-03T11:11:45.885+05:30' org_id='oracle' comp_id='tnslsnr'
type='UNKNOWN' level='16' host_id='Server1 .vsnl.co.in'
host_addr='x.x.x.x'>
<txt>TNS-01192: Missing SID_LIST_ value left of equation for SID description in LISTENER.ORA
</txt>
</msg>
<msg time='2017-08-03T11:11:45.885+05:30' org_id='oracle' comp_id='tnslsnr'
type='UNKNOWN' level='16' host_id='Server1 .vsnl.co.in'
host_addr='x.x.x.x'>
<txt>No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=Server1 .vsnl.co.in)(PORT=1527)))
</txt>
</msg>
set asm profile and edit in listener.ora file.
VALID_NODE_CHECKING_REGISTRATION_LISTENER = SUBNET
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = Server..co.in)(PORT = 1527))
)
)
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER = ON
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER = ON
VALID_NODE_CHECKING_REGISTRATION_LISTENER = SUBNET
ora12c@Server1 admin]$ lsnrctl start LISTENER
LSNRCTL for Linux: Version 12.1.0.2.0 - Production on 03-AUG-2017 11:11:45
Copyright (c) 1991, 2014, Oracle. All rights reserved.
Starting /rdbms/app/12.1.0/grid/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 12.1.0.2.0 - Production
System parameter file is /rdbms/app/12.1.0/grid/network/admin/listener.ora
Log messages written to /rdbms/app/12.1.0/grid_base/diag/tnslsnr/Server1 /listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=Server1 .vsnl.co.in)(PORT=1527)))
TNS-01192: Missing SID_LIST_ value left of equation for SID description in LISTENER.ORA
Listener failed to start. See the error message(s) above...
Solution :
If you look into log.xml file , you get to know below message
<msg time='2017-08-03T11:11:45.885+05:30' org_id='oracle' comp_id='tnslsnr'
type='UNKNOWN' level='16' host_id='Server1 .vsnl.co.in'
host_addr='x.x.x.x'>
<txt>TNS-01192: Missing SID_LIST_ value left of equation for SID description in LISTENER.ORA
</txt>
</msg>
<msg time='2017-08-03T11:11:45.885+05:30' org_id='oracle' comp_id='tnslsnr'
type='UNKNOWN' level='16' host_id='Server1 .vsnl.co.in'
host_addr='x.x.x.x'>
<txt>No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=Server1 .vsnl.co.in)(PORT=1527)))
</txt>
</msg>
set asm profile and edit in listener.ora file.
VALID_NODE_CHECKING_REGISTRATION_LISTENER = SUBNET
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = Server..co.in)(PORT = 1527))
)
)
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER = ON
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER = ON
VALID_NODE_CHECKING_REGISTRATION_LISTENER = SUBNET
Thats it :)
No comments:
Post a Comment