I have done my search regarding to my problem but couldn't find a helpful answer.
Here is the problem description:
I am using ORACLE EBS R12 on my linux redhat server. What I want to achieve is that I have production server that has DB and apps server and my ultimate goal
is that I want to clone it to the test server. However, as for now, I am aiming to clone the DB part only (with out shutting down the production or any services). So,
here is how I am aiming to approach the problem:
1- Copying the oracle_home from production to test server. (I did it).
2- On the production, creating pfile from spfile and then copying it to the test server . ( I did it).
3- Connecting to the DB in test server as sys user to start the db in nomount option using that parameter file I copied from the production.
4- Starting up the DB using mount option.
5- to restore the control file from RMAN backup.
Now, I am stuck in step No. 3. I can't connect to ORACLE DB using "/as sysdba" and I don't have the password. I am only able to connect to the DB using apps user.
So, whenever I try to connect using /as sysdba (after I set the environmental variable) , I get ORA-01031: insufficient privilege. I have done my search here and there
and modified my oracle user and assigned it to dba group ($usermod -G <dba_group_name> <oracle_user_name> but that goes without fixing the error. After that, I
desperately tried to modify the content of sqlnet.ora in $ORACLE_HOME/network/admin to comment the line "SQLNET.AUTHENTICATION_SERVICES" as some article
suggested but it didn't help.
Can you please help and give the solution and as to why I am encountering this error?
Keep in mind that I am able to connect using /as sysdba in the production server. My problem mentioned above is in the test server.
Thanks in advanced.
Can you check if the value of "DBA GROUP" in $ORACLE_HOME/rdbms/lib/config.c is correct as per your instance.
Also try to trace the error as below:
strace -o /tmp/strace_sysdba.log -cfT sqlplus / as sysdba