Managing Serviceguard Extension for SAP on Linux (IA64 Integrity and x86_64), February 2008

Step-by-Step Cluster Conversion
Database Configuration
Chapter 3 167
echo "startup mount;" >> $SRVMGRDBA_CMD_FILE
echo "spool endbackup.log" >> $SRVMGRDBA_CMD_FILE
echo "select 'alter database datafile '''||f.name||''' end
backup;'" >> $SRVMGRDBA_CMD_FILE
echo "from v\$datafile f, v\$backup b" >>
$SRVMGRDBA_CMD_FILE
echo "where b.file# = f.file# and b.status = 'ACTIVE'" >>
$SRVMGRDBA_CMD_FILE
echo "/" >> $SRVMGRDBA_CMD_FILE
echo "spool off" >> $SRVMGRDBA_CMD_FILE
echo "!grep '^alter' endbackup.log >endbackup.sql" >>
$SRVMGRDBA_CMD_FILE
echo "@endbackup.sql" >> $SRVMGRDBA_CMD_FILE
echo "!rm endbackup.*" >> $SRVMGRDBA_CMD_FILE
echo "alter database open;" >> $SRVMGRDBA_CMD_FILE
echo "exit;" >> $SRVMGRDBA_CMD_FILE
eval $SRVMGRDBA command=@$SRVMGRDBA_CMD_FILE >> $LOG 2>&1
OR860 Oracle Database Step:
Perform the following steps as ora<sid>.
Configure the listener to listen on the relocatible name of the database
package. To do this, change all references from <local> to the relocatible
name <relocdb> in the files on the shared volume group. Be careful if
these files were customized after the SAP installation. For example:
$ORACLE_HOME/network/admin/listener.ora
$ORACLE_HOME/network/admin/tnsnames.ora
When using Oracle 10g:
/sapmnt/<SID>/profile/oracle/listener.ora
/sapmnt/<SID>/profile/oracle/tnsnames.ora