7.0

Application Discovery Manager Administration Guide
22 VMware, Inc.
5ItisrecommendedthatyoucreateadatabaseinstanceontheOracleserver.EnsurethattheOracleserver
isupbyrunningthefollowingcommandsontheOracleserverasanoracleuser:
$sqlplus '/as sysdba'
SQL> select name from v$database;
6 Createrequiredgroupsandusers.
aLogintotheserverasroot.
bAddanewgroup,nlayers,byrunningthefollowingcommand.
# groupadd nlayers
cAddanewuser,nlayers,byrunningthefollowingcommand.
#useradd -m -g oinstall -g nlayers -G dba nlayers
dSwitchtonlayersuserandnavigateto /home/nlayers/
eEditthe.bashrcfilebyaddingthefollowinglines:
export SENECA_HOME=/home/nlayers/Seneca
export TMOUT=1800
fEditthe.bash_profile filebyaddingthefollowinglinesafterthe#userspecificaliasesand
functionsrow:
export ORACLE_BASE=/opt/oracle/app/oracle
export ORACLE_HOME=/opt/oracle/app/oracle/product/11.2.0/db_1
export ORACLE_SID=nlayers
export TWO_TASK=nlayers
export LD_LIBRARY_PATH=${ORACLE_BASE}/product/11.2.0/db_1/lib
umask 022
PATH=${ORACLE_HOME}/bin:$PATH
export PATH
unset USERNAME
gLogintotheOracleserverasoracleandrunthefollowingcommands.
$ mkdir -p /opt/oracle/app/oracle/admin/nlayers/backup
$ mkdir -p /opt/oracle/app/oracle/admin/nlayers/archive
$ mkdir -p /opt/oracle/app/oracle/admin/nlayers/adump
$ mkdir -p /opt/oracle/app/oracle/admin/nlayers/bdump
$ mkdir -p /opt/oracle/app/oracle/admin/nlayers/cdump
$ mkdir -p /opt/oracle/app/oracle/admin/nlayers/udump
$ mkdir -p /opt/oracle/app/oracle/oradata/nlayers
hLogintotheOracleserverasrootandrunthefollowingcommands.
$ mkdir -p /var/log/nlayers/db
$ chmod -R 775 /var/log/nlayers/db
$ chown nlayers:nlayers /var/log/nlayers
To Create an ADM Instance on Oracle
1LogintotheOracleserverasoracleandnavigateto
/opt/oracle/app/oracle/product/11.2.0/db_1/bin
2 Createafile,create_nlayers_db.sql,withthefollowingcontent:
CREATE DATABASE "NLAYERS"
USER SYS IDENTIFIED BY nlayers
USER SYSTEM IDENTIFIED BY nlayers
MAXLOGFILES 5
MAXLOGMEMBERS 5
MAXDATAFILES 100
MAXINSTANCES 1
MAXLOGHISTORY 292
LOGFILE
GROUP 1 '/opt/oracle/app/oracle/oradata/nlayers/redo1.log' SIZE 10M,
GROUP 2 '/opt/oracle/app/oracle/oradata/nlayers/redo2.log' SIZE 10M,