| ora_12154 [message #66033] |
Sun, 14 October 2001 12:39  |
George
Messages: 68
Registered: April 2001
|
Member |
|
|
Could you tell me what is the TNS service name? I am configure the internet file system for 9iAS, my db is on a seperate box(ip 1.2.3.4). I tried ora_icache_orgin, and DEVL.INTERASSET.COM but i got 12154 error. I ping and tnsping the server and net service names and all worked fine.
Here is my tnsnames.ora:
ORA_ICACHE =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = icache))
)
(CONNECT_DATA =
(SERVICE_NAME = planet.interasset.com-icache)
)
)
PLANET.INTERASSET.COM-ICACHE =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = icache))
)
(CONNECT_DATA =
(SERVICE_NAME = planet.interasset.com-icache)
)
)
ORA_ICACHE_ORIGIN =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 1.2.3.4)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = devl.interasset.com)
)
)
DEVL.INTERASSET.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 1.2.3.4)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = devl.interasset.com)
)
)
thanks
----------------------------------------------------------------------
|
|
|
|
| Re: ora_12154 [message #66037 is a reply to message #66033] |
Mon, 15 October 2001 21:07  |
K.SREENIVASAN
Messages: 110
Registered: January 2001
Location: banglore
|
Senior Member |
|
|
HAI,
PLEASE EDIT THE FOLLOWING
ORA_ICACHE =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = icache))
)
(CONNECT_DATA =
(ORACLE_SID= ORCL)
)
)
HERE ORCL IS THE DATABASE SID.AT THAT PLACE MENTSION YOUR DATABASE SID.THEN
CHECK THE SQLNET.ORA ALSO.
THAT'S ALL.
K.SREENIVASAN
----------------------------------------------------------------------
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
