Skip to Content
author's profile photo Former Member
Former Member

Fatal NI connect error 12560

Hi All,

I am having Windows platform and Oracle database.

I am doing a conversion of a non-unicode ECC 4.7 oracle 9.2 to

Unicode ECC 6.0 oracle 10g.

I have done the non unicode to unicode conversion of ECC 4.7 Now Doing Oracle Upgrade from 9.2 to 10g for this I am following the below Guide

*Upgrade to Oracle

Database 10g Release

2 (10.2): Windows

*

While in doing post Upgrade steps of oracle upgrade I need to run the sapdba_role.sql script file. after running this script I checked the log file named sqlnet.log it is Showing the below error.

#########################################################

Fatal NI connect error 12560, connecting to:

(DESCRIPTION=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle)(ARGV0=oracleECC)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(CONNECT_DATA=(SID=ECC)(CID=(PROGRAM=D:\oracle\ECC\102\BIN\sqlplus.exe)(HOST=GMS46)(USER=eccadm))))

VERSION INFORMATION:

TNS for 32-bit Windows: Version 10.2.0.1.0 - Production

Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 10.2.0.1.0 - Production

Time: 21-JAN-2008 12:39:45

Tracing not turned on.

Tns error struct:

ns main err code: 12560

TNS-12560: TNS:protocol adapter error

ns secondary err code: 0

nt main err code: 530

TNS-00530: Protocol adapter error

nt secondary err code: 2

nt OS err code: 0

#########################################################

Can anyone help me out..

Thankx in advance

Regards

Vinay Paul

Edited by: Vinay Paul on Jan 21, 2008 8:34 AM

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jan 21, 2008 at 09:01 PM

    Are you using Windows Terminal Server to work on your server? If yes, can you try to add the user environment variable LOCAL=<SID> and try again? If you do not want to do permanent changes in your system you can open a DOS box, set local=<your db sid> and try to execute the script again with sqlplus.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.