You are here

Post Installation Steps

Edit the /etc/oratab file and set restart flag to 'Y.
Change:
omr:/u01/app/oracle/product/12.1.0/dbhome_1:N
To:
omr:/u01/app/oracle/product/12.1.0/dbhome_1:Y
 
Next, create a directory for Oracle Database redo logs:
$ mkdir /u01/app/oracle/product/redo_logs/
 
Next, access the database as sysdba and create a pfile from the spfile pfile.
$ sqlplus / AS SYSDBA
SQL*Plus: Release 12.1.0.1.0 Production on Mon Jun 23 14:31:06 2014
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL> create pfile from spfile;
File created.
SQL> quit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
$
 

Next, access the Database as sysdba and make either the Eval, Small, Medium, or Large Site initialization parameters, then restart the database.

The following tables show the minimum Oracle Management Repository Database settings for an Eval, Small, Medium and Large Site. 

Table 10: Eval Configuration Minimum Database Settings
Parameter Minimum Value
Processes 300
memory_target 700 MB
redo log file size 50 MB
shared_pool_size 450 MB
session_cached_cursors remove
 
Table 11: Small Site Minimum Database Settings
Parameter Minimum Value
*memory_target of 3 GB can be used in place of sga_target and pga_aggregate_target
processes 300
pga_aggregate_target* 1024 MB
sga_target* 2 GB
redo log file size 300 MB
shared_pool_size 600 MB
db_securefile PERMITTED
 
Table 12: Medium Site Minimum Database Settings
Parameter Minimum Value
*memory_target of 5.25 GB can be used in place of sga_target and pga_aggregate_target
processes 600
pga_aggregate_target* 1280 MB
sga_target* 4 GB
redo log file size 600 MB
shared_pool_size 600 MB
db_securefile PERMITTED
 
Table 13: Large Site Minimum Database Settings
Parameter Minimum Value
*memory_target of 7.5 GB can be used in place of sga_target and pga_aggregate_target
processes 1000
pga_aggregate_target* 1536 MB
sga_target* 6 GB
redo log file size 1000 MB
shared_pool_size 600 MB
db_securefile PERMITTED
 
The next example shows applying the Small Site Oracle Management Repository Database initialization parameters, including force logging, and adding the redo log files.
 
Note: Please consult with your DBA to confirm your redo log file settings. The below ALTER DATABASE ADD LOGFILE GROUP commands are only an example that will create the necessary redo log file for the Oracle Enterprise Manager installer.  
 
The SQL commands to be entered are listed below in BOLD ITALIC.
 
sqlplus / AS SYSDBA
SQL> ALTER SYSTEM SET processes=300 SCOPE=SPFILE;
System altered.
SQL> ALTER SYSTEM SET session_cached_cursors=200 SCOPE=SPFILE;
System altered.
SQL> ALTER SYSTEM SET pga_aggregate_target=1024M SCOPE=SPFILE;
System altered.
SQL> ALTER SYSTEM SET sga_target=2G SCOPE=SPFILE;
System altered.
SQL> ALTER SYSTEM SET shared_pool_size=600M SCOPE=SPFILE;
System altered.
SQL> ALTER SYSTEM SET db_securefile=PERMITTED SCOPE=BOTH;
System altered.
SQL> ALTER DATABASE ADD LOGFILE GROUP 4 ('/u01/app/oracle/product/redo_logs/log1a.rdo') SIZE 300M REUSE;
Database altered.
SQL> ALTER DATABASE ADD LOGFILE GROUP 5 ('/u01/app/oracle/product/redo_logs/log2a.rdo') SIZE 300M REUSE;
Database altered.
SQL> ALTER DATABASE ADD LOGFILE GROUP 6 ('/u01/app/oracle/product/redo_logs/log3a.rdo') SIZE 300M REUSE;
Database altered.
SQL> SHUTDOWN IMMEDIATE;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup;
ORACLE instance started.
Total System Global Area 3791417344 bytes
Fixed Size         2295176 bytes
Variable Size         855640696 bytes
Database Buffers     2919235584 bytes
Redo Buffers         14245888 bytes
Database mounted.
Database opened.
SQL> quit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
$
 
Next validate that the httpsport is 5500.
$ sqlplus / AS SYSDBA
SQL*Plus: Release 12.1.0.1.0 Production on Mon Jun 23 15:08:01 2014
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL> SELECT dbms_xdb_config.gethttpsport FROM dual;
GETHTTPSPORT
------------
    5500
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
 
Next, as root, create a database startup and shutdown script named dbora /etc/init.d. The dboar script calls the dbstart and dbshut routines.
 
The next example show the dbora script.
 
# cat /etc/init.d/dbora
#!/bin/sh
# chkconfig: 345 99 10
# description: Oracle auto start-stop script.
#
# Set ORA_HOME to be equivalent to the $ORACLE_HOME
# from which you wish to execute dbstart and dbshut;
#
# Set ORA_OWNER to the user id of the owner of the
# Oracle database in ORA_HOME.
ORA_HOME=/u01/app/oracle/product/12.1.0/db_1
ORA_OWNER=oracle
if [ ! -f $ORA_HOME/bin/dbstart ]
then
echo "Oracle startup: cannot start"
exit
fi
case "$1" in
'start')
# Start the Oracle databases:
# The following command assumes that the oracle login
# will not prompt the user for any values
su - $ORA_OWNER -c "$ORA_HOME/bin/dbstart $ORA_HOME"
touch /var/lock/subsys/dbora
;;
'stop')
# Stop the Oracle databases:
# The following command assumes that the oracle login
# will not prompt the user for any values
su - $ORA_OWNER -c "$ORA_HOME/bin/dbshut $ORA_HOME"
rm -f /var/lock/subsys/dbora
;;
esac
 
After the script is created, set the privileges for dbora to 750, by typing:
# chmod 750 /etc/init.d/dbora
The dbora script can now be configured as a Linux service.
 
Next, set the runlevels for the dbora service to 3, 4 and 5 by typing:
# chkconfig dbora on
Typing “chkconfig --list|grep dbora” will validate the dbora script is on at runlevels 3, 4 and 5, as shown in the next example.
# chkconfig --list|grep dbora
dbora 0:off 1:off 2:on 3:on 4:on 5:on 6:off
 
The last step is to create soft links for init.d to automate the database startup and shutdown process with Oracle Linux boot process.  As root, type the following commands to create the init.d soft links.
# ln -s /etc/init.d/dbora /etc/rc.d/rc0.d/K01dbora
# ln -s /etc/init.d/dbora /etc/rc.d/rc3.d/S96dbora
# ln -s /etc/init.d/dbora /etc/rc.d/rc5.d/S96dbora
 
You should test the script by rebooting the machine and validating that the database starts on reboot.

Download PDF Now!