This content has been marked as final. Show 3 replies
My DB system consisted of RAC.
Yesterday, i modified a sqlnet.ora, configuring a sqlnet.authentication_services=(none)
I checked it using sqlplus.
DB1 was OK but DB2 was failed
This is DB2 message.
SQL*Plus: Release 18.104.22.168.0 Production on Wed Feb 22 22:37:42 2012
Copyright (c) 1982, 2010, Oracle. All rights reserved.
SQL> connect sys/oracle as sysdba
ORA-01031: insufficient privileges
I didn't know why sys user didn't have sysdba privilege.
Then I downloaded DB1's sqlnet.ora and uploaded it at DB2.
But DB2 was failed.
Please answer a questions....
Edited by: user1080096 on 2012. 2. 24 오전 2:44
Check your variables env ORACLE_HOME and ORACLE_SID or try connect using easy connect method.
sqlplus sys/oracle@hostanme:<port>/<service_name> as sysdba
Edited by: Levi Pereira on Feb 24, 2012 11:10 AM