Sponsored Content
Top Forums UNIX for Advanced & Expert Users reporting NS-12564 error as ORA-12564 Post 302241006 by zam on Saturday 27th of September 2008 08:22:22 PM
Old 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

Question about error reporting

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

KSH to find a ORA error in a log file

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

error ORA-06512 while running query in script

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

Error reporting script

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

maxuprc and maxusers - ORA-27300, ORA-27301, ORA-27302

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

grep all ORA errors except one ORA error

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

ORA-27300 error because of 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

ORA-06512 Error in Oracle 10g

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

How to disable an error reporting ???

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

Ora-27603:ora-27626:

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
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)
All times are GMT -4. The time now is 11:43 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy