Re: Oracle Client and ORA-12535???

U¿ytkownik DA Morgan napisa³:

> hari_om_at_hotmail.com wrote:
>
>> Hello,
>> I have installed Oracle Client on my Windows XP. My Oracle Server is
>> IBM AIX box.
>> When I try to log in to SQL from my Oracle Client I get ORA-12535:
>> Operation Timed Out... wonder why?
>> I was doing a research on my CLient Installation and found there was
>> only TNSNAMES.ORA File and there was NO Listener.ORA file....
>> I guess we DO NOT NEED any Listener files on Client machine....
>> If so then how would the Oracle know where is my Oracle Server....?
>> THANKS!
>
> Do you have a DBA or someone on site that can guide you?
> You really do need to find a mentor or take a class as your
> questions, repeatedly, are about basics.
> There is never a listener.ora file on a client

He guessed right :)

>and the information
> in tnsnames.ora gets there one of two ways. Either you use the
> Oracle assistant to create it or you type it in yourself.
>
> Timed out? Can you even ping and tnsping the server from the workstation?

Note that ping is to IP server and tnsping to connect_string :) You can find 'connect_string' in TNSNAMES.ORA file and if you look into that file try to find 'ADDRESS' :)

-- 
Noel