Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> sqlplus fails with SID /TNSNAME ( insufficient priveleges )
Hello everyone,
When I connect to my oracle database using
export ORACLE_SID=words
sqlplus 'sys/ram as sysdba'
It works fine
but when I use
sqlplus 'sys/ram_at_words as sydba'
...
ERROR:
ORA-01031: insufficient privileges
My listener is working fine. I verified using lsnrctl status.
Funny thing is the same setup was working find until yesterday, but there was no data in the database. Today I created the tables and loaded the data , now I am getting this error after restarting the database.
Thanks
Ram
Received on Tue Jul 13 2004 - 01:59:00 CDT