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

On 4$B7n(B20$BF|(B, $B>e8a(B2$B;~(B48$BJ,(B, Woody Ling <woodyl..._at_gmail.com> wrote:
> On 4$B7n(B19$BF|(B, $B2<8a(B8$B;~(B08$BJ,(B, sybra..._at_hccnet.nl wrote:
>
>
>
>
>
> > On Sat, 19 Apr 2008 01:35:13 -0700 (PDT), Woody Ling
>
> > <woodyl..._at_gmail.com> wrote:
> > >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?
>
> > No, you are not.
> > You didn't read that one line, where I said:
>
> > >> OEM simply issues a srvctl command on the remote host.
>
> > Also, you don't mention a version, so it is very difficult to answer.
> > What OEM does in 9.2.0.8 is, provided the Intelligent Agent is
> > running, submit a job on the database server. That job issues a srvctl
> > command. No static registration required.
> > There may be more at hand in your installation, but as you require the
> > use of a crystal ball or a magic wand, I can't help you.
>
> > --
> > Sybrand Bakker
> > Senior Oracle DBA- $Bp,i6Ho0zMQJ8;z(B -
>
> > - $Bp}<(Ho0zMQJ8;z(B -
>
> Thanks for your help. I am using 10gR2 + RAC.
>
> I am sorry that I want to know more detail.
> The following are the steps to startup the database through OEM in my
> case when using static registeration:
> 1. Login SYS as sysdba in OEM
> 2. OEM shows me that the database is not available and I click a
> button to start the db.
> 3. OEM communications with sever process (what is it?)
> 4. OEM shows me a list of instances and let me choose which one to
> startup with the db.
> 5. I choose some of them and then click next.
> 6. OEM issues srvctl to start the instances and db base on my choice.
>
> But when I use dynamic registeration, the case becomes....
> 1. Login SYS as sysdba in OEM
> 2. OEM reports ORA-12514: TNS:listener does not currently know of
> service requested in connect descriptor
> 3. It seems that OEM does not have chance to issue srvctl.
>
> How to solve it? Thanks.- $Bp,i6Ho0zMQJ8;z(B -
>
> - $Bp}<(Ho0zMQJ8;z(B -

I think I am totally wrong after testing with different setting.

Sybrand Bakker should be correct that listener is not needed for startup a remote database with OEM.

Thanks Sybrand Bakker . Received on Sun Apr 20 2008 - 20:58:35 CDT