This discussion is archived
10 Replies Latest reply: Jan 3, 2013 10:29 AM by EdStevens RSS

Listener problem

931717 Newbie
Currently Being Moderated
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 Pro
    Currently Being Moderated
    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 Oracle ACE
    Currently Being Moderated
    Please Post your SQLNET.ORA
     Recreate the sqlnet.ora file manually or using NetCA or NetMgr
  • 3. Re: Listener problem
    931717 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Oracle ACE
    Currently Being Moderated
    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 Journeyer
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Oracle ACE Director
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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 Expert
    Currently Being Moderated
    Hi

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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points