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.
There’s definately a lot to know about this topic. I love all of the points you have made.
Thanks for sharing your thoughts about website. Regards
Hello, all is going perfectly here and ofcourse
every one is sharing data, that’s really excellent, keep up writing.
Hi! This is my 1st comment here so I just wanted to give a quick shout out and say I truly enjoy reading through your articles. Can you suggest any other blogs/websites/forums that go over the same topics? Thanks!