Installation guide

13
MAXLOGMEMBERS 2
MAXDATAFILES 32
MAXINSTANCES 1
MAXLOGHISTORY 112
LOGFILE
GROUP 1 '/lnx_x86-64_path/oracle/dbs/t_log1.dbf' size 25M
GROUP 2 '/lnx_x86-64_path/oracle/dbs/t_log2.dbf' size 25M
DATAFILE
'/lnx_x86-64_path/oracle/dbs/t_db1.dbf'
CHARACTER SET WE8DEC
ALTER DATABASE OPEN
11. Shut down the database.
SQL> SHUTDOWN IMMEDIATE
12. Before changing the word size of your release, you must edit the
initialization parameter file (pfile) by adding the following line:
_system_trig_enabled=false
13. Use the following command to start the database:
SQL> STARTUP PFILE = '$ORACLE_HOME/dbs/init-10gdb1.ora'
14. Check the amount of free space in the SYSTEM tablespace. Ensure there is
enough room for SYSTEM tablespace to increase its size by 50%.
SQL> SELECT SUM (df.bytes) AS total,
SUM (fs.bytes) AS free,
(SUM (fs,bytes)/SUM(df.bytes) * 100) AS percent_free
FROM dba_data_files df,
DBA_FREE_SPACE fs
WHERE df.tablespace_name = 'SYSTEM'
AND
df.tablespace_name = fs.tablespace_name
GROUP BY df.tablespace_name
If you get a percent_free value less than 33%, then you must add a new
raw device data file to SYSTEM tablespace, for example:
SQL> ALTER TABLESPACE SYSTEM ADD DATAFILE '/dev/raw/raw108' SIZE 200M;
15. Use the following commands to restart the database in upgrade mode:
SQL> SHUTDOWN IMMEDIATE;
SQL> STARTUP UPGRADE
16. To change the word size of your release, enter the following command:
SQL> @$ORACLE_HOME/rdbms/admin/utlirp.sql
17. Run the utlrp.sql script to recompile all PL/SQL packages now instead of
when the packages are accessed for the first time. This step is optional but
recommended.
SQL> @$ORACLE_HOME/rdbms/admin/utlrp.sql