This discussion is archived
5 Replies Latest reply: Feb 11, 2013 7:31 PM by yakub21 RSS

Primary Database Server showing Active Standby Database Oracle processes ?

yakub21 Newbie
Currently Being Moderated
I just checked one of my primary databases which has an active standby database on a different zone server and I'm seeing the Standby Processes on both the Primary Server and the Standby Server.
The Primary is accessible though I don't understand why the Oracle Standby Processes are showing up on the Primary Database when I do a:
ps -ef|grep pmon

On the Primary Both PMONS show up on the Primary. Any Ideas Why.
Oracle 11gR2 Database Primary Name and Standby.
  • 1. Re: Primary Database Server showing Active Standby Database Oracle processes ?
    mseberg Guru
    Currently Being Moderated
    Hello;

    Odd
    /u01/app/oracle/product/11.2.0.3/rdbms/admin: >ps -ef|grep pmon
    oracle    9580 15912  0 12:33 pts/1    00:00:00 grep pmon
    oracle   15554     1  0 07:47 ?        00:00:00 ora_pmon_PRIMARY
    Only see one on mine. Can you post the full output?

    Best Regards

    mseberg
  • 2. Re: Primary Database Server showing Active Standby Database Oracle processes ?
    CKPT Guru
    Currently Being Moderated
    yakub21 wrote:
    I just checked one of my primary databases which has an active standby database on a different zone server and I'm seeing the Standby Processes on both the Primary Server and the Standby Server.
    The Primary is accessible though I don't understand why the Oracle Standby Processes are showing up on the Primary Database when I do a:
    ps -ef|grep pmon

    On the Primary Both PMONS show up on the Primary. Any Ideas Why.
    Oracle 11gR2 Database Primary Name and Standby.
    Where is proof? Please paste here your findings.
  • 3. Re: Primary Database Server showing Active Standby Database Oracle processes ?
    UweHesse Expert
    Currently Being Moderated
    What do you think is 'the Standby Processes' ? It's not PMON - that process will always be at every started instance regardless which kind of database (or ASM instance) you have.
    Do you see MRP0 (Managed Recovery Process) on the Primary? That would indeed be strange - I hesitate to say impossible :-)

    Kind regards
    Uwe Hesse

    "Don't believe it, test it!"
    http://uhesse.com
  • 4. Re: Primary Database Server showing Active Standby Database Oracle processes ?
    Satishbabu Gunukula Oracle ACE
    Currently Being Moderated
    It looks like you might have some process or scripts with prefix or suffix "Standby" and it is causing the confusion to you.

    If you still see both process provide the output.

    Regards
    http://www.oracleracexpert.com
    ORA-01031: insufficient privileges
    http://www.oracleracexpert.com/2013/02/ora-01031-insufficient-privileges.html
    How to Change Oracle DBNAME and DBID
    http://www.oracleracexpert.com/2013/02/how-to-change-oracle-dbname-and-dbid.html
  • 5. Re: Primary Database Server showing Active Standby Database Oracle processes ?
    yakub21 Newbie
    Currently Being Moderated
    No. After further analysis of the problem I discovered that the System Administrator claims that he created the Solaris 10 Global zone on the Primary Database server and created a Local Zone for the Physical Standby Server. I find that very confusing from the Unix Server configuration perspective because now you have to ask the question about Global and Local Zones. My expectation was that the primary and physical standby would be in its own zone utilizing the carved out resources from the global zone. However the System Administrator argued that you must query the local zone/Global Zone. I simply don't prefer such an approach. I prefer to be able to query the specific processes for a given zone independently so as to confirm optimal configuration of the server.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points