I am not able to view the data for the Oracle9i stage. The error is ORA-12154: TNS:could not resolve service name. I tried on the datastage server and got the same error
Code: Select all
$ sqlplus username/password@SID
SQL*Plus: Release 9.2.0.4.0 - Production on Wed May 4 19:22:24 2005
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
ERROR:
ORA-12154: TNS:could not resolve service name
Code: Select all
$ sqlplus
SQL*Plus: Release 9.2.0.4.0 - Production on Wed May 4 19:21:17 2005
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Enter user-name: rcil
Enter password:
Connected to:
Oracle Database 10g Enterprise Edition Release 10.1.0.3.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
thanks