CommVault Forums

Solving Forward - Solving Together
Welcome to CommVault Forums Sign in | Join | Help
in

Oracle Database Status "Unknown"

Last post 01-16-2013, 3:42 AM by Michael Fox. 3 replies.
Sort Posts: Previous Next
  • Oracle Database Status "Unknown"
    Posted: 12-14-2012, 7:06 AM

    Hello,

    we tried to do an Oracle Control File restore with the GUI to the same host. But we were not able to see any other Database Status as "Mounted" or "Unknown". "Unknown" Status is displayed if the instance is in Nomount - Started mode. We should see "Started" according to the doku. This prevents the Control File restore from working. The system gets RMAN errors and the restore goes pending.

    A full DB restore in a "Mounted" Status does work ok.

    It's Oracle on Windows, no Catalog with CV Version 9 and the Oracle iDA.

    Would anybody know the most likely reason for this?

    Should we backup the control file separately with the file iDA since we are not able to restore the Control File via the Oracle iDA?

    Thanks for your help in advance.

    Bernd

  • Re: Oracle Database Status "Unknown"
    Posted: 12-14-2012, 12:02 PM
    • efg is not online. Last active: 04-17-2014, 10:48 AM efg
    • Top 10 Contributor
    • Joined on 02-02-2010
    • CommVault Oceanport NJ
    • Expert
    • Points 877
    • Commvault Global Group

    What are you using for connect string in the GUI?   Are you using just a "/" or a full TNS string like "sys/passwd@servicename"?  If the latter is used, then you MUST have a static listener defined for the database in question.   If not, then you will need a local connect in order to connect with the instance.  If the DB is in a started nomount, you can also verify the settings by trying to connect to the DB using the same connect string that you set in the GUI.   You may be getting an error from TNS about "blocking" connections.   If this is the case, you can add the following directive to the tnsnames.ora file for this database:

    (UR = A)

    If that allows the connection the iDA will also be able to connect.  

    On windows you may need to enable NTS authentication in the sqlnet.ora file to allow a local (connect / as sysdba) connection to work.

     

    Let us know if this helps.


    Ernst F. Graeler
    Senior Technical Lead/Analyst
  • Re: Oracle Database Status "Unknown"
    Posted: 12-18-2012, 4:12 AM

    Hello Ernst,

    we are using a full TNS string like "sys/passwd@servicename". There is a listener defined, like this inside listener.ora:

    (DESCRIPTION =

       (ADDRESS = (PROTOCOL = TCP)(HOST = 10.20.x.y)(PORT = 1521))

    But as it turns out, there is no DNS entry for the IP Address. The servername is not resolveable.

    This might explain why we were not able to connect to the instance.

    We will try to rectify this and do a new test.

    I will keep you posted.

    Thank you for the reply.

  • Re: Oracle Database Status "Unknown"
    Posted: 01-16-2013, 3:42 AM

    BerndMueller_CW:

    Hello Ernst,

    we are using a full TNS string like "sys/passwd@servicename". There is a listener defined, like this inside listener.ora:

    (DESCRIPTION =

       (ADDRESS = (PROTOCOL = TCP)(HOST = 10.20.x.y)(PORT = 1521))

    But as it turns out, there is no DNS entry for the IP Address. The servername is not resolveable.

    This might explain why we were not able to connect to the instance.

    We will try to rectify this and do a new test.

    I will keep you posted.

    Thank you for the reply.

     

    How did you go?

The content of the forums, threads and posts reflects the thoughts and opinions of each author, and does not represent the thoughts, opinions, plans or strategies of CommVault Systems, Inc. ("CommVault") and CommVault undertakes no obligation to update, correct or modify any statements made in this forum. Any and all third party links, statements, comments, or feedback posted to, or otherwise provided by this forum, thread or post are not affiliated with, nor endorsed by, CommVault.
CommVault, CommVault and logo, the “CV” logo, CommVault Systems, Solving Forward, SIM, Singular Information Management, Simpana, CommVault Galaxy, Unified Data Management, QiNetix, Quick Recovery, QR, CommNet, GridStor, Vault Tracker, InnerVault, QuickSnap, QSnap, Recovery Director, CommServe, CommCell, SnapProtect, ROMS, and CommValue, are trademarks or registered trademarks of CommVault Systems, Inc. All other third party brands, products, service names, trademarks, or registered service marks are the property of and used to identify the products or services of their respective owners. All specifications are subject to change without notice.
Close
Copyright © 2014 CommVault | All Rights Reserved. | Legal | Privacy Policy