June 15th, 2012, 04:09 PM
Installation of Oracle 10g
I have installed the Oracle 10g at the following location : -
But I was trying to ping Oracle Client from Command Prompt. See Below : -
ERROR IS COMING no listener
MINE tnsnames.ora File : -
What this error means??? Help me in connecting to the ORACLE 10g.
# tnsnames.ora Network Configuration File: C:\oracle\product\10.2.0\client_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
(ADDRESS = (PROTOCOL = TCP)(HOST = sonia)(PORT = 1521))
(SERVICE_NAME = SONIA)
I have studied on the net that for Oracle to connect three ora files need to be there. But in my ADMIN Folder two files are created by Oracle Configuration Tools names SqlNet.ORA , TNSNAMES.ORA. LISTENER.ORA file is not created.
July 27th, 2012, 12:54 AM
I think you have installed oracle client only not the server. If server is installed the path will read dbhome_1 not client_1 as mentioned by you.