Re: [suse-oracle] SLES 10 and Oracle 10g client
"Gilberto C. Andrade" <[email protected]>
| Newsgroups | gmane.linux.suse.oracle.general |
|---|---|
| Message-ID | <[email protected]> |
On Wed, Apr 23, 2008 at 7:36 AM, Marius Roets <[email protected]> wrote: > Hi everybody, > I have a number of SLES 10 servers, all of them connecting to a number > of Oracle databases. They all use Oracle 10g instant client. > Previously I have used the exact same setup on SLES 9, with no > problems. From time to time, it would happen that an Oracle connection > on the client side would just stop responding. From this point > onwards, all connection attempts just hangs. Rebooting the server > solves the problem. The servers are all different configurations, and > they connect to different database ranging from 8i to 10g, yet all of > them have had this problem at some point. The only common aspect is > the SLES 10 / Oracle 10g instant client combination. > > Has anybody encountered anything like this before? > Recently we found that $ORACLE_HOME/network/admin/sqlnet.ora is source of problems and you have to check it for wrong protocols path: # sqlnet.ora Network Configuration File: /opt/oracle/oas/10.1.2.0.2/server/network/admin/sqlnet.ora # Generated by Oracle configuration tools. NAMES.DIRECTORY_PATH= (LDAP, EZCONNECT, TNSNAMES, ONAMES, HOSTNAME) That one caused problems for me. I've just changed to: NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT, ONAMES, HOSTNAME) And that's it! Gilberto _______________________________________________ suse-oracle mailing list [email protected] http://listx.novell.com/mailman/listinfo/suse-oracle