| Getting ORA-12545: Connect failed because target host or object does not exist [message #66684] |
Fri, 18 October 2002 02:07  |
Walter Schmid
Messages: 2
Registered: October 2002
|
Junior Member |
|
|
Hi everybody,
We have the following problem with Oracle 9i server and Oracle 9.2 client:
1) Oracle 9i DB server installed and running on Win2K server.
2) Connect works fine from any UNIX client using Oracle 9.2 client software.
3) Connect from sqlplus with user/passwd@ oranend.xxx.yyy.com succeeds from any Win2000 client (also using Oracle 9.2 client)
4) Connect request from java pgm via jdbc works fine from HP-UX client, but comes up with an error when issued from Win2K client (same software):
Database connection phase: getConnection failure: ORA- 12545: Connect failed because target host or object
does not exist
Connection string used is:
"jdbc:oracle:oci:@oranend.xxx.yyy.com"
Configuration follows:
5) Client tnsnames.ora
ORANEND.XXX.YYY.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = nendaz
(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ORANEND)
)
)
6) Server:
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS=(PROTOCOL=TCP)(HOST=NENDAZ)
(PORT=1521))
)
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME=ORANEND)
(SID_NAME = ORANEND)
(ORACLE_HOME = C:oracleora90)
)
)
7) client sqlnet.ora
NAMES.DEFAULT_DOMAIN = xxx.yyy.com
SQLNET.AUTHENTICATION_SERVICES= (NTS)
NAMES.DIRECTORY_PATH= (TNSNAMES,LDAP, ...)
8) Oracle database parameters in init.ora:
db_name = ORANEND
db_domain=xxx.yyy.com
instance_name=ORANEND
Have tried a lot of alternatives, but cannot overcome this issue.
Any hints would be gratefully appreciated !
Many thanks in advance and best regards
Walter
|
|
|
|
|
|
|
|
| Re: Getting ORA-12545: Connect failed because target host or object does not exist [message #66694 is a reply to message #66688] |
Mon, 28 October 2002 21:09  |
Rajendra Verma
Messages: 2
Registered: October 2002
|
Junior Member |
|
|
when u are using making a jdbc call, and using thin driver then sqlnet.ora file doenot comes into picture.
SO I willl suggest u to make address entry in listener.ora file corressponding IP address of server or try hostname with fullly qualified domain name.
In a normal sqlplus connection domain is automatically attached with the hostname as defined in sqlnet.ora.
If all this does'nt work then remove the listener.ora file (which is not a required file ) and try all the possible ways of making connections ,
hope this works
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
