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

From: <>
Date: Fri, 18 Apr 2008 19:35:47 +0200
Message-ID: <>

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

>I get error message when I try to use sqlplus to startup my db
>remotely: sqlplus sys_at_xyzdb as sysdba
>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?
>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.


Sybrand Bakker
Senior Oracle DBA
Received on Fri Apr 18 2008 - 12:35:47 CDT

Original text of this message