ChannelDB2

Query Oracle nickname returns SQL1097N error

Problem

select * from ora_nick
SQL1097N The node name was not found in the node directory.

And there is following error in db2diag.log

2010-10-21-18.43.05.633000-420 E44694087H664 LEVEL: Error
PID : 2424 TID : 4780 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : FEDDB
APPHDL : 0-145 APPID: *LOCAL.DB2.101022014258
AUTHID : USER
EDUID : 4780 EDUNAME: db2agent (FEDDB) 0
FUNCTION: DB2 UDB, net8 wrapper, Net8_Connection::error_report, probe:30
DATA #1 : String, 28 bytes
Oracle Error - Current User
DATA #2 : String with size, 5 bytes
QCFYY
DATA #3 : String, 22 bytes
Oracle Error Received
DATA #4 : String, 66 bytes
ORA-12154: TNS:could not resolve the connect identifier specified


Explanation and Resolution

From the error in db2diag.log, we know Federation Server Oracle wrapper detects ORA-12154 error from Oracle and reports back.
ORA-12154 error is caused by Oracle related configuration change if Federation Server has not been changed.
Specifically, please double anything is changed in tsnames.ora file.

Other reference document about resolution of ORA-12154
http://www-01.ibm.com/support/docview.wss?uid=swg21231112
http://ora-12154.ora-code.com

Views: 191

Tags: DB2, Federation, Information, Integration, SQL1097N, oracle, wrapper, wrapperORA-12154

Comment

You need to be a member of ChannelDB2 to add comments!

Join ChannelDB2

Try BLU Acceleration on Cloud

© 2014   Created by channeldb2.

Badges  |  Report an Issue  |  Terms of Service