-
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)
-
What error are you getting? Post the same.
HTHU
-
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!?
-
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.
-
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)
)
)
_____________________________________________________________________
-
What is the result of tnsping? Is this successful?
tnsping SPOORNET
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|