09-27-2008
reporting NS-12564 error as ORA-12564
Hi
My client connection to RAC Oracle Release 10.2.0.4.0 database suddenly stopped working.
ACPT_1 - works but not with OEM.
ACPT_2 - does not work at all.
Getting error ORA-12564: TNS:connection refused
Any ideas very much appreciated
Thanks
ACPT_1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = xxx.xxx.xxx.xxx)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SID = ACPT)
(INSTANCE_NAME = ACPT1)
)
)
ACPT_2 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = xxx.xxx.xxx.xxx)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = ACPT)
(INSTANCE_NAME = ACPT1)
)
)
The extract from the client trace file is below
(5316) [000001 28-SEP-2008 09:29:04:771] snsbitts_ts: acquired the bit
(5316) [000001 28-SEP-2008 09:29:04:771] snsbitts_ts: acquired the bit
(5316) [000001 28-SEP-2008 09:29:04:771] nsmfr: 1644 bytes at 0x513b9e8
(5316) [000001 28-SEP-2008 09:29:04:771] nsmfr: 736 bytes at 0x5155cf8
(5316) [000001 28-SEP-2008 09:29:04:771] nscall: connecting...
(5316) [000001 28-SEP-2008 09:29:04:771] nladget: entry
(5316) [000001 28-SEP-2008 09:29:04:771] nladget: exit
(5316) [000001 28-SEP-2008 09:29:04:771] nsmfr: 297 bytes at 0x5149478
(5316) [000001 28-SEP-2008 09:29:04:771] nsmfr: 212 bytes at 0x514fef8
(5316) [000001 28-SEP-2008 09:29:04:771] nladtrm: entry
(5316) [000001 28-SEP-2008 09:29:04:771] nladtrm: exit
(5316) [000001 28-SEP-2008 09:29:04:771] nioqper: error from nscall
(5316) [000001 28-SEP-2008 09:29:04:771] nioqper: ns main err code: 12564
(5316) [000001 28-SEP-2008 09:29:04:771] nioqper: ns (2) err code: 0
(5316) [000001 28-SEP-2008 09:29:04:771] nioqper: nt main err code: 0
(5316) [000001 28-SEP-2008 09:29:04:771] nioqper: nt (2) err code: 0
(5316) [000001 28-SEP-2008 09:29:04:771] nioqper: nt OS err code: 0
(5316) [000001 28-SEP-2008 09:29:04:771] niomapnserror: entry
(5316) [000001 28-SEP-2008 09:29:04:771] niqme: entry
(5316) [000001 28-SEP-2008 09:29:04:771] niqme: reporting NS-12564 error as ORA-12564
(5316) [000001 28-SEP-2008 09:29:04:771] niqme: exit
(5316) [000001 28-SEP-2008 09:29:04:771] niomapnserror: exit
(5316) [000001 28-SEP-2008 09:29:04:771] niqme: entry
(5316) [000001 28-SEP-2008 09:29:04:771] niqme: NSG error 1153 outside of range 12500 to 12530 - reporting as internal error ORA-12160
(5316) [000001 28-SEP-2008 09:29:04:771] niqme: exit
(5316) [000001 28-SEP-2008 09:29:04:771] niotns: Couldn't connect, returning 12564
(5316) [000001 28-SEP-2008 09:29:04:771] niotns: exit
(5316) [000001 28-SEP-2008 09:29:04:771] nsbrfr: nsbfs at 0x51487a8, data at 0x513eef0.
(5316) [000001 28-SEP-2008 09:29:04:771] nsbrfr: nsbfs at 0x5148748, data at 0x513f710.
(5316) [000001 28-SEP-2008 09:29:04:771] nsbrfr: nsbfs at 0x3def858, data at 0x513dff0.
(5316) [000001 28-SEP-2008 09:29:04:771] nigtrm: Count in the NI global area is now 0
(5316) [000001 28-SEP-2008 09:29:04:771] nrigbd: entry
(5316) [000001 28-SEP-2008 09:29:04:771] nrigbd: exit
(5316) [000001 28-SEP-2008 09:29:04:771] nigtrm: Count in the NL global area is now 0
(5316) [000001 28-SEP-2008 09:29:04:771] nlse_term_audit: entry
(5316) [000001 28-SEP-2008 09:29:04:771] nlse_term_audit: exit
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
hi all,
i've got a script that takes in what a user enters (multiple entries) and then joins them all together and appends this to a file. what i want to happen now is the terminal should display "record saved" if the save to the file is successful, if it isn't just display the standard unix... (2 Replies)
Discussion started by: wazzag
2 Replies
2. 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
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. UNIX for Dummies Questions & Answers
I am very new to unix/linux and am unsure how to do the following tasks within my script
1) append a log file and add a timestamped echo "Error occured" to it, if posibble to print it to file and on screen at the same time would be even better.
2) As my main script will be calling on a couple... (1 Reply)
Discussion started by: shamwick
1 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. 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
8. 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
9. AIX
Hi
A few days ago I attached an usb external disk to a server running AIX, then I removed it without typing any commands. Now, the server can't find the usb device and it keeps reporting the errors every 3 hours, like this
55479D40 0112080017 T H usbms0 ADDITIONAL INFORMATION... (2 Replies)
Discussion started by: bobochacha29
2 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 REDHAT
ztrsna
ZTRSNA(l) ) ZTRSNA(l)
NAME
ZTRSNA - estimate reciprocal condition numbers for specified eigenvalues and/or right eigenvectors of a complex upper triangular matrix T
(or of any matrix Q*T*Q**H with Q unitary)
SYNOPSIS
SUBROUTINE ZTRSNA( JOB, HOWMNY, SELECT, N, T, LDT, VL, LDVL, VR, LDVR, S, SEP, MM, M, WORK, LDWORK, RWORK, INFO )
CHARACTER HOWMNY, JOB
INTEGER INFO, LDT, LDVL, LDVR, LDWORK, M, MM, N
LOGICAL SELECT( * )
DOUBLE PRECISION RWORK( * ), S( * ), SEP( * )
COMPLEX*16 T( LDT, * ), VL( LDVL, * ), VR( LDVR, * ), WORK( LDWORK, * )
PURPOSE
ZTRSNA estimates reciprocal condition numbers for specified eigenvalues and/or right eigenvectors of a complex upper triangular matrix T
(or of any matrix Q*T*Q**H with Q unitary).
ARGUMENTS
JOB (input) CHARACTER*1
Specifies whether condition numbers are required for eigenvalues (S) or eigenvectors (SEP):
= 'E': for eigenvalues only (S);
= 'V': for eigenvectors only (SEP);
= 'B': for both eigenvalues and eigenvectors (S and SEP).
HOWMNY (input) CHARACTER*1
= 'A': compute condition numbers for all eigenpairs;
= 'S': compute condition numbers for selected eigenpairs specified by the array SELECT.
SELECT (input) LOGICAL array, dimension (N)
If HOWMNY = 'S', SELECT specifies the eigenpairs for which condition numbers are required. To select condition numbers for the j-th
eigenpair, SELECT(j) must be set to .TRUE.. If HOWMNY = 'A', SELECT is not referenced.
N (input) INTEGER
The order of the matrix T. N >= 0.
T (input) COMPLEX*16 array, dimension (LDT,N)
The upper triangular matrix T.
LDT (input) INTEGER
The leading dimension of the array T. LDT >= max(1,N).
VL (input) COMPLEX*16 array, dimension (LDVL,M)
If JOB = 'E' or 'B', VL must contain left eigenvectors of T (or of any Q*T*Q**H with Q unitary), corresponding to the eigenpairs
specified by HOWMNY and SELECT. The eigenvectors must be stored in consecutive columns of VL, as returned by ZHSEIN or ZTREVC. If
JOB = 'V', VL is not referenced.
LDVL (input) INTEGER
The leading dimension of the array VL. LDVL >= 1; and if JOB = 'E' or 'B', LDVL >= N.
VR (input) COMPLEX*16 array, dimension (LDVR,M)
If JOB = 'E' or 'B', VR must contain right eigenvectors of T (or of any Q*T*Q**H with Q unitary), corresponding to the eigenpairs
specified by HOWMNY and SELECT. The eigenvectors must be stored in consecutive columns of VR, as returned by ZHSEIN or ZTREVC. If
JOB = 'V', VR is not referenced.
LDVR (input) INTEGER
The leading dimension of the array VR. LDVR >= 1; and if JOB = 'E' or 'B', LDVR >= N.
S (output) DOUBLE PRECISION array, dimension (MM)
If JOB = 'E' or 'B', the reciprocal condition numbers of the selected eigenvalues, stored in consecutive elements of the array.
Thus S(j), SEP(j), and the j-th columns of VL and VR all correspond to the same eigenpair (but not in general the j-th eigenpair,
unless all eigenpairs are selected). If JOB = 'V', S is not referenced.
SEP (output) DOUBLE PRECISION array, dimension (MM)
If JOB = 'V' or 'B', the estimated reciprocal condition numbers of the selected eigenvectors, stored in consecutive elements of the
array. If JOB = 'E', SEP is not referenced.
MM (input) INTEGER
The number of elements in the arrays S (if JOB = 'E' or 'B') and/or SEP (if JOB = 'V' or 'B'). MM >= M.
M (output) INTEGER
The number of elements of the arrays S and/or SEP actually used to store the estimated condition numbers. If HOWMNY = 'A', M is
set to N.
WORK (workspace) COMPLEX*16 array, dimension (LDWORK,N+1)
If JOB = 'E', WORK is not referenced.
LDWORK (input) INTEGER
The leading dimension of the array WORK. LDWORK >= 1; and if JOB = 'V' or 'B', LDWORK >= N.
RWORK (workspace) DOUBLE PRECISION array, dimension (N)
If JOB = 'E', RWORK is not referenced.
INFO (output) INTEGER
= 0: successful exit
< 0: if INFO = -i, the i-th argument had an illegal value
FURTHER DETAILS
The reciprocal of the condition number of an eigenvalue lambda is defined as
S(lambda) = |v'*u| / (norm(u)*norm(v))
where u and v are the right and left eigenvectors of T corresponding to lambda; v' denotes the conjugate transpose of v, and norm(u)
denotes the Euclidean norm. These reciprocal condition numbers always lie between zero (very badly conditioned) and one (very well condi-
tioned). If n = 1, S(lambda) is defined to be 1.
An approximate error bound for a computed eigenvalue W(i) is given by
EPS * norm(T) / S(i)
where EPS is the machine precision.
The reciprocal of the condition number of the right eigenvector u corresponding to lambda is defined as follows. Suppose
T = ( lambda c )
( 0 T22 )
Then the reciprocal condition number is
SEP( lambda, T22 ) = sigma-min( T22 - lambda*I )
where sigma-min denotes the smallest singular value. We approximate the smallest singular value by the reciprocal of an estimate of the
one-norm of the inverse of T22 - lambda*I. If n = 1, SEP(1) is defined to be abs(T(1,1)).
An approximate error bound for a computed right eigenvector VR(i) is given by
EPS * norm(T) / SEP(i)
LAPACK version 3.0 15 June 2000 ZTRSNA(l)