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
ORA-12541: TNS: no listener
Moderators: chulett, rschirm, roy
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.
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.
Re: ORA-12541: TNS: no listener
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.
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.
Are you sure you replied to the correct post? Wondering if it should be here: viewtopic.php?t=149931
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers