Visit Our UNIX and Linux User Community


Problem in accessing Oracle Database Server from Linux Machine


 
Thread Tools Search this Thread
Operating Systems Linux Problem in accessing Oracle Database Server from Linux Machine
# 1  
Old 08-22-2014
Problem in accessing Oracle Database Server from Linux Machine

I am facing a strange issue in connecting to Oracle database from Linux Machine
- The connectivity is not failing all the time , the failure to success ratio is 1:70.
- Error "ORA-12545: Connect failed because target host or object does not exist"
- Majority of the time the connection is successful
- I am able to ping the target database server using the hostname defined in /etc/hosts
- There is another Oracle server which has a seamless connectivity.

Entry in tnsnames.ora
Code:
XXX.XXXXXX.COM =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = XXX.XXX.XX.XX)(PORT = XXXX))
    )
    (CONNECT_DATA =
        (SERVER = DEDICATED)
        (SERVICE_NAME = XXXX)
       (FAILOVER_MODE =
        (TYPE = SELECT)
        (METHOD = BASIC)
        (RETRIES = 180)
        (DELAY = 5)

    )))


Last edited by Franklin52; 08-22-2014 at 11:19 AM.. Reason: Please use code tags
# 2  
Old 08-22-2014
Does tnsping return successfully every time or is there a similar failure there?
# 3  
Old 08-22-2014
The tnsping is not currently available in the machine, I wonder if we are allowed to use it.
# 4  
Old 08-22-2014
Are either the DB or the client running on virtualised machines?
# 5  
Old 08-22-2014
no both the server are not VM
# 6  
Old 08-25-2014
Well, now we have the tnsping working.

Code:
[root@XXXXXX:xxx]# tnsping XXXX.XXXXXXXX.XX 5

TNS Ping Utility for Linux: Version 9.2.0.1.0 - Production on 25-AUG-2014 09:34:53

Copyright (c) 1997 Oracle Corporation.  All rights reserved.

Used parameter files:
/usr/lib/oracle/11.2/client64//network/admin/sqlnet.ora


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = XXX.XXX.XX.XXX)(PORT = XXXX))) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = XXXXXX) (FAILOVER_MODE = (TYPE = SELECT) (METHOD = BASIC) (RETRIES = 180) (DELAY = 5))))
OK (220 msec)
OK (230 msec)
OK (230 msec)
OK (230 msec)


Last edited by radoulov; 08-25-2014 at 09:41 AM..
# 7  
Old 08-25-2014
Check Troubleshooting Guide for ORA-12545 / TNS-12545 Connect failed because target host or object does not exist (Doc ID 553328.1) on MOS.

Previous Thread | Next Thread
Test Your Knowledge in Computers #133
Difficulty: Easy
The first prototypes of Linux were publicly released in 1991.
True or False?

5 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Problem in Connecting to Oracle Database using KornShell

Hello, I am very new to Scripting. I am having a Kornshell Script below for connecting to Oracle database. But getting an error while executing it. #!/bin/ksh ssh -X root@192.168.2.127 <perimuka> sleep 5 su - oracle sqlplus <mraghunandanan>/<peri123> <<eof Can anyone tell what is wrong... (3 Replies)
Discussion started by: mraghunandanan
3 Replies

2. AIX

Problem accessing Oracle Directory on AIX

What are we doing ? 1) We ftp a PDF file to Oracle Directory which is on AIX server, using Business Object Server. The ftp account we use is prmtftdv. The oracle directory is owned by "oracle" account on aix. The default file permission is 640. 2) We are trying to read the PDF file using oracle... (1 Reply)
Discussion started by: ssatyaranga
1 Replies

3. IP Networking

Accessing a FTP Server hosted on Linux

We have set-up a FTP server on a Linux machine, which sits behind a firewall. Most users outside our firewall can access it, but one user in particular cannot. I assume it has something to do with their firewall rules. It appears that they can connect with no problem but the server does not grant... (1 Reply)
Discussion started by: Breen
1 Replies

4. UNIX for Dummies Questions & Answers

oracle database on solaris and linux

what is the difference in running oracle database on solaris and linux operating system (3 Replies)
Discussion started by: ganga
3 Replies

5. IP Networking

Problem accessing network using Linux

Ok, here at work, we have Windows computers which login into a MS domain server. Some of us also have Linux boxes which get a ip address from the dhcp server. We can see other boxes and see the internet until about 1 week ago. Now, we still get a ip address but can't see anything within our... (3 Replies)
Discussion started by: natter
3 Replies

Featured Tech Videos