oracle question

8 messages in this thread

list Rebecca Henderson · Tue, 20 May 2008 11:32:56 -0700 ·

I have a server that has multiple SIDs, 

They all use 1 listener, I have a - in the bb-roracle.ids file because
they all use the same one.

I get this: The SID RMAN1 is ok but the RMAN and OEM1 show as down How
can I stop the 

Two red statuses. Any help would be appreciated!

Thank you in advance,

Becki

Oracle Listener Check (rman1)


     Listener LISTENER_RMAN1 UP
     Listener LISTENER DOWN
 
    Listener LISTENER DOWN

list Bruce White · Tue, 20 May 2008 14:25:03 -0500 ·

How are you doing the oracle listener test?  This does not look like the
standard output from the oratns test you add to the bb-hosts file.
 
        .....Bruce

▸ quoted from Rebecca Henderson

From: Rebecca Henderson [mailto:user-89b343014dc7@xymon.invalid] 
Sent: Tuesday, May 20, 2008 1:33 PM
To: user-ae9b8668bcde@xymon.invalid
Subject: [hobbit] oracle question

I have a server that has multiple SIDs, 
They all use 1 listener, I have a - in the bb-roracle.ids file because they
all use the same one.
I get this: The SID RMAN1 is ok but the RMAN and OEM1 show as down How can I
stop the 
Two red statuses. Any help would be appreciated!
Thank you in advance,
Becki
Oracle Listener Check (rman1)

     Listener LISTENER_RMAN1 UP
     Listener LISTENER DOWN

    Listener LISTENER DOWN


Note: The information contained in this message may be privileged and
confidential and protected from disclosure. If the reader of this message is
not the intended recipient, or an employee or agent responsible for
delivering this message to the intended recipient, you are hereby notified
that any dissemination, distribution or copying of this communication is
strictly prohibited. If you have received this communication in error,
please notify us immediately by replying to the message and deleting it from
your computer. Thank you. Fellowes, Inc.

list Benjamin P. August · Tue, 20 May 2008 12:39:30 -0700 ·

Can you specify the listener for each SID? I know it's the same, and I  
know it's the default, but it's worth a shot.

Or maybe you can just disable the listener check for those other SIDs, maybe?

-- 
--Ben
Benjamin P. August
System Administrator - VPUE
Stanford University


Quoting Rebecca Henderson <user-89b343014dc7@xymon.invalid>:

▸ quoted from Bruce White

I have a server that has multiple SIDs,

They all use 1 listener, I have a - in the bb-roracle.ids file because
they all use the same one.

I get this: The SID RMAN1 is ok but the RMAN and OEM1 show as down How
can I stop the

Two red statuses. Any help would be appreciated!

Thank you in advance,

Becki

Oracle Listener Check (rman1)


     Listener LISTENER_RMAN1 UP
     Listener LISTENER DOWN

    Listener LISTENER DOWN

list Rebecca Henderson · Tue, 20 May 2008 12:47:50 -0700 ·

I did try specifying for each I will try to disable them next.
Thanks I just thought if someone had come across this that there 
Was another way to get it done.

-----Original Message-----
From: user-ae9b8668bcde@xymon.invalid [mailto:user-ae9b8668bcde@xymon.invalid] 
Sent: Tuesday, May 20, 2008 12:36 PM
To: Rebecca Henderson; user-ae9b8668bcde@xymon.invalid
Subject: Re: [hobbit] oracle question
Importance: Low

▸ quoted from Benjamin P. August


Can you specify the listener for each SID? I know it's the same, and I  
know it's the default, but it's worth a shot.

Or maybe you can just disable the listener check for those other SIDs,
maybe?

-- 
--Ben
Benjamin P. August
System Administrator - VPUE
Stanford University


Quoting Rebecca Henderson <user-89b343014dc7@xymon.invalid>:

I have a server that has multiple SIDs,

They all use 1 listener, I have a - in the bb-roracle.ids file
because
they all use the same one.

I get this: The SID RMAN1 is ok but the RMAN and OEM1 show as down

How

can I stop the

Two red statuses. Any help would be appreciated!

Thank you in advance,

Becki

Oracle Listener Check (rman1)


     Listener LISTENER_RMAN1 UP
     Listener LISTENER DOWN

    Listener LISTENER DOWN

list Benjamin P. August · Tue, 20 May 2008 12:48:40 -0700 ·

Nope, we only have one SID per server. Sorry about that.

▸ quoted from Rebecca Henderson


-- 
--Ben
Benjamin P. August
System Administrator - VPUE
Stanford University


