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_client_info

OCI_SET_CLIENT_INFO(3)													    OCI_SET_CLIENT_INFO(3)

oci_set_client_info - Sets the client information

SYNOPSIS

       bool oci_set_client_info (resource  $connection, string	$client_info)

DESCRIPTION

	Sets the client information for Oracle tracing.

	The  client  information  is registered with the database when the next 'roundtrip' from PHP to the database occurs, typically when an SQL
       statement is executed.

	The client information can subsequently be queried from database administration views such as V$SESSION.

	The value may be retained across persistent connections.

PARAMETERS

	      o $connection
		-An Oracle connection identifier, returned by oci_connect(3), oci_pconnect(3), or oci_new_connect(3).

	      o $client_info
		- User chosen string up to 64 bytes long.

RETURN VALUES

	Returns TRUE on success or FALSE on failure.

EXAMPLES

       Example #1

	      Setting the client information

	      <?php

	      $c = oci_connect('hr', 'welcome', 'localhost/XE');

	      // Record the client information
	      oci_set_client_info($c, 'My Application Version 2');

	      // Code that causes a roundtrip, for example a query:
	      $s = oci_parse($c, 'select * from dual');
	      oci_execute($s);
	      oci_fetch_all($s, $res);

	      sleep(30);

	      ?>

	      // While the script is running, the administrator can see the client
	      // information:

	      sqlplus system/welcome
	      SQL> select client_info from v$session;

NOTES

       Note

	      Oracle version requirement

	      This function is available when PHP is linked with Oracle Database libraries from version 10 g onwards.

       Tip

	      Performance

	      With older versions of OCI8 or the Oracle Database, the client information can be set using the Oracle  DBMS_APPLICATION_INFO  pack-
	      age. This is less efficient than using oci_set_client_info(3).

       Caution

	      Roundtrip Gotcha

	      Some  but  not  all  OCI8  functions  cause roundtrips. Roundtrips to the database may not occur with queries when result caching is
	      enabled.

SEE ALSO

       oci_set_module_name(3), oci_set_action(3), oci_set_client_identifier(3).

PHP Documentation Group 												    OCI_SET_CLIENT_INFO(3)

Shell Programming and Scripting