8 Replies Latest reply on May 16, 2016 2:08 AM by GreenMachine

    TNS-12541: TNS:no listener  Connecting to (ADDRESS=(PROTOCOL=TCP)(Host=xof13dtsb01)(Port=1626))

    2963369

      Hello

      after applied jan2016 CPU patch (p21845960_101350_LINUX) on tech oracle home (10.1.2.0) on application server the lsitener not staring ang getting the following error.

       

      LSNRCTL for Linux: Version 10.1.0.5.0 - Production on 04-MAR-2016 08:07:35

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

      Starting /u01/applmgr/apps/tech_st/10.1.2/bin/tnslsnr: please wait...

      TNSLSNR for Linux: Version 10.1.0.5.0 - Production

      System parameter file is /u01/applmgr/inst/apps/FINTST12_xof13dtsb01/ora/10.1.2/network/admin/listener.ora

      Log messages written to /u01/applmgr/inst/apps/FINTST12_xof13dtsb01/logs/ora/10.1.2/network/apps_fintst12.log

      Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=xof13dtsb01.testbwcad.testad.bwc.state.oh.us)(PORT=1626)))

      Connecting to (ADDRESS=(PROTOCOL=TCP)(Host=xof13dtsb01)(Port=1626))

      TNS-01153: Failed to process string: ˜6ƒ

        

      03/04/16-08:07:35 :: adalnctl.sh: exiting with status 1

       

       

      >>

      FNDFS_APPLTOP_xof13dtsb01=

        (DESCRIPTION=

        (ADDRESS_LIST=

        (ADDRESS=(PROTOCOL=tcp)(HOST=XOF13DTSB01.testbwcad.testad.bwc.state.oh.us)(PORT=1626))

        )

        (CONNECT_DATA=

        (SID=FNDFS)

        )

        )

       

       

      [applmgr@xof13dtsb01 admin]$ tnsping "(ADDRESS=(PROTOCOL=tcp)(HOST=XOF13DTSB01.testbwcad.testad.bwc.state.oh.us)(PORT=1626))"

       

      TNS Ping Utility for Linux: Version 10.1.0.5.0 - Production on 04-MAR-2016 22:50:24

       

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

       

      Attempting to contact (ADDRESS=(PROTOCOL=tcp)(HOST=XOF13DTSB01.testbwcad.testad.bwc.state.oh.us)(PORT=1626))

      TNS-12541: TNS:no listener

       

       

      [applmgr@xof13dtsb01 admin]$

       

       

      ANy help appericated

      thanks

      James

       

      Message was edited by: 2963369

        • 1. Re: TNS-12541: TNS:no listener  Connecting to (ADDRESS=(PROTOCOL=TCP)(Host=xof13dtsb01)(Port=1626))
          Narsi M-Oracle

          Hello,

           

          Patch  21845960 is for 10.1.3.5 Application Server i.e., 10.1.3 Oracle Home

          Patch 21845960: CPUOCT2015 TRACKING BUG FOR APPLICATION SERVER 10.1.3.5 UNIX

          Why would you apply it on your Forms Oracle Home.

           

          Hope this helps!!!

           

           

          Regards,

          Narsi

          • 2. Re: TNS-12541: TNS:no listener  Connecting to (ADDRESS=(PROTOCOL=TCP)(Host=xof13dtsb01)(Port=1626))
            2963369

            made a mistake .  rollback from 10.1.2 and applied to 10..1.3

             

            same problem lisnter is not starting

            thanks

            James

            • 3. Re: TNS-12541: TNS:no listener  Connecting to (ADDRESS=(PROTOCOL=TCP)(Host=xof13dtsb01)(Port=1626))
              happy10319

              Hi,

              verify if patching has backed up listener.ora file.

              If yes rename your actual listener.ora and replace it by that backup.

              Restart listener.

              • 4. Re: TNS-12541: TNS:no listener  Connecting to (ADDRESS=(PROTOCOL=TCP)(Host=xof13dtsb01)(Port=1626))
                2963369

                LSNRCTL> start
                Starting /u01/applmgr/apps/tech_st/10.1.2/bin/tnslsnr: please wait...

                TNSLSNR for Linux: Version 10.1.0.5.0 - Production
                System parameter file is /u01/applmgr/inst/apps/FINTST12_xof13dtsb01/ora/10.1.2/network/admin/listener.ora
                Log messages written to /u01/applmgr/apps/tech_st/10.1.2/network/log/listener.log
                Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=xof13dtsb01.testbwcad.testad.bwc.state.oh.us)(PORT=1521)))

                Connecting to (ADDRESS=(PROTOCOL=tcp)(PORT=1521))
                TNS-01153: Failed to process string: ▒6▒

                 

                question system parameterfileis pointing to this file

                /u01/applmgr/inst/apps/FINTST12_xof13dtsb01/ora/10.1.2/network/admin/listener.ora

                 

                there is no port 1521 ? where is it picking it from..

                 

                here is my listener.ora

                 

                [applmgr@xof13dtsb01 appl]$ cat /u01/applmgr/inst/apps/FINTST12_xof13dtsb01/ora/10.1.2/network/admin/listener.ora
                # $Header: admk80ln_ux.sql 120.9 2007/03/09 04:31:05 sbandla ship $
                # LISTENER.ORA For Oracle Applications
                # This file is automatically generated
                APPS_FINTST12 =
                  (ADDRESS_LIST =
                    (ADDRESS= (PROTOCOL= TCP)(Host= xof13dtsb01)(Port= 1626))
                  )
                SID_LIST_APPS_FINTST12 =
                  (SID_LIST =
                    ( SID_DESC = ( SID_NAME = FNDSM )
                                 ( ORACLE_HOME = /u01/applmgr/apps/tech_st/10.1.2 )
                                 ( PROGRAM = /u01/applmgr/apps/apps_st/appl/fnd/12.0.0/bin/FNDSM )
                                 ( envs='MYAPPSORA=/u01/applmgr/apps/apps_st/appl/APPSFINTST12_xof13dtsb01.env,PATH=/usr/bin:/usr/ccs/bin:/bin,FNDSM_SCRIPT=/u01/applmgr/inst/apps/FINTST12_xof13dtsb01/admin/scripts/gsmstart.sh' )
                    )
                    ( SID_DESC = ( SID_NAME = FNDFS  )
                                 ( ORACLE_HOME = /u01/applmgr/apps/tech_st/10.1.2 )
                                 ( PROGRAM = /u01/applmgr/apps/apps_st/appl/fnd/12.0.0/bin/FNDFS )
                                 ( envs='EPC_DISABLED=TRUE,NLS_LANG=American_America.US7ASCII,LD_LIBRARY_PATH=/u01/applmgr/apps/tech_st/10.1.2/lib32:/u01/applmgr/apps/tech_st/10.1.2/lib:/usr/X11R6/lib:/usr/openwin/lib:/u01/applmgr/apps/tech_st/10.1.2/jdk/jre/lib/i386:/u01/applmgr/apps/tech_st/10.1.2/jdk/jre/lib/i386/server:/u01/applmgr/apps/tech_st/10.1.2/jdk/jre/lib/i386/native_threads:/u01/applmgr/apps/apps_st/appl/sht/12.0.0/lib,SHLIB_PATH=/u01/applmgr/apps/tech_st/10.1.2/lib32:/u01/applmgr/apps/tech_st/10.1.2/lib:/usr/X11R6/lib:/usr/openwin/lib:/u01/applmgr/apps/tech_st/10.1.2/jdk/jre/lib/i386:/u01/applmgr/apps/tech_st/10.1.2/jdk/jre/lib/i386/server:/u01/applmgr/apps/tech_st/10.1.2/jdk/jre/lib/i386/native_threads:/u01/applmgr/apps/apps_st/appl/sht/12.0.0/lib,LIBPATH=/u01/applmgr/apps/tech_st/10.1.2/lib32:/u01/applmgr/apps/tech_st/10.1.2/lib:/usr/X11R6/lib:/usr/openwin/lib:/u01/applmgr/apps/tech_st/10.1.2/jdk/jre/lib/i386:/u01/applmgr/apps/tech_st/10.1.2/jdk/jre/lib/i386/server:/u01/applmgr/apps/tech_st/10.1.2/jdk/jre/lib/i386/native_threads:/u01/applmgr/apps/apps_st/appl/sht/12.0.0/lib,APPLFSTT=FINTST12;FINTST12_FO;FINTST12_BALANCE,APPLFSWD=/u01/applmgr/inst/apps/FINTST12_xof13dtsb01/appl/admin;/u01/applmgr/inst/apps/FINTST12_xof13dtsb01/appltmp;/u01/applmgr/apps/apps_st/comn/webapps/oacore/html/oam/nonUix/launchMode/restricted' )
                    )
                  )
                STARTUP_WAIT_TIME_APPS_FINTST12 = 0
                CONNECT_TIMEOUT_APPS_FINTST12 = 10
                TRACE_LEVEL_APPS_FINTST12 = OFF
                LOG_DIRECTORY_APPS_FINTST12 = /u01/applmgr/inst/apps/FINTST12_xof13dtsb01/logs/ora/10.1.2/network
                LOG_FILE_APPS_FINTST12 = APPS_FINTST12
                TRACE_DIRECTORY_APPS_FINTST12 = /u01/applmgr/inst/apps/FINTST12_xof13dtsb01/logs/ora/10.1.2/network
                TRACE_FILE_APPS_FINTST12 = APPS_FINTST12
                ADMIN_RESTRICTIONS_APPS_FINTST12 = ON
                IFILE = /u01/applmgr/inst/apps/FINTST12_xof13dtsb01/ora/10.1.2/network/admin/FINTST12_xof13dtsb01_listener_ifile.ora
                SUBSCRIBE_FOR_NODE_DOWN_EVENT_APPS_FINTST12 = OFF

                • 5. Re: TNS-12541: TNS:no listener  Connecting to (ADDRESS=(PROTOCOL=TCP)(Host=xof13dtsb01)(Port=1626))
                  2963369

                  LSNRCTL> start APPS_FINTST12

                  Starting /u01/applmgr/apps/tech_st/10.1.2/bin/tnslsnr: please wait...

                   

                  TNSLSNR for Linux: Version 10.1.0.5.0 - Production

                  System parameter file is /u01/applmgr/inst/apps/FINTST12_xof13dtsb01/ora/10.1.2/network/admin/listener.ora

                  Log messages written to /u01/applmgr/inst/apps/FINTST12_xof13dtsb01/logs/ora/10.1.2/network/apps_fintst12.log

                  Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=xof13dtsb01.testbwcad.testad.bwc.state.oh.us)(PORT=1626)))

                   

                  Connecting to (ADDRESS=(PROTOCOL=TCP)(Host=xof13dtsb01)(Port=1626))

                  TNS-01153: Failed to process string: ▒6▒

                  • 6. Re: TNS-12541: TNS:no listener  Connecting to (ADDRESS=(PROTOCOL=TCP)(Host=xof13dtsb01)(Port=1626))
                    hsrirajavatsavai

                    Hi 2963369,

                     

                    We are having the exact same issue. Please share the solution if the issue is resolved.

                     

                    Thank you.

                    • 7. Re: TNS-12541: TNS:no listener  Connecting to (ADDRESS=(PROTOCOL=TCP)(Host=xof13dtsb01)(Port=1626))
                      2963369

                      i applied the ias patch on the oracle home caused the issue. I copied oracle home from my backup that resolved the problem.

                       

                      thanks

                      • 8. Re: TNS-12541: TNS:no listener  Connecting to (ADDRESS=(PROTOCOL=TCP)(Host=xof13dtsb01)(Port=1626))
                        GreenMachine

                        did you resolve this issue?  we are having a similar issue after applying patches for JRE 8