Home » Other » Client Tools » ORA-12545 error in PL/SQL developer in windows 7 (pl/sql developer 7.1)
ORA-12545 error in PL/SQL developer in windows 7 [message #590253] Tue, 16 July 2013 06:18 Go to next message
debasisp
Messages: 10
Registered: February 2010
Location: BANGALORE,INDIA
Junior Member
I am using Oracle 11g version, and i am using plsql developer 7.1.
I am able to connect Oracle through sql*plus, But i am not able to connect Oracle through plsql developer from past few days, it is giving me error like:
ora-12545 connect failed because target host does not exist
I recently installed oracle dev_suite 10g client first and then i installed oracle 11g server in windows 7. Both tns files are having identical entries.

Please find the tns entries below.

EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = DEPANIGR-IN)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = PLSExtProc)
)
)

ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = DEPANIGR-IN)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)

Please guide me resolving this issue.

Regards,

Striker

[Updated on: Tue, 16 July 2013 06:21]

Report message to a moderator

Re: ORA-12545 error in PL/SQL developer in windows 7 [message #590256 is a reply to message #590253] Tue, 16 July 2013 06:40 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ORA-12545: Connect failed because target host or object does not exist
 *Cause: The address specified is not valid, or the program being
 connected to does not exist.
 *Action: Ensure the ADDRESS parameters have been entered correctly; the
 most likely incorrect parameter is the node name.  Ensure that the
 executable for the server exists (perhaps "oracle" is missing.)
 If the protocol is TCP/IP, edit the TNSNAMES.ORA file to change the
 host name to a numeric IP address and try again.


1/ What is the result of "ping DEPANIGR-IN"?
2/ I advise you to NOT use such character than - in names
3/ Are you sure you use THIS tsnnames.ora?
4/ What is yuor sqlnet.ora?
5/ What your TNS_ADMIN variable?
6/ What is the result of "tnsping orcl"?
7/ Copy and past your connection string?

Regards
Michel
Re: ORA-12545 error in PL/SQL developer in windows 7 [message #590258 is a reply to message #590256] Tue, 16 July 2013 07:01 Go to previous messageGo to next message
debasisp
Messages: 10
Registered: February 2010
Location: BANGALORE,INDIA
Junior Member
Michel,

Thanks for responding to my query. Please find the details below:

1/ What is the result of "ping DEPANIGR-IN"?

Pinging DEPANIGR-IN [102.46.208.165] with 32 bytes of data:
Reply from 102.46.208.165: bytes=32 time<1ms TTL=128
Reply from 102.46.208.165: bytes=32 time<1ms TTL=128
Reply from 102.46.208.165: bytes=32 time<1ms TTL=128
Reply from 102.46.208.165: bytes=32 time<1ms TTL=128

Ping statistics for 102.46.208.165:
Packets: Sent = 4, Received = 4, Lost = 0 (0% loss),
Approximate round trip times in milli-seconds:
Minimum = 0ms, Maximum = 0ms, Average = 0ms

2/ I advise you to NOT use such character than - in names

Truely agreed. I even tried with my ip adress in the host= but i got the same error again.

3/ Are you sure you use THIS tsnnames.ora? yes. This is the oracle server which i installed in my system.

4/ What is yuor sqlnet.ora?

in oracle home the sqlnet.ora file is having the details as SQLNET.AUTHENTICATION_SERVICES= (NTS)

NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)

In devsuite 10 home the sqlnet.ora is having details as SQLNET.AUTHENTICATION_SERVICES= (NTS)

NAMES.DIRECTORY_PATH= (LDAP, TNSNAMES, EZCONNECT, ONAMES, HOSTNAME)


5/ What your TNS_ADMIN variable? Michel, I am not sure about the TNS_ADMIN variable. I searched it in registry but dint find anything like that. Could you please guide?

6/ What is the result of "tnsping orcl"?

C:\Users\depanigr>tnsping orcl

TNS Ping Utility for 64-bit Windows: Version 11.2.0.1.0 - Production on 16-JUL-2
013 17:23:48

Copyright (c) 1997, 2010, Oracle. All rights reserved.

Used parameter files:
D:\app\depanigr\product\11.2.0\dbhome_1\network\admin\sqlnet.ora


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = DEPANIGR
-IN)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_N
AME = orcl)))
OK (0 msec)


7/ Copy and past your connection string? i m trying to connect using scott/abcdef@orcl
Re: ORA-12545 error in PL/SQL developer in windows 7 [message #590265 is a reply to message #590258] Tue, 16 July 2013 08:06 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
If tnsping works and not your connection from plsql developer then you are not using the same tnsnames.ora for both product.

Add a TNS_ADMIN variable in your environment that points to "D:\app\depanigr\product\11.2.0\dbhome_1\network\admin"

Regards
Michel
Re: ORA-12545 error in PL/SQL developer in windows 7 [message #590551 is a reply to message #590265] Fri, 19 July 2013 04:15 Go to previous messageGo to next message
debasisp
Messages: 10
Registered: February 2010
Location: BANGALORE,INDIA
Junior Member
Michel,

I maintained TNS_ADMIN as an environmental variable which is pointing to the admin folder where my tns file resides. But still i am getting the same error. I uninstall oracle 11g and install it again. still the issue persists.
Re: ORA-12545 error in PL/SQL developer in windows 7 [message #590554 is a reply to message #590253] Fri, 19 July 2013 04:32 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
debasisp wrote on Tue, 16 July 2013 13:18
i am not able to connect Oracle through plsql developer from past few days

Does it mean that - previously - you managed to establish a connection? If so, what changed on your computer? Did you install some additional software?
Re: ORA-12545 error in PL/SQL developer in windows 7 [message #590556 is a reply to message #590554] Fri, 19 July 2013 05:14 Go to previous messageGo to next message
debasisp
Messages: 10
Registered: February 2010
Location: BANGALORE,INDIA
Junior Member
No.. I dint change any system configuration nor any additional software has been installed. I was using windows xp earlier. Now everybody has been asked to upgrade to windows 7. I installed windows 7. Then i installed oracle devsuite 10g client and then oracle 11g server. I tried connecting scott/abcdef@orcl through sqlplus. but when installed pl/sql developer and tried logging in i got the error. As mentioned earlier i have the same tns file in both devsuite folder and in oracle home admin folder.
Re: ORA-12545 error in PL/SQL developer in windows 7 [message #590868 is a reply to message #590253] Tue, 23 July 2013 11:43 Go to previous message
Kaeluan
Messages: 179
Registered: May 2005
Location: Montreal, Quebec
Senior Member
Hi,

From what i can see in your log you are using Oracle 11g 64 bits. PL/SQL Developper is working only with 32 bits client.
If you go in PL/SQL Developper in the menu "Tools"-"Preferences" there is a place to specify the oracle home that need to be used by PL/SQL Developper, check the avalable values in the list.
Also if you have more than 1 Oracle home, verify if your TNSNAMES and SQLNET.ora are deployed in all oracle home.

Hope it help



Previous Topic: Oracle xsl fo reports
Next Topic: Oracle Reporting tools
Goto Forum:
  


Current Time: Thu Mar 28 10:50:41 CDT 2024