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: connect / as sysdba on 9i

RE: connect / as sysdba on 9i

From: Jacques Kilchoer <Jacques.Kilchoer_at_quest.com>
Date: Thu, 5 Feb 2004 10:57:43 -0800
Message-ID: <B5C5F99D765BB744B54FFDF35F602621033DAE88@irvmbxw02>


Helmut:
You are using HP-UX.

If ORACLE_HOME, ORACLE_SID are set correctly AND
you are signed on as a UNIX user who is part of the DBA group then
you should be able to say "connect / as sysdba"

In this case the value of the O7_DICTIONARY_ACCESSIBILITY parameter will = not make a difference.

> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Daiminger, Helmut
> Sent: jeudi, 5. f=E9vrier 2004 07:20
> To: 'oracle-l_at_freelists.org'
> Subject: RE: connect / as sysdba on 9i

>=20
>=20

> Hi!
>=20

> No, it is a member of the dba group...
>=20

> id
> uid=3D107(oracle) gid=3D102(dba)
>=20

> Thanks,
> Helmut
>=20

> -----Original Message-----
> From: Kirtikumar Deshpande [mailto:kirtikumar_deshpande_at_yahoo.com]=20
> Sent: Thursday, February 05, 2004 3:17 PM
> To: oracle-l_at_freelists.org
> Subject: Re: connect / as sysdba on 9i
>=20
>=20

> Your UNIX id is not in the 'dba' group.=20
>=20

> - Kirti=20
>=20
>=20
>=20

> --- "Daiminger, Helmut" <HELMUT.DAIMINGER_at_WWK.DE> wrote:
> > Hi!
> >=20
> > What parameters need to be set to allow
> >=20
> > connect / as sysdba on 9i?
> >=20
> > On my db this is disabled. Only "connect sys/pwd_at_database=20
> as sysdba"=20
> > works.
> >=20
> > Any ideas?
> >=20
> > This is 9.2 on HP-UX.
> >=20
> > Thanks,
> > Helmut
> >=20
> >=20
> > ----------------------------------------------------------------
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > ----------------------------------------------------------------
> > To unsubscribe send email to: oracle-l-request_at_freelists.org put=20
> > 'unsubscribe' in the subject line.
> > --
> > Archives are at http://www.freelists.org/archives/oracle-l/
> > FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> > -----------------------------------------------------------------
>=20
>=20

> __________________________________
> Do you Yahoo!?
> Yahoo! Finance: Get your refund fast by filing online.
> http://taxes.yahoo.com/filing.html
> ----------------------------------------------------------------
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> ----------------------------------------------------------------
> To unsubscribe send email to: oracle-l-request_at_freelists.org put
> 'unsubscribe' in the subject line.
> --
> Archives are at http://www.freelists.org/archives/oracle-l/
> FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------
> ----------------------------------------------------------------
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> ----------------------------------------------------------------
> To unsubscribe send email to: oracle-l-request_at_freelists.org
> put 'unsubscribe' in the subject line.
> --
> Archives are at http://www.freelists.org/archives/oracle-l/
> FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------
>=20

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Received on Thu Feb 05 2004 - 12:57:43 CST

Original text of this message

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