Page 1 of 1
Oracle Enterprise stage error
Posted: Wed Apr 01, 2009 5:07 am
by 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
Re: Oracle Enterprise stage error
Posted: Wed Apr 01, 2009 5:36 am
by Pagadrai
muralisankarr wrote:
Missing server name : Can't connect
APT_OraReadoperator : Connect failed
Hi,
Have you given a valid server name?
Re: Oracle Enterprise stage error
Posted: Wed Apr 01, 2009 5:46 am
by muralisankarr
Pagadrai wrote:
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).
Posted: Wed Apr 01, 2009 6:36 am
by v2kmadhav
can you connect to the database from the datastage box?
do you see a TNS entry on your datastage server for that database?
Posted: Wed Apr 01, 2009 7:44 am
by 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.