Saturday, July 31, 2010

Oracle Database Installation On RHEL 5.0

Oracle Database Installation:
#xhost +
#su - oracle
$dbca
Create database – Next
General Purpose – Next
Global Database Name=prd
SID=prd
Uncheck configure Enterprise Manager – Next
Use same administrative password for all accouts
system – sys ---manager
select use database file from template – Next
check specify flash recovery area
check enable archive mode – Next
check sample schemas (optional)
and remaining be the default values – Next – Finish

$pwd
/u01
$vi login.sql
Set sqlp “_user’@’_connect_identifier>”
$sqlplus / as sysdba
If any occurs like error while loading shared libraries then enter the below line.
$chcon –t textrel_shlib_t ‘/u01/app/oracle/product/11.2.0/db_1/lib/liblntsh.so.11.1’
$sqlplus / as sysdba
ssy@prd>startup