OTM installation ..
--> create user otm with group as otm
10g installation(10.2.0.1.0)
-login as otm user
Run runInstaller from the database dump.
post installation steps
--creating otm database
$OARCLE_HOME/bin
run ./dbca
set the initialization parameter files as given below
db_block_size = 8192
#db_block_size = 4096
# db_block_size should be at least 4K . Set it to 8K if you can. Extents allocated to segments will be round to
# multiple of db blocks. Segment header of a segment uses one db block. Bigger dn block has more advantages
db_cache_size = 209715200
# 200 MB data buffer
db_16k_cache_size = 104857600
# 100MB for 16k block buffers
shared_pool_size = 125829120
# 120 MB shared pool
# If shared pool is too small, Oracle needs to re-parse SQL statements more often
log_buffer = 163840 #160K
# If log buffer is too small, Oracle writes redo entries back to redo log files often
sort_area_size = 1048576 # 1M sorting area
# This is maximum amount of memory Oracle allocates for a sort in UGA. Lager value of this parameter
# permits more sorts to be done in memory.
# It is ignored when pga_aggregate_target is set.
job_queue_processes = 4
# Set SNPn job queue processes to 4
processes = 200
# This number affect the number of connections to the database.
LOG_CHECKPOINT_INTERVAL= 0
# Do not set this parameter if FAST_START_MTTR_TARGET is set. Otherwise set it to 0 or infinity.
optimizer_index_cost_adj = 50
# Setting this parameter to encourage optimizer to favor NESTED LOOP over HASH JOIN.
cursor_sharing = SIMILAR
# Let statements that only differ in literal values and have the same execution plan to share cursor. So it can reduce parsing calls and enhance query performance.
statistics_level = ALL
#Collect row source execution statistics and timed operating system statistics.
pga_aggregate_target = 209715200 (200 MB)
#This is the target of memory usage of work area and other data structure control information for server process. When this parameter is set, automatic memory management is turned on. Oracle suggests for initial setting this parameter can be set to 0.16* total memory that this database can use. If you set this parameter, you should keep watching PGA usage and adjust it accordingly. Don't set it too small. It will affect query performance if too small. If you don't set it, default is unset with a values shown as 0.
query_rewrite_enabled = true
# For using function based index.
query_rewrite_integrity = trusted
# For using function based index.
O7_DICTIONARY_ACCESSIBILITY=TRUE
# Let a user with select any table privilege to see V$ views
COMPATIBLE=10.2.0.2
open_cursors = 300
# To have enough cursors when deleting from GC3
-configure client to connect to otm database
set environment
ORACLE_HOME=/data/otmclient/oracle/product/10.2.0/client_1
PATH=$PATH:/data/otmclient/oracle/product/10.2.0/client_1/bin
export ORACLE_HOME
export PATH
configure Net service using netmgr in $client_home/bin
check for the connectivity to otm database.
--> database upgrade from 10.2.0.1 to 10.2.0.2
apply the companion CD
run installer from /companion folder
select 2nd option -installing oracle database 10g products
select the oracle_home for the database
