| Error ORA-12545 [message #49723] |
Wed, 06 February 2002 06:18  |
Yura A. Pedan
Messages: 2
Registered: February 2002
|
Junior Member |
|
|
Help!
I hase Oracle Server 8.1.6(.3.3 patches) on WinNT4 workstation. I can local connect into server, but I can not connect remote.
Error message:
***********************************************************************
Fatal NI connect error 12545, connecting to:
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=my_computer)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=ora_db)(CID=(PROGRAM=d:OracleOra81binSQLPLUS.EXE)(HOST=other_comp)(USER=user1))))
VERSION INFORMATION:
TNS for 32-bit Windows: Version 8.1.6.3.0 - Production
Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 8.1.6.3.0 - Production
Time: 06-FEB-2002 18:00:53
Tracing not turned on.
Tns error struct:
nr err code: 0
ns main err code: 12545
TNS-12545: Connect failed because target host or object does not exist
ns secondary err code: 12560
nt main err code: 515
TNS-00515: Connect failed because target host or object does not exist
nt secondary err code: 1001
nt OS err code: 0
|
|
|
|
| Re: Error ORA-12545 [message #49725 is a reply to message #49723] |
Wed, 06 February 2002 07:50  |
Nina
Messages: 113
Registered: March 2000
|
Senior Member |
|
|
1) Try to modify the client TNSNAMES.ORA file and adding (SERVER=DEDICATED):
Find out the port number of dispatcher by doing
select * from v$dispatcher;
(You get port numbers different from 1521 or 1526.)
Use one of these port numbers in your client side tnsnames.ora
Test the connection.
If you want to use Dedicated Server then
keep the port number to 1521 or 1526 depending on what is in your
listener.ora.
Add line server=dedicated in your tnsnames.ora
2) can you ping or telnet to other_host?
From metalink:
somebody with the same problem:
Can you ping the host name of the server or tnsping the alias of the server as configured in your tnsnames.ora file? If not, then the problem is most likely with the configuration of your tnsnames.ora file. Ensure that the information matches that of the server's listener.ora file and its database information.
Several problems could result in an ORA-1254. Make sure the tracing is on Enable client tracing to 16 by including the following parameter in your client SQLNET.ORA file:
trace_level_client=16
OR you could try to add an entry in the hosts file and change the corresponding entry in TNSNAMES.ORA by replacing the IP-adress with the nickname. This works sometimes.
hope that helps
|
|
|
|
|
|
|
|
| Re: Error ORA-12545 [message #50507 is a reply to message #49725] |
Tue, 19 March 2002 02:25 |
Nanditasi
Messages: 1
Registered: March 2002
|
Junior Member |
|
|
|
There are some machine where the port number 1521 works in our network but some of them requires the port number to be changed to the o/p returned by the query mentioned by you or change server=dedicated mode. Why do the machine in the same network behave so differently ?
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
