Results 1 to 2 of 2

Thread: listner problem

  1. #1
    Join Date
    Nov 2003
    Posts
    2

    Unanswered: listner problem

    I installed oracle 8.1.7 EE on windows 2000 server (SP4). At the end of the installation the "Net8 Configuration" doesn't end the configuration stopping its process on "lsnrctl start LISTENER". I kill the LSNRCTL process and the setup continued.

    I have tried to setup the listener using the "Net8 Configuration Assistant" tools but at the end of the configuration the process is stopped.

    I have also seen that running svrmgrl the tools return "ORA-12560: TNS:protocol adapter error".

    Thanks in advance.

    Following my listener.ora configuration:

    # LISTENER.ORA Network Configuration File: D:\Oracle\Ora81\network\admin\listener.ora
    # Generated by Oracle configuration tools.

    LISTENER =
    (DESCRIPTION_LIST =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST =192.168.1.239)(PORT = 1521))
    )
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST =127.0.0.1)(PORT = 1521))
    )
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
    )
    )
    )

    SID_LIST_LISTENER =
    (SID_LIST =
    (SID_DESC =
    (SID_NAME = PLSExtProc)
    (ORACLE_HOME = D:\Oracle\Ora81)
    (PROGRAM = extproc)
    )
    )

  2. #2
    Join Date
    Oct 2003
    Location
    Slovakia
    Posts
    482

    Re: listner problem

    Originally posted by fabio.lanciotti
    I installed oracle 8.1.7 EE on windows 2000 server (SP4). At the end of the installation the "Net8 Configuration" doesn't end the configuration stopping its process on "lsnrctl start LISTENER". I kill the LSNRCTL process and the setup continued.

    I have tried to setup the listener using the "Net8 Configuration Assistant" tools but at the end of the configuration the process is stopped.

    I have also seen that running svrmgrl the tools return "ORA-12560: TNSrotocol adapter error".

    Thanks in advance.

    Following my listener.ora configuration:

    # LISTENER.ORA Network Configuration File: D:\Oracle\Ora81\network\admin\listener.ora
    # Generated by Oracle configuration tools.

    LISTENER =
    (DESCRIPTION_LIST =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST =192.168.1.239)(PORT = 1521))
    )
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST =127.0.0.1)(PORT = 1521))
    )
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
    )
    )
    )

    SID_LIST_LISTENER =
    (SID_LIST =
    (SID_DESC =
    (SID_NAME = PLSExtProc)
    (ORACLE_HOME = D:\Oracle\Ora81)
    (PROGRAM = extproc)
    )
    )

    It indicates that Oracle client does not know what instance to connect to or what TNS alias to use.
    You need set the ORACLE_SID in your enviroment

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •