11-15-2008
Try thousand times could not resolve famous ORA-12514 error
It is related to Linux, Oracle 9.2.0. I am new to Oracle.
I am trying to connect to Oracle database say A, but as I am running this command dbstart the error is
“ORA-12514: TNS: listener could not resolve SERVICE_NAME given in connect descriptor”
I have successfully started lsnrctl. Here are respective ora files. Please tell me where I am wrong?
My ORACLE_HOME is set as:
/home/oracle/product/9.2.0
Here are my tnsnames.ora, listener.ora & sqlnet.ora files. For clarification database names are "Pana" & "Pana2", host name is "pana".
TNSNAMES.ORA::
PANA2 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)
(HOST = pana)(PORT = 1521)
(CONNECT_DATA = (SERVER = DEDICATED)
(SERVICE_NAME = Pana)
)
)
PANA =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)
(HOST = pana)(PORT = 1521)
(CONNECT_DATA = (SERVER = DEDICATED)
(SERVICE_NAME = Pana)
)
)
LISTENER.ORA:
LISTENER =
(ADDRESS = (PROTOCOL = TCP) (HOST = pana)(PORT = 1521))
SID_LIST_LISTENER =
(SID_LIST =
(SID_DES =
(GLOBAL_DBNAME = Pana2)
(ORACLE_HOME = /home/oracle/product/9.2.0)
(SID_NAME = Pana)
)
(SID_DES =
(GLOBAL_DBNAME = Pana)
(ORACLE_HOME = /home/oracle/product/9.2.0)
(SID_NAME = Pana)
)
)
SQLNET.ORA::
SQLNET.AUTHENICATION_SERVICE = (NONE)
NAMES.DEFAULT_DOMAIN = localadmin
NAMES.DIRECTORY_PATH = (TNSNAMES, ONAMES, HOSTNAME)
NAMES.PREFERRED_SERVERS =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = TCP)
(PORT = 1521)
(HOST = Pana2)
)
(ADDRESS =
(PROTOCOL = TCP)
(PORT = 1521)
(HOST = Pana)
)
)
10 More Discussions You Might Find Interesting
1. HP-UX
Hi:
i have writen a script that needs a finishing
Pourpouse is to find a particular error in a file after we enter file name
and the return msg would describe if >there is a error -> "Contact DBA"
if there is no oracle error ->"No ora error found."
for the same i have written a script... (6 Replies)
Discussion started by: techbravo
6 Replies
2. Linux
Recently I was struggling to resolve ORA-12514 error, after I solved that there is a another error "TNS-12535: TNS: operation timed out". For your information in my machine I have disabled firewall & also added SQLNET.EXPIRE_TIME = 10. But the problem is still persists. Again all your help is... (2 Replies)
Discussion started by: yajneshilu
2 Replies
3. Shell Programming and Scripting
1 #!/bin/ksh
2 ################################################################
3 # Written by Johnson 12/03/2008
4 # Version 1.0
5 # This script executes some SQL to provide Spike Check Report to TNS team.
6 ... (3 Replies)
Discussion started by: shivanete
3 Replies
4. Ubuntu
Hi,
Iam trying to run a gmake command and have the latest version of Gnu in my redhat linux system.
I need to execute the following steps;
---> chmod +x utils/*
---> ./utils/AllCodeManagerFix
---> gmake LINUX
Iam able to do the chmod command but when I run the second command I get... (2 Replies)
Discussion started by: viji19812001
2 Replies
5. UNIX for Dummies Questions & Answers
Hi everyone,
when i run ;
sqlplus -s username/password@TTTEST @umt.sql
i take "ORA-12154: TNS:could not resolve service name"
i want to run "umt.sql" query and also see result.
thanx for your helping. (6 Replies)
Discussion started by: temhem
6 Replies
6. Solaris
Hi all,
Am intermittently getting the following errors on one of my databases.
Errors in file /oracle/HRD/saptrace/background/hrd_psp0_13943.trc:
ORA-27300: OS system dependent operation:fork failed with status: 12
ORA-27301: OS failure message: Not enough space
ORA-27302:... (1 Reply)
Discussion started by: newbie_01
1 Replies
7. UNIX for Advanced & Expert Users
Hi - I am trying to grep all "ORA" errors in a log files.I have to grep all ORA errors except one error for example ORA-01653.How can exclude that error in "grep" command?
In following "grep" command I want to exclude "ORA-01653" error
grep -i ORA alert.log >>/tmp/ora_errors.txt
... (7 Replies)
Discussion started by: Mansoor8810
7 Replies
8. HP-UX
Dear All,
i am not able to start the 9i oracle database because of the following problems.
I log in into unix
and then into sqlplus
export oracle_sid=SATEST
startup nomount
i am getting the following errors
ORA-27300: OS system dependent operation:semget failed with... (3 Replies)
Discussion started by: alokpattar
3 Replies
9. HP-UX
HI All ,
I am using oracle 10g and HP AIX . I am getting the below error while running the package.
ORA-29280: invalid directory path
ORA-06512: at "SYS.UTL_FILE", line 41
ORA-06512: at "SYS.UTL_FILE", line 478
ORA-06512: at "DW_APP.PKG_ASS_FVC", line 595
ORA-06512: at line 2
... (4 Replies)
Discussion started by: Perlbaby
4 Replies
10. Red Hat
Hi,
User claim that job is running slow from their end.
I DBA found in database the below errors in alert log file.
ORA-27603: Cell storage I/O error, I/O failed on disk o/192.168.10.3/RECO_DM01_CD_01_drm01 at offset 13335789568 for data length 1048576
ORA-27626: Exadata error: 2201 (IO... (2 Replies)
Discussion started by: Maddy123
2 Replies
LEARN ABOUT DEBIAN
net::time
Net::Time(3perl) Perl Programmers Reference Guide Net::Time(3perl)
NAME
Net::Time - time and daytime network client interface
SYNOPSIS
use Net::Time qw(inet_time inet_daytime);
print inet_time(); # use default host from Net::Config
print inet_time('localhost');
print inet_time('localhost', 'tcp');
print inet_daytime(); # use default host from Net::Config
print inet_daytime('localhost');
print inet_daytime('localhost', 'tcp');
DESCRIPTION
"Net::Time" provides subroutines that obtain the time on a remote machine.
inet_time ( [HOST [, PROTOCOL [, TIMEOUT]]])
Obtain the time on "HOST", or some default host if "HOST" is not given or not defined, using the protocol as defined in RFC868. The
optional argument "PROTOCOL" should define the protocol to use, either "tcp" or "udp". The result will be a time value in the same
units as returned by time() or undef upon failure.
inet_daytime ( [HOST [, PROTOCOL [, TIMEOUT]]])
Obtain the time on "HOST", or some default host if "HOST" is not given or not defined, using the protocol as defined in RFC867. The
optional argument "PROTOCOL" should define the protocol to use, either "tcp" or "udp". The result will be an ASCII string or undef upon
failure.
AUTHOR
Graham Barr <gbarr@pobox.com>
COPYRIGHT
Copyright (c) 1995-2004 Graham Barr. All rights reserved. This program is free software; you can redistribute it and/or modify it under
the same terms as Perl itself.
perl v5.14.2 2010-12-30 Net::Time(3perl)