Hi,
Does anybody know about this error?
XXXXXX..ORAOCI9_8: ORA-12154: TNS:could not resolve service name
XXXXXX..ORAOCI9_8.DSLink1: DSP.Open GCI $DSP.Open error -2.
Iam getting this error when trying to view the data(using view data)in the source stage.
Thanks..
Error while trying to view the data in the OCI soure stage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 24
- Joined: Sun Jan 23, 2005 3:36 pm
-
- Charter Member
- Posts: 299
- Joined: Wed Nov 13, 2002 5:38 pm
- Location: USA
This is a very basic Oracle message. I would suggest enlisting the aid of an Oracle DBA since you appear unfamiliar with it.
The Datasource name may have been mis-defined. Can you access Oracle from outside of DataStage from the ETL Server? Try a quick tnsping of the same connection string you are using from within Datastage but from the commandline. If it is unable to ping the database, then your tnsnames.ora entry for the DNS string on the ETL Server is missing or other Oracle problem. If you can access Oracle then you have not defined Oracle connectivity to DataStage correctly.
The Datasource name may have been mis-defined. Can you access Oracle from outside of DataStage from the ETL Server? Try a quick tnsping of the same connection string you are using from within Datastage but from the commandline. If it is unable to ping the database, then your tnsnames.ora entry for the DNS string on the ETL Server is missing or other Oracle problem. If you can access Oracle then you have not defined Oracle connectivity to DataStage correctly.
-
- Participant
- Posts: 24
- Joined: Sun Jan 23, 2005 3:36 pm
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
Obtaining metadata may probably be misleading as you can have multiple oracle instances having same schema / metadata information.
You can check the correctness by adding few dummy tables, fields and insert dummy values, which you can then try to see from DataStage. This will confirm the connection.
You can check the correctness by adding few dummy tables, fields and insert dummy values, which you can then try to see from DataStage. This will confirm the connection.
-
- Participant
- Posts: 24
- Joined: Sun Jan 23, 2005 3:36 pm