I have one procedure which calls a function. My requirement is if that function didnt return value in 1 minute then stop the exection of that function and call next statement.
Begin
(1).........
(2).......
(3) get_func_val:= function(1,2);
(4)......
(5)....
end;
My requirement is, if (3) doesn't return value in 1 minute, stop the execution of (3) and start executing (4).
is there any way to reduce the dblink timeout, i need to test if the remote server is up by testing the dblink throw 'select 1 from dual@link_name' but it take too long time 5-6 min., i need to make it 5 sec after that the exception tns timeout appear. I try with some sqlnet.ora parameters like INBOUND_ TIMEOUT but not work for me, also i try using tnsping but it also take long time when the remote server is down.
View 2 Replies View Related[#|2010-03-17T19:00:26.689+0530|SEVERE|glassfishv3.0|tcplistener.ModuleHandler|_ThreadID=30;_ThreadName=Thread-1;|The log message is null.
java.net.SocketException: Connection reset
at java.net.SocketInputStream.read(SocketInputStream.java:168)
at java.net.SocketInputStream.read(SocketInputStream.java:182)
at java.io.FilterInputStream.read(FilterInputStream.java:66)
at tcplistener.ByteWrapper.unwrapFromStream(ByteWrapper.java:136)
at tcplistener.ModuleHandler.run(ModuleHandler.java:106)
at java.lang.Thread.run(Thread.java:619)
|#]
[code].....
Is there any way to control the timeout before connecting via dblink. the idea is to test the dblink before calling functions over it, the problem it when i try 'select 1 from dual@dblink' in case if the remote server is down it takes too long time 5-7 min. which causing hang up the session,
So is there any parameter to reduce the waiting time say after 3 sec stop and return the timeout exception.I try the SQLNET.INBOUND_CONNECT_TIMEOUT parameter but not working, also try the tnsping but it alse take long time when the server down.
the database version is 10gr2.
When I connect to a Oracle database(remote) using TOAD client, because of the settings of timeout done at the server end(in Oracle), the TOAD session gets time out in 5 minutes.
I want to know how I can increase the timeout interval or if I can keep on pinging the database server so that the TOAD connection does not gets timeout?
PS: When we connect to a unix server using putty, we can keep on pining the server at regular timeout interval by going to Change Settings->Connection->Set KeepAlive
Is there a similar way for TOAD?
Is there any timeout for sql queries in oracle, if so what is the timeout parameter.
View 3 Replies View RelatedThis error keeps on comming in my welogic forms server window many often....can any one tell me why it is so ?
<Error> <oracle.forms.servlet> <FRM-91230> <fatal
error in runtime process: timeout on connection to Java client>
how can i edit the timeout for each user
i.e i need the user who didn't user forms or reports to be disconnected automatically from the oracle how can i do that
We have implemented a approval notification for our customer which on a high level is as follows
requester -> Approver 1-> Approver 2
Once a request is submitted, the 'approval' notification goes to Approver 1 followed by Approver 2. The request is approved when both approves approve the request. If no action is taken by the approvers, the original notifications are cancelled and escalation notification is sent to supervisor of approver 2.
We have a timeout of 48 hours set for the initial approval notifications sent to the approvers (1 & 2). In case Approver 2 requests for more information using the 'Request information' button, the TIMEOUT clock does not seem to reset and the notification is cancelled after 48 hrs even if the notification is in the queue of the requester.
This is causing the escalation notification to be supervisor of approver 2.
The question here is why does the timeout clock not reset when the notification goes back to the requester for additional information. Is this how the standard oracle workflow notification behaves ? Is there a way to customize and achieve this ?
I was getting the following error when trying to connect development database.
sqlplus bala/test11@ORCL.SBC.COM
SQL*Plus: Release 10.2.0.1.0 - Production on Mon Jul 18 13:04:18 2011
Copyright (c) 1982, 2005, Oracle. All rights reserved.
ERROR:ORA-12170: TNS:Connect timeout occurred
Enter user-name:
But i am to connect this database through putty,toad at that time. But after sometime, i was able to connect the database.
I installed my Oracle 10g R2 software in redhat linux installed in VMWare player in my laptop.
I am trying to connect to database from my laptop which has windows 7 installed
My goal is to connect to database installed in linux vmware from my laptop having windows7 OS..
I have installed Oracle instant client on windows 7,trying to make a connection to database but its giving me the following error when i tried...
sqlplus sqlplus scott/tiger@(description=(address_list=(
address=(protocol=TCP)(host=192.168.1.7)(port=1521)))(connect_data=(service_name=subhani)))..
ora-12170:TNS Connect TimeOut Error..
I am getting ORA-02049: timeout: distributed transaction waiting for lock , how to resolve this type error
View 3 Replies View RelatedI get below error when trying to connect to database server using
C:Documents and SettingsAdministrator>sqlplus jack/jack@DB_PROD
SQL*Plus: Release 10.2.0.1.0 - Production on Tue Jan 24 12:11:45 2012
Copyright (c) 1982, 2005, Oracle. All rights reserved.
ERROR:
ORA-12170: TNS:Connect timeout occurred
Enter user-name:
FYI,
The database i am trying to connect is 9.2.0.8.0 and the client that is installed in my machine is 10.2.0.1.0
Is problem with the database versions ?
I have this box that runs a dataguard observer in a test lab.
Is there a way to configure connect time failover and connection timeout in the connect identifier used by DGMGRL? It does not seem to respect the parameters I supply.
This is what I used for TNSNAMES connection string:
DB=
(DESCRIPTION =
(ADDRESS_LIST =
(FAILOVER=ON)
[Code].....
When the hosts are up, if the instance is not running, I really get a quick reply from DGMGRL. However, when some host is not available, it can take quite a while to get an answer, minutes..
=
I though I could use
(TYPE=select)
(METHOD=basic)
(RETRIES=5)
#(DELAY=1) # defaults to 1 when retries is set
in the connect_data section, but this does not seem to have an effect
=
I also tried ' (CONNECT_TIMEOUT=5)' in the ADDRESS_LIST section
=
So assuming that Oracle NET services are not available on the hosts. What can I use to make 'dgmgrl' report that it can't connect to the host quickly ? Should I look into the TCP timeout parameters ?
We have a daily batch job executing a oracle-plsql function. Actually the quartz scheduler invokes a java program which makes a call to the oracle-plsql function. This oracle plsql function deletes data (which is more than 6 months) from 4 tables and then commits the transaction.
This batch job was running successfully in the test environment but started failing when new data was dumped to the tables which happened 2 weeks ago (The code is supposed to go into production this week). Earlier the number of rows in each table was not more than 0.1 million. But now it is 1 million in 3 tables and 2.4 million in the other table.
After running for 3 hours, we are getting a error in java (written in the log file) "...Connection reset; nested exception is java.sql.SQLException: Io exception: Connection reset....". When the row-counts on the tables were checked, it was clear that no record was deleted from any of the tables.
Is it possible in oracle database, for the plsql procedure/function to be automatically terminated/killed when the connection is timed out and the invoking session is no longer active?
i get while getting a report in ASP..
Error like this
Error Code 1460: Timeout
Background: The gateway could not receive a timely response from the website you are trying to access, a DNS server, or another gateway server. This might indicate that the network is congested or that the website is experiencing technical difficulties.
I got a database query which takes about 4-5 sec to run, but since it seems to take too long time something happens, timeout(?) and returns a white page.
What would be the proper way to debug this? I only got access to the web console. Sometimes on the second try it loads the webpage, and I guess it has cached it then and can load it. So maybe weblogic timesout my request?
When i try to compile a package, im getting below error.
ERROR at line 1:ORA-04021: timeout occurred while waiting to lock object
i gave below query and found the sid of object.
select * from v$access where object='THINKING_PKG'
From v$session view,i found sid and serial# and at same time i queried dba_jobs and saw one jobs is running at this time.Now how to compile this object.
Any way to setup Data Pump Export timeout on resumable error (like with classique export). Seems that default timeout is 2h (7200s).I have tried to set system parameter 'resumable_timeout' from 0 to 60 but no change.
I would like to script an export, but I just want that the script exits on errors like this one:
ORA-39171: Le travail se heurte à une attente avec possibilité de reprise.
ORA-01691: impossible d'étendre le segment LOB SYS.SYS_LOB0000145352C00039$$ de 128 dans le tablespace SYSTEM
Actually, the script have to wait 2h for expdp timeout.