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

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

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
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org