Quoting Rebecca Henderson <user-89b343014dc7@xymon.invalid>:

I did try specifying for each I will try to disable them next.
Thanks I just thought if someone had come across this that there
Was another way to get it done.

-----Original Message-----
From: user-ae9b8668bcde@xymon.invalid [mailto:user-ae9b8668bcde@xymon.invalid]
Sent: Tuesday, May 20, 2008 12:36 PM
To: Rebecca Henderson; user-ae9b8668bcde@xymon.invalid
Subject: Re: [hobbit] oracle question
Importance: Low

Can you specify the listener for each SID? I know it's the same, and I
know it's the default, but it's worth a shot.

Or maybe you can just disable the listener check for those other SIDs,
maybe?

--
--Ben
Benjamin P. August
System Administrator - VPUE
Stanford University

Quoting Rebecca Henderson <user-89b343014dc7@xymon.invalid>:

I have a server that has multiple SIDs,

They all use 1 listener, I have a - in the bb-roracle.ids file
because
they all use the same one.

I get this: The SID RMAN1 is ok but the RMAN and OEM1 show as down

How

can I stop the

Two red statuses. Any help would be appreciated!

Thank you in advance,

Becki

Oracle Listener Check (rman1)


     Listener LISTENER_RMAN1 UP
     Listener LISTENER DOWN

    Listener LISTENER DOWN

list Rebecca Henderson · Tue, 20 May 2008 12:50:58 -0700 ·

The bbroracle.ksh.
bb-roracle.def
bb-roracle.ids

▸ quoted from Bruce White

-----Original Message-----
From: user-ae9b8668bcde@xymon.invalid [mailto:user-ae9b8668bcde@xymon.invalid] 
Sent: Tuesday, May 20, 2008 12:22 PM
To: Rebecca Henderson; 'user-ae9b8668bcde@xymon.invalid'
Subject: RE: [hobbit] oracle question
Importance: Low

How are you doing the oracle listener test?  This does not look like the
standard output from the oratns test you add to the bb-hosts file.

        .....Bruce

========================================================================
===

From: Rebecca Henderson [mailto:user-89b343014dc7@xymon.invalid] 
Sent: Tuesday, May 20, 2008 1:33 PM
To: user-ae9b8668bcde@xymon.invalid
Subject: [hobbit] oracle question

I have a server that has multiple SIDs, 

They all use 1 listener, I have a - in the bb-roracle.ids file because
they all use the same one.

I get this: The SID RMAN1 is ok but the RMAN and OEM1 show as down How
can
I stop the 

Two red statuses. Any help would be appreciated!

Thank you in advance,

Becki

Oracle Listener Check (rman1)

========================================================================
===

    Listener LISTENER_RMAN1 UP

    Listener LISTENER DOWN

    Listener LISTENER DOWN

Note: The information contained in this message may be privileged and
confidential and protected from disclosure. If the reader of this
message
is not the intended recipient, or an employee or agent responsible for
delivering this message to the intended recipient, you are hereby
notified
that any dissemination, distribution or copying of this communication is
strictly prohibited. If you have received this communication in error,
please notify us immediately by replying to the message and deleting it
from your computer. Thank you. Fellowes, Inc.

list Tom Callahan · Tue, 20 May 2008 16:03:39 -0400 ·

Bb-roracle reads our /etc/oratab if I remember correctly, to determine the
active/available SID¹s on your machine.

If you are running RAC, then the instance¹s are not named RMAN... By your
example they would be RMAN1 and RMAN2 depending on the physical node. OEM1
would be OEM running on that physical node, but I assume you now are using
Grid Control instead. OEM hails from pre-10g.

Check your /etc/oratab and make sure it reflects what you are currently
running. Make sure your bb-roracle.ids file contains the correct SID to be
testing for that physical node. You also need to point bb-roracle at the
correct ORACLE_HOME and TNS_ADMIN values if I remember correctly.


On 5/20/08 3:50 PM, "Rebecca Henderson" <user-89b343014dc7@xymon.invalid>

▸ quoted from Rebecca Henderson

wrote:

The bbroracle.ksh.
bb-roracle.def
bb-roracle.ids

-----Original Message-----
From: user-ae9b8668bcde@xymon.invalid [mailto:user-ae9b8668bcde@xymon.invalid]
Sent: Tuesday, May 20, 2008 12:22 PM
To: Rebecca Henderson; 'user-ae9b8668bcde@xymon.invalid'
Subject: RE: [hobbit] oracle question
Importance: Low

