Table of Contents
Advertisement
NOTE
Tuning, Troubleshooting, Security, and Maintenance
System Maintenance
/etc/csh.login
/etc/rc.config.d/ovoracle
/etc/opt/OV/share/conf/ovdbconf
You will need to change the database release entry and check the
.profile and .cshrc files of the users that require access to the
database, for example; oracle, root, and opc_op.
/etc/tnsnames.ora (if SQL*Net is used)
/etc/listener.ora (if SQL*Net is used)
/etc/sqlnet.ora (if SQL*Net is used)
Upgrading the Oracle database version (7.3.4 to 8.0.5) within ITO
A.05.00:
• ORACLE_HOME may be set in the files listed above: but it is not a
requirement.
• ITO creates a symbolic link libopcora.sl which points to the
current Oracle installation. Change this link to point to the new
(upgrade) installation. Enter:
rm -f /opt/OV/libcl/libopcora.sl
ln -s $ORACLE_HOME/lib/libclntsh.sl \
/opt/OV/lib/libopcora.sl
Database Configuration Tips
Although using Oracle's archivelog mode helps to reduce the loss of data
after a backup and restore, Oracle offers additional ways to avoid data
loss in the unlikely event that a disk fails. If you have access to more
than one disk, it is recommended that you take a look at the following
configuration tips and use the information to help you implement such a
scenario in your own ITO environment:
• Move one or more Oracle control files to the second disk:
1. Create the directories on the second disk:
mkdir -p /u02/oradata/openview
chown oracle:dba /u02/oradata/openview
470
Chapter 10
Advertisement
Table of Contents
Troubleshooting
