Thursday, November 3, 2016

sqlplus: error while loading shared libraries: libsqlplus.so: cannot open shared object file

 sqlplus / as sysdba
-bash: sqlplus: command not


Solution::::  switch to database OS user and perform bellow
export ORACLE_HOME=/u05/oracle/prod/db/tech_st/11.1.0/
$ export PATH=$ORACLE_HOME/bin:$PATH
$ export ORACLE_SID=PROD


sqlplus / as sysdba
sqlplus: error while loading shared libraries: libsqlplus.so: cannot open shared object file: No such file or directory

Solution::::   export LD_LIBRARY_PATH=$ORACLE_HOME/lib
sqlplus / as sysdba
SQL*Plus: Release 11.1.0.7.0 - Production on Tue May 27 06:28:05 2014
Copyright (c) 1982, 2008, Oracle.  All rights reserved

No comments:

Post a Comment