DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 13

Thread: Listener

  1. #1
    Join Date
    Jan 2002
    Posts
    152
    I intalled Oracle Server on my computer,and I tried to create a new DataBase,but when I'm going to create a service pointing to that Database,I can't connect because I have no listener service on my computer...How can I add it????
    Thanks

  2. #2
    Join Date
    Mar 2002
    Posts
    301
    Hi,

    You can add listener in 2 ways:

    1. Use Net8 Configuration Assistant.
    2. Open the file Listener.ora and manually include your new instance info.

    Vijay.
    Say No To Plastics

  3. #3
    Join Date
    Jan 2002
    Posts
    152
    I always get the same error:
    ORA-12541
    and I can't connect to the database...

  4. #4
    Join Date
    Mar 2002
    Posts
    301
    Hi,

    For configuring the listener it is not necessary to login to the database.
    Configure the listener and then create a net service name, by adding an entry into TNSNAMES.ORA file
    either by using NET8 CONFIGURATION ASSISTANT or MANUALLY EDITING THE FILE.

    Please give the complete error message, OS and version what ever u are facing.


    Vijay.
    Say No To Plastics

  5. #5
    Join Date
    Jan 2002
    Location
    Netherlands
    Posts
    1,587
    Then start the listener service by invoking
    lsnrctl start.
    then continue.
    Tarry Singh
    I'm a JOLE(JavaOracleLinuxEnthusiast)
    TarryBlogging
    --- Everything was meant to be---

  6. #6
    Join Date
    Oct 2001
    Posts
    126
    I believe that you are looking for the exact command to add the listener service into the "control panel/services." I don't remember on top of my head. However, if you can find one listener service entry on the registry of other NT servers, you can export that key, modify it, then import the key back to your NT server. This will add the listener services on the "control panel/services."

    Susan

  7. #7
    Join Date
    Jan 2002
    Posts
    152
    Yes,Susan,you are right,I want to add the listener service to the control panel/services...But I don't know how can I get OracleOraHome81TNSListener working...

  8. #8
    Join Date
    May 2002
    Posts
    2
    Just go to Control panel/Services, Right click on OracleOraHome81TNSListener, select Start. To start it automatically, use Properties option, General Type, Startup type.

    jl

  9. #9
    Join Date
    Oct 2001
    Posts
    126
    type "oradim " on dos prompt. It will list the syntax on how to add services in registry.

    Susan

  10. #10
    Join Date
    Jan 2002
    Posts
    152
    ...Thanks,but I don't have OracleOraHome81TNSListener on my computer...That's the problem...I need a way to get it,so I could start it.
    I have more Databases installed,but the one I created with the Oracle server installed on my computer,is the only who doesn't work,and I can't connect because of the listener...

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