Tnsnames.ora

[31006558]

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)

[ggnanaraj]

What error are you getting? Post the same.

HTHU

[31006558]

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!?

[ggnanaraj]

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.

[31006558]

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)
)
)
_____________________________________________________________________

[ggnanaraj]

What is the result of tnsping? Is this successful?

tnsping SPOORNET

[yanban]

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 ?)