Home » Infrastructure » Windows » Cant Connect to oracle on windows from linux
Cant Connect to oracle on windows from linux [message #346127] Sat, 06 September 2008 06:32 Go to next message
vishaltalentbeat
Messages: 1
Registered: September 2008
Junior Member
Hi,
I am not able to connect to Oracle on Windows from Linux machine.

Oracle is installed on windows server and I am using hibernate from my application which is deployed on the linux machine but I am not able to connect to oracle database.

Do I need to change something in tnsnames.ora file or listerns file.

The exception I am getting is as below.

2008-09-06 16:46:11,934 INFO com.whizpay5_1.common.dao.CommonDAO - userSqlQuery select UserLogin.loginName , UserLogin.loginPassword , UserMaster.address1 , UserMaster.organizationMaster.orgId, UserMaster.email , UserMaster.firstName , UserMaster.lastName , UserMaster.organizationMaster1.orgId , UserMaster.userId , UserMaster.userType.userTypeId , OrganizationMaster.orgName , OrganizationMaster.logo from com.whizpay5_1.hibernate.UserLogin UserLogin, com.whizpay5_1.hibernate.UserMaster UserMaster, com.whizpay5_1.hibernate.OrganizationMaster OrganizationMaster where UserLogin.loginName='test' and UserLogin.loginPassword='GL+K6zPmBRRMfuz13eKGjg==' and UserMaster.userType='2' and UserLogin.userMaster=UserMaster.userId and UserMaster.organizationMaster1 = OrganizationMaster.orgId and UserLogin.statusType=OrganizationMaster.statusType and OrganizationMaster.statusType='1' and UserMaster.statusType='1'
2008-09-06 16:46:13,309 INFO com.mchange.v2.log.MLog - MLog clients using log4j logging.
2008-09-06 16:46:13,485 INFO com.mchange.v2.c3p0.impl.C3P0ImplUtils - Failed to get local InetAddress for VMID. This is unlikely to matter. At all. We'll add some extra randomness
java.net.UnknownHostException: whizpay: whizpay
at java.net.InetAddress.getLocalHost(InetAddress.java:1315)
at com.mchange.v2.c3p0.impl.C3P0ImplUtils.generateVmId(C3P0ImplUtils.java:120)
at com.mchange.v2.c3p0.impl.C3P0ImplUtils.<clinit>(C3P0ImplUtils.java:98)
at com.mchange.v2.c3p0.impl.DriverManagerDataSourceBase.<init>(DriverManagerDataSourceBase.java:205)
at com.mchange.v2.c3p0.DriverManagerDataSource.<init>(DriverManagerDataSource.java:60)
at com.mchange.v2.c3p0.DriverManagerDataSource.<init>(DriverManagerDataSource.java:56)
at com.mchange.v2.c3p0.DataSources.unpooledDataSource(DataSources.java:152)
at org.hibernate.connection.C3P0ConnectionProvider.configure(C3P0ConnectionProvider.java:96)
at org.hibernate.connection.ConnectionProviderFactory.newConnectionProvider(ConnectionProviderFactory.java:124)
at org.hibernate.connection.ConnectionProviderFactory.newConnectionProvider(ConnectionProviderFactory.java:56)
at org.hibernate.cfg.SettingsFactory.createConnectionProvider(SettingsFactory.java:366)
at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:60)
at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:1881)
at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1174)
at com.whizpay5_1.dao.factory.HibernateSessionFactory.currentSession(HibernateSessionFactory.java:49)
at com.whizpay5_1.common.dao.CommonDAO.login(CommonDAO.java:94)
at com.whizpay5_1.common.businesslogic.LoginBusinessLogic.login(LoginBusinessLogic.java:81)
at com.whizpay5_1.common.action.LoginAction.login(LoginAction.java:70)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:274)
at org.apache.struts.actions.DispatchAction.execute(DispatchAction.java:194)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:419)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:224)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1194)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:165)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:103)
at com.caucho.server.dispatch.ServletFilterChain.doFilter(ServletFilterChain.java:106)
at com.caucho.server.webapp.WebAppFilterChain.doFilter(WebAppFilterChain.java:173)
at com.caucho.server.dispatch.ServletInvocation.service(ServletInvocation.java:229)
at com.caucho.server.http.HttpRequest.handleRequest(HttpRequest.java:274)
at com.caucho.server.port.TcpConnection.run(TcpConnection.java:511)
at com.caucho.util.ThreadPool.runTasks(ThreadPool.java:516)
at com.caucho.util.ThreadPool.run(ThreadPool.java:442)
at java.lang.Thread.run(Thread.java:619)
2008-09-06 16:46:14,423 INFO com.mchange.v2.c3p0.C3P0Registry - Initializing c3p0-0.9.1 [built 16-January-2007 14:46:42; debug? true; trace: 10]
2008-09-06 16:46:14,809 INFO com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource - Initializing c3p0 pool... com.mchange.v2.c3p0.PoolBackedDataSource@903b402 [ connectionPoolDataSource -> com.mchange.v2.c3p0.WrapperConnectionPoolDataSource@df95a831 [ acquireIncrement -> 1, acquireRetryAttempts -> 30, acquireRetryDelay -> 1000, autoCommitOnClose -> false, automaticTestTable -> null, breakAfterAcquireFailure -> false, checkoutTimeout -> 0, connectionCustomizerClassName -> null, connectionTesterClassName -> com.mchange.v2.c3p0.impl.DefaultConnectionTester, debugUnreturnedConnectionStackTraces -> false, factoryClassLocation -> null, forceIgnoreUnresolvedTransactions -> false, identityToken -> l355357tuezechknsy|150a0, idleConnectionTestPeriod -> 100, initialPoolSize -> 10, maxAdministrativeTaskTime -> 0, maxConnectionAge -> 0, maxIdleTime -> 0, maxIdleTimeExcessConnections -> 0, maxPoolSize -> 100, maxStatements -> 100, maxStatementsPerConnection -> 0, minPoolSize -> 10, nestedDataSource -> com.mchange.v2.c3p0.DriverManagerDataSource@a8588e4 [ description -> null, driverClass -> null, factoryClassLocation -> null, identityToken -> l355357tuezechknsy|66998f, jdbcUrl -> jdbc:mysql://10.20.10.65/crowdperks?autoreconnect=true&zeroDateTimeBehavior=round&noDatetimeStringSync=true&jdbcCompliant Truncation=false&dontTrackOpenResources=true&holdResultsOpenOverStatementClose=true, properties -> {user=******, password=******} ], preferredTestQuery -> null, propertyCycle -> 0, testConnectionOnCheckin -> false, testConnectionOnCheckout -> false, unreturnedConnectionTimeout -> 0, usesTraditionalReflectiveProxies -> false; userOverrides: {} ], dataSourceName -> null, factoryClassLocation -> null, identityToken -> l355357tuezechknsy|71d29a, numHelperThreads -> 3 ]
2008-09-06 16:46:34,807 WARN com.mchange.v2.async.ThreadPoolAsynchronousRunner - com.mchange.v2.async.ThreadPoolAsynchronousRunner$DeadlockDetector@1087be0 -- APPARENT DEADLOCK!!! Creating emergency threads for unassigned pending tasks!
2008-09-06 16:46:34,811 WARN com.mchange.v2.async.ThreadPoolAsynchronousRunner - com.mchange.v2.async.ThreadPoolAsynchronousRunner$DeadlockDetector@1087be0 -- APPARENT DEADLOCK!!! Complete Status:
Managed Threads: 3
Active Threads: 3
Active Tasks:
com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@e2d858 (com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#1)
com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@e9927a (com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#0)
com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@8fc7a7 (com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#2)
Pending Tasks:
com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@17ccb2f
com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@1ff8de3
com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@bc448b
com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@383244
com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@16c1bce
com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@95a253
com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@1d41116
Pool thread stack traces:
Thread[com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#1,5,main]
java.net.PlainSocketImpl.socketConnect(Native Method)
java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:333)
java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:195)
java.net.PlainSocketImpl.connect(PlainSocketImpl.java:182)
java.net.SocksSocketImpl.connect(SocksSocketImpl.java:366)
java.net.Socket.connect(Socket.java:519)
java.net.Socket.connect(Socket.java:469)
java.net.Socket.<init>(Socket.java:366)
java.net.Socket.<init>(Socket.java:179)
com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:121)
com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:219)
com.mysql.jdbc.Connection.createNewIO(Connection.java:1771)
com.mysql.jdbc.Connection.<init>(Connection.java:440)
com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:400)
com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:135)
com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:182)
com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:171)
com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java: 137)
com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1014)
com.mchange.v2.resourcepool.BasicResourcePool.access$800(BasicResourcePool.java:32)
com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool.java:1810)
com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:547)
Thread[com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#2,5,main]
java.net.PlainSocketImpl.socketConnect(Native Method)
java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:333)
java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:195)
java.net.PlainSocketImpl.connect(PlainSocketImpl.java:182)
java.net.SocksSocketImpl.connect(SocksSocketImpl.java:366)
java.net.Socket.connect(Socket.java:519)
java.net.Socket.connect(Socket.java:469)
java.net.Socket.<init>(Socket.java:366)
java.net.Socket.<init>(Socket.java:179)
com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:121)
com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:219)
com.mysql.jdbc.Connection.createNewIO(Connection.java:1771)
com.mysql.jdbc.Connection.<init>(Connection.java:440)
com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:400)
com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:135)
com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:182)
com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:171)
com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java: 137)
com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1014)
com.mchange.v2.resourcepool.BasicResourcePool.access$800(BasicResourcePool.java:32)
com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool.java:1810)
com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:547)
Thread[com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#0,5,main]
java.net.PlainSocketImpl.socketConnect(Native Method)
java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:333)
java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:195)
java.net.PlainSocketImpl.connect(PlainSocketImpl.java:182)
java.net.SocksSocketImpl.connect(SocksSocketImpl.java:366)
java.net.Socket.connect(Socket.java:519)
java.net.Socket.connect(Socket.java:469)
java.net.Socket.<init>(Socket.java:366)
java.net.Socket.<init>(Socket.java:179)
com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:121)
com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:219)
com.mysql.jdbc.Connection.createNewIO(Connection.java:1771)
com.mysql.jdbc.Connection.<init>(Connection.java:440)
com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:400)
com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:135)
com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:182)
com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:171)
com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java: 137)
com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1014)
com.mchange.v2.resourcepool.BasicResourcePool.access$800(BasicResourcePool.java:32)
com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool.java:1810)
com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:547)



PLEASE HELP ME TO RESOLVE THIS PROBLEM IF ANYBODY HAS SOLUTION ON IT
Re: Cant Connect to oracle on windows from linux [message #346148 is a reply to message #346127] Sat, 06 September 2008 09:14 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I don't see any Oracle error in this, what is it?
Are you sure you can't connect? Why?

Regards
Michel

[Edit: Add missing word]

[Updated on: Sat, 06 September 2008 12:12]

Report message to a moderator

Re: Cant Connect to oracle on windows from linux [message #346153 is a reply to message #346127] Sat, 06 September 2008 10:38 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
> jdbc:mysql://10.20.10.65/crowdperks

Why posting MYSQL problem in Oracle forum?
Previous Topic: Creating windows script to be run by dbms_scheduler (merged)
Next Topic: Installation Problem Oracle 10g XE on Windows XP sp2
Goto Forum:
  


Current Time: Fri Mar 29 01:12:23 CDT 2024