Share the content if you found it is useful (You can share using 300 community websites) click "share" at the end of the post.

You are encouraged to leave a comment.








Saturday, March 17, 2012

OBIEE 11g - Installation - Database Install Part2

Previous post links here..

Select Global Database name and SID



Select the Data File locations:

System will be checking for the prerequisites available for the installation: If any thing failed.. please revisit and then give retry.

Once the system Check is completed, it will post the summary.

Typical Install will start after the summary.


Once completed, you need to run ./root.sh from the oracle Home:

Once it is completed, it will create the database with options that you provide like characterset, SGA size and other parameters like listener details.

Once the database is installed and your oracle Net is configured you need to create a profile for the database access.

Your typical Profile will be:

export ORACLE_HOME=/oracle/OBIDB/tech_st/11.2.0

export ORACLE_BASE=/oracle/OBIDB

export ORACLE_SID=obieedb

export PATH=$PATH:$ORACLE_HOME/bin

export TNS_ADMIN=$ORACLE_HOME/network/admin

export ORACLE_TERM=xterm

export ORACLE_OWNER=oracle

export TNS_ADMIN=$ORACLE_HOME/network/admin

export CLASSPATH=$ORACLE_HOME/jdbc/lib/classes12.zip

export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$ORACLE_HOME/lib32

export LDPATH=$ORACLE_HOME/lib:$ORACLE_HOME/lib32

Once your profile is set and correct you can see the sqlplus and listener status.