07-08-2011
Having worked for some time on this issue I'd like to share my findings.
The initial issue was a system not being able to boot after Clusterware was installed. We found the following:
Clusterware installs a cluster daemon "ohasd" which is started in /etc/inittab in runlevel 2. Unfortunately the starting script never comes back if anything goes wrong.
As it is with usual HACMP-installations the Oracle binaries are being installed on a VG which is itself part of a HACMP-Resource group. Therefore the filesystem where the ohasd daemon is expected to be will not be there at system start (but only after cluster start and activation of the resource group).
The solution was to take the start routines and everything else installed by Oracle out of the systems start routines (inittab, rc-scripts) and put it in the start-scripts of the resource group. I will provide you with a list of what exactly we did when time permits. Still, ohasd, which effectively prevented system boot, was the biggest issue we encountered.
I hope this helps someone.
bakunin
8 More Discussions You Might Find Interesting
1. Cybersecurity
I have openssh identity and identity.pub which work well on many machines to uniquely identify myself.
I want to put these on a host (Tru64) using ssh2. I can convert the public key to ssh2 format using "ssh-keygen -e" on an openssh box.
How should I convert the private key? (2 Replies)
Discussion started by: porter
2 Replies
2. AIX
Hello,
I was wondering if I have 3 nodes (A, B, C) all configured to startup with HACMP, but I would like to configure HACMP in such a way:
1) Node B should startup first. After the cluster successfully starts up and mounts all the filesystems, then
2) Node A, and Node C should startup !
... (4 Replies)
Discussion started by: filosophizer
4 Replies
3. AIX
Hello,
I would like to know if anyone has faced this problem. Whenever there is a duplicate IP address, HACMP goes down infact HACMP ( PowerHA ) takes the whole system down.
Does anyone know how to solve this problem ? (3 Replies)
Discussion started by: filosophizer
3 Replies
4. AIX
I was wondering if any one have any guides or documention regarding Oracle and SAP on AIX 6.1 + PowerHA setups in one guide step by step
Thanks (2 Replies)
Discussion started by: h@foorsa.biz
2 Replies
5. AIX
hi,
when I do a failover, hacmp always starts db2 but recently it fails to start db2..noticed the issue is db2nodes.cfg is not modified by hacmp and is still showing primary node..manually changed the node name to secondary after which db2 started immediately..unable to figure out why hacmp is... (4 Replies)
Discussion started by: gkr747
4 Replies
6. AIX
Hi,
does anyone happen to have a sample of a hacmp monitoring script for oracle? With the process monitoring I seem to be only able to monitor the listener but not oracle itself ?
Thanks in advance
zxmaus (1 Reply)
Discussion started by: zxmaus
1 Replies
7. AIX
Few questions regarding Power HA ( previously known as HACMP) and VIOS POWERVM IVM ( IBM Virtualization I/O Server )
Is it possible to create HACMP cluster between two VIOS servers
Physical Machine_1
VIOS_SERVER_1
LPAR_1
SHARED_DISK_XX
VIOS_SERVER_2
Physical Machine_2
LPAR_2... (6 Replies)
Discussion started by: filosophizer
6 Replies
8. AIX
Hello,
AIX 6.1 TL7 SP6
POwerHA 6.1 SP10
I was experimenting with new hacmp build. It's 3-node cluster build on AIX 6.1 lpars. It contains Ethernet and diskhb networks. Shared vg disk is SAN disk. Two nodes see disk using vscsi, third node sees disk using npiv. Application is db2 server.
... (4 Replies)
Discussion started by: vilius
4 Replies
LEARN ABOUT OSX
dbix::class::storage::dbi::oracle::wherejoins
DBIx::Class::Storage::DBI::Oracle::WhereJoins(3) User Contributed Perl Documentation DBIx::Class::Storage::DBI::Oracle::WhereJoins(3)
NAME
DBIx::Class::Storage::DBI::Oracle::WhereJoins - Oracle joins in WHERE syntax support (instead of ANSI).
PURPOSE
This module is used with Oracle < 9.0 due to lack of support for standard ANSI join syntax.
SYNOPSIS
DBIx::Class should automagically detect Oracle and use this module with no work from you.
DESCRIPTION
This class implements Oracle's WhereJoin support. Instead of:
SELECT x FROM y JOIN z ON y.id = z.id
It will write:
SELECT x FROM y, z WHERE y.id = z.id
It should properly support left joins, and right joins. Full outer joins are not possible due to the fact that Oracle requires the entire
query be written to union the results of a left and right join, and by the time this module is called to create the where query and table
definition part of the SQL query, it's already too late.
METHODS
See DBIx::Class::SQLMaker::OracleJoins for implementation details.
BUGS
Does not support full outer joins. Probably lots more.
SEE ALSO
DBIx::Class::SQLMaker
DBIx::Class::SQLMaker::OracleJoins
DBIx::Class::Storage::DBI::Oracle::Generic
DBIx::Class
AUTHOR
Justin Wheeler "<jwheeler@datademons.com>"
CONTRIBUTORS
David Jack Olrik "<djo@cpan.org>"
LICENSE
This module is licensed under the same terms as Perl itself.
perl v5.16.2 2012-08-16 DBIx::Class::Storage::DBI::Oracle::WhereJoins(3)