1 2 3 4 Previous Next 47 Replies Latest reply: Feb 4, 2013 1:11 AM by 968325 Go to original post RSS
      • 15. Re: adcfgclone.pl dbTier gets error
        968325
        i did all this and i did all the solutions in the notes and there are no more lines in the status for listener
        • 16. Re: adcfgclone.pl dbTier gets error
          968325
          [oraprod@emctestdb TEST_emctestdb]$ tnsping TEST

          TNS Ping Utility for Linux: Version 10.2.0.5.0 - Production on 30-JAN-2013 03:28:47

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

          Used parameter files:
          /oracle/oracle/proddb/10.2.0/network/admin//sqlnet_ifile.ora


          Used TNSNAMES adapter to resolve the alias
          Attempting to contact (DESCRIPTION= (ADDRESS=(PROTOCOL=tcp)(HOST=emctestdb)(PORT=1522)) (CONNECT_DATA=(SID=TEST)))
          TNS-12537: TNS:connection closed
          • 17. Re: adcfgclone.pl dbTier gets error
            968325
            [oraprod@emctestdb TEST_emctestdb]$ lsnrctl status TEST

            LSNRCTL for Linux: Version 10.2.0.5.0 - Production on 30-JAN-2013 03:36:02

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

            Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROCTEST))
            STATUS of the LISTENER
            ------------------------
            Alias TEST
            Version TNSLSNR for Linux: Version 10.2.0.5.0 - Production
            Start Date 30-JAN-2013 00:01:47
            Uptime 0 days 3 hr. 34 min. 15 sec
            Trace Level off
            Security ON: Local OS Authentication
            SNMP OFF
            Listener Parameter File /oracle/oracle/proddb/10.2.0/network/admin/TEST_emctestdb/listener.ora
            Listener Log File /oracle/oracle/proddb/10.2.0/network/admin/test.log
            Listening Endpoints Summary...
            (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROCTEST)))
            (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=emctestdb.emceg.com)(PORT=1522)))
            Services Summary...
            Service "PLSExtProc" has 1 instance(s).
            Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
            Service "TEST" has 1 instance(s).
            Instance "TEST", status UNKNOWN, has 1 handler(s) for this service...
            The command completed successfully
            • 18. Re: adcfgclone.pl dbTier gets error
              968325
              SQL*Plus: Release 10.2.0.5.0 - Production on Wed Jan 30 03:39:40 2013

              Copyright (c) 1982, 2010, Oracle. All Rights Reserved.

              Enter value for 1: Enter value for 2: Enter value for 3: ERROR:
              ORA-12537: TNS:connection closed


              ERRORCODE = 1 ERRORCODE_END
              .end std out.

              .end err out.
              • 19. Re: adcfgclone.pl dbTier gets error
                968325
                adcrobj.sh started at Wed Jan 30 03:39:40 EET 2013

                Parameters passed are : -nopromptmsg

                The environment settings are as follows ...

                ORACLE_HOME : /oracle/oracle/proddb/10.2.0
                ORACLE_SID : TEST
                TWO_TASK :
                PATH : /usr/bin:/oracle/oracle/proddb/10.2.0/bin:/usr/bin:/usr/sbin:/oracle/oracle/proddb/10.2.0/jdk/bin:/usr/ccs/bin:/bin:/usr/bin/X11:/usr/local/bin:/usr/bin:/usr/bin:/oracle/oracle/proddb/10.2.0/bin:/usr/bin:/usr/sbin:/oracle/oracle/proddb/10.2.0/jdk/bin:/usr/ccs/bin:/bin:/usr/bin/X11:/usr/local/bin:/usr/bin:/oracle/oracle/proddb/10.2.0/bin:/usr/bin:/usr/sbin:/oracle/oracle/proddb/10.2.0/jdk/bin:/usr/ccs/bin:/bin:/usr/bin/X11:/usr/local/bin:/usr/lib64/qt-3.3/bin:/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:/home/oraprod/bin
                • 20. Re: adcfgclone.pl dbTier gets error
                  yoonas
                  You copied back all the dbtier files and run perl adcfgclone.pl dbTier (As per the note) .

                  try sqlplus <username>/<password>@TEST

                  while your tns ping shows this
                  >
                  Attempting to contact (DESCRIPTION= (ADDRESS=(PROTOCOL=tcp)(HOST=emctestdb)(PORT=1522)) (CONNECT_DATA=(SID=TEST)))
                  TNS-12537: TNS:connection closed
                  >

                  lsnrctl status shows this
                  >
                  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROCTEST)))
                  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=emctestdb.emceg.com)(PORT=1522)))
                  >

                  Can you post the sqlnet.ora and tnsnames.ora

                  Regards
                  Yoonas
                  • 21. Re: adcfgclone.pl dbTier gets error
                    968325
                    [oraprod@emctestdb TEST_emctestdb]$ sqlplus apps/apps@TEST

                    SQL*Plus: Release 10.2.0.5.0 - Production on Wed Jan 30 04:08:57 2013

                    Copyright (c) 1982, 2010, Oracle. All Rights Reserved.

                    ERROR:
                    ORA-12537: TNS:connection closed


                    Enter user-name:


                    I cant find sqlnet.ora in TNS_ADMIN
                    • 22. Re: adcfgclone.pl dbTier gets error
                      968325
                      TNSNAMES


                      TEST = (DESCRIPTION=
                      (ADDRESS=(PROTOCOL=tcp)(HOST=emctestdb)(PORT=1522))
                      (CONNECT_DATA=(SID=TEST))
                      )

                      TEST_LOCAL =
                      (DESCRIPTION=
                      (ADDRESS=(PROTOCOL=tcp)(HOST=emctestdb)(PORT=1522))
                      )

                      TEST_REMOTE =
                      (DESCRIPTION=
                      (ADDRESS=(PROTOCOL=tcp)(HOST=emctestdb)(PORT=1522))
                      )

                      #
                      # Intermedia
                      #
                      extproc_connection_data =
                      (DESCRIPTION=
                      (ADDRESS_LIST =
                      (ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROCTEST))
                      )
                      (CONNECT_DATA=
                      (SID=PLSExtProc)
                      (PRESENTATION = RO)
                      ) )

                      IFILE=/oracle/oracle/proddb/10.2.0/network/admin/TEST_emctestdb/TEST_emctestdb_ifile.ora
                      • 23. Re: adcfgclone.pl dbTier gets error
                        yoonas
                        echo $TNS_ADMIN
                        ping emctestdb
                        see if sqlnet is available at /oracle/oracle/proddb/10.2.0/network/admin/


                        export TNS_ADMIN=/oracle/oracle/proddb/10.2.0/network/admin/TEST_emctestdb

                        sqlplus apps/apps@TEST
                        • 24. Re: adcfgclone.pl dbTier gets error
                          968325
                          [oraprod@emctestdb TEST_emctestdb]$ echo $TNS_ADMIN
                          /oracle/oracle/proddb/10.2.0/network/admin/TEST_emctestdb

                          [oraprod@emctestdb TEST_emctestdb]$ ping emctestdb
                          PING emctestdb.emceg.com (10.10.100.8) 56(84) bytes of data.
                          64 bytes from emctestdb.emceg.com (10.10.100.8): icmp_seq=1 ttl=64 time=0.028 ms
                          64 bytes from emctestdb.emceg.com (10.10.100.8): icmp_seq=2 ttl=64 time=0.015 ms
                          64 bytes from emctestdb.emceg.com (10.10.100.8): icmp_seq=3 ttl=64 time=0.020 ms


                          yes it has sqlnet.ora

                          NAMES.DIRECTORY_PATH=(TNSNAMES, ONAMES, HOSTNAME)
                          SQLNET.EXPIRE_TIME= 10
                          tcp.validnode_checking = yes
                          tcp.invited_nodes=(EMCPROD.emceg.com, EMCPRODDB.emceg.com)


                          IFILE=/oracle/oracle/proddb/10.2.0/network/admin//sqlnet_ifile.ora



                          [oraprod@emctestdb admin]$ export TNS_ADMIN=/oracle/oracle/proddb/10.2.0/network/admin/TEST_emctestdb
                          [oraprod@emctestdb admin]$ sqlplus apps/apps@TEST

                          SQL*Plus: Release 10.2.0.5.0 - Production on Wed Jan 30 04:46:40 2013

                          Copyright (c) 1982, 2010, Oracle. All Rights Reserved.

                          ERROR:
                          ORA-12537: TNS:connection closed


                          Enter user-name:
                          • 25. Re: adcfgclone.pl dbTier gets error
                            yoonas
                            Change the setting in sqlnet.ora

                            From
                            tcp.validnode_checking = yes
                            tcp.invited_nodes=(EMCPROD.emceg.com, EMCPRODDB.emceg.com)
                            to
                            tcp.validnode_checking = no
                            ##tcp.invited_nodes=(EMCPROD.emceg.com, EMCPRODDB.emceg.com)

                            or

                            tcp.validnode_checking = yes
                            tcp.invited_nodes=(emctestdb.emceg.com, 10.10.100.8)

                            lsnrctl stop TEST
                            lsnrctl start TEST

                            sqlplus apps/apps@TEST
                            • 26. Re: adcfgclone.pl dbTier gets error
                              968325
                              ok thank you it solved my problem now and i ran autoconfig and its successful . but should i run the adcfgclone.pl dbTier again or it will crash the DB ?
                              • 27. Re: adcfgclone.pl dbTier gets error
                                yoonas
                                No, try adcfgclone.pl on appsTier
                                • 28. Re: adcfgclone.pl dbTier gets error
                                  968325
                                  is that mean adcfgclone.pl dbTier is completed successful ?
                                  • 29. Re: adcfgclone.pl dbTier gets error
                                    yoonas
                                    It could be that the issue we resolved now was stopping adcfgclone.pl from successfull completion, from the log you can see the it was not able to get connection to database. When we tried autoconfig before it was not able to run successfully. Now you are able to run autoconfig so we can assume if this issue were no there adcfgclone.pl woul have completed successfully !.

                                    So try running adcfgclone.pl on appsTier,

                                    if you run adcfgclone.pl dbTier it will recreate your database so you may have to delete those files and copy again from source..

                                    _Troubleshooting RapidClone issues with Oracle Applications 11i [ID 364565.1]_

                                    Edited by: yoonus on Jan 30, 2013 7:36 AM

                                    Edited by: yoonus on Jan 30, 2013 7:38 AM