1 Reply Latest reply on Sep 16, 2013 5:03 PM by Courtney Llamas-Oracle

    EMDIAG Utility Issue 1.0


      EMDIAG Utility does not work:


      [oracle@yyyyyyyy bin]$ echo $ORACLE_HOME
      [oracle@yyyyyyyy bin]$ echo $EMDIAG_HOME
      [oracle@yyyyyyyy bin]$ pwd
      [oracle@yyyyyyyy bin]$ ./repvfy version

      Please enter the SYSMAN password:

      repvfy 2013.0830 - EMDIAG - Repository verification
      repvfy <options> <commands>

      Error connecting to the database.
      TNS = host=localhost;sid=xxxxxx
      ORA-12541: TNS:no listener (DBD ERROR: OCIServerAttach) at /prog/app/oracle/product/11.2.0/db_1/emdiag/bin/repvfy.pl line 2133

      --- TNSPING output ---

      TNS Ping Utility for Linux: Version - Production on 13-SEP-2013 12:19:32

      Copyright (c) 1997, 2011, Oracle.  All rights reserved.

      Used parameter files:

      TNS-03505: Failed to resolve name

      --- TNSPING output ---


      Similar issue previously reported:

      EMDIAG utility issue



      Please advise.



      Jagan Chintalapani

        • 1. Re: EMDIAG Utility Issue 1.0
          Courtney Llamas-Oracle

          Have you setup the repvfy.cfg file or passed the tns?


          • The TNS descriptor may be omitted if:
          • repvfy runs from the repository database $ORACLE_HOME
          • ORACLE_SID is set to the SID of the Cloud Control database repository
          • the database repository is listened on port 1521
          • You can also create a repvfy.cfg file and store it in the <EMDIAG_HOME>/cfg directory. This file can be used to supply input parameters instead of passing them at the command line. A template file called repvfy.cfg.template, with a configuration example is present in the /cfg directory. Copy this file and rename the copy to repvfy.cfg for customization.
            Consult the following note for additional information on the repvfy configuration file:
            Note 421600.1 - EMDIAG REPVFY Kit - How to Configure the 'repvfy.cfg' File