Fatal NI connect error 12560

[Former Member]

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

[Former Member · Accepted solution]

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.

[Former Member · Accepted solution]

Hi,

it worked for me thankyou