Oracle-L: RE: localhost question

From: Munish Bajaj <mbajaj_at_quark.co.in>
Date: Tue, 13 May 2003 07:40:53 -0800
Message-ID: <F001.00597822.20030513074053@fatcity.com>

Please Check that there is a entry for localhost in the /etc/hosts file on the unix box which is giving the problem.

-----Original Message-----
Sent: Tuesday, May 13, 2003 1:07 AM
To: Multiple recipients of list ORACLE-L

List,

this weekend where I work we changed the ip addresses and went to a dns configuration to log into our Oracle databases on unix servers. On one box a user can no longer use the "localhost" host name to login with a unix account and make a connection with an Oracle instance. On all the other servers he can still user "localhost". We use a connect string in a file such as:

he gets an error message like the one below:

dbpool.ConnectionPool.InitializePool_at_210 <mailto:dbpool.ConnectionPool.InitializePool_at_210>, Thread[main,5,main], Mon May 12 13:14:15 CDT 2003)
java.sql.SQLException: Io exception: The Network Adapter could not establish the connection

at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:168)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:210)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:323)
at oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java:260)

at
oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java:365) at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:260) at java.sql.DriverManager.getConnection(DriverManager.java:543) at java.sql.DriverManager.getConnection(DriverManager.java:194) at
com.psc.dsg.di.dds.dbpool.ConnectionPool.CreateConnection(ConnectionPool.jav a:159)
at
com.psc.dsg.di.dds.dbpool.ConnectionPool.InitializePool(ConnectionPool.java: 198)
at com.psc.dsg.di.dds.core.DataService.<init>(DataService.java:222) at com.psc.dsg.di.dds.core.DataService.main(DataService.java:471) Does anybody have any suggestions? Does it have to do with "Network Adapter could not establixh the connection". All other type of connections work. thanks,
David Ehresmann
--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Ehresmann, David
INET: David.Ehresmann_at_ps.net

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Munish Bajaj
INET: mbajaj_at_quark.co.in

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------