In this post, we are discussing about issue which I faced on fresh oracle software install.
[oracle@test1.test.com ] Ora:TEST2 $ sqlplus "/ as sysdba" SQL*Plus: Release 11.2.0.4.0 Production on Mon May 30 12:30:31 2016 Copyright (c) 1982, 2013, Oracle. All rights reserved. ERROR: ORA-01031: insufficient privileges
Normally this issue points to incorrect permissions on oracle binaries OR incorrect value for SQLNET.AUTHENTICATION_SERVICES in sqlnet.ora. But in my case both were correctly set.
After checking on metalink, I found following note related to the same issue, which explains different scenarios, on of them is if the OS user is part of the OSDBA group.
Troubleshooting ORA-1031 or ORA-1017 Errors When Connecting As SYSDBA (Doc ID 730067.1)
I tried to compare file “$ORACLE_HOME/rdbms/lib/config.s” with other oracle home where sqlplus “/ as sysdba” was working fine.
Note: config file name vary from OS to OS on some OS it is config.c and on some OS it is config.s
[oracle@test1.test.com ] Ora: TEST1 $ diff config.s /u01/app/oracle/TEST2/11.2.0.4/rdbms/lib/config.s 23c23 < .ascii "oinstall\0" --- > .ascii "\0"
I found the culprit!!! In my new installation, Library file was missing group details. After making all necessary changes, I had to relink all oracle binaries.
For binary relink, perform following steps:
– Make sure that no oracle processes running
– Login as oracle
– Make sure LD_LIBRARY_PATH and ORACLE_HOME are set properly
– $ORACLE_HOME/bin/relink all
After binary relink, sqlplus “/ as sysdba” started working as expected.
Done!!!!!!!!!!
Hope so u will find this post very useful:-)
Cheers
Regards,
Adityanath
Categories: Administration, ORA errors
I’ve read several good stuff here. Certainly worth bookmarking for revisiting. I surprise how a lot effort you place to make one of these wonderful informative website.