Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: sqlplus fails with SID /TNSNAME ( insufficient priveleges )

Re: sqlplus fails with SID /TNSNAME ( insufficient priveleges )

From: Sybrand Bakker <sybrandb_at_hccnet.nl>
Date: Tue, 13 Jul 2004 22:56:12 +0200
Message-ID: <r0j8f0pal2v825uq7im0ifvllfadb5njih@4ax.com>


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 DBA
Received on Tue Jul 13 2004 - 15:56:12 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US