Membuat Database Oracle 11g secara Manual di Windows

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:appAdministratorproduct11.1.0db_sisindotek
C:>set PATH=%ORACLE_HOME%bin;%PATH%
C:>set ORACLE_SID=MYORA

Tahap 2 BUAT DIREKTORI YANG DIBUTUHKAN
C:>mkdir C:appAdministratordbmyoraadminadump
C:>mkdir C:appAdministratordbmyoraadmindpdump
C:>mkdir C:appAdministratordbmyoraadminpfile
C:>mkdir C:appAdministratordbmyoradiag
C:>mkdir C:appAdministratordbmyoraflash_recovery_area
C:appAdministratordbmyoraoradata

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:appAdministratordbmyoraflash_recovery_area'
audit_file_dest='C:appAdministratordbmyoraadminadump'
diagnostic_dest='C:appAdministratordbmyoradiag'
control_files = ('C:appAdministratordbmyoraoradatacontrol1.ctl', 'C:appAdministratordbmyora

oradatacontrol2.ctl', 'C:appAdministratordbmyoraoradatacontrol3.ct

Tahap 4 BUAT WINDOW SERVICE

C:>oradim -NEW -SID myora -STARTMODE manual
Instance created.
 
C:>sc query oracleservicemyora
 
SERVICE_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:>sqlplus
 
SQL*Plus: Release 11.1.0.1.0 Production on Wed May 23 07:39:54 2012
 
Copyright (c) 1982, 2010, Oracle.  All rights reserved.
 
Enter user-name: /as sysdba
Connected to an idle instance.
 
SQL> create spfile from pfile;
 
File created.


Tahap 6 – START INSTANCE DALAM MODE NOMOUNT

SQL> startup nomount
ORACLE instance started.
 
Total System Global Area  523108352 bytes
Fixed Size                  1375704 bytes
Variable Size             314573352 bytes
Database Buffers          201326592 bytes
Redo 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 500
LOGFILE
GROUP 1 (
    'C:appAdministratordbmyoraoradataredo01a.rdo',
    'C:appAdministratordbmyoraoradataredo01b.rdo'
    ) SIZE 50M,
GROUP 2 (
    'C:appAdministratordbmyoraoradataredo02a.rdo',
    'C:appAdministratordbmyoraoradataredo02b.rdo'
    ) SIZE 50M,
GROUP 3 (
    'C:appAdministratordbmyoraoradataredo03a.rdo',
    'C:appAdministratordbmyoraoradataredo03b.rdo'
    ) SIZE 50M
DATAFILE 'C:appAdministratordbmyoraoradatasystem01.dbf' SIZE 100M AUTOEXTEND ON
NEXT 50K
MAXSIZE 100M
EXTENT MANAGEMENT LOCAL
SYSAUX DATAFILE 'C:appAdministratordbmyoraoradatasysaux01.dbf' SIZE 200M
UNDO TABLESPACE UNDOTBS1 DATAFILE 'C:appAdministratordbmyoraoradataundotbs01.dbf' SIZE 300M AUTOEXTEND OFF
DEFAULT TEMPORARY TABLESPACE TEMP TEMPFILE 'C:appAdministratordbmyoraoradatatemp01.dbf' SIZE 200M REUSE AUTOEXTEND OFF
CHARACTER SET WE8ISO8859P1
NATIONAL 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%rdbmsadmincatalog.sql
SQL> @%ORACLE_HOME%rdbmsadmincatproc.sql
SQL> connect system/system
SQL> @%ORACLE_HOME%sqlplusadminpupbld.sql
Tahap 10 enabled archive

SQL> connect /as sysdba
SQL> shut immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount
ORACLE instance started.
 
Total System Global Area  523108352 bytes
Fixed Size                  1375704 bytes
Variable Size             314573352 bytes
Database Buffers          201326592 bytes
Redo Buffers                5832704 bytes
Database mounted.
SQL> alter database archivelog;
 
Database altered.
 
SQL> alter database open;
 
Database altered.
 
SQL> archive log list
Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence     12
Next log sequence to archive   13
Current log sequence           13

Oleh :

Hery Purnama

Freelance IT Trainer

http://freelance-it-trainer.blogspot.com

http://www.inhousetrainer.net

Call/SMS/WA : 081223344506

PinBB : 7DC633AA

email : inhousetrainer@yahoo.com

Hery Purnama – 081.223344.506 – inhousetrainer@yahoo.com.
Freelance IT Trainer, Trainer Excel VBA Macro, Trainer Sencha ExtJS, Trainer Google Map API, Trainer SPSS, Trainer MS Project, Trainer Primavera, Trainer Google Sktechup 3D, Trainer Android Phonegap, Trainer Oracle, Trainer SQL Server, Trainer MySQL, Trainer PHP Jquery Mobile , Trainer Java, Trainer HTML5 Javascript, Trainer SEO Internet Marketing, Trainer Project Management, Trainer SMS Gateway, Trainer CMS WordPress, ITIL, COBIT

Trainer freelance Prince, ITIL, COBIT, TOGAF, PMBOK, PMO, ITPM , jakarta bandung

Freelance trainer for soft skill FRAMEWORK topics : PRINCE, ITIL, COBIT, TOGAF, PMBOK, PMP, ITPM, PMO, SQA 
JAKARTA, BANDUNG, MAKASAR, BALI, MEDAN, INDONESIA, MALAYSIA, SINGAPORE
for inquiry please contact :

Hery Purnama
MCDBA, CPMP, ITILF
Tel/WA : 081.223344.506
pinBB : 7DC633AA

www.inhousetrainer.net
inhousetrainer@yahoo.com

Hometown : Bandung

Hery Purnama – 081.223344.506 – inhousetrainer@yahoo.com.
Freelance IT Trainer, Trainer Excel VBA Macro, Trainer Sencha ExtJS, Trainer Google Map API, Trainer SPSS, Trainer MS Project, Trainer Primavera, Trainer Google Sktechup 3D, Trainer Android Phonegap, Trainer Oracle, Trainer SQL Server, Trainer MySQL, Trainer PHP Jquery Mobile , Trainer Java, Trainer HTML5 Javascript, Trainer SEO Internet Marketing, Trainer Project Management, Trainer SMS Gateway, Trainer CMS WordPress, ITIL, COBIT

Trainer MS. Access di jakarta, bandung, bekasi, bali, medan, indonesia

Hery Purnama, 081223344506, freelance trainer MS.Access Database Fundamental or Programming MS.Access VBA Macro, Bandung – Jawa Barat

Details : www.inhousetrainer.net
   

Hery Purnama – 081.223344.506 – inhousetrainer@yahoo.com.
Freelance IT Trainer, Trainer Excel VBA Macro, Trainer Sencha ExtJS, Trainer Google Map API, Trainer SPSS, Trainer MS Project, Trainer Primavera, Trainer Google Sktechup 3D, Trainer Android Phonegap, Trainer Oracle, Trainer SQL Server, Trainer MySQL, Trainer PHP Jquery Mobile , Trainer Java, Trainer HTML5 Javascript, Trainer SEO Internet Marketing, Trainer Project Management, Trainer SMS Gateway, Trainer CMS WordPress, ITIL, COBIT

Trainer Oracle DBA workshop 1

Hery Purnama 081223344506 , freelance trainer for  Oracle DBA topics , fundamental PL/SQL, workshop I, workshop II ,  Performance tuning.

other details please access http://inhousetrainer.net
   

Hery Purnama – 081.223344.506 – inhousetrainer@yahoo.com.
Freelance IT Trainer, Trainer Excel VBA Macro, Trainer Sencha ExtJS, Trainer Google Map API, Trainer SPSS, Trainer MS Project, Trainer Primavera, Trainer Google Sktechup 3D, Trainer Android Phonegap, Trainer Oracle, Trainer SQL Server, Trainer MySQL, Trainer PHP Jquery Mobile , Trainer Java, Trainer HTML5 Javascript, Trainer SEO Internet Marketing, Trainer Project Management, Trainer SMS Gateway, Trainer CMS WordPress, ITIL, COBIT

Trainer Web Java ajax with xml and json

Hery Purnama , 081.223344.505 , freelance Trainer for training web java , ajax, xml or json

Inhouse trainer for location Jakarta, bandung, surabaya, balikpapan, makasar, menado and other city in Indonesia, singapore, malaysia

For inquiry please contact
+62.81223344506
PinBB 7dc633aa

inhousetrainer@yahoo.com
inhousetrainer.net

Hery Purnama – 081.223344.506 – inhousetrainer@yahoo.com.
Freelance IT Trainer, Trainer Excel VBA Macro, Trainer Sencha ExtJS, Trainer Google Map API, Trainer SPSS, Trainer MS Project, Trainer Primavera, Trainer Google Sktechup 3D, Trainer Android Phonegap, Trainer Oracle, Trainer SQL Server, Trainer MySQL, Trainer PHP Jquery Mobile , Trainer Java, Trainer HTML5 Javascript, Trainer SEO Internet Marketing, Trainer Project Management, Trainer SMS Gateway, Trainer CMS WordPress, ITIL, COBIT

Cari trainer ITIL, COBIT , PMBOK, PMO, ITPM, TOGAF , CPMP

Hery Purnama, 081.223344.506 , freelance certified trainer for PMBOK, ITIL V.3/2011, ITPM, TOGAF, CPMP, PMP

Location Jakarta , Bandung, Medan, Semarang, Makasar, Surabaya, Ambon, Indonesia

for inqury please contact
HERY PURNAMA

Freelance IT Trainer
Call/WA : 081.223344.506
pinBB : 7DC633AA

inhousetrainer@yahoo.com
www.inhousetrainer.net
http://freelance-it-trainer.blogspot.com

"..Dedicated to share…"

Hery Purnama – 081.223344.506 – inhousetrainer@yahoo.com.
Freelance IT Trainer, Trainer Excel VBA Macro, Trainer Sencha ExtJS, Trainer Google Map API, Trainer SPSS, Trainer MS Project, Trainer Primavera, Trainer Google Sktechup 3D, Trainer Android Phonegap, Trainer Oracle, Trainer SQL Server, Trainer MySQL, Trainer PHP Jquery Mobile , Trainer Java, Trainer HTML5 Javascript, Trainer SEO Internet Marketing, Trainer Project Management, Trainer SMS Gateway, Trainer CMS WordPress, ITIL, COBIT

Inhouse training CATIA 3D V5 di ESDM jakarta

Terima kasih kepada staff dan manajemen LITBANG ESDM jakarta dan Sciencom training center Jakarta atas undangan mengajar CATIA 3D V5 yang berlangsung selama 4 hari

Semoga bermanfaat

Hery Purnama, MCDBA, CPMP, ITILF
CATIA Freelance Trainer
081.223344.506
http://inhousetrainer.net

Hometown : Bandung – Jawa Barat
   

Hery Purnama – 081.223344.506 – inhousetrainer@yahoo.com.
Freelance IT Trainer, Trainer Excel VBA Macro, Trainer Sencha ExtJS, Trainer Google Map API, Trainer SPSS, Trainer MS Project, Trainer Primavera, Trainer Google Sktechup 3D, Trainer Android Phonegap, Trainer Oracle, Trainer SQL Server, Trainer MySQL, Trainer PHP Jquery Mobile , Trainer Java, Trainer HTML5 Javascript, Trainer SEO Internet Marketing, Trainer Project Management, Trainer SMS Gateway, Trainer CMS WordPress, ITIL, COBIT

catia v5 trainer freelance

Hery Purnama , 081223344506, catia 3d trainer, mechanical design, drafting, modelling, structure analysis
freelance trainer for catia v5

Regards,

Hery Purnama
MCDBA, CPMP, ITILF
Tel/WA : 081.223344.506
pinBB : 7DC633AA

www.inhousetrainer.net
inhousetrainer@yahoo.com

Hometown : Bandung

Hery Purnama – 081.223344.506 – inhousetrainer@yahoo.com.
Freelance IT Trainer, Trainer Excel VBA Macro, Trainer Sencha ExtJS, Trainer Google Map API, Trainer SPSS, Trainer MS Project, Trainer Primavera, Trainer Google Sktechup 3D, Trainer Android Phonegap, Trainer Oracle, Trainer SQL Server, Trainer MySQL, Trainer PHP Jquery Mobile , Trainer Java, Trainer HTML5 Javascript, Trainer SEO Internet Marketing, Trainer Project Management, Trainer SMS Gateway, Trainer CMS WordPress, ITIL, COBIT

PMBOK Freelance Trainer Jakarta, Bandung

Project Management Body of Knowledge , PMBOK trainer, for inquiry please contact HERY PURNAMA 081.223344.506 , Other topics are PMO , ITPM, ITIL, COBIT, TOGAF, PRINCE

Regards,

Hery Purnama
MCDBA, CPMP, ITILF
Tel/WA : 081.223344.506
pinBB : 7DC633AA

www.inhousetrainer.net
inhousetrainer@yahoo.com

Hometown : Bandung

Hery Purnama – 081.223344.506 – inhousetrainer@yahoo.com.
Freelance IT Trainer, Trainer Excel VBA Macro, Trainer Sencha ExtJS, Trainer Google Map API, Trainer SPSS, Trainer MS Project, Trainer Primavera, Trainer Google Sktechup 3D, Trainer Android Phonegap, Trainer Oracle, Trainer SQL Server, Trainer MySQL, Trainer PHP Jquery Mobile , Trainer Java, Trainer HTML5 Javascript, Trainer SEO Internet Marketing, Trainer Project Management, Trainer SMS Gateway, Trainer CMS WordPress, ITIL, COBIT

Google play excel vba macro

zu y aaTutorial excel vba maco is available in google play. download at https://play.google.com/store/apps/details?id=net.inhousetrainer.excelmacro

Regards,

Hery Purnama
MCDBA, CPMP, ITILF
Tel/WA : 081.223344.506
pinBB : 7DC633AA

www.inhousetrainer.net
inhousetrainer@yahoo.com

Hometown : Bandung

Hery Purnama – 081.223344.506 – inhousetrainer@yahoo.com.
Freelance IT Trainer, Trainer Excel VBA Macro, Trainer Sencha ExtJS, Trainer Google Map API, Trainer SPSS, Trainer MS Project, Trainer Primavera, Trainer Google Sktechup 3D, Trainer Android Phonegap, Trainer Oracle, Trainer SQL Server, Trainer MySQL, Trainer PHP Jquery Mobile , Trainer Java, Trainer HTML5 Javascript, Trainer SEO Internet Marketing, Trainer Project Management, Trainer SMS Gateway, Trainer CMS WordPress, ITIL, COBIT