Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Trap the EXIT_CODE from a script
Top Forums UNIX for Advanced & Expert Users Trap the EXIT_CODE from a script Post 303019169 by jim mcnamara on Sunday 24th of June 2018 12:33:24 PM
Old 06-24-2018
the V$LOCK database shows deadlocks. Most oracle "hangs" are caused by another, usually interactive process, that has a previous lock on a row. Your code performs DDL which does implicit locking (update, insert, etc.), so it is susceptible. Have your DBA clobber the offending process.

Example: We had lots of users who left for lunch in the middle of an update/insert Oracle form. Since we could not rewrite hundreds of forms to be better about transactions and locking, the DBA intervened and killed off the offending user process when a batch job got hung.

Consider DBA help.

Also oracle code example of a deadlock workaround:
Programming applications to handle deadlocks
 

10 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

how to use trap command in shell script

Right now I have implemented autossh between ServerA & ServerB which are sun solaris based. I have made this shell script. I am facing one problem which I am going to discuss now. The problem is when I sftp some files (suppose there is 10 files I have to transfer through sftp) from one server to... (2 Replies)
Discussion started by: girish.batra
2 Replies

2. Shell Programming and Scripting

Trap key press in a script

How can I trap a character press in the shell script. For eg:- I have a script runinng a infinite loops , I will need to quit if q is pressed. I have seen the traping the signal , but they give option only for traping the defined interrupt signals. But those does not help me here. (3 Replies)
Discussion started by: praveenbvarrier
3 Replies

3. Shell Programming and Scripting

Cntl+z Trap is not detecting ??? Help required to add a trap detection ???

Hi folks, I have tried to add some trap detection in the below script....this script is used to monitor database activities...in a rather awkward way :rolleyes:.... The idea behind adding trap is that....this script creates lots of temporary files in the running folder to store the count... (1 Reply)
Discussion started by: frozensmilz
1 Replies

4. UNIX for Advanced & Expert Users

trap ctrl c in shell script

how to trap the ctrl c in unix shell script my script is running in while loop it should not be terminate with ctrl c. if i press ctrl c while running script it shloud ignore the same. please healp.......... thanks in advance (2 Replies)
Discussion started by: arvindng
2 Replies

5. Shell Programming and Scripting

Nullify the effect of Trap command in later part of the script

Hi All, i have an issue regarding trap command. i have specified trap function in the beginning of the script to catch some signals but in the later part of the script i want to remove the effect of this. Can anybody help me out of this. for e.g. pressing Ctrl+C for the first time should... (2 Replies)
Discussion started by: vikas_kesarwani
2 Replies

6. Shell Programming and Scripting

How trap a signal in shell script?

Hi , i have a scenario where...i have to put a check where if script is executing more than 15mins i have to kill that script and n retry again 2nd time. i this case i can use background process to do it but i feel trap will be the efficent way to do so... but i dont know much about it... (1 Reply)
Discussion started by: crackthehit007
1 Replies

7. Shell Programming and Scripting

SCRIPT TO TRAP ILLEGAL COMBOS

Hello, I am trying to identify names which are "illegal" in the sense that they do not comply with the spelling norms of a culture. I have written NGrams for initial and final combos which are illegal. These are lists stored in 2 files named Initial and Final. Here are few... (2 Replies)
Discussion started by: gimley
2 Replies

8. Shell Programming and Scripting

Use of stty vs trap in script-driven login menu

