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

Home -> Community -> Mailing Lists -> Oracle-L -> Urgent SYSDBA

Urgent SYSDBA

From: Mukesh Ghildiyal <mcgoracle_at_yahoo.com>
Date: Thu, 10 Aug 2000 13:28:54 -0700 (PDT)
Message-Id: <10585.114298@fatcity.com>


Hello experts

I am in problem here. I installed 8.0.5 on NT4 with servicepack 6a and its ok. I am able to create the database and install the sqlnet alises. I edited the initSID.ora file and put following:
REMOTE_LOGIN_PASSWORDFILE=EXCLUSIVE then I did following
orapwd80 -file=pwdfl password=oracle entries=10

then I did following
created sys and system user account with ora_dba group in NT.

Now I have password for sys,system and internal

I granted the system the sysdba .

Now problem

if I do

svrmgr30 > connect sys/oracle as sysdba (it works)
svrmgr30 > connect system/oracle as sysdba (it works)
svrmgr30 > connect internal/oracle as sysdba (it
works)

but when I do following at sqlplus prompt sql> connect sys/oracle as sysdba (it does not work) errors out with ORA-01031 insufficient privileges

Also it does not work for system and internal as well at sqlplus prompt.

Please help, whats wrong why it does not work at sql prompt

Many thanks

MCG



Do You Yahoo!?
Kick off your party with Yahoo! Invites. Received on Thu Aug 10 2000 - 15:28:54 CDT

Original text of this message

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