Home » RDBMS Server » Networking and Gateways » ora_12154
ora_12154 [message #66033] Sun, 14 October 2001 12:39 Go to next message
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 Go to previous message
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

----------------------------------------------------------------------
Previous Topic: ORA 00000 - Normal Successful
Next Topic: Re: ORA-03121
Goto Forum:
  


Current Time: Fri Mar 29 00:09:18 CDT 2024