| Listner issues [message #73177] |
Wed, 25 February 2004 22:37  |
Dan White
Messages: 48
Registered: September 2003
|
Member |
|
|
I have 2 databases, 1 Oracle9i Enterprise Edition Release 9.2.0.4.0 running on windows2000 server(my laptop) and a second Oracle9i Enterprise Edition Release 9.2.0.4.0 running on redhat ES 3 When I try to use SQL Plus from the widows 2000 machiene i can not to connect to the linux database here is my TNSNAMES.ora
# TNSNAMES.ORA Network Configuration File: c:Oracleora90networkadmintnsnames.ora
# Generated by Oracle configuration tools.
ORATEST.TECHNOLOGY.INNOVATIVE-CONSULT.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = dwhitelp)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = oratest)
)
)
# TNSNAMES.ORA extries for linux machiene
RXFT =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = icitech4)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = rxft)
)
)
RXFP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = icitech4)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = rxfp)
)
)
RXFD =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = icitech4)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = rxfd)
)
)
ODS1 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = icitech4)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ods1)
)
)
|
|
|
|
|
|
| Re: Listner issues [message #73185 is a reply to message #73180] |
Thu, 26 February 2004 05:46  |
Dan White
Messages: 48
Registered: September 2003
|
Member |
|
|
I get the following.
ORA-12154 TNS:Could not resolve service name
I can log on to the linux box and connect via sqlplus using the sid so I know I'm hitting the listner from there.
Thanks,
Dan
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
