Re: Oracle Client & ORA-12535

HARI OM 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!
>
> HARI OM
You don't need listener on the client machine, it runs on the server to accept client connections so need for a listener.ora file on the client machine. Since you mentioned AIX server, I assume this is not a home setup... don't you have a DBA onsite?

• You should first ping your server and see if you can reach it. If you can't then you got other issues.
• Run netca on your client machine and configure to connect to the database on the server. This will create a tnsnames.ora file in ORACLE_HOME\network\admin directory. Open it in notepad and see if the connect parameters are Ok. You should know the database SID, PORT and Host IP address or name for this. Your DBA should help you out with this. After the setup, tnsping the service_name and see if you can reach the listener on the server.

There is a CONNECT_TIMEOUT value for listener which can be set... you would need access to the server to verify/modify this. Once again, this is more of your DBA's task.

Regards
/Rauf Received on Thu Jan 13 2005 - 12:19:54 CST