EBS R12.2.5 - Autoconfig on DB has ERROR

Beauty_and_dBest

    EBS 12.2.5

    12c

    OL6

     

     

    Hi ALL,

     

    I already cloned our PROD to DR server.

     

    Now, I am restoring PROD latest data to our DR server.

     

    Our PROD and DR has the same file structure.

     

    For example in PROD, we have data at   /u01/oraprod/PROD/db/data

     

    So in our DR server,  we also have data at /u01/oprod/PROD/db/data.

     

    Now I remove DR - data  and replace it with the latest PROD - data.

     

    I was able to startup the database, but I need to run Autoconfig to replace the server node names in the database.

     

    When I run Autoconfig, we encounter error below:

     

     

     

    Executable : /u01/oracle/PSPROD/db/12.1.0/bin/sqlplus

     

    SQL*Plus: Release 12.1.0.2.0 Production on Wed Oct 30 06:06:40 2019

    Copyright (c) 1982, 2014, Oracle.  All rights reserved.

     

    Enter value for 1: Enter value for 2: Enter value for 3: ERROR:

    ORA-12545: Connect failed because target host or object does not exist

     

    ERRORCODE = 1 ERRORCODE_END

    .end std out.

     

    SQLPLUS Executable : /u01/oracle/PSPROD/db/12.1.0/bin/sqlplus

    SQL*Plus: Release 12.1.0.2.0 Production on Wed Oct 30 06:06:40 2019

    Copyright (c) 1982, 2014, Oracle.  All rights reserved.

     

    Enter value for 1: Enter value for 2: Enter value for 3: ERROR:

    ORA-12545: Connect failed because target host or object does not exist

     

     

    adcrobj.sh exiting with status 1

    ERRORCODE = 1 ERRORCODE_END

    .end std out.

     

    WARNING: [AutoConfig Error Report]

    The following report lists errors AutoConfig encountered during each

    phase of its execution.  Errors are grouped by directory and phase.

    The report format is:

          <filename>  <phase>  <return code where appropriate>

     

      [PROFILE PHASE]

      AutoConfig could not successfully execute the following scripts:

        Directory: /u01/oracle/PSPROD/db/12.1.0/appsutil/install/PSPROD_psoracledr

          afdbprf.sh              INSTE8_PRF         1

     

      [APPLY PHASE]

      AutoConfig could not successfully execute the following scripts:

        Directory: /u01/oracle/PSPROD/db/12.1.0/appsutil/install/PSPROD_psoracledr

         adcrobj.sh              INSTE8_APPLY       1

     

    AutoConfig is exiting with status 2

     

    AutoConfig execution completed on Wed Oct 30 06:06:41 2019

     

     

    Please help.........

     

    Kind regards,

    jc

      • 1. Re: EBS R12.2.5 - Autoconfig on DB has ERROR
        yoonas

        Enter value for 1: Enter value for 2: Enter value for 3: ERROR:

        ORA-12545: Connect failed because target host or object does not exist

         

        oerr ora 12545

        12545, 00000, "Connect failed because target host or object does not exist"

        // *Cause: The address specified is not valid, or the program being

        // connected to does not exist.

        // *Action: Ensure the ADDRESS parameters have been entered correctly; the

        // most likely incorrect parameter is the node name.  Ensure that the

        // executable for the server exists (perhaps "oracle" is missing.)

        // If the protocol is TCP/IP, edit the TNSNAMES.ORA file to change the

        // host name to a numeric IP address and try again.

        can you do a

        tnsping <service_name>

        post output

        • 2. Re: EBS R12.2.5 - Autoconfig on DB has ERROR
          Beauty_and_dBest

          Hi Yoonas,

           

          I can ping okay the service name

           

          I can even run sqlplus apps/apps at the appsTier.

           

           

          Kind regards,

          • 3. Re: EBS R12.2.5 - Autoconfig on DB has ERROR
            Maaz Khan

            hi jc,

             

            I would like to know more about your requirement, please let us know if you are trying to clone your current prod to dr?

            prod and dr terms are normally used when you have implemented a disaster recovery solution using Oracle dataguard.

             

            Regards,

            Maaz

            • 4. Re: EBS R12.2.5 - Autoconfig on DB has ERROR
              Beauty_and_dBest

              Hi Maaz,

               

              It is just a simple manual DR. No need for dataguard, although I was also able to setup DR using dataguard

              But for this demo, I only want simple RMAN recovery.

              I have tried it many times, using the following procedure.

               

              RMAN backup PROD

                then copy backup to DR, 

                   then do RMAN restore DR,

                      then open resetlogs,

                         then do cleanup nodes at DR

                            then run autoconfig on dbTier and Appstier.

                               then the instance will startup successfully.

               

               

              But this time, instead of RMAN backup and restore, I only copy the PROD-data folder as cold backup and replace it to the DR-data.

              I believe this is the same to RMAN backup and restore.

               

               

              Please help...

               

              Kind regards,

              • 5. Re: EBS R12.2.5 - Autoconfig on DB has ERROR
                yoonas

                What was the next step after copying?

                • 6. Re: EBS R12.2.5 - Autoconfig on DB has ERROR
                  Beauty_and_dBest

                  Hi Yoonas,

                   

                  The next step was to open the database; 

                  Which is successful. But the node name need cleanup?

                   

                   

                   

                  Then run autoconfig.

                   

                   

                   

                  Kind regards,

                  • 7. Re: EBS R12.2.5 - Autoconfig on DB has ERROR
                    yoonas

                    After you have copied database files you could

                    open a new terminal and

                    run adcfgclone dbtier

                    just like a new clone