Now I remember why I didn't do this in version 8.0 of database - the startup/shutdown in RMAN that work in 8i+ gave errors. So until we upgrade those to 8i/9 I guess we live with 2 versions of scripts.
-----Original Message-----
From: Stankus, Paula G
Sent: Wednesday, September 18, 2002 2:04 PM
To: '[EMAIL PROTECTED]'
Subject: RE: HELP! CAN't STARTUP REMOTE DATABASE USING SQL*PLUS -
BUG?-NA-ARE YOU SURE?
Nope - Tried all that and didn't work - password file, granting sysdba to sys, changing remote_passwordfile_..=exclusive. It is easier to just run shutdown/startup in rman itself. It it was that easy I wouldn't have posted it. I read all available docs first!
-----Original Message-----
From: Molina, Gerardo [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 18, 2002 1:59 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: HELP! CAN't STARTUP REMOTE DATABASE USING SQL*PLUS -
BUG?-NA
My guess is that to start up or shut down a database remotely, you have to
use connect <user>/<password> as sysdba;
You will probably need a password file.
See Note 1029539.6 on Metalink which describes how to create password file.
HTH,
Gerardo