ORA-02068: severe error from ORAMVS

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • karpalmera
    New Member
    • Jun 2007
    • 14
    #1

    ORA-02068: severe error from ORAMVS

    We have checked the status of listener and it's okay.
    ORAORD7, TNSG473 & G4G407 are okay.
    Still, we are encountering this problem when trying to connect to DB2.
    =============== =============== =============== ======
    Oracle7 Server Release 7.2.3.0.0 - Production Release
    With the distributed option
    PL/SQL Release 2.2.3.0.0 - Production

    SQL> desc tablev@oramvs
    ERROR:
    ORA-02068: following severe error from ORAMVS
    ORA-01033: ORACLE initialization or shutdown in progress
    =============== =============== =============== ======
    We can do SQL Select in Oracle but not in ORAMVS.
    What could possibly be the problem in our ORACLE Gateway?
    How can we check where to look for the error details?


    thank you!
    Tags: None
    • debasisdas
      Recognized Expert Expert
      • Dec 2006
      • 8119
      #2
      What is this ORAMVS ?

        Comment

        • karpalmera
          New Member
          • Jun 2007
          • 14
          #3
          Originally posted by debasisdas
          What is this ORAMVS ?

          ORAMVS is our Oracle in MVS(Multi Virtual Storage).
          Oracle in Mainframe. Our mainframe is OS/390.

          Our mainframe is using DB2.

          Background: We need this ORACLE-DB2 connection because we make view tables in oracle for DB2 base tables.

          thanks!

            Comment

            • subashsavji
              New Member
              • Jan 2008
              • 93
              #4
              Originally posted by karpalmera
              We have checked the status of listener and it's okay.
              ORAORD7, TNSG473 & G4G407 are okay.
              Still, we are encountering this problem when trying to connect to DB2.
              =============== =============== =============== ======
              Oracle7 Server Release 7.2.3.0.0 - Production Release
              With the distributed option
              PL/SQL Release 2.2.3.0.0 - Production

              SQL> desc tablev@oramvs
              ERROR:
              ORA-02068: following severe error from ORAMVS
              ORA-01033: ORACLE initialization or shutdown in progress
              =============== =============== =============== ======
              We can do SQL Select in Oracle but not in ORAMVS.
              What could possibly be the problem in our ORACLE Gateway?
              How can we check where to look for the error details?


              thank you!
              may be useful

              the error messages succeeding the ORA-02068 will
              indicate the type/nature of problem that lead to the severe error.

              In addition, you may want to check the alert log of the remote
              database and the udump directory.

              As an aside, you can also close any existing db links before using a
              db link. Not a real issue with Oracle to Oracle, but a problem when
              dealing with other databases that will time out the connection -
              causing the next SQL on that db link to fail as Oracle attempts to
              re-use it. Executing the exact same SQL immediately again works as
              Oracle will create a brand new (and active) db link.

              Using this technique of closing a db link which has not been used for
              some time by that session (before using that link name again), can
              save you a lot of exception coding.

                Comment

                Previous template Next
                Working...