Page 1 of 2 12 LastLast
Results 1 to 15 of 18
  1. #1
    Join Date
    Oct 2003
    Posts
    10

    Unanswered: 9i - Listener error

    Hi all.
    I am having a few difficulties. Initially i installed 9i software only to set about creating a db and listener service manually (more fool me). Anyway i created the db easily enough (oradim) and tried from there to create the listener service. At this point i am not too sure what is going on as i dont understand where or how the listener service is created, if someone could explain that to me it would be great!

    I have edited the listener.ora file and tnsnames.ora file and sqlnet.ora file for a db i have created called "Newdb".
    THe files are:
    Listener.ora
    LISTENER =
    (DESCRIPTION_LIST =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.10)(PORT = 1521))
    )
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
    )
    )
    )

    SID_LIST_LISTENER =
    (SID_LIST =
    (SID_DESC =
    (SID_NAME = PLSExtProc)
    (ORACLE_HOME = d:\oracle\ora92)
    (PROGRAM = extproc)
    )
    (SID_DESC =
    (GLOBAL_DBNAME = NEWDB)
    (ORACLE_HOME = D:\Oracle\ora92)
    (SID_NAME = NEWDB)
    )
    )

    Tnsnames:
    newdb.WORLD =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (COMMUNITY = tcp.world)(PROTOCOL = TCP)(Host = 192.168.1.10)(Port = 1521))
    )
    (CONNECT_DATA =
    (SERVICE_NAME = newdb)
    )
    )

    and sqlnet:
    names.directory_path = (TNSNAMES)
    names.default_domain = world
    names.default_domain= world
    sqlnet.expire_time = 0
    sqlnet.authentication_services = (NTS)

    Running lsnrctl status gives:
    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168. 1.10)(PORT=1521)
    ))
    TNS-12541: TNS:no listener
    TNS-12560: TNS: protocol adapter error
    TNS-00511: No listener
    32-bit Windows Error: 61: Unknown error
    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1) ))
    STATUS of the LISTENER
    ------------------------
    Alias LISTENER
    Version TNSLSNR for 32-bit Windows: Version 9.2.0.1.0 - Produc
    tion
    Start Date 01-OCT-2003 16:40:59
    Uptime 0 days 0 hr. 4 min. 48 sec
    Trace Level off
    Security OFF
    SNMP OFF
    Listener Parameter File D:\oracle\ora92\network\admin\listener.ora
    Listener Log File D:\oracle\ora92\network\log\listener.log
    Listening Endpoints Summary...
    (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168. 1.10)(PORT=1521)))
    (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\ pipe\EXTPROC1ipc)))
    Services Summary...
    Service "NEWDB" has 1 instance(s).
    Instance "NEWDB", status UNKNOWN, has 1 handler(s) for this service...
    Service "PLSExtProc" has 1 instance(s).
    Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
    The command completed successfully

    The first time i run this it hangs however, but i cannot connect to newdb as there is no listener!!!!

    Can someone point me in the right direction please.

    Thanks for your time

    Cult

  2. #2
    Join Date
    Sep 2003
    Location
    The Netherlands
    Posts
    311
    hi,

    maybe i missed it, but i do not see you creating a database, only creating an instance. You need a database as well.
    Am i correct ?
    Edwin van Hattem
    OCP DBA / System analyst

  3. #3
    Join Date
    Oct 2003
    Posts
    10
    er possibly.

    I did:
    "oradim -new -sid newdb -intpwd *** -startmode auto.


    This is where your going to point out that i know nothing
    All replies gratefully received

  4. #4
    Join Date
    Sep 2003
    Location
    The Netherlands
    Posts
    311
    hi,

    no i am not ! ;-)

    You only have the instance created, but not the database and the datafiles etc to store actually data.
    Use the database assistant to create one and restart your listener.

    Hope this helps
    Edwin van Hattem
    OCP DBA / System analyst

  5. #5
    Join Date
    Oct 2003
    Posts
    10
    It does help, and thank you for taking the time Edwin.

    A couple more questions if i may.
    The instance is a container for (x) number of databases, is that correct? Have you got a link where i can read up on what instances are?

    Secondly i would rather create the database by hand than use a wizard, i assume there are commands for this, can you point me in the directions for these as well?


    Thanks again for your help.


    Cult

  6. #6
    Join Date
    Oct 2003
    Posts
    10
    Anyway.
    I have done as you said and created a database using the database configuration assistant yet i still cannot tnsping the database i created.

    I restarted the listener service and when i ping i receive the error: "No listener".

    The TNS services is there and so are both the old SID and the new SID.

    *lost*

  7. #7
    Join Date
    Oct 2003
    Posts
    10
    More information for anyone who could possibly help me:
    Having connected through sysdba the database is mounted etc.

    When i do lsrnctl status it initially hangs so i have to shut dos and try it again, however when i do it the second time it gives:

    C:\Documents and Settings\Administrator>lsnrctl status

    LSNRCTL for 32-bit Windows: Version 9.2.0.1.0 - Production on 02-OCT-2003 11:16:
    56

    Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.

    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168. 1.10)(PORT=1521)
    ))
    TNS-12541: TNS:no listener
    TNS-12560: TNSrotocol adapter error
    TNS-00511: No listener
    32-bit Windows Error: 61: Unknown error
    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1) ))
    STATUS of the LISTENER
    ------------------------
    Alias LISTENER
    Version TNSLSNR for 32-bit Windows: Version 9.2.0.1.0 - Produc
    tion
    Start Date 02-OCT-2003 11:07:27
    Uptime 0 days 0 hr. 9 min. 31 sec
    Trace Level off
    Security OFF
    SNMP OFF
    Listener Parameter File D:\oracle\ora92\network\admin\listener.ora
    Listener Log File D:\oracle\ora92\network\log\listener.log
    Listening Endpoints Summary...
    (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168. 1.10)(PORT=1521)))
    (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\ pipe\EXTPROC1ipc)))
    (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=xenophob e)(PORT=8080))(Presentation=
    HTTP)(Session=RAW))
    (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=xenophob e)(PORT=2100))(Presentation=
    FTP)(Session=RAW))
    Services Summary...
    Service "NEWDB" has 1 instance(s).
    Instance "NEWDB", status UNKNOWN, has 1 handler(s) for this service...
    Service "PLSExtProc" has 1 instance(s).
    Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
    Service "craig" has 2 instance(s).
    Instance "craigsid", status UNKNOWN, has 1 handler(s) for this service...
    Instance "craigsid", status READY, has 1 handler(s) for this service...
    Service "craigsidXDB" has 1 instance(s).
    Instance "craigsid", status READY, has 1 handler(s) for this service...
    The command completed successfully


    And each time i try to connect i receive a TNS error (no listener).

  8. #8
    Join Date
    Sep 2003
    Location
    Assen, Nederland
    Posts
    55
    Well maybe going to the net services and reconfiguring/registering the db there/ and as a last resort deleting and recreating the listener may help.

    have it up and running. Actually it's always up and running if the software is installed.

    Then use the services to register the database , test it.

    Then report back...
    Hope that helped...
    Visit My Website : http://www.oraflame.com
    _____________________________
    Tarry Singh

    OCP DBA 8i
    Currently: SQL Server DBA 7,2000
    Oracle, PHP Programmer

  9. #9
    Join Date
    Sep 2003
    Location
    Assen, Nederland
    Posts
    55
    But maybe first you'd wanna also look into the net manager. click on listener, and check general, services, etc etc

    Reconfigure them , save the config and then try...
    Hope that helped...
    Visit My Website : http://www.oraflame.com
    _____________________________
    Tarry Singh

    OCP DBA 8i
    Currently: SQL Server DBA 7,2000
    Oracle, PHP Programmer

  10. #10
    Join Date
    Oct 2003
    Posts
    10
    Soooo

    I have rebuilt the listener, created a new database, added that to the listener, rebooted the machine and still it does not respond.

    The only thing to add to this is that i created the whole thing using terminal services logged on as administrator.....
    Dont know if that makes any dif?

  11. #11
    Join Date
    Sep 2003
    Location
    The Netherlands
    Posts
    311
    Originally posted by Culture
    It does help, and thank you for taking the time Edwin.

    A couple more questions if i may.
    The instance is a container for (x) number of databases, is that correct? Have you got a link where i can read up on what instances are?

    Secondly i would rather create the database by hand than use a wizard, i assume there are commands for this, can you point me in the directions for these as well?


    Thanks again for your help.


    Cult
    Correction :
    An instance handles one database, but one database can have one or more instances.

    When creating a database manually, pls look at the administrator guide for details. Basicly it is doen in the following manner:
    1 create an instance
    2 startup database in nomount mode
    3 issue create dataabse command
    4 issue create tablespace commands with the datafile clause
    3 issue create rollback segment commands
    4 create the datadictionary using the scripts like catproc, catexp etc.
    5 shutdown the database and restart in in normal mode.
    Normally this is done using scripts.

    Hope this helps
    Edwin van Hattem
    OCP DBA / System analyst

  12. #12
    Join Date
    Sep 2003
    Location
    The Netherlands
    Posts
    311
    Originally posted by Culture
    Soooo

    I have rebuilt the listener, created a new database, added that to the listener, rebooted the machine and still it does not respond.

    The only thing to add to this is that i created the whole thing using terminal services logged on as administrator.....
    Dont know if that makes any dif?
    OK,

    Now, please tell the following:
    Did u restart the listener after rebooting the machine ?
    From where and how are u doing tnsping?
    using terminal services should not make a dif, but check the listener.ora for strange text.

    Hope this helps
    Edwin van Hattem
    OCP DBA / System analyst

  13. #13
    Join Date
    Oct 2003
    Posts
    10
    I have set the listener to automatically start when the machien boots, i tnsping from within dos:
    "tnsping <dbname>"

    There is no strange text within tnsnames.ora (as far as i can tell) - it is the same as originally posted.

  14. #14
    Join Date
    Sep 2003
    Location
    The Netherlands
    Posts
    311
    hi,

    are you on the machine which runs the listener ?
    Or are you on a client tnspinging the listener on the remote machine ?
    Can you give us the output of the start command from lstnrctl?
    Edwin van Hattem
    OCP DBA / System analyst

  15. #15
    Join Date
    Oct 2003
    Posts
    10
    The machine which runs this is next to me, i am connecting to it using terminal services as a "remote control" software.

    I try to TNSPING from the server itself to itself.

    The ouput from running lsnrctl start is:

    C:\Documents and Settings\Administrator>lsnrctl start

    LSNRCTL for 32-bit Windows: Version 9.2.0.1.0 - Production on 02-OCT-2003 18:40:
    11

    Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.

    Starting tnslsnr: please wait...

    TNSLSNR for 32-bit Windows: Version 9.2.0.1.0 - Production
    System parameter file is D:\oracle\ora92\network\admin\listener.ora
    Log messages written to D:\oracle\ora92\network\log\listener.log
    Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=xenophob e)(PORT=1521)))

    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=xenophob e)(PORT=1521)))
    TNS-12541: TNS:no listener
    TNS-12560: TNSrotocol adapter error
    TNS-00511: No listener
    32-bit Windows Error: 61: Unknown error

Posting Permissions

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