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
PG_CLIENT_ENCODING(3)													     PG_CLIENT_ENCODING(3)

pg_client_encoding - Gets the client encoding

SYNOPSIS
string pg_client_encoding ([resource $connection]) DESCRIPTION
PostgreSQL supports automatic character set conversion between server and client for certain character sets. pg_client_encoding(3) returns the client encoding as a string. The returned string will be one of the standard PostgreSQL encoding identifiers. Note This function requires PHP 4.0.3 or higher and PostgreSQL 7.0 or higher. If libpq is compiled without multibyte encoding support, pg_client_encoding(3) always returns SQL_ASCII. Supported encoding depends on PostgreSQL version. Refer to the PostgreSQL Documenta- tion supported encodings. The function used to be called pg_clientencoding(3). PARAMETERS
o $connection - PostgreSQL database connection resource. When $connection is not present, the default connection is used. The default connection is the last connection made by pg_connect(3) or pg_pconnect(3). RETURN VALUES
The client encoding, or FALSE on error. EXAMPLES
Example #1 pg_client_encoding(3) example <?php // Assume $conn is a connection to a ISO-8859-1 database $encoding = pg_client_encoding($conn); echo "Client encoding is: ", $encoding, " "; ?> The above example will output: Client encoding is: ISO-8859-1 SEE ALSO
pg_set_client_encoding(3). PHP Documentation Group PG_CLIENT_ENCODING(3)
All times are GMT -4. The time now is 03:08 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy