Database stage for Oracle 10g

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

vnspn
Participant
Posts: 165
Joined: Mon Feb 12, 2007 11:42 am

Post by vnspn »

Thanks for the information Ken.

I have setup the "tnsnames.ora" file under the Oracle 9i Client folder. Then, using the DS Manager, I selected the option to import through Plug-in Meta Data Defintions. When I select the Oracle 9i plugin there, I get an error message saying "Unable to initialize plug-in:". Is this the error you mean to say because of permissions?
kcbland
Participant
Posts: 5208
Joined: Wed Jan 15, 2003 8:56 am
Location: Lutz, FL
Contact:

Post by kcbland »

Could be, but you need to reboot the DS server after the client install. Verify the client works by running sqlplus from the CMD prompt. If that works the client is installed correctly. You can also try a tnsping yourSID to test if the DS server "sees" the Oracle instance.
Kenneth Bland

Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Post Reply