09-10-2008
also, we are not going to use dbms_jobs or dbms_scheduler
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
I scheduled 2 Oracle jobs to run on IBM AIX 4.3.3 at
06:50 and 06:58 on 02/02/03 with the below syntax:
$ at 06:50 02/02/03 /orac/ora11/temp/sun_job1.sh
Job oracle.1044175800.a will be run at Sun Feb 2 06:50:00 2003.
$ at 06:58 02/02/03 /orac/ora11/temp/sun_job2.sh
Job... (1 Reply)
Discussion started by: ted
1 Replies
2. Shell Programming and Scripting
Hello,
I want to know about job scheduling utilities available in unix. It should not be responsible just for starting the job like in case of cron but should also be able to handle the execution of jobs.
Regards,
Ritesh (1 Reply)
Discussion started by: turlapaty
1 Replies
3. UNIX and Linux Applications
I am working on UNIX AIX system, with Oracle OS.
We are not supposed to use any tools to schedule our unix shell scripts.
Basically we have to make use of Oracle tables and Shell scripts to manage dependencies, restartability, scheduling, parallelizing,etc.
If anyone has worked/ is working... (1 Reply)
Discussion started by: singhabhijit
1 Replies
4. Shell Programming and Scripting
Hi Guys,
I am new to Unix,
Please tell me how to schedule a job to be executed on saturday,sunday and on friday night 8:00 PM onwards.
and also how to change the password of oracle user every year through unix?
Please help me to resolve this issue...
Regards,
Mahesh Raghunandanan (1 Reply)
Discussion started by: mraghunandanan
1 Replies
5. UNIX for Advanced & Expert Users
Hi,
I want to schedule a job through Autosys (in Linux server) to run on 1st day of every 3rd month(gap of 90 days). Please someone help me to achive my above requirement
Example:
Run the sample.sh on 01-Jan-2009, 01-Apr-2009, 01-Jul-2009, 01-Oct-2009.
Thanks in advance (4 Replies)
Discussion started by: apsprabhu
4 Replies
6. UNIX and Linux Applications
Hello!
I will be working with Autosys and I am looking for individuals that have knowledge of this UNIX application.
Thank-you! (3 Replies)
Discussion started by: preshe79
3 Replies
7. Shell Programming and Scripting
Hi All,
I have a script which is scheduled in the Cron. It runs every 10th and 40th min of an hour.The job has to run every 30min.
But, I do not want to have the 00:10 MST run every day.Is it possible to exclude that run from the schedule?Or any other way through which i can run my job every... (4 Replies)
Discussion started by: sparks
4 Replies
8. Shell Programming and Scripting
I am writing a script to run the jobs on demand, like when i am done with some online updates i want to run the sheduler script to schedule the job 1 by 1. It executes the following way
sched.ksh <data file>
The data file will have the jobs to be executed in the order to be executed and... (1 Reply)
Discussion started by: nw2unx123
1 Replies
9. Red Hat
Hi Everybody,
I want to run a script at every 5 seconds. I know how to run it every 5 minutes, is there any possibility to run a script at 5 seconds interval.
Regards,
Mastan (3 Replies)
Discussion started by: mastansaheb
3 Replies
10. Shell Programming and Scripting
Hi All,
I am new to unix and i have a task in front of me.
The code part is "android update sdk" . I need to crontab this process.
Hence i have written a script that runs the above command and sends a mail once the update is done. The problem with the automation is the installer asks for a... (5 Replies)
Discussion started by: Kashyap
5 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)