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

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

RE: Urgent SYSDBA

From: Thapliyal, Deepak <DThapliyal_at_ea.com>
Date: Thu, 10 Aug 2000 14:29:31 -0700
Message-Id: <10585.114305@fatcity.com>


i think you can start connecting as internal via sql*plus and completely augment the svrmgrl functionality using the same only from 8i(8.1.X) onwards ..

hth
deepak

-----Original Message-----
From: Mukesh Ghildiyal [mailto:mcgoracle_at_yahoo.com] Sent: Thursday, August 10, 2000 2:35 PM
To: Multiple recipients of list ORACLE-L Subject: Urgent SYSDBA

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. http://invites.yahoo.com/
-- 
Author: Mukesh Ghildiyal
  INET: mcgoracle_at_yahoo.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
Received on Thu Aug 10 2000 - 16:29:31 CDT

Original text of this message

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