1 2 Previous Next 18 Replies Latest reply on Dec 10, 2015 6:03 AM by Beauty_and_dBest

    Cloning error

    Beauty_and_dBest

      Hi ALL,

       

      R12.1.3

      RHEL6

       

      I am cloning my db tier and it was completed and started.

      The clone is exactly same image as the source even the SID and folder structures.

      The difference only is the server hostname.

       

      When I run the shutdown command:

      I got error:

       

      Logfile: /u01/oracle/PROD/db/tech_st/11.1.0/appsutil/log/PROD_erp/addlnctl.txt

      You are running addlnctl.sh version 120.1.12010000.4

      Shutting down listener process PROD ...

      LSNRCTL for Linux: Version 11.1.0.7.0 - Production on 09-DEC-2015 13:16:04

      Copyright (c) 1991, 2008, Oracle.  All rights reserved.

      Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=erp.andsons.com)(PORT=1523)))

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

      TNS-12560: TNS:protocol adapter error

        TNS-00515: Connect failed because target host or object does not exist

       

      addlnctl.sh: exiting with status 1

       

       

      The database was shutdown okay, but the listener is not

      I noticed that the HOST  is still the old one and port=1523 , when i cloned it as 1521?

       

      Please help...

       

      Thanks,

      jc

        • 1. Re: Cloning error
          Hussein Sawwan-Oracle

          Change the port in the listener.ora file and start the listener. If it starts successfully edit the database context file to use same port "1521" ("s_dbport"), run AutoConfig and start/stop db/listener then.

           

          Thanks,

          Hussein

          1 person found this helpful
          • 2. Re: Cloning error
            Beauty_and_dBest

            Hi hussein,

             

            I just rerun the postclone, but I got different error:

             

            APPS Password : Log file located at /u01/oracle/PROD/db/tech_st/11.1.0/appsutil/log/PROD_erp2/ApplyDBTier_12091354.log

              |      0% completed       RC-00110: Fatal: Error occurred while relinking of ApplyDBTechStack

             

            ERROR while running Apply...

            Wed Dec  9 13:55:23 2015

             

            ERROR: Failed to execute /u01/oracle/PROD/db/tech_st/11.1.0/appsutil/clone/bin/adclone.pl

             

             

            It seems my $PATH is not set correctly. I do not know what value to set it to.

             

            Please help...

             

            Thanks.

            • 3. Re: Cloning error
              Hussein Sawwan-Oracle

              Why did you have to run postclone?

               

              There should be more details about the error in the log file.

               

              Thanks,

              Hussein

              1 person found this helpful
              • 4. Re: Cloning error
                Beauty_and_dBest

                Hi,

                 

                I doing post clone  believing it will set correct the variables

                The problem maybe because I copied the bash_profile from my source. hence it was confused about the old variables being set?

                 

                # User specific environment and startup programs

                export ORACLE_BASE=/u01/oracle/PROD

                export ORACLE_HOME=$ORACLE_BASE/db/tech_st/11.1.0

                export ORACLE_SID=PROD

                export LD_LIBRARY_PATH=$OEACLE_HOME/lib:$ORACLE_HOME/ctx/lib

                export ORA_NLS10=$ORACLE_HOME/nls/data/9idata

                 

                . $ORACLE_HOME/PROD_erp.env

                export BDUMP=$ORACLE_HOME/admin/PROD_erp/diag/rdbms/prod/PROD/trace

                PATH=$PATH:$HOME/bin:$ORACLE_HOME/bin:$ORACLE_HOME/lib:$ORACLE_HOME/OPatch:$ORACLE_HOME/appsutil/scripts/PROD_erp

                 

                 

                The source is PROD_erp  but the target should be PROD_erp2.

                But what is set is PROD_erp.

                 

                 

                Thanks

                • 5. Re: Cloning error
                  Beauty_and_dBest

                  Hi hussein,

                   

                  I my clone corrupted now?

                  Do I need to unzip the backup again to start a new clone?

                   

                  Thanks,

                  • 6. Re: Cloning error
                    Hussein Sawwan-Oracle

                    You haven't posted any details about the error yet hence we can't tell.

                     

                    If you want to reclone then unset those variables on the target node, unzip and run postclone again.

                     

                    Thanks,

                    Hussein

                    1 person found this helpful
                    • 7. Re: Cloning error
                      Beauty_and_dBest

                      I can not understand why my postclone was successful the first time?

                       

                      I want to save this clone as it will take time to go back again to get a new one.

                       

                      I will first locate the error logs.

                       

                      Thanks.

                      • 8. Re: Cloning error
                        Beauty_and_dBest

                        Hi hussein,

                         

                        I got this error log:

                         

                        Skipping Profile Phase

                        Skipping Apply Phase

                         

                        [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>

                         

                          [INSTANTIATE PHASE]

                          AutoConfig could not successfully instantiate the following files:

                            Directory: /u01/oracle/PROD/db/tech_st/11.1.0/appsutil/install/PROD_erp2

                              adcrdb.sh               INSTE8

                         

                        AutoConfig is exiting with status 1

                         

                        RC-50014: Fatal: Execution of AutoConfig was failed

                        Raised by oracle.apps.ad.clone.ApplyDBTechStack

                         

                         

                        Please help,

                         

                        Thanks.

                        • 9. Re: Cloning error
                          Hussein Sawwan-Oracle

                          Search the log file for adcrdb.sh and you should find more details about the error. Or upload the log file for us to review (Activity > Upload a File).

                           

                          Thanks,

                          Hussein

                          1 person found this helpful
                          • 10. Re: Cloning error
                            Beauty_and_dBest

                            Hi hussein,

                             

                            I can not find that "action" to upload file

                             

                            AC-00423: Template file: /u01/oracle/PROD/db/tech_st/11.1.0/appsutil/template/adcrdb.sh missing from file system.

                            Raised by oracle.apps.ad.autoconfig.InstantiateProcess

                             

                             

                            Thanks.

                            • 11. Re: Cloning error
                              Beauty_and_dBest

                              Hi hussein,

                               

                              I uploaded the file.

                               

                               

                              Thanks,

                              • 12. Re: Cloning error
                                Hussein Sawwan-Oracle

                                You have 2 errors in the log:

                                 

                                1) Using make file "ins_emagent.mk" for linking SYSMAN utilities...

                                Error while running adlnkoh.sh.

                                  return code = .16

                                Please check logfile located at /u01/oracle/PROD/db/tech_st/11.1.0/appsutil/log/PROD_erp2/make_12091431.log

                                 

                                2)

                                AC-00423: Template file: /u01/oracle/PROD/db/tech_st/11.1.0/appsutil/template/adcrdb.sh missing from file system.

                                Raised by oracle.apps.ad.autoconfig.InstantiateProcess

                                 

                                For #1, check the make log file for details about the error.

                                 

                                For #2, copy the file from the source node if it doesn't exist.

                                 

                                Thanks,

                                Hussein

                                1 person found this helpful
                                • 13. Re: Cloning error
                                  Beauty_and_dBest

                                  Thanks hussein,

                                   

                                  I checking now..brb

                                  • 14. Re: Cloning error
                                    Pravin Takpire

                                    If database is up then you don't need to run adcfgclone. You can do with adautconfig. Just change the listener.ora details, restart listener. Change XML file to reflect correct values and run autconfig

                                    regards

                                    Pravin

                                    1 person found this helpful
                                    1 2 Previous Next