Re: remote connection to server manager

"Alistair Thomson" <alistair_at_despammed.com> wrote in message news:<bodb36$b5d$1$8300dec7_at_news.demon.co.uk>...
> Hi
>
> Oracle 8.1.7.0.0 Standard Edition
> Solaris 8
>
> I have two servers, one with a primary database the other with a standby
> database. Both work okay.
>
> I would like to run a script from the primary server that can show me the
> last applied archive log (just want to be sure its working) but when I try
> and connect to the remote standby database I get the ora-1033 error db
> initialisation / shutdown in progress.
>
> I've got the init.ora parameters set on both servers to
> REMOTE_LOGIN_PASSWORDFILE=EXCLUSIVE and v$pwfile_users shows user SYS with
> SYSDBA and SYSOPER privs.
>
> The listener has an entry for the database on the remote server and I have a
> valid tnsnames entry on the local server.
>
> I've tried all sorts of connect strings eg
>
> $ svrmgrl
> connect internal_at_remote_db
>
> asks for password - it doesn't accept it
>
> $ sqlplus /nolog
> connect sys/pwd_at_remote_db as sysdba
>
> invalid username/password login denied
>
>
> What am I missing here?
>
> Thanks
>
> Alistair

As the database isn't open, you can't use sqlnet to connect, only local connections are permitted.

Sybrand Bakker
Senior Oracle DBA Received on Thu Nov 06 2003 - 09:20:08 CST