Re: Cannot remote startup database if dynamically registered with the listener?

On Fri, 18 Apr 2008 05:59:28 -0700 (PDT), Woody Ling <woodyling_at_gmail.com> wrote:

>I get error message when I try to use sqlplus to startup my db
>remotely: sqlplus sys_at_xyzdb as sysdba
>
>ERROR:
>ORA-12514: TNS:listener does not currently know of service requested
>in connect descriptor
>
>I found that I cannot use sqlplus to remote startup my database
>without static entry "(SID_DESC=(GLOBAL_NAME........))" in
>listener.ora. Since some documents said that we should use dynamically
>registered with listener for load balance in RAC environment, is there
>any way to startup db without static db register?
>
>
>Thanks.
>Woody Ling
>Hong Kong

There is.
You don't mention a version, but this probably works in both 9i and 10g.
It is called OEM.
OEM simply issues a srvctl command on the remote host. If you don't use OEM, yes, you do need static registration.

Hth

-- 
Sybrand Bakker
Senior Oracle DBA