Oracle DB Start shutdown scripts

10 More Discussions You Might Find Interesting

1. Red Hat

Script to run at start and shutdown

Hello, I have script that start and shutdown the application. where should i place my script so that it can execute at my OS shutdown ? Pls help me...

2. Red Hat

Boot/Shutdown scripts

Server: Redhat 6.2 Goal: Startup script/Shutdown Script Overview: I'm just doing a very basic test. I'm not getting chkconfig involved. Research so far: I've found a few different ways of getting this to work, some say I can just drop the scripts in the corresponding rc directory. Others...

3. AIX

Please update inittab/rc.shutdown/rc scripts to start/stop mqm (need help Urgent)

HI i need help from seniors on this issue, i need to know how to do this, i need to update 50+ server starting saturday. below is the ticket which i have with full description. Currently MQ Series must be stopped before and started after any reboot. Not having the start/stop as part of...

4. UNIX for Dummies Questions & Answers

Script to force Oracle database shutdown when shutdown immediate does not work

I have Oracle 9i R2 on AIX 5.2. My Database is running in shared server mode (MTS). Sometimes when I shutdown the database it shutsdown cleanly in 4-5 mints and sometimes it takes good 15-20 minutes and then I get some ora-600 errors and only way to shutdown is by opening another session and...

5. Solaris

Unable to shutdown and start machine

Hello. I have just installed solaris on my PC (standalone). It allows to reboot. But IF I shut down and the restart by pressing the button - It does not show my solaris OS and I am then forced to perform fresh installation. Could you please let me know the fix for it - So that shutdown and...

6. UNIX for Advanced & Expert Users

warnings @ system start & shutdown

Hi, I'm having this Ultra5 system with Solaris10 on it. And when its booting, I get this warning 3 times and the system wait a considerable amount of time there before proceeding. WARNING: add_spec: No major number for fp And when its shutting down, I get this: Shutdown: RPC: Program not...

7. AIX

Startup/Shutdown scripts

I understand that by putting in entries into the /etc/inittab file. We can actually call the our scripts during startup. mkitab "start_server:2:once:sh /scripts/startserver.sh" Would the system wait for startserver.sh finish executing before it goes to another entry? and how long would it...

8. SuSE

Shutdown scripts

Hello all I'm trying to automate the startup/shutdown of my database whenever the OS is bounced ... OS : Linux (Kernel : 2.4.20.-6) Oracle : 9.2.0.5 The contents of /etc/init.d/dbora file is listed below case "$1" in 'start') su - $ORACLE_OWNER -c "$ORACLE_HOME/bin/dbstart"...

9. Shell Programming and Scripting

Shutdown Scripts

Hi, Recently I've created a script to shutdown a few hpux workstations and I found out that the script can only shutdown 1 workstation and then exit out from the loop without shutting down the rest of the workstation. The scripts is as below (brief one): hcp_list="machine_a ...

10. UNIX for Advanced & Expert Users

rc scripts, do i need to kill them on shutdown?

We have a bunch of tools, that run on linux and on unix, I've got start up scripts that bring up their license managers when the unix box boots, do I need kill scripts for when the box is shutting down? I've not seen much documentation on this, just on getting the license managers started, but...

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)

Shell Programming and Scripting