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
Oracle Enterprise stage error
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 83
- Joined: Tue Oct 28, 2008 1:55 am
- Location: Chennai
Oracle Enterprise stage error
The minute you start talking about what you're going to do if you lose, you have lost
Re: Oracle Enterprise stage error
Hi,muralisankarr wrote: Missing server name : Can't connect
APT_OraReadoperator : Connect failed
Have you given a valid server name?
-
- Premium Member
- Posts: 83
- Joined: Tue Oct 28, 2008 1:55 am
- Location: Chennai
Re: Oracle Enterprise stage error
Hi,Pagadrai wrote:
Hi,
Have you given a valid server name?
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).
The minute you start talking about what you're going to do if you lose, you have lost
-
- Premium Member
- Posts: 1735
- Joined: Thu Mar 01, 2007 5:44 am
- Location: Troy, MI
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.
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.
Priyadarshi Kunal
Genius may have its limitations, but stupidity is not thus handicapped.![Wink :wink:](./images/smilies/icon_wink.gif)
Genius may have its limitations, but stupidity is not thus handicapped.
![Wink :wink:](./images/smilies/icon_wink.gif)