Oracle Enterprise stage error

[muralisankarr]

I want to use a Oracle Enterprise for a source. When I attempt to do so, I got the following error

Missing server name : Can't connect
APT_OraReadoperator : Connect failed


Please help me to sort out this

[Pagadrai]

Missing server name : Can't connect
APT_OraReadoperator : Connect failed

Hi,
Have you given a valid server name?

[muralisankarr]

Hi,
Have you given a valid server name?

Hi,

Server Name - Is it oracle connection string you are pointing ? If so I have given it correctly
(Sorry to ask such a silly qus. I'm new to PX).

[v2kmadhav]

can you connect to the database from the datastage box?
do you see a TNS entry on your datastage server for that database?

[priyadarshikunal]

Oracle connection string contains 3 parts
user/password@servername

pass the server name in oracle enterprise stage using additional property called remote server.

if passed that correctly, make sure the same is present in tnsname.ora but this would have given error like cannot resolve TNS.