the filename must be pwd<SID>.ora in orant\database\ directory.
Ivo Libal
=20
> -----Urspr=FCngliche Nachricht-----
> Von: Schoen Volker [SMTP:v.schoen_at_inplan.de]
> Gesendet am: Freitag, 11. August 2000 12:34
> An: Multiple recipients of list ORACLE-L
> Betreff: AW: Urgent SYSDBA
>=20
> in sqlplus try this:
>=20
> sql> connect sys/oracle@<service name> as sysdba (it does not work)
>=20
> You have to setup tnsnames.ora with a service name to your instance.
>=20
> regards
>=20
> Volker Sch=F6n
> E-Mail: mailto:v.schoen_at_inplan.de
> http://www.inplan.de
>=20
>=20
>=20
> -----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
>=20
>=20
> 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
>=20
> hth
> deepak
>=20
> -----Original Message-----
> Sent: Thursday, August 10, 2000 2:35 PM
> To: Multiple recipients of list ORACLE-L
>=20
>=20
> Hello experts
>=20
> 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
>=20
> then I did following
> orapwd80 -file=3Dpwdfl password=3Doracle entries=3D10
>=20
> then I did following
> created sys and system user account with ora_dba group
> in NT.
>=20
> Now I have password for sys,system and internal
>=20
> I granted the system the sysdba .
>=20
> Now problem
>=20
> 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)
>=20
> 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
>=20
> Also it does not work for system and internal as well
> at sqlplus prompt.
>=20
>=20
> Please help, whats wrong why it does not work at sql
> prompt
>=20
> Many thanks
>=20
>=20
> MCG
>=20
>=20
> __________________________________________________
> Do You Yahoo!?
> Kick off your party with Yahoo! Invites.
> http://invites.yahoo.com/
> --=20
> Author: Mukesh Ghildiyal
> INET: mcgoracle_at_yahoo.com
>=20
> 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
>=20
> 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: Schoen Volker
> INET: v.schoen_at_inplan.de
>=20
> 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 Fri Aug 11 2000 - 07:52:24 CDT