remote connection to server manager

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 Received on Thu Nov 06 2003 - 05:25:27 CST