How are you doing the oracle listener test?  This does not look like the
standard output from the oratns test you add to the bb-hosts file.

        .....Bruce

========================================================================
===

From: Rebecca Henderson [mailto:user-89b343014dc7@xymon.invalid]
Sent: Tuesday, May 20, 2008 1:33 PM
To: user-ae9b8668bcde@xymon.invalid
Subject: [hobbit] oracle question

I have a server that has multiple SIDs,

They all use 1 listener, I have a - in the bb-roracle.ids file because
they all use the same one.

I get this: The SID RMAN1 is ok but the RMAN and OEM1 show as down How
can
I stop the

Two red statuses. Any help would be appreciated!

Thank you in advance,

Becki

Oracle Listener Check (rman1)

========================================================================
===

    Listener LISTENER_RMAN1 UP

    Listener LISTENER DOWN

    Listener LISTENER DOWN

Note: The information contained in this message may be privileged and
confidential and protected from disclosure. If the reader of this
message
is not the intended recipient, or an employee or agent responsible for
delivering this message to the intended recipient, you are hereby
notified
that any dissemination, distribution or copying of this communication is
strictly prohibited. If you have received this communication in error,
please notify us immediately by replying to the message and deleting it
from your computer. Thank you. Fellowes, Inc.

list Rebecca Henderson · Tue, 20 May 2008 13:34:39 -0700 ·

Yes, I have checked. This one AIX server is running 2 9i databases and
1 10G. I have no problem with the 10G. The 9i databases use the 10G
LISTENER
I'm going to try a couple more things,
Thanks!

▸ quoted from Tom Callahan


-----Original Message-----
From: user-ae9b8668bcde@xymon.invalid [mailto:user-ae9b8668bcde@xymon.invalid] 
Sent: Tuesday, May 20, 2008 1:01 PM
To: Rebecca Henderson; user-ae9b8668bcde@xymon.invalid
Subject: Re: [hobbit] oracle question
Importance: Low

Bb-roracle reads our /etc/oratab if I remember correctly, to determine
the


active/available SID's on your machine.

If you are running RAC, then the instance's are not named RMAN... By

▸ quoted from Tom Callahan

your
example they would be RMAN1 and RMAN2 depending on the physical node.
OEM1
would be OEM running on that physical node, but I assume you now are
using
Grid Control instead. OEM hails from pre-10g.

Check your /etc/oratab and make sure it reflects what you are currently
running. Make sure your bb-roracle.ids file contains the correct SID to
be
testing for that physical node. You also need to point bb-roracle at the
correct ORACLE_HOME and TNS_ADMIN values if I remember correctly.


On 5/20/08 3:50 PM, "Rebecca Henderson"
<user-89b343014dc7@xymon.invalid> wrote:


The bbroracle.ksh.
bb-roracle.def
bb-roracle.ids

-----Original Message-----
From: user-ae9b8668bcde@xymon.invalid [[ mailto:user-ae9b8668bcde@xymon.invalid] ]mailto:user-ae9b8668bcde@xymon.invalid]
Sent: Tuesday, May 20, 2008 12:22 PM
To: Rebecca Henderson; 'user-ae9b8668bcde@xymon.invalid'
Subject: RE: [hobbit] oracle question
Importance: Low

How are you doing the oracle listener test?  This does not look like the
standard output from the oratns test you add to the bb-hosts file.


        .....Bruce


========================================================================
===


From: Rebecca Henderson [[ mailto:user-89b343014dc7@xymon.invalid]
]mailto:user-89b343014dc7@xymon.invalid]
Sent: Tuesday, May 20, 2008 1:33 PM
To: user-ae9b8668bcde@xymon.invalid
Subject: [hobbit] oracle question


I have a server that has multiple SIDs,

They all use 1 listener, I have a - in the bb-roracle.ids file because
they all use the same one.

I get this: The SID RMAN1 is ok but the RMAN and OEM1 show as down How
can
I stop the

Two red statuses. Any help would be appreciated!

Thank you in advance,

Becki


Oracle Listener Check (rman1)


========================================================================
===


    Listener LISTENER_RMAN1 UP


    Listener LISTENER DOWN


    Listener LISTENER DOWN


Note: The information contained in this message may be privileged and
confidential and protected from disclosure. If the reader of this
message
is not the intended recipient, or an employee or agent responsible for
delivering this message to the intended recipient, you are hereby
notified
that any dissemination, distribution or copying of this communication is
strictly prohibited. If you have received this communication in error,
please notify us immediately by replying to the message and deleting it
from your computer. Thank you. Fellowes, Inc.

oracle question 🔗 link

oracle question