I was getting the following error while trying to connect to database locally as a different user:
I was told that the Oracle Software from which the database was running was copied from another server.
oracledbtst: error while loading shared libraries: libskgxp11.so: cannot open shared object file: No such file or directory
ERROR:
ORA-12547: TNS:lost contact
ERROR:
ORA-12547: TNS:lost contact
I was told that the Oracle Software from which the database was running was copied from another server.
Hence, to resolve it, the following was done:
In order to fix it, this is what I did:
1. Stopped the database and the listener running from the home of the database.
2. Gave correct permission to $ORACLE_HOME/bin/oracle:
3. Relinked the Oracle binary as follows since the database version was 11.1 on Linux
4. Started my database and the listener
5. Tested the connection and it worked without any errors.
1. Stopped the database and the listener running from the home of the database.
2. Gave correct permission to $ORACLE_HOME/bin/oracle:
$ chmod 6751 $ORACLE_HOME/bin/oracle
$ cd $ORACLE_HOME/bin
$ relink all
$ relink all
5. Tested the connection and it worked without any errors.
Thanks Pranilesh.
ReplyDelete