• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2774
  • Last Modified:

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

Experts,

     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?
0
missymadi
Asked:
missymadi
  • 2
1 Solution
 
slightwv (䄆 Netminder) Commented:
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.

>>C:\app\admin\product\11.1.0\db_1\admin

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.
0
 
missymadiAuthor Commented:
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
0
 
slightwv (䄆 Netminder) Commented:
>>I only want to have one Oracle home

This might not be possible.  Some products require their own home.
0
 
schwertnerCommented:
Do the following  on the SERVER SIDE:

If you are on Windows start the Oracle Services:
Listener
Oracleservice<yourSID>SID

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

see

SID_LIST_LISTENER =
  (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
0

Featured Post

Veeam and MySQL: How to Perform Backup & Recovery

MySQL and the MariaDB variant are among the most used databases in Linux environments, and many critical applications support their data on them. Watch this recorded webinar to find out how Veeam Backup & Replication allows you to get consistent backups of MySQL databases.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now