Oracle AppsDBAs World: Installation of maintenance wizard

INSTALLING MAINTAINENCE WIZARD(Metalink Doc.id:329476.1)
=========================================

System Requirements
---------------------
Maintenance Wizard must be installed into an RDBMS 10g with a 10g iAS ORACLE_HOME on a UNIX or Linux machine. (Your e-Business Suite Applications may be on other operating systems, however).

create group
---------------
groupadd dba

create user
----------------
useradd -g dba oracle

MAINTENCE WIZARD
================

Prerequistite Instructions
--------------------------
Setting up OpenSSH
On the Maintenance Wizard Node:
Log in as the user who will own Maintenance Wizard.
Generate the ssh key by issuing the following command:
ssh-keygen -t rsa
Press the Enter key three times.
CD into the .ssh directory, which is located under the home directory. Note that a file called id_rsa.pub is created.
Use FTP to copy id_rsa.pub to the /tmp directory of the Remote Nodes.

On the Remote Node(s):
----------------------
Login as the user who owns the product being upgraded or maintained. For Applications tiers, use the applmgr account. For the database tiers, use the oracle account.
Remove specialized .login, .profile or similar files which cause extra verbiage to be displayed to the screen.
Create a directory called .ssh in the home directory.
If an authorized_keys file does not exist, create a new, empty one.
Copy the content of /tmp/id_rsa.pub (from the Maintenance Wizard Node) into a new file named authorized_keys. (If you already have a file called authorized_keys in this directory, open it in vi, go to the bottom of the file, add one blank line and then copy and paste the contents of the file /tmp/id_rsa.pub into the existing file and save it.)
Verify that the .ssh directory permission is set to 700.
Verify that the authorized_keys file permission is set to 600.
Verify that the $HOME directory does not have write permissions for group and others.
chmod go-w $HOME
Repeat the above steps for each Remote Node

Test the installation:
----------------------
Login to the Maintenance Wizard Node as Maintenance Wizard owner.
Execute the following command, replacing [user] with the username on the Remote Node, and [SERVER] with the host name of the Remote Node:
ssh -l [user] [SERVER]
When prompted to confirm the identity, respond "Yes".
Disconnect from the server.
Execute the following command:
ssh -l [user] [SERVER] echo 'foo'
Only the word foo should appear, followed by the prompt, and you should not be asked to enter and ID or password. If you are prompted for a password, verify the following:
The content of the authorized_keys file contains the content of id_rsa.pub of the client
The permissions of the authorized_keys file are set to 600.
The permissions of the .ssh directory are set to 700.
The permissions of the $HOME directory do not include execute for group and other.
If more than the word foo appears, then repeat the step above to remove all .login, .profile or similar files until ONLY the word foo appears.

INSTALL 10g RDBMS 10.2.0
========================
hosts file
----------
vi /etc/hosts
192.9.200.225 ias.oneapps.com ias

Set Kernel Parameters
---------------------
/etc/sysctl.conf
kernel.shmall = 2097152
kernel.shmmax = 2147483648
kernel.shmmni = 4096
# semaphores: semmsl, semmns, semopm, semmni
kernel.sem = 250 32000 100 128
fs.file-max = 65536
net.ipv4.ip_local_port_range = 1024 65000
net.core.rmem_default=262144
net.core.rmem_max=262144
net.core.wmem_default=262144
net.core.wmem_max=262144

/sbin/sysctl -p

/etc/security/limits.conf
soft nproc 2047
hard nproc 16384
soft nofile 2048
hard nofile 65536

set environment file in bash profile

run ./runinstaller

CREATE DATABASE USING: $ORACLE_HOME/bin run DBCA
-------------------------------------------------
Choose "Create a Database".
Choose "General Purpose".
Specify the Global Database Name.
Specify whether to configure to database with Enterprise Manager.
Set the default password for the SYS and SYSTEM accounts. (PLEASE, record these in a secure location!)
Choose your storage mechanism. We recommend that you choose "File System" and select a Common Location.
Specify any desired recovery options.
Specify NO sample schemas.
In the Character Sets tab, do NOT modify the Default Language (American) and Default Date Format (US).
Specify the desired values for parameters SGA, PGA and processes.
When the process has completed, exit the Database Creation Assistant.

INSTALL 10G ias 10.1.3
----------------------
rpms

glibc-2.3.4-2.9
glibc-common-2.3.4-2.9
binutils-2.15.92.0.2-13
compat-libstdc++-296-2.96-132.7.2
gcc-3.4.3-22.1
gcc-c++-3.4.3-22.1
libstdc++-3.4.3-22.1
libstdc++-devel-3.4.3-22.1
openmotif21-2.1.30-11.RHEL4.4
pdksh-5.2.14-30
setarch-1.6-1
make-3.80-5
gnome-libs-1.4.1.2.90-44.1
sysstat-5.0.5-1
compat-db-4.1.25-9
compat-libstdc++-devel-7.3-2.96.128
compat-glibc-7.x-2.2.4.32.6
compat-libstdc++-7.3-2.96.128
control-center-2.8.0-12
xscreensaver-4.18-5.rhel4.2

./runinstaller

To copy the file:
-----------------
cp /network/admin/tnsnames.ora /network/admin/

OR

create a symbolic link:

cd /network/admin
ln -s /network/admin/tnsnames.ora tnsnames.ora

Create the NEWEOF tablespace where the Maintenance Wizard schema objects will be stored
sqlplus
system user

create tablespace NEWEOF datafile '/u01/oracle/oradata/eof01.dbf' size 50M AUTOEXTEND ON NEXT 5M MAXSIZE 75M;

Verify that Zip and UnZip executables are installed and that ping is in the $PATH using the following commands:
which zip
which unzip
which ping

Installation Steps
==================
SU - ORACLE

SET BASH PROFILE RDBMS 10g

ORACLE_HOME=; export ORACLE_HOME
PATH=$ORACLE_HOME/bin:$PATH; export PATH
TWO_TASK=;export TWO_TASK
TNS_ADMIN=$ORACLE_HOME/network/admin; export TNS_ADMIN

create the Maintenance Wizard directory in the RDBMS $ORACLE_HOME directory

cd $ORACLE_HOME
mkdir eof
EOF_HOME=$ORACLE_HOME/eof; export EOF_HOME

DOWN LOAD THE Maintenance Wizard PATCH =6972475

unzip it into $EOF_HOME

cd ${EOF_HOME}/config

Run the installation script
./setup.sh

Stop and restart iAS.
opmnctl stopall
opmnctl startall

Post Install Steps
==================

Secure the $EOF_HOME/EOF.env file.
chmod 700 $EOF_HOME/EOF.env

URL http://.:/EOF/

SYSADMIN/YOURPASS:

posted by Senthil Kumaran @ 4:51 AM

0 Comments: