After Unix patching test listener was unable to start and encountered below error
[oracle:test]/oracle$ lsnrctl start test
LSNRCTL for Solaris: Version 11.2.0.2.0 - Production on 22-JUL-2015 21:44:11
Copyright (c) 1991, 2010, Oracle. All rights reserved.
Starting /test/oracle/11.2.0.4/bin/tnslsnr: please wait...
TNS-12537: TNS:connection closed
TNS-12560: TNS:protocol adapter error
TNS-00507: Connection closed
Solaris Error: 29: Illegal seek
SOLUTION :
Set Environment variables:
export ORACLE_SID=test
export ORACLE_SID
export ORACLE_HOME=/test/oracle/11.2.0.4
export ORACLE_HOME
export PATH=$PATH:$ORACLE_HOME/bin
export PATH
export PATH=$ORACLE_HOME/bin:$PATH
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
è Relinking of Oracle Home Binaries
èCd /test/oracle/11.2.0.4/bin
[oracle:test]/bin$ cd /test/oracle/11.2.0.4/bin
[oracle:test]/bin$ ./relink all
Now issue got resolved ,listner up and running fine
[oracle:test]/bin$ lsnrctl status test
LSNRCTL for Solaris: Version 11.2.0.2.0 - Production on 22-JUL-2015 23:12:35
Copyright (c) 1991, 2010, Oracle. All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=test))
STATUS of the LISTENER
------------------------
Alias test
Version TNSLSNR for Solaris: Version 11.2.0.4.0 - Production
Start Date 22-JUL-2015 22:56:34
Uptime 0 days 0 hr. 16 min. 1 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /var/opt/oracle/listener.ora
Listener Log File /opt/oracle/diag/tnslsnr/oracle/test/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=test)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=test.core.dba.com)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.10)(PORT=1577)))
Services Summary...
Service "test.core.dba.com" has 1 instance(s).
Instance "test", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
[oracle:test]/bin$
MOS - Link:
https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=406647806596864&id=131321.1&_afrWindowMode=0&_adf.ctrl-state=1aewq82nb1_175
[oracle:test]/oracle$ lsnrctl start test
LSNRCTL for Solaris: Version 11.2.0.2.0 - Production on 22-JUL-2015 21:44:11
Copyright (c) 1991, 2010, Oracle. All rights reserved.
Starting /test/oracle/11.2.0.4/bin/tnslsnr: please wait...
TNS-12537: TNS:connection closed
TNS-12560: TNS:protocol adapter error
TNS-00507: Connection closed
Solaris Error: 29: Illegal seek
SOLUTION :
Set Environment variables:
export ORACLE_SID=test
export ORACLE_SID
export ORACLE_HOME=/test/oracle/11.2.0.4
export ORACLE_HOME
export PATH=$PATH:$ORACLE_HOME/bin
export PATH
export PATH=$ORACLE_HOME/bin:$PATH
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
è Relinking of Oracle Home Binaries
èCd /test/oracle/11.2.0.4/bin
[oracle:test]/bin$ cd /test/oracle/11.2.0.4/bin
[oracle:test]/bin$ ./relink all
Now issue got resolved ,listner up and running fine
[oracle:test]/bin$ lsnrctl status test
LSNRCTL for Solaris: Version 11.2.0.2.0 - Production on 22-JUL-2015 23:12:35
Copyright (c) 1991, 2010, Oracle. All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=test))
STATUS of the LISTENER
------------------------
Alias test
Version TNSLSNR for Solaris: Version 11.2.0.4.0 - Production
Start Date 22-JUL-2015 22:56:34
Uptime 0 days 0 hr. 16 min. 1 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /var/opt/oracle/listener.ora
Listener Log File /opt/oracle/diag/tnslsnr/oracle/test/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=test)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=test.core.dba.com)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.10)(PORT=1577)))
Services Summary...
Service "test.core.dba.com" has 1 instance(s).
Instance "test", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
[oracle:test]/bin$
MOS - Link:
https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=406647806596864&id=131321.1&_afrWindowMode=0&_adf.ctrl-state=1aewq82nb1_175
No comments:
Post a Comment