01-08-2019
Hi,
If you're staying on SPARC then you're staying with OVM, there are a number of options - I would have liked to stay with our current setup. While we don't run clustered for our critical apps, we do have a hot DR site with matching kit with a dual 40Gb pipe between the two sites storage is replicated using Metro Mirror or Global Mirror.
We are currently running OVM 3.5 which is very stable, our zones (about 100 - haven't counted them) are both branded and lightweight. We have a large number of Oracle instances on Solaris, these cover Oracle 7.3.4 all the way up to Oracle 12. Where we have a zone we use a single SAN LUN, this make or DR easy with cross site replication to the DR site. Where we have an LDOM, the disks are all replicated to the other site - in general we keep the Oracle ASM disks as seperate LUN's. All of our Solaris DR is scripted and even on our LDOM's we can have a full failover to a DR system in 15 minutes from the go instruction.
The setup we use is a little unorthodox, but suffice to say that until DR is implemented the the target LDOM doesn't exist as when we implement a DR we use the same hostname and the same IP Addresses at the remote site ove stretched VLAN's at layer 2.
The RHEV managed systems are Solaris x86 so not really relevant in this context, I don't believe that there is a version of RHEV that will handle SPARC - happy to be advised otherwise folks.
Regards
Gull04
This User Gave Thanks to gull04 For This Post:
7 More Discussions You Might Find Interesting
1. Programming
Hello,
I would really appreciate some help with a problem my current client is having. He has an old legacy app that does his company's financial accounting and ERP for manufacturing, etc. The app was written by a company called "Just in time" in Austin, TX, and they are no longer in business.
... (2 Replies)
Discussion started by: w0lf
2 Replies
2. Infrastructure Monitoring
Hi All ,
I am new to shall scripting, i want write an script for oracle tns and listener.
If tns working i want o/p as "Listener and TNS are working"
else o/p should be ""Listener and TNS are not Working"
below is the command in unix to check the tns status, if no output it means TNS... (3 Replies)
Discussion started by: abdul bari
3 Replies
3. Shell Programming and Scripting
Hi, can anyone help me with this script please. I need the oracle command to go into the unix batch file.
#!/bin/sh
# A menu driven Shell script which has following options
# for acmtoron@>
#
#
# Exit
# As per option do the job
#----
while :
do
clear
echo " A C M LOG MONITORING... (0 Replies)
Discussion started by: tinaaguilera
0 Replies
4. Programming
Hi,
Though this is a unix forum mainly, am posting this oracle query here hoping to get a resolution.
I have set up two scheduled jobs in oracle 11g for executiong a procedure in specific time intervals. One as Hourly and other as minutely.
But the scheduled jobs are not running as per... (2 Replies)
Discussion started by: suresh_kb211
2 Replies
5. Emergency UNIX and Linux Support
Setup:
Multiple Virtual Machines running OEL5 / Oracle RDBMS 11.2
OVM 2 / Xen 3.4.0 Cluster consisting of 3 Machines
Shared SAN Storage synced with OCFS2
SAN connected with 4GB FC on 4 Paths per LUN
SAN target are 2 EMC Clariion mirroring each other
The problems we're facing are that... (6 Replies)
Discussion started by: pludi
6 Replies
6. Solaris
I have two SPARC T4-2 servers:
- Oracle Solaris 11.1 Installed.
- Oracle VM Server for SPARC 3.0 software Installed.
- Shared LUN provisioned to both servers from Clariion CX4 storage box (shared LUN to be used for the Live Migration of the VMs).
- Oracle VM Agent 3.2.1 for SPARC installed.
... (14 Replies)
Discussion started by: Mack1982
14 Replies
7. Shell Programming and Scripting
Hi Experts,
I have a list of Dbs.In that DBs i need to execute some sql scripts.
each sql script is unique and it should run on particular DB only.
For example. i have DBs like MDC20V,NDC20V,ODC20V and sql scripts like MD.sql,ND.sql,OD.sql.so MD.sql should run only in MDC20V and ND.sql should... (1 Reply)
Discussion started by: navsan420
1 Replies
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)