03-17-2006
Bouncing Oracle Servers
Hello buffoonix,
Thank you very much for your response.
Soon after posting my thread "Bouncing Oracle Servers" I had a look at Oracle SQL*PLUS Manual (Oracle 9i) on the web and found out my answer for this paticular version.
As you said, there are number of ways to startup and shutdown an Oracle server
1- using SQL*PLUS
2- using RMAN
3- using Oracle Eneterprise Manager.
Once again many thanks for your time.
Best regards
MH
9 More Discussions You Might Find Interesting
1. SCO
Hi. Can entire data be taken thr' ncftp from one SCO Unix server to another?
Please let me know. (0 Replies)
Discussion started by: hrishi10a
0 Replies
2. UNIX for Dummies Questions & Answers
hi all!
I am VB developer and i am trying to automate a process in UNIX for which i request your help.
I want to learn the technique by which we can write batch process in unix server to search for a list of files and to note down files that are missing from the list in the form of a log so... (2 Replies)
Discussion started by: varsai123
2 Replies
3. UNIX for Dummies Questions & Answers
Hello, i am new to both this forum and UNIX as well; i am working at a local cancer center trying to reassociate 2 UNIX server systems that i am unfamiliar with; Both C3600 workstations were associated, however they were disassociated and need to be reassociated so programs can be accessed on... (0 Replies)
Discussion started by: RarisRSX
0 Replies
4. UNIX for Advanced & Expert Users
Guys,
I need a monitoring software for my Unix servers.
Over the last couple of years, the number has increased to well over 40 servers.
All have different applications running on them and it is impossible to go to everyone of them and do checks.
I was using Spotlight on Unix.
I was... (1 Reply)
Discussion started by: jair
1 Replies
5. Shell Programming and Scripting
Hi
I have server A and server B.
On server B the directory is called /tmp/hmp
On server A I want to get the files on server B:/tmp/hmp via FTP. After I have got the files via FTP I have to delete them. In the script below I'm affraid of that I delete files before I get them by ftp.
... (1 Reply)
Discussion started by: hpedersen4
1 Replies
6. Shell Programming and Scripting
hi,
anyone please explain ab the unix servers
thanks in advance
Satya (2 Replies)
Discussion started by: Satyak
2 Replies
7. Shell Programming and Scripting
Is it possible to use the diff command to compare two directories on different Unix (AIX) servers?
We have two regions set up and we want to be able to compare if the scripts directory in both regions contain the same files?
I want to figure out if its possible.. Have been messing around by... (10 Replies)
Discussion started by: Jazmania
10 Replies
8. UNIX for Dummies Questions & Answers
Hi All,
when i ftp the file from windows machine to unix server the record count in the file is decreased by 1.
example: Say a text file has three lines in it and when you place this file in unix server from your local machine and run a below command
cat filename | wc -l
the output is... (2 Replies)
Discussion started by: Umeshrm
2 Replies
9. UNIX for Dummies Questions & Answers
:wall: Does anyone know of a good Unix Server Syncronization Softwarware, I have a customer that has a primary server but he wants to get another one as a backup and he wants to syncronize all the disks on a daily or weekly bases to have it ready in case the primary fails. Your help would be... (2 Replies)
Discussion started by: reb
2 Replies
LEARN ABOUT PHP
oci_set_action
OCI_SET_ACTION(3) OCI_SET_ACTION(3)
oci_set_action - Sets the action name
SYNOPSIS
bool oci_set_action (resource $connection, string $action_name)
DESCRIPTION
Sets the action name for Oracle tracing.
The action name is registered with the database when the next 'roundtrip' from PHP to the database occurs, typically when an SQL statement
is executed.
The action name can subsequently be queried from database administration views such as V$SESSION. It can be used for tracing and monitor-
ing such as with V$SQLAREA and DBMS_MONITOR.SERV_MOD_ACT_STAT_ENABLE.
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 $action_name
- User chosen string up to 32 bytes long.
RETURN VALUES
Returns TRUE on success or FALSE on failure.
EXAMPLES
Example #1
Setting the action
<?php
$c = oci_connect('hr', 'welcome', 'localhost/XE');
// Record the action
oci_set_action($c, 'Friend Lookup');
// 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 actions
// being performed:
sqlplus system/welcome
SQL> select action 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_client_info(3), oci_set_client_identifier(3).
PHP Documentation Group OCI_SET_ACTION(3)