Monday, June 28, 2010

Database Listener not coming up

Issue / Error
=============================
bash-3.00$ lsnrctl start $ORACLE_SID

lsnrctl: symbol lookup error: lsnrctl: undefined symbol: nlgh
bash-3.00$

Resolution ( relinking executables  )
=============================
bash-3.00$ cd $ORACLE_HOME/bin
bash-3.00$
bash-3.00$ relink all

writing relink log to: /prod/oracle/product/112/install/relink.log

/prod/oracle/product/112/bin/relink: line 146: 30017 Segmentation fault      $RUNINSTALLER $ARGS
>$LOGFILE 2>&1
bash-3.00$

bash-3.00$ lsnrctl start $ORACLE_SID

lsnrctl: symbol lookup error: lsnrctl: undefined symbol: nlgh
bash-3.00$

Followd Below steps

===================
cd $ORACLE_HOME/rdbms/lib
make -f ins_rdbms.mk install

cd $ORACLE_HOME/network/lib
make -f ins_net_server.mk install


bash-3.00$ lsnrctl start $ORACLE_SID

This resolved the issue
=====================



================================
Relink the Oracle executables  ( commands )

================================



make -kf ins_rdbms.mk install (in $ORACLE_HOME/rdbms/lib)
make -kf ins_network.mk install (in $ORACLE_HOME/network/lib)
make -kf ins_sqlplus.mk install (in $ORACLE_HOME/sqlplus/lib)
make -kf ins_reports60w.mk install (on CCMgr server)
make -kf ins_forms60w.install (on Forms/Web server)

No comments: