Oracle Table Error
Moderators: chulett, rschirm, roy
Oracle Table Error
Hi All
I am trying to extract data from an Oracle table. I can see the data when I put the connection credentials of the database and view the data from the Oracle Enterprise stage. I also see the database connection parameters present in the TNSNAMES.ORA file on the unix server. But when I try to run the job I get the following error.
ITEM_MASTER,0: Fatal Error: Fatal: ORA-12154: TNS:could not resolve the connect identifier specified
Can anyone please help me find the solution to the problem.
Thanks
I am trying to extract data from an Oracle table. I can see the data when I put the connection credentials of the database and view the data from the Oracle Enterprise stage. I also see the database connection parameters present in the TNSNAMES.ORA file on the unix server. But when I try to run the job I get the following error.
ITEM_MASTER,0: Fatal Error: Fatal: ORA-12154: TNS:could not resolve the connect identifier specified
Can anyone please help me find the solution to the problem.
Thanks
Regards
Kashif Khan
Kashif Khan
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
They look identical as below
Using Parameterization:
$RDWID=reliunix
$RDWPWD=LL;@1;VA=9BN0FEI49J52KI6B<<
$RDWDB=rdwp
With Parameterization job aborts.
====================================
Using Hardcoded Values:
$RDWID=reliunix
$RDWPWD=LL;@1;VA=9BN0FEI49J52KI6B<<
$RDWDB=rdwp
With Hardcoded credentials job runs successfully.
Using Parameterization:
$RDWID=reliunix
$RDWPWD=LL;@1;VA=9BN0FEI49J52KI6B<<
$RDWDB=rdwp
With Parameterization job aborts.
====================================
Using Hardcoded Values:
$RDWID=reliunix
$RDWPWD=LL;@1;VA=9BN0FEI49J52KI6B<<
$RDWDB=rdwp
With Hardcoded credentials job runs successfully.
Regards
Kashif Khan
Kashif Khan
-
- Participant
- Posts: 342
- Joined: Tue Nov 04, 2008 10:38 am
- Location: Chennai, India
Sorry for replying late. I am V 8.0.1
When I installed the Datastage Client, I had installed the following two fix patches.
patch_e119863 : Run-time error 5 when attempting to save an OCI stage table definition to the repository
patch_e124328 : Information Server Parallel job with FTP EE stage receives the error: Fatal Error: This index is out of range: 0
And none of these patches would fix my problem.[/b]
When I installed the Datastage Client, I had installed the following two fix patches.
patch_e119863 : Run-time error 5 when attempting to save an OCI stage table definition to the repository
patch_e124328 : Information Server Parallel job with FTP EE stage receives the error: Fatal Error: This index is out of range: 0
And none of these patches would fix my problem.[/b]
Regards
Kashif Khan
Kashif Khan