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

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Fri, 18 Apr 2008 19:35:31 +0200
Message-ID: <5048c$4808dbe4$524b5c40$4064@cache6.tilbu1.nb.home.nl>


Woody Ling 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

Of course: change your tnsnames.ora on the client, it has the wrong SERVICE_NAME= entry.

service_name := SID||DB_DOMAIN; Received on Fri Apr 18 2008 - 12:35:31 CDT

Original text of this message