RMANCAT (02)

Monday 09 June, 2008 - 23:33

Have been trying to work out the best way to configure rmancat . The preferred approach is to:

  1. Have the default listener (LISTENER) on port 2521 shared between +ASM and rmancat.
  2. A soft link from $ASM_HOME/network/admin/tnsnames.ora to $ORACLE_HOME/network/admin/tnsnames.ora (Should be using TNS_ADMIN but this works. If I have time, will revisit this.)
  3. Set up the listener.ora with two SIDs prefined (ASM and RMANCAT)
  4. Set LOCAL_LISTENER = ASM for +ASM
  5. Set LOCAL_LISTENER = RMANCAT for rmancat

I tried using the procedures as described on pp.2-10 to 2-13 of Administrator’s Reference for UNIX-Based Operating Systems . The first problem (p.2-11) is that the W option is invalid. The second problem is with dbora (pp.2-12 to 2-13). On startup, the following messages appear in /var/log/messages :
dbora: + rsh rmancat.yaocm.id.au -l oracle /etc/rc3.d/S99dbora start ORA_DB
dbora: rmancat.yaocm.id.au: Connection refused
dbora: + exit

Used the method from /u00/app/oracle/OracleHomes/agent10g/install/unix/scripts/agentstup instead to code /etc/init.d/dbora as follows:
#! /bin/sh -x
#
# Change the value of ORACLE_HOME to specify the correct Oracle home
# directory for your installation.
ORACLE_HOME=/u00/app/oracle/product/10.2.0/db_1
#
# Change the value of ORACLE to the login name of the
# oracle owner at your site.
#
ORACLE=oracle
PATH=${PATH}:$ORACLE_HOME/bin
HOST=`hostname`
PLATFORM=`uname`
SU=/bin/su
export ORACLE_HOME PATH
#
case $1 in
'start')
$SU $ORACLE -c "$ORACLE_HOME/bin/dbstart $ORACLE_HOME " &
;;
'stop')
$SU $ORACLE -c "$ORACLE_HOME/bin/dbshut $ORACLE_HOME " &
;;
*)
echo "usage: $0 {start|stop}"
exit
;;
esac
#
exit

However, this does not quite work because dbora runs before CSSD is ready.

Maybe this is Oracle's way of making one use RAC because clusterware is so much simpler than all this stuffing around with ASM, multiple listeners.