Message-Id: <10585.114305@fatcity.com> From: "Thapliyal, Deepak" Date: Thu, 10 Aug 2000 14:29:31 -0700 Subject: 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 .. hth deepak -----Original Message----- From: Mukesh Ghildiyal [mailto:mcgoracle@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@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@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