Sponsored Content
Operating Systems AIX Oracle 10G best practices on Power6 AIX5.3 Post 302192549 by indulis on Wednesday 7th of May 2008 07:41:49 AM
Old 05-07-2008
Lots of stuff to think about!

You need to think about the reasons for running RAC. Is it to overcome downtime due to scheduled server outages? Or for high availability (ie 24x7 or as close as possible)? Are you trying for a 2-site cluster (much harder to administer and set up)?

Anyway you need a way to get to the data which is shared between the cluster nodes, raw disk or a clustered filesystem or NFS- you can use ASM (raw disk shared across cluster ie all backups via Oracle) or GPFS (filesystem shared across cluster, backups via Oracle interacting with backup s/w such as TSM). Both supported with AIX. Also you can look at HACMP shared raw LVs (not v popular these days) or a NAS (though then access to DB is via NFS).

You will need to consider what happens in the different failure scenarios. Especially for 2-site scenario, as you will likely find you will need 3 sites (3rd site is a voting site).

There are documents available with examples for setting up RAC and GPFS from the IBM Oracle Competency Centre. Contact oraclibm fr ibm com for the "Oracle 10g RAC cookbook on IBM pseries running AIX".

Then you can start thinking about tuning as well!

Don't forget about having enough capacity available in case one server is unavailable for a long time.

For availability you will need to consider lots of other stuff to reduce outages (e.g. AIX multibos)

Luck!

Last edited by indulis; 05-07-2008 at 08:44 AM.. Reason: correction
 

7 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

oracle 10g

I have download Oracle 10g for Solaris and I have configurate environment than I will start runInstaller and I have a messege that my version of solaris is not 5.7 , 5.8 and 5,9 I have 5.10 Solaris version what I shoud do I have download most actuall Oracle databases. (4 Replies)
Discussion started by: Deux
4 Replies

2. AIX

Oracle Process has removed from AIX5.2

Hello, I am creating oracle connection from one aix5.2 machine to another aix5.2 database machine. Oracle connection i am reusing it always. If there is now work for java thread to process, oracle instance will be idle and will be active once java thread processes. We have installed OS... (0 Replies)
Discussion started by: balareddy
0 Replies

3. AIX

oracle 10g on AIX 5

hi can anyone help me by telling step by stem oracle10g installation in AIX 5 . Munir mondolsoft Bangladesh (3 Replies)
Discussion started by: dbamunir
3 Replies

4. Solaris

Installing oracle 10g on solaris

Thanks all for your help. Now here is another problem i have, i have been trying to install oracle 10g on solaris but i keep getting this error message "there is not enough memory on the volume you specify to copy the starter database files the oracle universal installer discover that you have... (8 Replies)
Discussion started by: mutiat
8 Replies

5. Solaris

How can i install oracle 10g on x86

Please guide me to install oracle 10g in x86 machine running solaris10. I tried the method that is distributed with the Oracle cd, but i finds it to be too complicated for me to complete. Please help. (2 Replies)
Discussion started by: Sesha
2 Replies

6. AIX

Oracle 10g on AIX7

Hi, anyone know if Oracle Database 10g is AIX 7 certified??? thanks in advance. Regards. Mario (2 Replies)
Discussion started by: Zio Bill
2 Replies

7. Solaris

need help in oracle upgrade from 10g to 11g

Hi , situation has come where in i want to upgrade my database from 10g to 11g ,my code heavily depends on Pro*C , i just want to know if i upgrade my DB from 10g to 11g , will there be any changes in my pro*c compiler ..? if so then wat are the prerequisites i need to check ..? thanks ... (2 Replies)
Discussion started by: senkerth
2 Replies
NDB_PRINT_BACKUP_(1)					       MySQL Database System					      NDB_PRINT_BACKUP_(1)

NAME
ndb_print_backup_file - print NDB backup file contents SYNOPSIS
ndb_print_backup_file file_name DESCRIPTION
ndb_print_backup_file obtains diagnostic information from a cluster backup file. Usage ndb_print_backup_file file_name file_name is the name of a cluster backup file. This can be any of the files (.Data, .ctl, or .log file) found in a cluster backup directory. These files are found in the data node's backup directory under the subdirectory BACKUP-#, where # is the sequence number for the backup. For more information about cluster backup files and their contents, see Section 17.5.3.1, "MySQL Cluster Backup Concepts". Like ndb_print_schema_file and ndb_print_sys_file (and unlike most of the other NDB utilities that are intended to be run on a management server host or to connect to a management server) ndb_print_backup_file must be run on a cluster data node, since it accesses the data node file system directly. Because it does not make use of the management server, this utility can be used when the management server is not running, and even when the cluster has been completely shut down. Additional Options None. COPYRIGHT
Copyright (C) 1997, 2014, Oracle and/or its affiliates. All rights reserved. This documentation is free software; you can redistribute it and/or modify it only under the terms of the GNU General Public License as published by the Free Software Foundation; version 2 of the License. This documentation is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details. You should have received a copy of the GNU General Public License along with the program; if not, write to the Free Software Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA or see http://www.gnu.org/licenses/. SEE ALSO
For more information, please refer to the MySQL Reference Manual, which may already be installed locally and which is also available online at http://dev.mysql.com/doc/. AUTHOR
Oracle Corporation (http://dev.mysql.com/). MySQL 5.5 01/30/2014 NDB_PRINT_BACKUP_(1)
All times are GMT -4. The time now is 10:40 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy