Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: sqlplus fails with SID /TNSNAME ( insufficient priveleges )
On Tue, 13 Jul 2004 12:29:00 +0530, ramprasad <ramprasad.ap_at_gmail.com>
wrote:
>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
One of the causes for ora-1031 is the combination of
remote_login_passwordfile = exclusive
password of internal not being identical to sys.
This will become apparent after bouncing the database.
Has 0 to do with the contents of the database.
-- Sybrand Bakker, Senior Oracle DBAReceived on Tue Jul 13 2004 - 15:56:12 CDT