setting up a db and tnsnameslisterner does not appear/work

Posted on 2004-11-15
Last Modified: 2008-03-10

I have tried to install Toad on a windows 2003 server with a 9.2 oracle database.

I set up the database but when I try and connect to sqlplus/toad I get ora-12154: TNS: could not resolve service name....

The only difference I can find with this setup is that when I go to deveice manager - services there is no Ora92TNSnameslistener in the list. There has also been no TNS entry in Oracle\ora92\network\admin\.

I've manually put:
    (ADDRESS = (PROTOCOL = TCP)(HOST = gbsflatest)(PORT = 1521))

but still no joy.

When I try:
c:Lsnrctl status

I get lsnrctl for 32-bit windows.......
starting tnslsnr: please wait..
Failed to open service <OracleOraHome92TNSListener>, error 1060
STATUS of the Listener..........
The listener supports no services

any ideas what Im doing wrong?

Question by:joehodge

    Author Comment

    I've set up the listener via Oracle Net configuration Assistant and I can now see the tnsnames service running,

    however, when I try c:\ Lsnrctl status I get :

    Service OracleOraHome92TNSListener already running
    TNS-12536: TNS:operation would block
    TNS-12560: TNS:protocol adapter error
     TNS-00506: Operation would block
      32-bit Windows Error: 997: Unknown error

    Author Comment


    I have now set the oracle_sid=playp1 and I can enter sqplus via the dos prompt.

    I still get an tnsnames error if I try and access the database throgh TOAD or sqlplus (via Programs - Application Development - SQPLUS)

    ?? Im confused??
    LVL 1

    Accepted Solution

    When you connect, are you typing in PLAYP1 into TOAD or are you typing PLAYP1.WORLD?

    Check your sqlnet.ora file and see of your domain is defaulted, that may have something to do with it.

    Author Comment


    thats got it working. I put


    in my sqlnet.ora

    and then

        (ADDRESS_LIST =
          (ADDRESS = (PROTOCOL = TCP)(HOST = GBSFTEST)(PORT = 1521))
        (CONNECT_DATA =
          (SERVICE_NAME = PLAYP1)

    and it worked.


    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Join & Write a Comment

    This article started out as an Experts-Exchange question, which then grew into a quick tip to go along with an IOUG presentation for the Collaborate confernce and then later grew again into a full blown article with expanded functionality and legacy…
    Subquery in Oracle: Sub queries are one of advance queries in oracle. Types of advance queries: •      Sub Queries •      Hierarchical Queries •      Set Operators Sub queries are know as the query called from another query or another subquery. It can …
    This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
    This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.

    729 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    21 Experts available now in Live!

    Get 1:1 Help Now