Re: SQLPLUS to a mounted Oracle instance

Greg

Doing the following from memory as I'm not working at a site with NT currently! I don't think that Oracle changed this for 2000 but someone who's working with 2000 may like to confirm this?

On NT once you have added SYS or SYSTEM into your password file using either the orapwd utility or grant sysdba to system. You can connect using sqlplus /nolog "sys/password as sysdba" or it maybe sqlplus /nolog connect sys/password as sysdba, assuming you use password authentication. If you don't then you would make sure the NT user is in the ORA_OPER or ORA_DBA NT groups or alternatively the ORA_sid_OPER or ORA_sid_DBA group if you want to restrict that user to just one dB. Then use sqlplus /nolog "/ as sysdba". Note the sid should be in upper case and you must make sure that SQLNET.AUTHENTICATION_SERVICES = (NTS) is set in the SQLNET.ORA file on the server.

Hope this helps.

Regards

Fraser McCallum
MVP Oracle
www.brainbench.com

"Greg Arpino" <greg.arpino_at_webloyalty.com> wrote in message news:d7a6a759.0107241154.204de775_at_posting.google.com...
> I am currently running Oracle 8.1.6.0 on Windows 2000. I'm trying to
> SQL*Plus to a mounted (not opened) instance on a remote machine in
> order to apply archive logs. When I attempt to do so I get the error:
>
> ORA-01033: ORACLE initialization or shutdown in progress
>
> If I try to SQL*Plus as INTERNAL, I get:
>
> ORA-01031: insufficient privileges
>
> If I SQL*Plus as internal on the local server where the instance is
> running, I have no problem.
>
> Am I missing something or is this just not possible under our current
> patch set?
>
> Any help would be greatly appreciated.
Received on Tue Jul 24 2001 - 18:17:22 CDT