11-09-2009
The oracle instance TTTEST is not defined in the tnsnames.ora file on the box where you issued the sqlplus command.
10 More Discussions You Might Find Interesting
1. Linux
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... (3 Replies)
Discussion started by: yajneshilu
3 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
ghkjkjoj (4 Replies)
Discussion started by: chetankelvin
4 Replies
4. UNIX for Advanced & Expert Users
Hi all
We connect to 10 Oracle Databases from our UNIX box through the regular TNS file we have on any oracle client installation.
Recently we acquired a new connection. I added the entries as usual to the TNS file. The connection fails with the below error message
ORA-12541: TNS:no... (2 Replies)
Discussion started by: b_sri
2 Replies
5. 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
6. 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
7. Red Hat
Hi,
I am facing a strange issue when connecting to SQLPLUS via a shell scripts.
I am using Linux 2.6.18-274.18.1 and gbash shell.
When I connect to SQLPLUS through scripts then it throws TNS Time Out error ""sometimes"" and connects successfully other times.This is only happening when... (9 Replies)
Discussion started by: aashish.sharma8
9 Replies
8. Shell Programming and Scripting
Platform: Oracle Linux 6.3
From a log file, I want to grep all lines with the pattern "TNS-" but I want to skip those with the pattern "TNS-12514" . How can I do this ? (3 Replies)
Discussion started by: John K
3 Replies
9. Shell Programming and Scripting
I have requirement to replace old TNS entries with New one in multiple files.
one file may contain more then one occurrence of tns.
Example: Below is the one of occurrence in a current file(s). i am interested to replace only red part.
<connection-pool name="Google_APP_CP"... (4 Replies)
Discussion started by: KDDubai333
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
config::general::interpolated
General::Interpolated(3pm) User Contributed Perl Documentation General::Interpolated(3pm)
NAME
Config::General::Interpolated - Parse variables within Config files
SYNOPSIS
use Config::General;
$conf = new Config::General(
-ConfigFile => 'configfile',
-InterPolateVars => 1
);
DESCRIPTION
This is an internal module which makes it possible to interpolate Perl style variables in your config file (i.e. $variable or
"${variable}").
Normally you don't call it directly.
VARIABLES
Variables can be defined everywhere in the config and can be used afterwards as the value of an option. Variables cannot be used as keys or
as part of keys.
If you define a variable inside a block or a named block then it is only visible within this block or within blocks which are defined
inside this block. Well - let's take a look to an example:
# sample config which uses variables
basedir = /opt/ora
user = t_space
sys = unix
<table intern>
instance = INTERN
owner = $user # "t_space"
logdir = $basedir/log # "/opt/ora/log"
sys = macos
<procs>
misc1 = ${sys}_${instance} # macos_INTERN
misc2 = $user # "t_space"
</procs>
</table>
This will result in the following structure:
{
'basedir' => '/opt/ora',
'user' => 't_space'
'sys' => 'unix',
'table' => {
'intern' => {
'sys' => 'macos',
'logdir' => '/opt/ora/log',
'instance' => 'INTERN',
'owner' => 't_space',
'procs' => {
'misc1' => 'macos_INTERN',
'misc2' => 't_space'
}
}
}
As you can see, the variable sys has been defined twice. Inside the <procs> block a variable ${sys} has been used, which then were
interpolated into the value of sys defined inside the <table> block, not the sys variable one level above. If sys were not defined inside
the <table> block then the "global" variable sys would have been used instead with the value of "unix".
Variables inside double quotes will be interpolated, but variables inside single quotes will not interpolated. This is the same behavior as
you know of Perl itself.
In addition you can surround variable names with curly braces to avoid misinterpretation by the parser.
SEE ALSO
Config::General
AUTHORS
Thomas Linden <tlinden |AT| cpan.org>
Autrijus Tang <autrijus@autrijus.org>
Wei-Hon Chen <plasmaball@pchome.com.tw>
COPYRIGHT
Copyright 2001 by Wei-Hon Chen <plasmaball@pchome.com.tw>. Copyright 2002-2010 by Thomas Linden <tlinden |AT| cpan.org>.
This program is free software; you can redistribute it and/or modify it under the same terms as Perl itself.
See <http://www.perl.com/perl/misc/Artistic.html>
VERSION
2.14
perl v5.10.1 2010-12-01 General::Interpolated(3pm)