|
|
<![CDATA[
Assumes SID of X136
1. Login to the server
2. vi ~/.profile
change ORACLE_SID as
ORACLE_SID X136
3. create initX136.ora in $HOME/LABS/
# vi $HOME/LABS/initX136.ora
-------------------------------------------------------------
# $Header: init.ora
# Sample parameter file for
# Oracle8i: database Administration Class Edition 1.0
compatible = 8.1.5
db_block_buffers = 100
db_file_multiblock_read_count = 8
db_files = 30
distributed_transactions = 10
dml_locks = 200
job_queue_interval = 10
job_queue_processes = 2
log_checkpoint_interval = 10000
log_checkpoint_timeout = 1800
max_dump_file_size = 10240 # limit trace file size to 5M each
parallel_max_servers = 5
processes = 60
processes = 60
#service_names = db01
sort_area_size = 64000
db_file_multiblock_read_count = 8
shared_pool_size = 3500000
#remote_login_passwordfile=exclusive
#timed_statistics = true
parallel_max_servers = 12 # SMALL
global_names = TRUE
db_domain = world
#rollback_segments = (sysrol)
# Parameters to be edited
db_name = X136
db_block_size = 8192
control_files = ($HOME/DATA/DISK5/control01.con)
background_dump_dest = ($HOME/BDUMP)
user_dump_dest = ($HOME/UDUMP)
core_dump_dest = ($HOME/CDUMP)
java_pool_size = 1000000
-------------------------------------------------------------
4. create a password file for INTERNAL
$ vi $ORACLE_HOME/dbs/orapwX136
$ rm $ORACLE_HOME/dbs/orapwX136
$ orapwd file=$ORACLE_HOME/dbs/orapwX136 entries=5 password=admin
$ chmod 777 $ORACLE_HOME/dbs/orapwX136
5. create an sql script to perform the create database
$ vi $HOME/LABS/creX136.sql
-------------------------------------------------------------
spool $HOME/LABS/creX136.log
set echo on
connect INTERNAL/admin as sysdba
startup nomount pfile=$HOME/LABS/initX136.ora
CREATE DATABASE "X136"
MAXLOGFILES 10
MAXLOGMEMBERS 2
MAXDATAFILES 30
MAXLOGHISTORY 100
LOGFILE
GROUP 1 ('$HOME/DATA/DISK6/redo0101.log') size 150K,
GROUP 2 ('$HOME/DATA/DISK6/redo0201.log') size 150K
DATAFILE '$HOME/DATA/DISK4/system01.dbf' SIZE 20M REUSE AUTOEXTEND ON
MAXINSTANCES 1
CHARACTER SET WE8ISO8859P1
NATIONAL CHARACTER SET WE8ISO8859P1;
spool off
-------------------------------------------------------------
6. Ensure current $ORACLE_SID is pointing to X136
$ export ORACLE_SID=X136
$ echo $ORACLE_HOME
7. Run the script from SVRMGRL
$ svrmgrl
SVRMGRL> connect internal/admin as sysdba
SVRMGRL> @$HOME/LABS/creX136.sql
8. If successful, confirm database exist by
$ SVRMGRL
SVRMGRL> connect internal/admin as sysdba
SVRMGRL> SELECT name,created,log_mode FROM v$database;
SVRMGRL> SELECT status, instance FROM v$thread;
SVRMGRL> SELECT name from v$datafile;
SVRMGRL> SELECT member FROM v$logfile;
SVRMGRL> SELECT name FROM v$controlfile;
SVRMGRL> show SGA
9. Create the data dictionaries by running @$ORACLE_HOME/rdbms/admin/catalog.sql
Create the packages by running @$ORACLE_HOME/rdbms/admin/catproc.sql
$ SVRMGRL
SVRMGRL> connect internal/admin as sysdba
SVRMGRL> @$ORACLE_HOME/rdbms/admin/catalog.sql
SVRMGRL> @$ORACLE_HOME/rdbms/admin/catproc.sql
]]>
<![CDATA[
]]>
|
|