5 Replies Latest reply: Feb 11, 2013 9:31 PM by yakub21 RSS

    Primary Database Server showing Active Standby Database Oracle processes ?

    yakub21
      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
          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
            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-Oracle
              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
                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
                  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.