Re: Getting Ora 12203 when connecting from Discoverer

On Wednesday, December 5, 2012 2:16:13 PM UTC+5:30, dem..._at_gmail.com wrote:
> Yes it worked as:-
>
>
>
> Initially we have issue where Oracle 9i client was already installed on the system.
>
> Then we tried to install Discoverer 4.1.37 Desktop edition on the same system.
>
> After settling up Multiple Homes issue,Dsicoverer desktop got installed perrfectly.
>
> But after that we were getting ORA-12203 : unable to connect to destination Error.
>
>
>
> So deal with this, we Just changed the Environment Variable value for attribute:
>
> Oracle_Home: <Discoverer folder path>.
>
> And its Also called TNS_ADMIN, as it tells the system where the TNS entried can be found for whole system.
>
>
>
> And its located at:
>
>
>
> My computer > (right click> Properties)>Advanced tAB >ENVIRONMENT Variables > User VAriables at Top> Oracle_Home attribute.
>
>
>
> After pointing this Variable to your discoverer folder path.
>
>
>
> Discoverer can connect normally to any server in tns entries.

In investigating this Issue, this resource was really helpful to understand what got wrong: http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:489021635775 Received on Wed Dec 05 2012 - 09:48:50 CET