Tnsnames.ora
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: Tnsnames.ora

  1. #1
    31006558 Guest

    Angry Tnsnames.ora

    Greatings

    1.I recently installed 9i on my new XP workstation/server. All went well except for the LOCAL NET SERVICE NAMING. I tried the manual way in network\admin\tnsnames.ora. It didn't work.

    2. I reinstalled 9i and got the same problem.

    3.As a last resort I installed 8.1.6...that didn't work either (the TNSNAMES).

    Any usefull suggestion will be of great help..(logical)

  2. #2
    Join Date
    Sep 2000
    Location
    Chennai, India
    Posts
    865
    What error are you getting? Post the same.

    HTHU

  3. #3
    31006558 Guest
    ERROR 100 - NLNV-NLNV STRING FORMAT ERROR ON STUDIO
    ORA-12154 ON PLSQL

    Unfortunately I didnt record the install error. If info crutial I will run again to record error!?

  4. #4
    Join Date
    Sep 2000
    Location
    Chennai, India
    Posts
    865
    Check this out...for your error...

    http://download-west.oracle.com/docs...les.htm#440455

    Moreover, post the contents of your tnsnames.ora here.

    HTH.

  5. #5
    31006558 Guest
    Will go to site,thanx

    #-replace DB name
    _____________________________________________________________________
    # TNSNAMES.ORA Network Configuration File: C:\oracle\ora90\network\admin\tnsnames.ora
    # Generated by Oracle configuration tools.

    INST1_HTTP.ELOGICS.LOCAL =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = ROBCOMPUTER)(PORT = 1521))
    )
    (CONNECT_DATA =
    (SERVER = SHARED)
    (SERVICE_NAME = MODOSE)
    (PRESENTATION = http://HRService)
    )
    )

    SPOORNET=
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = ROBCOMPUTER)(PORT = 1521))
    )
    (CONNECT_DATA =
    (SERVICE_NAME = SPOORNET)
    )
    )

    ########=
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = LOGICSTOO)(PORT = 1521))
    )
    (CONNECT_DATA =
    (SERVICE_NAME = ########)
    )
    )

    TEST=
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = LOGICSTOO)(PORT = 1521))
    )
    (CONNECT_DATA =
    (SERVICE_NAME = TEST)
    )
    )

    ####=
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = LOGICSTOO)(PORT = 1521))
    )
    (CONNECT_DATA =
    (SERVICE_NAME = ####)
    )
    )

    EXTPROC_CONNECTION_DATA.ELOGICS.LOCAL =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
    )
    (CONNECT_DATA =
    (SID = PLSExtProc)
    (PRESENTATION = RO)
    )
    )
    _____________________________________________________________________

  6. #6
    Join Date
    Sep 2000
    Location
    Chennai, India
    Posts
    865
    What is the result of tnsping? Is this successful?

    tnsping SPOORNET

  7. #7
    Join Date
    Apr 2002
    Location
    France
    Posts
    118
    Try with that :

    #-replace DB name
    # TNSNAMES.ORA Network Configuration File: C:\oracle\ora90\network\admin\tnsnames.ora
    # Generated by Oracle configuration tools.

    SPOORNET =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = ROBCOMPUTER)(PORT = 1521))
    )
    (CONNECT_DATA =
    (SERVICE_NAME = SPOORNET)
    )
    )

    a =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = LOGICSTOO)(PORT = 1521))
    )
    (CONNECT_DATA =
    (SERVICE_NAME = a)
    )
    )

    TEST =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = LOGICSTOO)(PORT = 1521))
    )
    (CONNECT_DATA =
    (SERVICE_NAME = TEST)
    )
    )

    b =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = LOGICSTOO)(PORT = 1521))
    )
    (CONNECT_DATA =
    (SERVICE_NAME = b)
    )
    )


    There is a carriage return after the last )

    (I also changed the names with the ###, not to good names are they ?)
    If there is no solution, it is because there is no problem - Shadok -

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width