Jared,
If home selector not correct(meaning set to 8i) and try to use 9i sql after
setting correct oracle home for 9i on command line, it generates error like
'date format' not correct and oracle not working properly.
So home selector must point to 9i but connecting as sys will require password.
I am handling 10-12 Windows server with 8i and 9i databases on same machine.
Besides 8i does not require you to connect sys as sysdba but 9i does.
Regards
Rafiq
- Jared.Still_at_radisys.com wrote:
> In that case, it couns like you need to change your ORACLE_HOME via the
> "Home Selector",
> open a new CMD window, set the ORACLE_SID, and try again.
>
>
>
>
>
> Mohammad Rafiq <rafiq9857_at_yahoo.com>
> Sent by: oracle-l-bounce_at_freelists.org
> 02/05/2004 01:07 PM
> Please respond to oracle-l
>
>
> To: oracle-l_at_freelists.org
> cc:
> Subject: Re: connect / as sysdba on 9i
>
>
> Does not work with 9i. No problem with 8i.
>
> Regards
> Rafiq
>
>
>
> --- Jared.Still_at_radisys.com wrote:
> > Often on Win2k it is as simple as setting your ORACLE_SID env variable
> >
> >
> >
> >
> > Mohammad Rafiq <rafiq9857_at_yahoo.com>
> > Sent by: oracle-l-bounce_at_freelists.org
> > 02/05/2004 06:44 AM
> > Please respond to oracle-l
> >
> >
> > To: oracle-l_at_freelists.org
> > cc:
> > Subject: Re: connect / as sysdba on 9i
> >
> >
> > Kirti,
> >
> > What about Windows 2000 when same behaviour while logging as sys(not
> > system)as
> > and user is a part of dba group. I think it depends on setting of
> > remote_login_passwordfile=EXCLUSIVE( if setting is NONE no problem).
> >
> >
> > Regards
> > Rafiq
> >
> >
> >
> >
> > --- Kirtikumar Deshpande <kirtikumar_deshpande_at_yahoo.com> wrote:
> > > Your UNIX id is not in the 'dba' group.
> > >
> > > - Kirti
> > >
> > >
> > >
> > > --- "Daiminger, Helmut" <HELMUT.DAIMINGER_at_WWK.DE> wrote:
> > > > Hi!
> > > >
> > > > What parameters need to be set to allow
> > > >
> > > > connect / as sysdba on 9i?
> > > >
> > > > On my db this is disabled. Only "connect sys/pwd_at_database as sysdba"
>
> > works.
> > > >
> > > > Any ideas?
> > > >
> > > > This is 9.2 on HP-UX.
> > > >
> > > > Thanks,
> > > > Helmut
> > > >
> > > >
> > > > ----------------------------------------------------------------
> > > > 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
> > > > -----------------------------------------------------------------
> > >
> > >
> > > __________________________________
> > > 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
> > > -----------------------------------------------------------------
> >
> >
> > __________________________________
> > 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
> > -----------------------------------------------------------------
>
>
> __________________________________
> 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
> -----------------------------------------------------------------
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
-----------------------------------------------------------------
Received on Thu Feb 05 2004 - 20:55:13 CST