DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: reporting NS-12564 error as ORA-12564

  1. #1
    Join Date
    Jun 2007
    Posts
    60

    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

  2. #2
    Join Date
    Oct 2006
    Location
    Mumbai
    Posts
    184
    Hi,

    Please upload the entire tnsnames.ora of the client machine connecting to the RAC DB and the listener.log from each of the nodes.

    Suspect there is a problem in configuring the tnsnames.ora for the client, there has to have a common service name to connect to the instances...

    Also, please provide output if SQL client is able to connect to the RAC DB.

    On the CLient:

    SQL> conn system/@

    Regards,
    Paresh

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width