Berikut cara membuat database baru di Oracle 11g R2 secara manual tanpa DBCA, ikuti tahapannya :
Tahap 1 SIAPKAN ENVIRONMENT VARIABLE
C:\>set ORACLE_HOME=C:\app\Administrator\product\11.1.0\db_sisindotekC:\>set PATH=%ORACLE_HOME%\bin;%PATH%C:\>set ORACLE_SID=MYORA
Tahap 2 BUAT DIREKTORI YANG DIBUTUHKAN
C:\>mkdir C:\app\Administrator\db\myora\admin\adump C:\>mkdir C:\app\Administrator\db\myora\C:\>mkdir C:\app\Administrator\db\myora\C:\>mkdir C:\app\Administrator\db\myora\C:\>mkdir C:\app\Administrator\db\myora\C:\app\Administrator\db\myora\
Tahap 3 BUAT PARAMETER FILE
berikan nama initmyora.ora dan simpan di folder {ORACLE_HOME}\database\
db_name='MYORA'
db_block_size=8192
memory_target=500m
processes=100
open_cursors=300
remote_login_passwordfile='EXCLUSIVE'
undo_tablespace='UNDOTBS1'
compatible ='11.1.0'
audit_trail ='db'
db_recovery_file_dest_size=5g
db_recovery_file_dest='C:\app\Administrator\db\myora\flash_recovery_area'
audit_file_dest='C:\app\Administrator\db\myora\admin\adump'
diagnostic_dest='C:\app\Administrator\db\myora\diag'
control_files = ('C:\app\Administrator\db\myora\oradata\control1.ctl', 'C:\app\Administrator\db\myora
\oradata\control2.ctl', 'C:\app\Administrator\db\myora\oradata\control3.ct
Tahap 4 BUAT WINDOW SERVICE
C:\>oradim -NEW -SID myora -STARTMODE manualInstance created.C:\>sc query oracleservicemyoraSERVICE_NAME: oracleservicemyora TYPE : 10 WIN32_OWN_PROCESS STATE : 4 RUNNING (STOPPABLE,PAUSABLE,ACCEPTS_SHUTDOWN) WIN32_EXIT_CODE : 0 (0x0) SERVICE_EXIT_CODE : 0 (0x0) CHECKPOINT : 0x0 WAIT_HINT : 0x0
Tahap 5 Konek ke Instance dan buat spfile
C:\>sqlplusSQL*Plus: Release 11.1.0.1.0 Production on Wed May 23 07:39:54 2012Copyright (c) 1982, 2010, Oracle. All rights reserved.Enter user-name: /as sysdbaConnected to an idle instance.SQL> create spfile from pfile;File created.Tahap 6 - START INSTANCE DALAM MODE NOMOUNT
SQL> startup nomountORACLE instance started.Total System Global Area 523108352 bytesFixed Size 1375704 bytesVariable Size 314573352 bytesDatabase Buffers 201326592 bytesRedo Buffers 5832704 bytes
Tahap 7 - BUAT DATABASE
gunakan script berikut
CREATE DATABASE MYORA USER sys IDENTIFIED BY sys USER system IDENTIFIED BY system MAXLOGFILES 5 MAXLOGMEMBERS 3 MAXDATAFILES 200 MAXINSTANCES 1 MAXLOGHISTORY 500LOGFILEGROUP 1 ( 'C:\app\Administrator\db\myora\, 'C:\app\Administrator\db\myora\ ) SIZE 50M,GROUP 2 ( 'C:\app\Administrator\db\myora\, 'C:\app\Administrator\db\myora\ ) SIZE 50M,GROUP 3 ( 'C:\app\Administrator\db\myora\, 'C:\app\Administrator\db\myora\ ) SIZE 50MDATAFILE 'C:\app\Administrator\db\myora\ SIZE 100M AUTOEXTEND ON
NEXT 50K
MAXSIZE 100M
EXTENT MANAGEMENT LOCALSYSAUX DATAFILE 'C:\app\Administrator\db\myora\SIZE 200MUNDO TABLESPACE UNDOTBS1 DATAFILE 'C:\app\Administrator\db\myora\SIZE 300M AUTOEXTEND OFFDEFAULT TEMPORARY TABLESPACE TEMP TEMPFILE 'C:\app\Administrator\db\myora\SIZE 200M REUSE AUTOEXTEND OFFCHARACTER SET WE8ISO8859P1NATIONAL CHARACTER SET UTF8;
Tahap 8 Buat data dictionary object
Jasalankan catalog.sql dan catproc.sql yang ada di folder RDBMS oracle home andag
SQL> @%ORACLE_HOME%\rdbms\admin\catalog.sqlSQL> @%ORACLE_HOME%\rdbms\admin\catproc.sqlSQL> connect system/systemSQL> @%ORACLE_HOME%\sqlplus\admin\pupbld.sqlTahap 10 enabled archive
SQL> connect /as sysdbaSQL> shut immediateDatabase closed.Database dismounted.ORACLE instance shut down.SQL> startup mountORACLE instance started.Total System Global Area 523108352 bytesFixed Size 1375704 bytesVariable Size 314573352 bytesDatabase Buffers 201326592 bytesRedo Buffers 5832704 bytesDatabase mounted.SQL> alter database archivelog;Database altered.SQL> alter database open;Database altered.SQL> archive log listDatabase log mode Archive ModeAutomatic archival EnabledArchive destination USE_DB_RECOVERY_FILE_DESTOldest online log sequence 12Next log sequence to archive 13Current log sequence 13Oleh :
Hery Purnama
