How to Start TNS & Listner Process
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: How to Start TNS & Listner Process

Hybrid View

  1. #1
    Join Date
    Nov 2000
    Posts
    224

    Question

    Oracle 8.1.6, Sun/Solaris (2.6)

    I want to connect to the database from Client machine and I need to findout whether Listner process is running or not on Database server. If it is not running then How to Start it.

  2. #2
    Join Date
    Oct 2000
    Posts
    90
    If you log in as Oracle and type

    lsnrctl

    this is the program that controls everything. To find out if it is running, type

    services

    If nothing is running, type

    start

    If it doesn't start anything, you will have to edit the file

    listener.ora

    Best of luck.

  3. #3
    Join Date
    Nov 2000
    Posts
    224
    When I do lsnrctl and then type the services, I got the following errors

    LSNRCTL> services
    Connecting to (ADDRESS=(PROTOCOL=ipc)(KEY=PNPKEY))
    TNS-01103: Protocol specific component of the address is incorrectly specified
    TNS-12541: TNS:no listener
    TNS-12560: TNS:protocol adapter error
    TNS-00511: No listener
    Solaris Error: 2: No such file or directory


    My listener.ora looks like

    trace_level_listener=admin
    trace_directory_listener=/oracle/u01/admin/sqlnet

    listener=
    (ADDRESS= (PROTOCOL=TCP)(HOST=1xx.xx.xx.xx)(PORT=1521))

    sid_list_listener=(SID_LIST=
    (SID_DESC=(SID_NAME=test)
    (ORACLE_HOME=/oracle/u01/8.1.6)
    (ORACLE_SID=test)))

  4. #4
    Join Date
    Apr 2000
    Posts
    126

    Wink How to Start TNS & Listner Process

    Try:

    LISTENER =
    (DESCRIPTION_LIST =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 1xx.xx.xx.xx)(PORT = 1521))
    )
    )
    )

    SID_LIST_LISTENER =
    (SID_LIST =
    (SID_DESC =
    (SID_NAME = test)
    (ORACLE_HOME = /oracle/u01/8.1.6)
    )
    )


  5. #5
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Did you try starting the listener

    lsnrctl start


    then try doing

    lsnrctl services

    # LISTENER.ORA Configuration File:/oracle/u01/8.1.6/network/admin/listener.ora
    # Generated by Oracle configuration tools.

    LISTENER =
    (DESCRIPTION_LIST =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
    )
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = host_name)(PORT = 1521))
    )
    )

    SID_LIST_LISTENER =
    (SID_LIST =
    (SID_DESC =
    (SID_NAME = PLSExtProc)
    (ORACLE_HOME = /oracle/u01/8.1.6)
    (PROGRAM = extproc)
    )
    (SID_DESC =
    (GLOBAL_DBNAME = test)
    (ORACLE_HOME = /oracle/u01/8.1.6)
    (SID_NAME = test)
    )
    )

    trace_level_listener=admin
    trace_directory_listener=/oracle/u01/admin/sqlnet


    Try the above piece of code.

    Sam


  6. #6
    Join Date
    Nov 2000
    Posts
    224
    You are Great Guys.

    Lot of Thanks,


Posting Permissions

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



Click Here to Expand Forum to Full Width