10 Replies Latest reply: Jan 3, 2013 12:38 PM by BelMan RSS

    Listener problem

    931717
      Hello,

      I am trying to start my listener and its unable to start and giving me this error.Kindly tell me what to do .

      Thanks,
      928714.




      Started with pid=14915
      Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROCGss)))
      Error listening on: (ADDRESS=(PROTOCOL=TCP)(Host=apps55.oracle.com)(Port=1521))
      TNS-12532: TNS:invalid argument
      TNS-12560: TNS:protocol adapter error
      TNS-00502: Invalid argument
      Linux Error: 515: Unknown error 515
      No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROCGss)))
        • 1. Re: Listener problem
          Niket Kumar
          post tour listener.ora file.


          listener.ora file should look like below.

          SID_LIST_LISTENER =
          (SID_LIST =
          (SID_DESC =
          (SID_NAME = PLSExtProc)
          (ORACLE_HOME = "ORACLE_HOME PATH")
          (PROGRAM = extproc)
          )
          (SID_DESC =
          (SID_NAME = CLRExtProc)
          (ORACLE_HOME = "ORACLE_HOME PATH")
          (PROGRAM = extproc)
          )
          )

          LISTENER =
          (DESCRIPTION_LIST =
          (DESCRIPTION =
          (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
          (ADDRESS = (PROTOCOL = TCP)(HOST = "SERVER_NAME")(PORT = 1521))
          )
          )
          • 2. Re: Listener problem
            Osama_Mustafa
            Please Post your SQLNET.ORA
             Recreate the sqlnet.ora file manually or using NetCA or NetMgr
            • 3. Re: Listener problem
              931717
              My listener.ora file looks like this.


              $Header: ad8ilsnr.ora 115.7 2010/04/14 06:16:10 upinjark ship $
              #
              # ###############################################################
              #
              # This file is automatically generated by AutoConfig. It will be read and
              # overwritten. If you were instructed to edit this file, or if you are not
              # able to use the settings created by AutoConfig, refer to Metalink document
              # 165195.1 for assistance.
              #
              # ###############################################################

              #

              #
              # Net8 definition for Database listener
              #

              Gss =
              (ADDRESS_LIST =
              (ADDRESS= (PROTOCOL= IPC)(KEY= EXTPROCGss))
              (ADDRESS= (PROTOCOL= TCP)(Host= apps55.oracle.com )(Port= 1521))
              )
              1,1 Top

              SID_LIST_Gss =
              (SID_LIST =
              (SID_DESC =
              (ORACLE_HOME= /proddb/gssdb/9.2.0)
              (SID_NAME = Gss)
              )
              (SID_DESC =
              (SID_NAME = PLSExtProc)
              (ORACLE_HOME = /proddb/gssdb/9.2.0)
              (PROGRAM = extproc)
              )
              )

              STARTUP_WAIT_TIME_Gss = 0
              CONNECT_TIMEOUT_Gss = 10
              TRACE_LEVEL_Gss = OFF

              LOG_DIRECTORY_Gss = /proddb/gssdb/9.2.0/network/admin
              LOG_FILE_Gss = Gss
              TRACE_DIRECTORY_Gss = /proddb/gssdb/9.2.0/network/admin
              TRACE_FILE_Gss = Gss
              ADMIN_RESTRICTIONS_Gss = OFF


              IFILE=/proddb/gssdb/9.2.0/network/admin/Gss_apps55/listener_ifile.ora
              • 4. Re: Listener problem
                931717
                My sqlnet.ora file looks like this.

                ###############################################################
                #
                # This file is automatically generated by AutoConfig. It will be read and
                # overwritten. If you were instructed to edit this file, or if you are not
                # able to use the settings created by AutoConfig, refer to Metalink document
                # 165195.1 for assistance.
                #
                #$Header: NetServiceHandler.java 115.59 2010/05/13 07:23:09 upinjark ship $
                #
                ###############################################################

                NAMES.DIRECTORY_PATH=(TNSNAMES, ONAMES, HOSTNAME)
                SQLNET.EXPIRE_TIME= 10
                tcp.validnode_checking = yes
                tcp.invited_nodes=(APPS56.oracle.com, APPS55.oracle.com)


                IFILE=/proddb/gssdb/9.2.0/network/admin/Gss_apps55/sqlnet_ifile.ora
                ~
                ~
                ~
                ~
                ~
                • 5. Re: Listener problem
                  Osama_Mustafa
                  928714 wrote:
                  My sqlnet.ora file looks like this.

                  ###############################################################
                  #
                  # This file is automatically generated by AutoConfig. It will be read and
                  # overwritten. If you were instructed to edit this file, or if you are not
                  # able to use the settings created by AutoConfig, refer to Metalink document
                  # 165195.1 for assistance.
                  #
                  #$Header: NetServiceHandler.java 115.59 2010/05/13 07:23:09 upinjark ship $
                  #
                  ###############################################################

                  NAMES.DIRECTORY_PATH=(TNSNAMES, ONAMES, HOSTNAME)
                  SQLNET.EXPIRE_TIME= 10
                  tcp.validnode_checking = yes
                  tcp.invited_nodes=(APPS56.oracle.com, APPS55.oracle.com)


                  IFILE=/proddb/gssdb/9.2.0/network/admin/Gss_apps55/sqlnet_ifile.ora
                  ~
                  ~
                  ~
                  ~
                  ~
                  your sqlnet.ora is corrupted , recreate it again as i told you and restart listener please
                  • 6. Re: Listener problem
                    Dave Rabone
                    Sqlnet.ora looks ok at first glance, but listener.ora has been edited, probably with vi.

                    1,1 top looks to me like a vi command which has ended up in the file.

                    Remove that, and reverse the order of the Sid_list_gss and gss entries in the file
                    • 7. Re: Listener problem
                      931717
                      Hello,
                      I removed sqlnet.ora file and listener started up.So is it ok without sqlnet.ora file in the instance?


                      Thanks,
                      928714.
                      • 8. Re: Listener problem
                        Srini Chavali-Oracle
                        If this is an EBS install, you should not be editing or messing with these files. Autoconfig will recreate them when it is run the next time.

                        Pl post EBS related issues in the EBS forums - https://forums.oracle.com/forums/category.jspa?categoryID=3 -

                        HTH
                        Srini
                        • 9. Re: Listener problem
                          EdStevens
                          928714 wrote:
                          Hello,
                          I removed sqlnet.ora file and listener started up.So is it ok without sqlnet.ora file in the instance?


                          Thanks,
                          928714.
                          If there is no listener.ora, the listener will start with all default values. And if everything else is default, the databased instance(s) will register themselves with the listener.
                          sqlnet.ora provides some run-time values to both client and listener. If there is no sqlnet.ora, all values will be assumed to be default.

                          as for "without sqlnet.ora file in the *instance*" (emphasis mine), these are files to configure the operation of TNS. They do not belong to an instance and are not instance specific.
                          • 10. Re: Listener problem
                            BelMan
                            Hi

                            Make sure that the hostname and IP are listed in hosts file in linux etc then start the listener