Oracle 11g silent installaiton and no tnsnames.ora file installed?

Posted on 2010-01-07
Last Modified: 2013-11-11

     I installed Oracle 11g using a response file. However when I tried to make a connection through SQL Developer I got the following message:
Listener refused the connection with the following error ORA-12505, TNS listener does not currently know of SID given in connect descriptor The Connection descriptor used....

I searched for tnsnames.ora and the path is C:\app\admin\product\11.1.0\db_1\owb\network\admin          I'm not sure what owb directory is used for and how tnsnames ended up in this directory. Should't tnsname.ora be in C:\app\admin\product\11.1.0\db_1\admin?
Question by:missymadi
    LVL 76

    Expert Comment

    by:slightwv (䄆 Netminder)
    OWB = Oracle Warehouse Builder

    Every ORACLE_HOME gets a set of config files.  It looks like you have more than one ORACLE_HOME on the box.


    By default it should be: ORACLE_HOME\network\admin

    If you wish to have ONE location besides the default you can set the TNS_ADMIN environment variable.

    Author Comment

    I guess I need to know where to set the Oracle home environment in the answer file for Oracle Standard Editon rsp file. I only want to have one Oracle home.

    THanks, Missy Madi
    LVL 76

    Expert Comment

    by:slightwv (䄆 Netminder)
    >>I only want to have one Oracle home

    This might not be possible.  Some products require their own home.
    LVL 47

    Accepted Solution

    Do the following  on the SERVER SIDE:

    If you are on Windows start the Oracle Services:

    As Administrator of the machine.
    Also the installation of Oracle should be done as Administrator.

    If this is Unix:

    % lsnrctl start

    and to tray to start the instance over SQl*Plus

    You need to do this as Oracle user.

    If you need remote access do static registration:

    Backup LISTENER.ORA file!!!!!!!

    In ...\network\admin open listener.ora


      (SID_LIST =
        (SID_DESC =
          (SID_NAME = PLSExtProc)
          (ORACLE_HOME = D:\Ora10g)
          (PROGRAM = extproc)
        (SID_DESC =
          (SID_NAME = test)
          (ORACLE_HOME = D:\Ora10g)

    Add the entry
        (SID_DESC =
          (SID_NAME = test)
          (ORACLE_HOME = D:\Ora10g)
    with regard to the particular Oracle Home and SID Name.

    Restart the listener:
    c:>lsnrctl stop
    c:>lsnctl start

    Featured Post

    PRTG Network Monitor: Intuitive Network Monitoring

    Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

    Join & Write a Comment

    Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here. General principle of Oracle compression Oracle compression is a way of reducing the d…
    Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
    This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
    This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.

    734 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

    24 Experts available now in Live!

    Get 1:1 Help Now