1 2 Previous Next 19 Replies Latest reply on Mar 3, 2016 1:23 AM by Hussein Sawwan-Oracle

    Error while running adcfgclone.pl on appsTier

    Noname123

      1- I have done the EBS r12 clone. 
      2- I have run the autoconf on DB tier.
      3- I have run the adcfgclone.pl on appsTier
      but when it encountered errors.

       

       

       

      Here is the error:

      RC-40201: Unable to connect to Database <instance_name>

       

      The following is the tail of the adcfgclone.pl completion with error:

      ERROR while running Apply...

      Tue Mar  1 16:59:11 2016

       

      ERROR: Failed to execute /apps/apps/prod/apps/apps_st/comn/clone/bin/adclone.pl

       

       

       

       

      The following is the error messages from the log of applying adcfgclone.pl session :

      INFO: Could not get the DB connection

      s_dbSid is set to s_dbSid , not to DB Name

       

       

       

       

      INFO: Could not get the DB  connection

      s_contextname is not updated

       

       

       

       

      INFO: Could not get the DB Connection

      s_dbSidLower is not updated

       

       

      Checking Proxy Setting

      Source values

              s_proxyhost :

              s_proxyport :

      RC-50219: Warning: Database connection was not possible. Retaining the source value for s_applptmp.

      Resetting APPS JDBC URL

       

       

       

       

       

      How to solve that?

        • 1. Re: Error while running adcfgclone.pl on appsTier
          happy10319

          Hi,

          can you connect to database in sqlplus from appsTier ?

           

          If yes run :

          select * from v$instance;

           

          and post the row returned.

           

          Also take a look in alertlog of database.

           

          Regards.

          • 2. Re: Error while running adcfgclone.pl on appsTier
            Noname123

            I went to APPL_TOP and executed sqlplus
            but it returned the following error:
            ORA-12541: TNS:no listener

             


            I logged in to the database from the dbTier to get the

            path of alert log file and It appeared that I am getting

            an old value of an old node (source node) instead of the

            new cloned one.  I will clean the fnd_nodes and then I will return

            to you and see if what result I will get.

            • 3. Re: Error while running adcfgclone.pl on appsTier
              Noname123

              It says no listener

              ORA-12541: TNS:no listener

              • 4. Re: Error while running adcfgclone.pl on appsTier
                happy10319

                Then you should verify if listener is running :

                ps -ef | grep -i listener

                And also verify alertlog if database is up.

                If listener is not running you may have to run it but beofre that verify in listner.log if any reason for that.

                If database is not up verify why and then run dbctrl start.

                 

                Regards.

                • 5. Re: Error while running adcfgclone.pl on appsTier
                  Noname123

                  I have run the listener and I got this

                  $ lsnrctl start APPS_TEST5

                   

                   

                   

                  :TNS-01151: Missing listener name, APPS_TEST5, in LISTENER.ORA

                   

                   

                   

                  I only have the database listener:

                  $ps -ef | grep lsnr

                  oratest5  3791     1  0 17:18 ?        00:00:00 /Stage/prodDB11gr2/prod/db/tech_st/11.2.0.3/bin/tnslsnr TEST5 -inherit

                  oratest5 18242 24283  0 19:20 pts/5    00:00:00 grep lsnr

                  • 6. Re: Error while running adcfgclone.pl on appsTier
                    Noname123

                    The database is up

                     

                    Now how to solve the error?

                    • 7. Re: Error while running adcfgclone.pl on appsTier
                      Noname123

                      I have run the apps listener from INST_TOP
                      but I got this error in the log file

                      TNS-01155: Incorrectly specified SID_LIST_APPS_TEST5 parameter in LISTENER.ORA

                      NL-00303: syntax error in NV string

                      • 8. Re: Error while running adcfgclone.pl on appsTier
                        happy10319

                        verify the content of LISTENER.ORA.

                        You can post it here.

                        Make a copy of it.

                        Edit it and correct it.

                        Run listener until no error in your listener log.

                         

                        Regards.

                        • 9. Re: Error while running adcfgclone.pl on appsTier
                          Noname123


                          this is the database listener.
                          $ORACLE_HOME/network/admin/<context_name>
                          vi listener.ora

                          TRACE_LEVEL_TEST5 = OFF

                           

                           

                          LOG_DIRECTORY_TEST5 = /Stage/prodDB11gr2/prod/db/tech_st/11.2.0.3/network/admin

                          LOG_FILE_TEST5 = TEST5

                          TRACE_DIRECTORY_TEST5 = /Stage/prodDB11gr2/prod/db/tech_st/11.2.0.3/network/admin

                          TRACE_FILE_TEST5 = TEST5

                          ADMIN_RESTRICTIONS_TEST5 = ON

                          SUBSCRIBE_FOR_NODE_DOWN_EVENT_TEST5 = OFF

                           

                           

                           

                           

                          # added parameters for bug# 9286476

                          LOG_STATUS_TEST5  =  ON

                          INBOUND_CONNECT_TIMEOUT_TEST5 = 60

                           

                           

                          # ADR is only applicable for 11gDB

                          DIAG_ADR_ENABLED_TEST5  = ON

                          ADR_BASE_TEST5 = /Stage/prodDB11gr2/prod/db/tech_st/11.2.0.3/admin/<sid_hostname>

                           

                           

                           

                           

                          IFILE=/Stage/prodDB11gr2/prod/db/tech_st/11.2.0.3/network/admin/sid_hostname/listener_ifile.ora

                           


                          where to find the applications listener?sorry i am new to oracle apps.

                          • 10. Re: Error while running adcfgclone.pl on appsTier
                            happy10319

                            run a find for listener_ifile.ora on your apps tier.

                             

                            In general you do not need (if I do not make a big mistake ) listener on apps tiers. You need just tnsnames.ora on it.

                             

                             

                            As I can see there is no script to run listener on apps tiers in following folder :

                            COMMON_TOP/admin/scripts/<CONTEXT_NAME>

                            directory, where <CONTEXT_NAME> is the name of the database instance

                             

                            Then I think yes database  listener is only on database tier.

                             

                            Is there anything wrong with your listener.ora on database tier ?

                            Other wise rename listener.ora and restart listener and try to tnsping or connect using :

                            sqlplus apps/apps@databasename

                             

                            Regards.

                            • 11. Re: Error while running adcfgclone.pl on appsTier
                              Noname123

                              I haven't changed anything in the listener.ora file.

                               

                              What I did is:
                              1- I set the environmental variable file  in the db tier.
                                  Then, i went to the apps tier and logged in using sqlplus apps user.

                               

                              I noticed that when I set the environmental variable of apps tier then

                              it fails (no listener error) to log in using apps user.

                               

                               

                              So, now I am able to log in using sqlplus apps from apps tier  (without setting the environmental variables file of db tier  "without setting the apps tier env variables" )

                               

                              Then I tried this time to run adcfgclone.pl on apps Tier but it failed with the same error that made me open this discussion:
                              RC-40201: Unable to connect to Database <instance_name>




                              Now, how to proceed with solving the error?

                              • 12. Re: Error while running adcfgclone.pl on appsTier
                                happy10319

                                can you see in adcfgclone.log at which step it fails ?

                                • 13. Re: Error while running adcfgclone.pl on appsTier
                                  Noname123

                                  It is failing after entering the port number...Here is the log content:

                                  -------------------ADX Database Utility Finished---------------

                                   

                                   

                                   

                                   

                                   

                                   

                                  StackTrace:

                                  java.lang.Exception: Cant connect to database using DBUtil

                                          at oracle.apps.ad.context.CloneContext.checkDatabaseConnection(CloneContext.java:3745)

                                          at oracle.apps.ad.context.CloneContext.setDatabaseName(CloneContext.java:4577)

                                          at oracle.apps.ad.context.CloneContext.doClone(CloneContext.java:620)

                                          at oracle.apps.ad.context.CloneContext.main(CloneContext.java:5196)

                                   

                                   

                                  RC-40201: Unable to connect to Database TEST5.

                                   

                                   

                                  INFO: Could not get the DB connection

                                  Defaulting s_dbGlnam to s_dbSid

                                   

                                   

                                   

                                   

                                  INFO: Could not get the DB connection

                                  s_dbSid is set to s_dbSid , not to DB Name

                                   

                                   

                                   

                                   

                                  INFO: Could not get the DB  connection

                                  s_contextname is not updated

                                   

                                   

                                   

                                  Checking Proxy Setting

                                  Source values

                                          s_proxyhost :

                                          s_proxyport :

                                  RC-50219: Warning: Database connection was not possible. Retaining the source value for s_applptmp.

                                  Resetting APPS JDBC URL

                                  • 14. Re: Error while running adcfgclone.pl on appsTier
                                    happy10319

                                    by :

                                    "It is failing after entering the port number."

                                     

                                    Which port ? Database port ?

                                    Do you mean entering port number by you ? Then verify if it's the correct port.

                                    1 2 Previous Next