Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Problem in accessing Oracle Database Server from Linux Machine
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
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
 

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... (3 Replies)
Discussion started by: natter
3 Replies

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 Replies)
Discussion started by: ganga
3 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. 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

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... (3 Replies)
Discussion started by: mraghunandanan
3 Replies

LEARN ABOUT MOJAVE

datetime::locale::am

DateTime::Locale::am(3) 				User Contributed Perl Documentation				   DateTime::Locale::am(3)

NAME

       DateTime::Locale::am

SYNOPSIS

	 use DateTime;

	 my $dt = DateTime->now( locale => 'am' );
	 print $dt->month_name();

DESCRIPTION

       This is the DateTime locale package for Amharic.

DATA

       This locale inherits from the DateTime::Locale::root locale.

       It contains the following data.

   Days
       Wide (format)

	 XX
	 XXXX
	 XXX
	 XXX
	 XXX
	 XXX
	 XXX

       Abbreviated (format)

	 XX
	 XXX
	 XXX
	 XXX
	 XXX
	 XXX
	 XXX

       Narrow (format)

	 X
	 X
	 X
	 X
	 X
	 X
	 X

       Wide (stand-alone)

	 XX
	 XXXX
	 XXX
	 XXX
	 XXX
	 XXX
	 XXX

       Abbreviated (stand-alone)

	 XX
	 XXX
	 XXX
	 XXX
	 XXX
	 XXX
	 XXX

       Narrow (stand-alone)

	 X
	 X
	 X
	 X
	 X
	 X
	 X

   Months
       Wide (format)

	 XXXXX
	 XXXXX
	 XXX
	 XXXX
	 XX
	 XX
	 XXX
	 XXXX
	 XXXXXX
	 XXXXXX
	 XXXXX
	 XXXXX

       Abbreviated (format)

	 XXX
	 XXX
	 XXX
	 XXX
	 XX
	 XX
	 XXX
	 XXX
	 XXX
	 XXX
	 XXX
	 XXX

       Narrow (format)

	 X
	 X
	 X
	 X
	 X
	 X
	 X
	 X
	 X
	 X
	 X
	 X

       Wide (stand-alone)

	 XXXXX
	 XXXXX
	 XXX
	 XXXX
	 XX
	 XX
	 XXX
	 XXXX
	 XXXXXX
	 XXXXXX
	 XXXXX
	 XXXXX

       Abbreviated (stand-alone)

	 XXX
	 XXX
	 XXX
	 XXX
	 XX
	 XX
	 XXX
	 XXX
	 XXX
	 XXX
	 XXX
	 XXX

       Narrow (stand-alone)

	 X
	 X
	 X
	 X
	 X
	 X
	 X
	 X
	 X
	 X
	 X
	 X

   Quarters
       Wide (format)

	 Q1
	 Q2
	 Q3
	 Q4

       Abbreviated (format)

	 Q1
	 Q2
	 Q3
	 Q4

       Narrow (format)

	 1
	 2
	 3
	 4

       Wide (stand-alone)

	 Q1
	 Q2
	 Q3
	 Q4

       Abbreviated (stand-alone)

	 Q1
	 Q2
	 Q3
	 Q4

       Narrow (stand-alone)

	 1
	 2
	 3
	 4

   Eras
       Wide

	 BCE
	 CE

       Abbreviated

	 X/X
	 X/X

       Narrow

	 X/X
	 X/X

   Date Formats
       Full

	  2008-02-05T18:30:30 = XXXXX 05 XXXXX XX 2008 X/X
	  1995-12-22T09:05:02 = XXXX 22 XXXXX XX 1995 X/X
	 -0010-09-15T04:44:23 = XXXX 15 XXXXXX XX -10 X/X

       Long

	  2008-02-05T18:30:30 = 05 XXXXX 2008
	  1995-12-22T09:05:02 = 22 XXXXX 1995
	 -0010-09-15T04:44:23 = 15 XXXXXX -10

       Medium

	  2008-02-05T18:30:30 = XXX 5 2008
	  1995-12-22T09:05:02 = XXX 22 1995
	 -0010-09-15T04:44:23 = XXX 15 -10

       Short

	  2008-02-05T18:30:30 = 05/02/08
	  1995-12-22T09:05:02 = 22/12/95
	 -0010-09-15T04:44:23 = 15/09/-10

       Default

	  2008-02-05T18:30:30 = XXX 5 2008
	  1995-12-22T09:05:02 = XXX 22 1995
	 -0010-09-15T04:44:23 = XXX 15 -10

   Time Formats
       Full

	  2008-02-05T18:30:30 = 06:30:30 XXXX UTC
	  1995-12-22T09:05:02 = 09:05:02 XXX UTC
	 -0010-09-15T04:44:23 = 04:44:23 XXX UTC

       Long

	  2008-02-05T18:30:30 = 06:30:30 XXXX UTC
	  1995-12-22T09:05:02 = 09:05:02 XXX UTC
	 -0010-09-15T04:44:23 = 04:44:23 XXX UTC

       Medium

	  2008-02-05T18:30:30 = 6:30:30 XXXX
	  1995-12-22T09:05:02 = 9:05:02 XXX
	 -0010-09-15T04:44:23 = 4:44:23 XXX

       Short

	  2008-02-05T18:30:30 = 6:30 XXXX
	  1995-12-22T09:05:02 = 9:05 XXX
	 -0010-09-15T04:44:23 = 4:44 XXX

       Default

	  2008-02-05T18:30:30 = 6:30:30 XXXX
	  1995-12-22T09:05:02 = 9:05:02 XXX
	 -0010-09-15T04:44:23 = 4:44:23 XXX

   Datetime Formats
       Full

	  2008-02-05T18:30:30 = XXXXX 05 XXXXX XX 2008 X/X 06:30:30 XXXX UTC
	  1995-12-22T09:05:02 = XXXX 22 XXXXX XX 1995 X/X 09:05:02 XXX UTC
	 -0010-09-15T04:44:23 = XXXX 15 XXXXXX XX -10 X/X 04:44:23 XXX UTC

       Long

	  2008-02-05T18:30:30 = 05 XXXXX 2008 06:30:30 XXXX UTC
	  1995-12-22T09:05:02 = 22 XXXXX 1995 09:05:02 XXX UTC
	 -0010-09-15T04:44:23 = 15 XXXXXX -10 04:44:23 XXX UTC

       Medium

	  2008-02-05T18:30:30 = XXX 5 2008 6:30:30 XXXX
	  1995-12-22T09:05:02 = XXX 22 1995 9:05:02 XXX
	 -0010-09-15T04:44:23 = XXX 15 -10 4:44:23 XXX

       Short

	  2008-02-05T18:30:30 = 05/02/08 6:30 XXXX
	  1995-12-22T09:05:02 = 22/12/95 9:05 XXX
	 -0010-09-15T04:44:23 = 15/09/-10 4:44 XXX

       Default

	  2008-02-05T18:30:30 = XXX 5 2008 6:30:30 XXXX
	  1995-12-22T09:05:02 = XXX 22 1995 9:05:02 XXX
	 -0010-09-15T04:44:23 = XXX 15 -10 4:44:23 XXX

   Available Formats
       d (d)

	  2008-02-05T18:30:30 = 5
	  1995-12-22T09:05:02 = 22
	 -0010-09-15T04:44:23 = 15

       EEEd (d EEE)

	  2008-02-05T18:30:30 = 5 XXX
	  1995-12-22T09:05:02 = 22 XXX
	 -0010-09-15T04:44:23 = 15 XXX

       Hm (H:mm)

	  2008-02-05T18:30:30 = 18:30
	  1995-12-22T09:05:02 = 9:05
	 -0010-09-15T04:44:23 = 4:44

       hm (h:mm a)

	  2008-02-05T18:30:30 = 6:30 XXXX
	  1995-12-22T09:05:02 = 9:05 XXX
	 -0010-09-15T04:44:23 = 4:44 XXX

       Hms (H:mm:ss)

	  2008-02-05T18:30:30 = 18:30:30
	  1995-12-22T09:05:02 = 9:05:02
	 -0010-09-15T04:44:23 = 4:44:23

       hms (h:mm:ss a)

	  2008-02-05T18:30:30 = 6:30:30 XXXX
	  1995-12-22T09:05:02 = 9:05:02 XXX
	 -0010-09-15T04:44:23 = 4:44:23 XXX

       M (L)

	  2008-02-05T18:30:30 = 2
	  1995-12-22T09:05:02 = 12
	 -0010-09-15T04:44:23 = 9

       Md (M-d)

	  2008-02-05T18:30:30 = 2-5
	  1995-12-22T09:05:02 = 12-22
	 -0010-09-15T04:44:23 = 9-15

       MEd (E, M-d)

	  2008-02-05T18:30:30 = XXX, 2-5
	  1995-12-22T09:05:02 = XXX, 12-22
	 -0010-09-15T04:44:23 = XXX, 9-15

       MMdd (dd/MM)

	  2008-02-05T18:30:30 = 05/02
	  1995-12-22T09:05:02 = 22/12
	 -0010-09-15T04:44:23 = 15/09

       MMM (LLL)

	  2008-02-05T18:30:30 = XXX
	  1995-12-22T09:05:02 = XXX
	 -0010-09-15T04:44:23 = XXX

       MMMd (MMM d)

	  2008-02-05T18:30:30 = XXX 5
	  1995-12-22T09:05:02 = XXX 22
	 -0010-09-15T04:44:23 = XXX 15

       MMMEd (E MMM d)

	  2008-02-05T18:30:30 = XXX XXX 5
	  1995-12-22T09:05:02 = XXX XXX 22
	 -0010-09-15T04:44:23 = XXX XXX 15

       MMMMd (MMMM d)

	  2008-02-05T18:30:30 = XXXXX 5
	  1995-12-22T09:05:02 = XXXXX 22
	 -0010-09-15T04:44:23 = XXXXXX 15

       MMMMdd (dd MMMM)

	  2008-02-05T18:30:30 = 05 XXXXX
	  1995-12-22T09:05:02 = 22 XXXXX
	 -0010-09-15T04:44:23 = 15 XXXXXX

       MMMMEd (E MMMM d)

	  2008-02-05T18:30:30 = XXX XXXXX 5
	  1995-12-22T09:05:02 = XXX XXXXX 22
	 -0010-09-15T04:44:23 = XXX XXXXXX 15

       ms (mm:ss)

	  2008-02-05T18:30:30 = 30:30
	  1995-12-22T09:05:02 = 05:02
	 -0010-09-15T04:44:23 = 44:23

       y (y)

	  2008-02-05T18:30:30 = 2008
	  1995-12-22T09:05:02 = 1995
	 -0010-09-15T04:44:23 = -10

       yM (y-M)

	  2008-02-05T18:30:30 = 2008-2
	  1995-12-22T09:05:02 = 1995-12
	 -0010-09-15T04:44:23 = -10-9

       yMEd (EEE, y-M-d)

	  2008-02-05T18:30:30 = XXX, 2008-2-5
	  1995-12-22T09:05:02 = XXX, 1995-12-22
	 -0010-09-15T04:44:23 = XXX, -10-9-15

       yMMM (y MMM)

	  2008-02-05T18:30:30 = 2008 XXX
	  1995-12-22T09:05:02 = 1995 XXX
	 -0010-09-15T04:44:23 = -10 XXX

       yMMMEd (EEE, y MMM d)

	  2008-02-05T18:30:30 = XXX, 2008 XXX 5
	  1995-12-22T09:05:02 = XXX, 1995 XXX 22
	 -0010-09-15T04:44:23 = XXX, -10 XXX 15

       yMMMM (y MMMM)

	  2008-02-05T18:30:30 = 2008 XXXXX
	  1995-12-22T09:05:02 = 1995 XXXXX
	 -0010-09-15T04:44:23 = -10 XXXXXX

       yQ (y Q)

	  2008-02-05T18:30:30 = 2008 1
	  1995-12-22T09:05:02 = 1995 4
	 -0010-09-15T04:44:23 = -10 3

       yQQQ (y QQQ)

	  2008-02-05T18:30:30 = 2008 Q1
	  1995-12-22T09:05:02 = 1995 Q4
	 -0010-09-15T04:44:23 = -10 Q3

       yyMM (MM/yy)

	  2008-02-05T18:30:30 = 02/08
	  1995-12-22T09:05:02 = 12/95
	 -0010-09-15T04:44:23 = 09/-10

       yyQ (Q yy)

	  2008-02-05T18:30:30 = 1 08
	  1995-12-22T09:05:02 = 4 95
	 -0010-09-15T04:44:23 = 3 -10

       yyyyMMMM (MMMM y)

	  2008-02-05T18:30:30 = XXXXX 2008
	  1995-12-22T09:05:02 = XXXXX 1995
	 -0010-09-15T04:44:23 = XXXXXX -10

   Miscellaneous
       Prefers 24 hour time?

       No

       Local first day of the week

       XX

SUPPORT

       See DateTime::Locale.

AUTHOR

       Dave Rolsky <autarch@urth.org>

COPYRIGHT

       Copyright (c) 2008 David Rolsky. All rights reserved. This program is free software; you can redistribute it and/or modify it under the
       same terms as Perl itself.

       This module was generated from data provided by the CLDR project, see the LICENSE.cldr in this distribution for details on the CLDR data's
       license.

perl v5.18.2							    2017-10-06						   DateTime::Locale::am(3)
All times are GMT -4. The time now is 05:39 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy