Prev | Current Page 564 | Next

Richard Niemiec

"Oracle Database 10g Performance Tuning Tips & Techniques"

Use the following commands to create these if they do not already exist, and assign the
oracle user to both groups, with oinstall as the primary group:
[root@oc1 ~]# /usr/sbin/groupadd oinstall
[root@oc1 ~]# /usr/sbin/groupadd dba
[root@oc1 ~]# /usr/sbin/useradd -g oinstall -G dba oracle
[root@oc1 ~]# passwd oracle
Changing password for user oracle.
New password:
Retype new password:
passwd: all authentication tokens updated successfully.
[root@oc1 ~]#
For the oracle user, set up the default environment in the logon script; this sample logon script
assumes the bash shell (Bourne Again Shell) on Oracle Enterprise Linux:
# .bash_profile
# Get the aliases and functions
if [ -f ~/.bashrc ]; then
. ~/.bashrc
fi
# User specific environment and startup programs
PATH=$PATH:$HOME/bin
export PATH
unset USERNAME
umask 022
ORACLE_BASE=/u01/app/oracle
# ORACLE_HOME is set after installation with OUI.
# ORACLE_HOME=$ORACLE_BASE/product/11.1.0/db_1
# ORACLE_SID different on each node;
# same database, different instance.
ORACLE_BASE=/u01/app/oracle
ORACLE_HOME=$ORACLE_BASE/product/11.1.0/db_1
ORACLE_SID=rac1
PATH=$ORACLE_HOME/bin:$PATH
export ORACLE_BASE ORACLE_HOME ORACLE_SID PATH
Make sure that the value for ORACLE_SID is unique on each node! As I install additional
products such as CRS and create the RAC instances, I will make changes to this logon script as
appropriate.
To set up user equivalence between nodes in the cluster, use either the .


Pages:
552 553 554 555 556 557 558 559 560 561 562 563 564 565 566 567 568 569 570 571 572 573 574 575 576
Stal rezerwacja hoteli pomiary wiatru Nike Buty Męskie Air Flex Trainer Lea Biżuteria swarovskiego