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

On Apr 19, 1:35 am, sybra..._at_hccnet.nl wrote:
> On Fri, 18 Apr 2008 05:59:28 -0700 (PDT), Woody Ling
>
>
>
>
>
> <woodyl..._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- Hide quoted text -
>
> - Show quoted text -

Actually I am using OEM web interface and dynamic registration for database service so that the listener can "see" the instance and database when the pmon is started and registered itself to the listener.

The problem is that when the rac database and all instances are stopped, there is no pmon process and the listener does not know any database service is available.

At this moment, when I login SYS as sysdba through an OEM web interface, the OEM communicates with listener and finds that there is no database available and reports ORA-12514. There is no way for me to startup the database.

The problem can only be solved by adding static entry in listener.ora to use static registration.

Am I correct? Received on Sat Apr 19 2008 - 03:35:13 CDT