RE: connect / as sysdba on 9i
- From: Jared.Still@xxxxxxxxxxx
- To: oracle-l@xxxxxxxxxxxxx
- Date: Thu, 5 Feb 2004 16:33:15 -0800
ORACLE_HOME doesn't need to be set in the environment.
But if you want to connect via '/ as sysdba' you will need to run
the Oracle Home Selector and open a new CMD window.
The Home Selector changes the search order of the PATH variable.
If you try to login as '/ as sysdba' on a 9i database while the search
path is set to find 8i first, you will get an error.
Jared
"Jacques Kilchoer" <Jacques.Kilchoer@xxxxxxxxx>
Sent by: oracle-l-bounce@xxxxxxxxxxxxx
02/05/2004 03:20 PM
Please respond to oracle-l
To: <oracle-l@xxxxxxxxxxxxx>
cc:
Subject: RE: connect / as sysdba on 9i
Does the ORACLE_HOME really make a difference on Windows, and if so why?
As long as the bin directory for the right version of Oracle is in the =
path, why would it matter? And SQL*Plus would be using the DLLs in the =
bin directory anyway.
> -----Original Message-----
> From: oracle-l-bounce@xxxxxxxxxxxxx
> [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of
> Jared.Still@xxxxxxxxxxx
> Sent: jeudi, 5. f=E9vrier 2004 14:01
> To: oracle-l@xxxxxxxxxxxxx
> Subject: Re: connect / as sysdba on 9i
>=20
>=20
> In that case, it couns like you need to change your=20
> ORACLE_HOME via the=20
> "Home Selector",
> open a new CMD window, set the ORACLE_SID, and try again.
>=20
>=20
>=20
>=20
>=20
> Mohammad Rafiq <rafiq9857@xxxxxxxxx>
> Sent by: oracle-l-bounce@xxxxxxxxxxxxx
> 02/05/2004 01:07 PM
> Please respond to oracle-l
>=20
> =20
> To: oracle-l@xxxxxxxxxxxxx
> cc:=20
> Subject: Re: connect / as sysdba on 9i
>=20
>=20
> Does not work with 9i. No problem with 8i.
>=20
> Regards
> Rafiq
>=20
>=20
> =20
> --- Jared.Still@xxxxxxxxxxx wrote:
> > Often on Win2k it is as simple as setting your ORACLE_SID=20
> env variable
> >=20
> >=20
> >=20
> >=20
> > Mohammad Rafiq <rafiq9857@xxxxxxxxx>
> > Sent by: oracle-l-bounce@xxxxxxxxxxxxx
> > 02/05/2004 06:44 AM
> > Please respond to oracle-l
> >=20
> >=20
> > To: oracle-l@xxxxxxxxxxxxx
> > cc:=20
> > Subject: Re: connect / as sysdba on 9i
> >=20
> >=20
> > Kirti,
> >=20
> > What about Windows 2000 when same behaviour while logging=20
> as sys(not=20
> > system)as=20
> > and user is a part of dba group. I think it depends on setting of=20
> > remote_login_passwordfile=3DEXCLUSIVE( if setting is NONE no =
problem).
> >=20
> >=20
> > Regards
> > Rafiq
> >=20
> >=20
> >=20
> >=20
> > --- Kirtikumar Deshpande <kirtikumar_deshpande@xxxxxxxxx> wrote:
> > > Your UNIX id is not in the 'dba' group.=20
> > >=20
> > > - Kirti=20
> > >=20
> > >=20
> > >=20
> > > --- "Daiminger, Helmut" <HELMUT.DAIMINGER@xxxxxx> 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=20
> sys/pwd@database as sysdba"=20
>=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@xxxxxxxxxxxxx
> > > > put 'unsubscribe' in the subject line.
> > > > --
> > > > Archives are at //www.freelists.org/archives/oracle-l/
> > > > FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
> > > >=20
> -----------------------------------------------------------------
> > >=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@xxxxxxxxxxxxx
> > > put 'unsubscribe' in the subject line.
> > > --
> > > Archives are at //www.freelists.org/archives/oracle-l/
> > > FAQ is at //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@xxxxxxxxxxxxx
> > put 'unsubscribe' in the subject line.
> > --
> > Archives are at //www.freelists.org/archives/oracle-l/
> > FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
> > -----------------------------------------------------------------
> >=20
> >=20
> >=20
> >=20
> > ----------------------------------------------------------------
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > ----------------------------------------------------------------
> > To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
> > put 'unsubscribe' in the subject line.
> > --
> > Archives are at //www.freelists.org/archives/oracle-l/
> > FAQ is at //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@xxxxxxxxxxxxx
> put 'unsubscribe' in the subject line.
> --
> Archives are at //www.freelists.org/archives/oracle-l/
> FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------
>=20
>=20
>=20
>=20
> ----------------------------------------------------------------
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> ----------------------------------------------------------------
> To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
> put 'unsubscribe' in the subject line.
> --
> Archives are at //www.freelists.org/archives/oracle-l/
> FAQ is at //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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
