IBM Information server installation on Oracle as metadata
Installation
of IA server In linux
Minimum
Linux kernel parameters (engine and services tiers)
The
following table contains the minimum kernel parameters and user
limits for
the
installation:
Parameter
Engine and services tiers
MSGMAX
8192
MSGMNB
16384
MSGMNI
No
requirement
SEMMNI
1024
SEMMNS
128000
SEMMSL
250
SEMOPM
32
SHMALL
2511724800
SHMMAX
307200000
SHMMNI
2000
SHMSEG
200
nproc
1000
or unlimited
nofile
10240
Create
Following User
/usr/sbin/groupadd
dstage
/usr/sbin/useradd
-g dstage -d /home/dsadm dsadm
Run
the passwd command to set the password for each account.
Create
xmeta and iadb in Oracle
#cd
u01/app/oracle/product/11.2.0/db_1/bin/
#./dbca
Change
Unicode based on requirement
To
start Multiple Database
XMETA
Login
to oracle user and set SID
#ORACLE_SID=xmeta
Check
for SID is set
#set
You
will find ORACLE_SID=xmeta
#sqlplus
/nolog
#conn
/as sysdba
#startup
Database
will mount and open state
IADB
Login
to oracle user and set SID
#ORACLE_SID=iadb
Check
for SID is set
#set
You
will find ORACLE_SID= iadb
#sqlplus
/nolog
#conn
/as sysdba
#startup
Database
will mount and open state
Connect
to Database using SQl Developer
u01/app/oracle/product/11.2.0/db_1/sqlDeveloper
#./sqldeveloper
connect
to xmeta and iadb
IADB
Run
the following scripts located in setup director (is-suite)
\is-suite\DatabaseSupport\UNIX_Linux\InformationAnalyzer\Oracle11g
- create_ia_db_tablespace.sql
- create_ia_db_user.sql
XMETA
Run
the following scripts located in setup director (is-suite)
\is-suite\DatabaseSupport\UNIX_Linux\MetadataRepository\Oracle11g
- create_xmeta_db_tablespace.sql
- create_xmeta_db_user.sql
- configure_xmeta_db.sql
Open
terminal and Point to IA-suite Directory and Give execution
permission to setup.sh.
#./setup.sh