Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-01031 with sqlplus / as sysdba whereas sqlplus sys/pw as sysdba works

DikkieDickDec 11 2012 — edited Dec 14 2012
Hi, I have a problem on our exadata-machine with different EBS-Oraclehomes (11.2.0.2).
I have cloned an Oracle-home using another user who belongs to the appropriate groups. Modified permissions and ownership of all files belonging to this Oracle-home.

For making a dbclone I have copied the passwordfile from dbhome1 to dbhome2.
So far, and after hours of trying, googling I haven't been able to do the following:

sqlplus / as sysdba

This results in ORA-0131 Insufficient privileges.

sqlplus sys/pw as sysdba works

So with RMAN I'm able to connect to target (source) and auxiliary (target) through sys/pw@dbname1 and 2.
But the duplicate crashes with a Segmentation Fault, probably due to that somewhere underwater it tries to connect '/ as sysdba' .

I've relinked oracle-home after modifying config.c, but with no success. I'm lost. The owner of this oracle-home has a username consisting of 13 characters. Tried, as I need another clone, also with a username with 12 characters, but that gives the same result. Probably it's easy to fix and a minor thing, but for now I'm lost.

Thanx in advance.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 11 2013
Added on Dec 11 2012
5 comments
1,592 views