AW: Urgent SYSDBA

From: Schoen Volker <v.schoen_at_inplan.de>
Date: Fri, 11 Aug 2000 11:31:02 +0200
Message-Id: <10586.114337@fatcity.com>

in sqlplus try this:

sql> connect sys/oracle@<service name> as sysdba (it does not work)

You have to setup tnsnames.ora with a service name to your instance.

regards

Volker Sch=F6n
E-Mail: mailto:v.schoen_at_inplan.de
http://www.inplan.de

-----Urspr=FCngliche Nachricht-----
Von: Thapliyal, Deepak [mailto:DThapliyal_at_ea.com] Gesendet: Freitag, 11. August 2000 00:36 An: Multiple recipients of list ORACLE-L Betreff: RE: Urgent SYSDBA

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
..=20

hth
deepak

-----Original Message-----
Sent: Thursday, August 10, 2000 2:35 PM
To: Multiple recipients of list ORACLE-L

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=3DEXCLUSIVE then I did following
orapwd80 -file=3Dpwdfl password=3Doracle entries=3D10

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/
--=20
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
also send the HELP command for other information (like subscribing). --=20
Author: Thapliyal, Deepak
INET: DThapliyal_at_ea.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------