04-07-2006
Oracle do not have a "nohup" or related command. If you mean to say you want to schedule a job to run within oracle at a specific time, you need to make use of the dbms_job package. This will automate a oracle process to run
at whatever time you want to run it.
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Hi,
I have a general question on using the "nohup" command. As far as I've got it, submmitting a job with no hang up specified, should result in the job running until completion, regardless of whether the session that submitted the job(parent) is still active. This is very helpful when doing... (1 Reply)
Discussion started by: errolg
1 Replies
2. UNIX for Dummies Questions & Answers
Hello All,
I am newbie to unix.I am trying to use NOHUP command in shell script it works fine with only "nohup test.sh 10 &" and "/opt/user/nohup test.sh 10 &" gives an error saying "ksh: /opt/user/nohup : not found".
Can anybody please guide me to make it work.
Thanks
Blazix (9 Replies)
Discussion started by: blazix
9 Replies
3. Shell Programming and Scripting
Hi
I am using nohup command in script(say nohup ls- ltr > somefile 2>&1 & ). I dont want any kind of output to be displayed on screen. When i tried the above nohup it still gives me some out put on screen like
2991
Done >somefile 2>&1
Please you let me know what is... (3 Replies)
Discussion started by: ammu
3 Replies
4. UNIX for Dummies Questions & Answers
Hello folks,
I have got a script which telnets to different boxes and runs a certain script with 3 run time args.
The line from the script which does it is:
(sleep 1; echo $USERID ; sleep 1; echo $PASSWD ; sleep 1 ; echo y ; sleep 1 ; echo "\r" ; sleep 1 ; echo "cd $FILEPATH" ; sleep 1 ; sleep 1... (1 Reply)
Discussion started by: Rajat
1 Replies
5. Shell Programming and Scripting
I want to know how to use a nohup command in the script........
I have to run following command
nohup /tmp/app/statuscheck.sh &
After typing this command I will type ctrl D to come to the prompt and the that command will run in backround.
I want to include that command in a... (2 Replies)
Discussion started by: jayaramanit
2 Replies
6. Shell Programming and Scripting
I want to know how to use a nohup command in the script........
I have to run following command
nohup /tmp/app/statuscheck.sh &
After typing this command I will type ctrl D to come to the prompt and the that command will run in backround.
Even after pressing & the command is not... (3 Replies)
Discussion started by: jayaramanit
3 Replies
7. UNIX for Dummies Questions & Answers
Hi..
Can anybody tell me, what exactly the nohup command does & when is it used?
Your help is appreciated. (3 Replies)
Discussion started by: Amol21
3 Replies
8. Shell Programming and Scripting
Hi everyone,
I am starting a nohup from a script (via scheduling system) as follows:
ssh user@server "nohup command & ; exit 0"
This command is not returning the command prompt untless I press "ENTER". This is causing the schedule to hang at this job and not continue with the rest of the jobs.... (12 Replies)
Discussion started by: nimo
12 Replies
9. AIX
I'm trying to run a compress script in the background, but I even though the script is running in the background I get "Sending nohup output to nohup.out." and the screen just stays there. How can I make the script run in background and make my command prompt come back.
I was using:
nohup... (2 Replies)
Discussion started by: NycUnxer
2 Replies
10. UNIX and Linux Applications
Good afternoon:
I need your help please, Im new at Unix nd specially Unix applicationas like oracle and Ive got this problem:
I was asked to execute the next script using nohup in order to not hang up the session because it was supposed to connect to the database and then insert about 2... (3 Replies)
Discussion started by: alexcol
3 Replies
LEARN ABOUT PHP
oci_set_edition
OCI_SET_EDITION(3) OCI_SET_EDITION(3)
oci_set_edition - Sets the database edition
SYNOPSIS
bool oci_set_edition (string $edition)
DESCRIPTION
Sets the database "edition" of objects to be used by a subsequent connections.
Oracle Editions allow concurrent versions of applications to run using the same schema and object names. This is useful for upgrading live
systems.
Call oci_set_edition(3) before calling oci_connect(3), oci_pconnect(3) or oci_new_connect(3).
If an edition is set that is not valid in the database, connection will fail even if oci_set_edition(3) returns success.
When using persistent connections, if a connection with the requested edition setting already exists, it is reused. Otherwise, a different
persistent connection is created
PARAMETERS
o $edition
- Oracle Database edition name previously created with the SQL " CREATE EDITION" command.
NOTES
Note
Oracle version requirement
This function is available from Oracle 11 gR2 onwards.
Caution
Persistent connections
To avoid inconsistencies and unexpected errors, do not use ALTER SESSION SET EDITION to change the edition on persistent connec-
tions.
Caution
DRCP Connection Pooling
To avoid inconsistencies and unexpected errors when using editions and DRCP with Oracle 11.2.0.1, keep a one-to-one correspondence
between the oci8.connection_class and the edition name used by applications. Each pooled server of a given connection class should
only be used with one edition. This restriction has been removed with Oracle 11.2.0.2.
RETURN VALUES
Returns TRUE on success or FALSE on failure.
EXAMPLES
Example #1
Two scripts can use different versions of myfunc() at the same time
<?php
// File 1
echo "Version 1 of application
";
oci_set_edition('ORA$BASE');
$c = oci_connect('hr', 'welcome', 'localhost/XE');
$s = oci_parse($c, "begin :r := myfunc(); end;");
oci_bind_by_name($s, ":r", $r, 20);
oci_execute($s);
echo "The result is $r
";
?>
<?php
// File 2
echo "Version 2 of application
";
oci_set_edition('E1');
$c = oci_connect('hr', 'welcome', 'localhost/XE');
$s = oci_parse($c, "begin :r := myfunc(); end;");
oci_bind_by_name($s, ":r", $r, 20);
oci_execute($s);
echo "The result is $r
";
?>
PHP Documentation Group OCI_SET_EDITION(3)