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

From: DA Morgan <>
Date: Fri, 18 Apr 2008 09:26:49 -0700
Message-ID: <>

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?
> Thanks.
> Woody Ling
> Hong Kong

Log onto the server at the operating system level as a member of the DBA group and then:

sqlplus /nolog
conn / as sysdba

Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington (replace x with u to respond)
Puget Sound Oracle Users Group
Received on Fri Apr 18 2008 - 11:26:49 CDT

Original text of this message