Re: SQLPLUS to a mounted Oracle instance

From: Alanoly J. Andrews <alanolya_at_invera.com>
Date: 25 Jul 2001 06:02:18 -0700
Message-ID: <e76061b9.0107250502.9ff810e@posting.google.com>

greg.arpino_at_webloyalty.com (Greg Arpino) 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.

I don't know about Oracle on Windows. But on the Unix platforms, to access the instance as a DBA from a remote machine, you need to set the parameter "remote_login_passwordfile" to "exclusive" and then run the "orapwd" utility.

A.A. Received on Wed Jul 25 2001 - 08:02:18 CDT