Networking And Gateways :: Connection Time Out On Log File Of App Server
Jul 4, 2011
I have a JBOSS aplication server connect to database. When I tested on local, everything was ok. But when i test on real system , have a message "connection time out" on log file of app server while Oracle db still active. I viewed OEM, the system is executing the query :
"SELECT a.path songFilePath, a.BEAT beat from vp_song a, mst_my_album b "+
"where "+
"a.BEAT = b.BEAT "+
"and b.my_album_id IN "+
"(select my_album_id from (select my_album_id, ROW_NUMBER() OVER
(order by my_album_id asc) "+
"R from mst_my_album where msisdn = ?) WHERE R BETWEEN ? and ?)";
When i connect from client to server the client looks up for the host address and port number in tnsnames.ora and connect to it via listener.ora in server.Where does pga and sga come into picture here?
Also what is the role of sqlnet.ora in client?What will happen if i specify a different port for the instance in tnsnames.ora and listener.ora?
I have one query related to database connection from server to client.I have one database in the server and I want to connect from client.I set the tnsnames in client system as follows.
I was trying to connect to a remote database from my client machine. Client machine runs a jsp code to connect to the database and execute a query. I have got oracle jdbc on my machine but still unable to connect to the database.
When checked in Google, i found that oracle connection manager has to be used to connect to the database from jdbc if the web server and database reside on different physical servers. But couldn't gather any further information regarding download and installation.
I do not have oracle connection manager on my system. I read in internet that it is shipped along with oracle 11g software. But i am not sure if that was the case in earlier version as well.
My question is where should i install oracle connection manager? (on database server or client machine) and is it possible to download and install only the connection manager as a stand alone so that i can connect to database from application?
I am getting the error TNS-12537. In the SQLnet.ora file, if no IP Address is listed everything works fine and the listener starts without any issue. But one of the Security requirements we have is, we need to list all the client IP address on the SQLNet.ora file. I checked the Windows Firewall services and it is disabled.
Microsoft Windows [Version 6.1.7601] Copyright (c) 2009 Microsoft Corporation. All rights reserved. M:>tnsping proditg TNS Ping Utility for 64-bit Windows: Version 11.2.0.3.0 - Production on 01-OCT- 013 10:31:14 Copyright (c) 1997, 2011, Oracle. All rights reserved.
I am facing ora - 12537 TNS connection closed issue while I am trying to login into database.I have installed Oracle database 11g on windows 7 premium OS.
when i am connecting to my database in command prompt,sql * plus editor is it successfully connecting to the database but not connecting with the oracle client OEM.
but after connecting the LAN it is not connecting and also in the case when i am connecting to the internet through the USB datacard it is not connecting with the oracle client OEM.
how can i connect to database when the LAN,USB datacard connection.
TNS-12518: TNS:listener could not hand off client connection TNS-12571: TNS:packet writer failure TNS-12560: TNS:protocol adapter error TNS-00530: Protocol adapter error Linux Error: 104: Connection reset by peer
ODBC--call failed.TNS:listener was not given the SID in CONNECT_DATA (#12504)
TNSname sets the SID. SQL*Plus is able to connect from the client Windows XP Proff using the same name. Access, on the same client, uses the same Oracle driver to connect successfully to other Oracle databases. These other databases show equal tnsname (different name and SID...)
ODBC Data Source Administrator configures the database and the test connection is successful.
Cannot set up a link from Access to the Oracle database. At some point, I have created a new Access database and it did let me connect, view the list of tables, and set up links to several tables, but the next day I could not open any of the tables and the complain was: ODBC--connection to 'MYDB' failed.
It seems that SQL*Plus passes correctly the SID from the TNSname but ODBC, when invoked from Access, does not. Yet, ODBC does it right for other databases.
I would like to implement connect time fail over from my JDBC thin client. The client will try to first connect with dedicated connection mode, if the connection time crosses more than two seconds, then connection will be opened with shared mode. To implement this, I have put the following connection string in my JDBC URL. I am able to connect to database with this URL, however it seems fail over does not work. Is it because, my database listener is not configured with dynamic service registration. If I implement the dynamic service registration, is fail over going to work? Note, I want to fail over in the same database instance but with different listener.
I am following lab instruction from my Oracle Admin Workshop book. The exercise is to create a 2nd listener to support connect-time failover. I have two listeners up and running. I connected the second listener using Static Database Registration in OEM, and then I started it.
When I looked in the listener.ora file, I was expecting to find the entries for FAILOVER=TRUE but it is not there. Both listeners are designed to connect to the same instance 'orcl'.
My questions:
1) Is the FAILOVER entry supposed to be done automatically when the second listener is created ? or is it always a manual entry ? 2) How can I test that it is working ?
I am facing below error so frequently in alert log file Fatal NI connect error 12170.
VERSION INFORMATION: TNS for 64-bit Windows: Version 11.1.0.6.0 - Production Oracle Bequeath NT Protocol Adapter for 64-bit Windows: Version 11.1.0.6.0 - Production Windows NT TCP/IP NT Protocol Adapter for 64-bit Windows: Version 11.1.0.6.0 - Production Time: 03-JAN-2011 02:00:00
My client get the error Ora-12514 when he tries to connect to the db.Well;
1) we restart the services: "OracleServiceOrcl" and listener but nothing changes 2) We restart the server and nothing changes 3) We checked the dump and he was done on March,26th. No db export yesterday. Is there any link with the clock change of this week-end (location of the server: France)? 4) The lsnrctl services listener command run successfully but it doesn't mention the instance ORCL.
I want to connect ORACLE-11gR2 that is on linux with an MS sql server. DO i need to use some third party drivers like easy soft ? Can i configure the database gateway without any third party drivers ?
Secondly if my oracle is on linux, can i configure the gateway on a seperate windows machine(that will connect to linux oracle and ms sql server) as i have found the gateway installation setup only for windows version.
I am having difficulty in making the 32 bit Oracle client connection to an existing 64 bit DB. The 64 bit SQL*Plus will connect just fine, but when trying to configure the 32 bit client I can never get a successful TEST of the connection. It always returns "No TNS Listener". I have tried several things, but may be way off base. To name a couple ...
1) Stopped the 64 bit listener so my 32 bit listener can use Port 1521 ... no success 2) Tried naming the 32 bit listener to LISTENER32 to not conflict with the original LISTENER name ... no success
If there is a documented way to make this work, I would surely like to be pointed to the "how to" of this item. I need this as a commercial application I have that connects to the DB requires the 32 bit client.
I am having 11.2.0.1.0 database with windows2k3 OS. For ORA-609 error i have started server side tracing by adding TRACE_LEVEL_SERVER=16,TRACE_LEVEL_DIRECOTRY=D:TRACE,and DIAG_ADR_ENABLED=off in sqlnet.ora file and i reload the listener.
Now i want to stop tracing so i have tried TRACE_LEVEL_SERVER=off but it wouldnot work. After that i remove TRACE_LEVEL_SERVER=16,TRACE_LEVEL_DIRECOTRY=D:TRACE from sqlnet.ora file and reload the listener but trace file generation is going on D:TRACE. stop server side tracing.
Currently we are loading data from oracle to sql server through oracle 11g gateway. during running scripts most of the queries takes a long time to complete. Because of this performance issue, we want to configure oracle golden gate to move data from oracle to sqlserver. whats the difference between oracle gateway & oracle golden gate? both are performing same functionality?
I have client and database on same machine, when I will connect to the instance , it will use IPC, suppose If I will use connection string then which process will handle this request?
We are having oracle 9i as database and migrating to sql server 2008. Our oracle 9i database connects to another oracle databases and these databases are having different oracle version(9.2.0.8.0, 9.2.0.7.0,10.2.0.5.0,11.2.0.2.0,9.2.0.6.0,10.2.0.4.0,8.1.7.4.0 )
I do have two queries :
1) how to connect from Sql server 2008 R2 to different Oracle databases
2) How will other oracle databases connect to Sql server 2008 R2 database
