Problem in accessing Oracle Database Server from Linux Machine Post: 302914140

Sponsored Content

Operating Systems Linux Problem in accessing Oracle Database Server from Linux Machine Post 302914140 by balaji kumar on Friday 22nd of August 2014 06:32:22 AM

08-22-2014

Registered User

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

balaji kumar

View Public Profile for balaji kumar

Find all posts by balaji kumar

5 More Discussions You Might Find Interesting

1. 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...

2. 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. 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...

4. 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...

5. 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...

LEARN ABOUT CENTOS

radsqlrelay

RADSQLRELAY(8)						     FreeRADIUS helper program						    RADSQLRELAY(8)

NAME

       radsqlrelay - relay SQL queries to a central database server

SYNOPSIS

       radsqlrelay [-?]  [-d sql_driver] [-b database] [-f file] [-h host] [-u user] [-P port] [-p password] [-1] [-x] file_path

DESCRIPTION

       radsqlrelay  tails a SQL logfile and forwards the queries to a database server. Used to replicate accounting records to one (central) data-
       base, even if the database has extended downtime.

       The SQL logfile is created by the rlm_sql_log module. The module must be configured in the radiusd server before you can use radsqlrelay.

OPTIONS

       -?     Print usage help information.

       -d sql_driver
	      Driver to use: mysql, pg, oracle.

       -b database
	      Name of the database to use.

       -f file
	      Read password from file, instead of command line.

       -h host
	      Connect to host.

       -u user
	      User for login.

       -P port
	      Port number to use for connection.

       -p password
	      Password to use when connecting to server.

       -1     One-shot mode: push the file to database and exit.

       -x     Turn on debugging.

       file_path
	      The pathname of the SQL logfile to use.

NOTES

   Oracle driver
       The command "radsqlrelay -d oracle -b db.domain.tld sql-relay" reads the database description stored in $TNS_ADMIN/tnsnames.ora:

       db.domain.tld =
	 (DESCRIPTION =
	   (ADDRESS_LIST =
	     (ADDRESS = (PROTOCOL = TCP)(HOST = db.domain.tld)(PORT = 1521))
	   )
	   (CONNECT_DATA =
	     (SERVICE_NAME = <DB SID>)
	   )
	 )

SEE ALSO

       rlm_sql_log(5)

AUTHOR

       Nicolas Baradakis <nicolas.baradakis@cegetel.net>

								   19 June 2005 						    RADSQLRELAY(8)