Normally the insufficient privileges, do occur when the OS level privileges are missing for Oracle User. Like assigning the DBA group for oracle user in unix versions and ORA_DBA group in Windows User Group. The more detailed error study can be found in the following metalink note-id: Checklist for Resolving CONNECT AS SYSDBA (INTERNAL) Issues [ID 233223.1]
UNIX: Checklist for Resolving Connect AS SYSDBA Issues [ID 69642.1]
For us this error occured when we are trying to Clone the Oracle Database using the RMAN database and after running the adcfgclone.pl dbTechstack . Thanks for the blog(newappsdba.blogspot.com), who has the same situation and the same error.
After running the adcfgclone.pl, whenever we tried to run the sqlplus as "sysdba", it will throw error as
'ORA-01031: insufficient privileges'.
As per the metalink id: SYSDBA and SYSOPER Privileges in Oracle [ID 50507.1]
The fix is :
The fix is :
In $ORACLE_HOME/rdbms/lib
mv config.o config.o.orig
make -f ins_rdbms.mk ioracle
May be the adcfgclone.pl is making some changes to this file or its corrupted. By applying the above solution it resolved the error.But each and everytime when we make the clone, it is quite necessary to do the above workaround.
But Oracle has provided a Permanent solution for the above error through the metalink ID : 1276420.1. To apply the patch 8999153 in Source system.
No comments:
Post a Comment