My employers would like me to selectively run one of several different (already-existing) Korn Shell menu-driven scripts out of the user's .profile file, depending on some yet-to-be-specified user critieria. I've never done this kind of thing, but I have the existing scripts (among other... (5 Replies)
Discussion started by: Clovis_Sangrail
5 Replies

9. Homework & Coursework Questions

VM trap may work differently than a pure install trap.

Use and complete the template provided. The entire template must be completed. If you don't, your post may be deleted! 1. The problem statement, all variables and given/known data: That is the last reply I received from my instructor, and I'm looking for some alternatives. When using... (2 Replies)
Discussion started by: newuser45
2 Replies

10. Shell Programming and Scripting

Trap Oracle error in shell script

sqlplus -s usrname/password@dbSID <<-SQL >> logfile @create_table.sql commit; quit; SQL I am running this script to execute an sql file. I want to display the oracle error if anything found during execution of the sql file and exit from script. Please suggest How do it. (1 Reply)
Discussion started by: millan
1 Replies

LEARN ABOUT PHP

dba_open

DBA_OPEN(3)								 1							       DBA_OPEN(3)

dba_open - Open database

SYNOPSIS

       resource dba_open (string  $path, string  $mode, [string  $handler], [mixed  $...])

DESCRIPTION

       dba_open(3) establishes a database instance for $path with $mode using $handler.

PARAMETERS

	      o $path
		- Commonly a regular path in your filesystem.

	      o $mode
		-  It is r for read access, w for read/write access to an already existing database, c for read/write access and database creation
		if it doesn't currently exist, and n for create, truncate and read/write access. The database is  created  in  BTree  mode,  other
		modes (like Hash or Queue) are not supported.  Additionally you can set the database lock method with the next char. Use l to lock
		the database with a .lck file or d to lock the databasefile itself. It is important that all of your applications do this  consis-
		tently.   If you want to test the access and do not want to wait for the lock you can add t as third character. When you are abso-
		lutely sure that you do not require database locking you can do so by using - instead of l or d. When none of d, l or -  is  used,
		dba will lock on the database file as it would with d.

	      Note

		      There  can  only	be  one  writer for one database file. When you use dba on a web server and more than one request requires
		     write operations they can only be done one after another. Also read during write is not allowed. The dba extension uses locks
		     to prevent this. See the following table:

		     DBA locking

		     +-------------+---------------+---+---+---+---+---+---+---+
		     |already open |		   |   |   |   |   |   |   |   |
		     |		   |		   |   |   |   |   |   |   |   |
		     |		   | $mode = "rl"  |   |   |   |   |   |   |   |
		     |		   |		   |   |   |   |   |   |   |   |
		     |		   | $mode = "rlt" |   |   |   |   |   |   |   |
		     |		   |		   |   |   |   |   |   |   |   |
		     |		   | $mode = "wl"  |   |   |   |   |   |   |   |
		     |		   |		   |   |   |   |   |   |   |   |
		     |		   | $mode = "wlt" |   |   |   |   |   |   |   |
		     |		   |		   |   |   |   |   |   |   |   |
		     |		   | $mode = "rd"  |   |   |   |   |   |   |   |
		     |		   |		   |   |   |   |   |   |   |   |
		     |		   | $mode = "rdt" |   |   |   |   |   |   |   |
		     |		   |		   |   |   |   |   |   |   |   |
		     |		   | $mode = "wd"  |   |   |   |   |   |   |   |
		     |		   |		   |   |   |   |   |   |   |   |
		     |		   | $mode = "wdt" |   |   |   |   |   |   |   |
		     |		   |		   |   |   |   |   |   |   |   |
		     +-------------+---------------+---+---+---+---+---+---+---+
		     |	not open   |		   |   |   |   |   |   |   |   |
		     |		   |		   |   |   |   |   |   |   |   |
		     |		   |	  ok	   |   |   |   |   |   |   |   |
		     |		   |		   |   |   |   |   |   |   |   |
		     |		   |	  ok	   |   |   |   |   |   |   |   |
		     |		   |		   |   |   |   |   |   |   |   |
		     |		   |	  ok	   |   |   |   |   |   |   |   |
		     |		   |		   |   |   |   |   |   |   |   |
		     |		   |	  ok	   |   |   |   |   |   |   |   |
		     |		   |		   |   |   |   |   |   |   |   |
		     |		   |	  ok	   |   |   |   |   |   |   |   |
		     |		   |		   |   |   |   |   |   |   |   |
		     |		   |	  ok	   |   |   |   |   |   |   |   |
		     |		   |		   |   |   |   |   |   |   |   |
		     |		   |	  ok	   |   |   |   |   |   |   |   |
		     |		   |		   |   |   |   |   |   |   |   |
		     |		   |	  ok	   |   |   |   |   |   |   |   |
		     |		   |		   |   |   |   |   |   |   |   |
		     |$mode = "rl" |		   |   |   |   |   |   |   |   |
		     |		   |		   |   |   |   |   |   |   |   |
		     |		   |	  ok	   |   |   |   |   |   |   |   |
		     |		   |		   |   |   |   |   |   |   |   |
		     |		   |	  ok	   |   |   |   |   |   |   |   |
		     |		   |		   |   |   |   |   |   |   |   |
		     |		   |	 wait	   |   |   |   |   |   |   |   |
		     |		   |		   |   |   |   |   |   |   |   |
		     |		   |	 false	   |   |   |   |   |   |   |   |
		     |		   |		   |   |   |   |   |   |   |   |
		     |		   |	illegal    |   |   |   |   |   |   |   |
		     |		   |		   |   |   |   |   |   |   |   |
		     |		   |	illegal    |   |   |   |   |   |   |   |
		     |		   |		   |   |   |   |   |   |   |   |
		     |		   |	illegal    |   |   |   |   |   |   |   |
		     |		   |		   |   |   |   |   |   |   |   |
		     |		   |	illegal    |   |   |   |   |   |   |   |
		     |		   |		   |   |   |   |   |   |   |   |
		     |$mode = "wl" |		   |   |   |   |   |   |   |   |
		     |		   |		   |   |   |   |   |   |   |   |
		     |		   |	 wait	   |   |   |   |   |   |   |   |
		     |		   |		   |   |   |   |   |   |   |   |
		     |		   |	 false	   |   |   |   |   |   |   |   |
		     |		   |		   |   |   |   |   |   |   |   |
		     |		   |	 wait	   |   |   |   |   |   |   |   |
		     |		   |		   |   |   |   |   |   |   |   |
		     |		   |	 false	   |   |   |   |   |   |   |   |
		     |		   |		   |   |   |   |   |   |   |   |
		     |		   |	illegal    |   |   |   |   |   |   |   |
		     |		   |		   |   |   |   |   |   |   |   |
		     |		   |	illegal    |   |   |   |   |   |   |   |
		     |		   |		   |   |   |   |   |   |   |   |
		     |		   |	illegal    |   |   |   |   |   |   |   |
		     |		   |		   |   |   |   |   |   |   |   |
		     |		   |	illegal    |   |   |   |   |   |   |   |
		     |		   |		   |   |   |   |   |   |   |   |
		     |$mode = "rd" |		   |   |   |   |   |   |   |   |
		     |		   |		   |   |   |   |   |   |   |   |
		     |		   |	illegal    |   |   |   |   |   |   |   |
		     |		   |		   |   |   |   |   |   |   |   |
		     |		   |	illegal    |   |   |   |   |   |   |   |
		     |		   |		   |   |   |   |   |   |   |   |
		     |		   |	illegal    |   |   |   |   |   |   |   |
		     |		   |		   |   |   |   |   |   |   |   |
		     |		   |	illegal    |   |   |   |   |   |   |   |
		     |		   |		   |   |   |   |   |   |   |   |
		     |		   |	  ok	   |   |   |   |   |   |   |   |
		     |		   |		   |   |   |   |   |   |   |   |
		     |		   |	  ok	   |   |   |   |   |   |   |   |
		     |		   |		   |   |   |   |   |   |   |   |
		     |		   |	 wait	   |   |   |   |   |   |   |   |
		     |		   |		   |   |   |   |   |   |   |   |
		     |		   |	 false	   |   |   |   |   |   |   |   |
		     |		   |		   |   |   |   |   |   |   |   |
		     |$mode = "wd" |		   |   |   |   |   |   |   |   |
		     |		   |		   |   |   |   |   |   |   |   |
		     |		   |	illegal    |   |   |   |   |   |   |   |
		     |		   |		   |   |   |   |   |   |   |   |
		     |		   |	illegal    |   |   |   |   |   |   |   |
		     |		   |		   |   |   |   |   |   |   |   |
		     |		   |	illegal    |   |   |   |   |   |   |   |
		     |		   |		   |   |   |   |   |   |   |   |
		     |		   |	illegal    |   |   |   |   |   |   |   |
		     |		   |		   |   |   |   |   |   |   |   |
		     |		   |	 wait	   |   |   |   |   |   |   |   |
		     |		   |		   |   |   |   |   |   |   |   |
		     |		   |	 false	   |   |   |   |   |   |   |   |
		     |		   |		   |   |   |   |   |   |   |   |
		     |		   |	 wait	   |   |   |   |   |   |   |   |
		     |		   |		   |   |   |   |   |   |   |   |
		     |		   |	 false	   |   |   |   |   |   |   |   |
		     |		   |		   |   |   |   |   |   |   |   |
		     +-------------+---------------+---+---+---+---+---+---+---+
			    ook: the second call will be successfull.

			    owait: the second call waits until dba_close(3) is called for the first.

			    ofalse: the second call returns false.

			    oillegal: you must not mix
			      "l" and "d" modifiers for $mode parameter.

	      o $handler
		-  The	name of the handler which shall be used for accessing $path. It is passed all optional parameters given to dba_open(3) and
		can act on behalf of them.

RETURN VALUES

	Returns a positive handle on success or FALSE on failure.

CHANGELOG

       +--------+---------------------------------------------------+
       |Version |						    |
       |	|						    |
       |	|		     Description		    |
       |	|						    |
       +--------+---------------------------------------------------+
       | 4.3.0	|						    |
       |	|						    |
       |	|  It's possible to open database files  over  net- |
       |	| work	connection.  However in cases a socket con- |
       |	| nection will be used (as with http  or  ftp)	the |
       |	| connection will be locked instead of the resource |
       |	| itself. This is important to know since  in  such |
       |	| cases  locking  is simply ignored on the resource |
       |	| and other solutions have to be found. 	    |
       |	|						    |
       +--------+---------------------------------------------------+
SEE ALSO

       dba_popen(3), dba_close(3).

PHP Documentation Group 													       DBA_OPEN(3)
All times are GMT -4. The time now is 11:13 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy