Oracle Database Post – Installation Task

Post Database Installation Steps

→Oracle recommends that you back up the root.sh script after you complete an installation. 

→ Set the language preferences for clients connecting to the database by setting the NLS_LANG environment variable.

→The NLS_LANG environment variable declares the language and territory character sets that client applications use to connect to the database

→Use the following guidelines only if the default semaphore parameter values are too low to accommodate all Oracle processes:

→Calculate the minimum total semaphore requirements using the following formula

→sum (process parameters of all database instances on the system) + overhead for oracle background processes + system and other application requirements

   Set semmns (total semaphores systemwide) to this total.

   Set semmsl (semaphores per set) to 250.

    Set semmni (total semaphores sets) to semmns/semmslrounded up to the nearest multiple of 1024.

 Enabling and Disabling Database Options

→When you install Oracle Database, some options are enabled and others are disabled. To enable or disable a particular database feature for an Oracle home, shut down the database and use the chopt tool

→The chopt tool is a command-line utility that is located in theORACLE_HOME/bin directory. The syntax for chopt is:

→ chopt [ enable | disable] db_optio

→The possible values for db_option are described in the following table:

 

Value	Description
dm	Oracle Data Mining RDBMS Files
olap	Oracle OLAP
partitioning	Oracle Partitioning
rat	Oracle Real Application Testing

→Example 8-1 Complete Example of Running the Chopt Tool

To enable the Oracle Data Mining option in your Oracle binary files, use the following command:

cd $ORACLE_HOME/bin

srvctl stop database -d myDb

chopt enable dm

srvctl start database -d myDb

---------------------------------------------------------------------

Downloading and Installing theORAchk Health Check Tool

→ ORAchk replaces the RACCheck utility. ORAchk extends health check coverage to the entire Oracle software stack, and identifies and addresses top issues reported by Oracle users.

→You must run the utlrp.sql script after creating or upgrading a database

---------------------------------------------------------------------------------------------

Setting TCP Network Protocol Buffer for Direct NFS Client

→To check the current TCP buffer size, enter the following command:

# sysctl -a |grep -e net.ipv4.tcp_[rw]mem

→The output of this command is similar to the following:

→net.ipv4.tcp_rmem = 4096        87380   1048576

→net.ipv4.tcp_wmem = 4096        16384   1048576

As root, use a text editor to open /etc/sysctl.conf, and add or change to the following:

# net.ipv4.tcp_rmem = 4096        87380   4194304

 # net.ipv4.tcp_wmem = 4096        16384   419430

1. Restart the network:

# /etc/rc.d/init.d/network restart

--------------------------------------------------------------------------