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

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

AW: Urgent SYSDBA

From: Libal, Ivo <ivo.libal_at_knapp-systems.com>
Date: Fri, 11 Aug 2000 14:52:24 +0200
Message-Id: <10586.114351@fatcity.com>


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

Original text of this message

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