#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jun 2012
    Posts
    6
    Rep Power
    0

    Installation of Oracle 10g


    I have installed the Oracle 10g at the following location : -
    C:\oracle\product\10.2.0\client_1\NETWORK\ADMIN

    But I was trying to ping Oracle Client from Command Prompt. See Below : -
    c:\Oracle>tnsping SONIA
    ERROR IS COMING no listener

    MINE tnsnames.ora File : -

    Code:
    # tnsnames.ora Network Configuration File: C:\oracle\product\10.2.0\client_1\network\admin\tnsnames.ora
    # Generated by Oracle configuration tools.
    
    SONIA =
      (DESCRIPTION =
        (ADDRESS_LIST =
          (ADDRESS = (PROTOCOL = TCP)(HOST = sonia)(PORT = 1521))
        )
        (CONNECT_DATA =
          (SERVICE_NAME = SONIA)
        )
      )
    What this error means??? Help me in connecting to the ORACLE 10g.
    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.
  2. #2
  3. Humble Learner
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jul 2007
    Location
    Bangalore, India
    Posts
    280
    Rep Power
    120
    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.

IMN logo majestic logo threadwatch logo seochat tools logo