Installation Fusion Application part 2

 

[fusionmgr@fusionsvr02 ~]$ more db.env

ORACLE_BASE=/u03/fusion/database; export ORACLE_BASE

ORACLE_HOME=/u03/fusion/database/product/11.2.0/dbhome_1; export ORACLE_HOME

ORACLE_SID=FUSION; export ORACLE_SID

PATH=/usr/sbin:$PATH; export PATH

PATH=/u03/fusion/database/product/11.2.0/dbhome_1/bin:$PATH; export PATH

[fusionmgr@fusionsvr02 ~]$ . ./db.env

[fusionmgr@fusionsvr02 ~]$ sqlplus '/as sysdba'

 

SQL*Plus: Release 11.2.0.3.0 Production on Tue Oct 23 11:19:51 2012

 

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

 

 

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

With the Partitioning, Oracle Label Security, Data Mining and Real Application Testing options

 

SQL> show parameter sga;

 

NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------

lock_sga                             boolean     FALSE

pre_page_sga                         boolean     FALSE

sga_max_size                         big integer 9G

sga_target                           big integer 9G

SQL> show parameter pga

 

NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------

pga_aggregate_target                 big integer 4G

SQL> alter system set sga_max_size=4G scope=spfile;

 

System altered.

 

SQL> alter system set sga_target=4G scope=spfile;

 

System altered.

 

SQL> shutdown immediate

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> startup

ORACLE instance started.

 

Total System Global Area 4275781632 bytes

Fixed Size                  2235208 bytes

Variable Size             855639224 bytes

Database Buffers         3405774848 bytes

Redo Buffers               12132352 bytes

Database mounted.

Database opened.

SQL> show parameter sga;

 

NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------

lock_sga                             boolean     FALSE

pre_page_sga                         boolean     FALSE

sga_max_size                         big integer 4G

sga_target                           big integer 4G