DSXchange

Hi

I getting below error while running my PX job that connects to Oracle,

main_program: (aptoci.C:89). Message: ORA-12541: TNS:no listener

It was running fine sometime back. Not sure what caused this issue. Server jobs that connect to Oracle are running fine.

Please advice.

Thanks,

Shashank

That's really interesting. No problem with server jobs; PX job worked before and now you get a TNS - No Listener error. Please do the following:
1. From the command line, issue a TNSPING xxx (service name). What do you get?
2. Go to your server and try to connect to your Oracle server via SQL prompt. Can you connect to your Oracle?
3. If above 2 tests are OK, then double check your PX job's connection statement.

Hi,

Are you using an Oracle or ODBC stage?
If Oracle are you using wired or non wired protocol drivers?
wired would use direct connectivity to oracle, non-wired would utilise Oracle clients.

Reinstalled Datastage (clearing out registry etc) and made sure the Remote Server was correct. It now works. Thanks!

Are you sure you replied to the correct post? Wondering if it should be here: viewtopic.php?t=149931