Welcome Guest ( Log In | Register )


 
 
 
 
 
 

 
 
Oracle 

Performance Tuning Reference poster
 
Oracle training in Linux 

commands
 
Oracle training Weblogic Book
 
Easy Oracle Jumpstart
 
Oracle training & performance tuning books
 
Burleson Consulting Remote DB Administration
 
 
 
Reply to this topicStart new topic
> Unable to connect oracle11g in server client env ORA-12545
Karan Gurnani
post Mar 19 2017, 02:46 AM
Post #1


Newbie
*

Group: Possible Spammers
Posts: 1
Joined: 19-March 17
Member No.: 51,843



I have a setup in such a way that Oracle 11g server is running on a windows 10 machine and I want to access it through an instant client running on a Ubuntu VMware machine configure through NAT.
When I trigger sqlplus / on the remote client it throws an error ORA-12545: Connect failed because target host or object does not exist
i have created a tnsnames.ora for the same on the VM and has the contents
XE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = dellpc )(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = XE)
)
)

The host name is mapped to the IP address in the /etc/hosts file
Also i am able to ping both the machines using their IP/hostnames, Also i am able to access the DB using the sqlplus hr/hr@dellpc:1521/xe comand from ubuntu machine which is a VM.

listener.ora file has the contents

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D:\oraclexe\app\oracle\product\11.2.0\server)
(PROGRAM = extproc)
)
(SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME = D:\oraclexe\app\oracle\product\11.2.0\server)
(PROGRAM = extproc)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)(HOST = DESKTOP-3KDSFM6)(PORT = 1521))
)
)

DEFAULT_SERVICE_LISTENER = (XE)


Can anyone please suggest how to fix this issue, i want to connect to db using sqlplus username/password but that is being prevented by ORA-12545
Go to the top of the page
 
+Quote Post
burleson
post Mar 20 2017, 11:10 AM
Post #2


Advanced Member
***

Group: Members
Posts: 13,340
Joined: 26-January 04
Member No.: 13



Hi Kuran, and welcome to the forum!

First, try these steps for troubleshooting network connectivity:

http://www.dba-oracle.com/t_troubleshootin...vity_errors.htm

******************************************************

>> ORA-12545

See details here:

http://www.dba-oracle.com/t_ora_12545_connect_failed.htm




--------------------
Hope this helps. . .

Donald K. Burleson
Oracle Press author
Author of Oracle Tuning: The Definitive Reference
Go to the top of the page
 
+Quote Post

Reply to this topicStart new topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:

 

Lo-Fi Version Time is now: 29th March 2017 - 02:08 AM