beautypg.com

Database:backup configuration tips – HP UX B6941-90001 User Manual

Page 470

background image

470

Chapter 10

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)

NOTE

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