1. buat database menggunakan database configuration assistant. ini berupa aplikasi yg jalan di GUI. 2. waktu install, bisa langsung buat databasenya atau tidak buat dulu (di buat setelah install, dengan membuat script di sqlplus atau menggunakan dbca). 3. connect user = sys , password = syspasswd(tergantung waktu install oracle, passwordnya di ganti atau tidak).
Frans Winowatan <[EMAIL PROTECTED]> wrote: Terima kasih buat pak febian atas pencerahaannya. tapi ada beberapa yang belum saya pahami 1. apa yang dimaksud dengan 'pake dbca' ??? 2. Pada saat installnya kita akan buat databasenya ngak ??? 3. connectnya pake user& password apa ??? mohon pencerahannya Frans Winowatan ----- Original Message ----- From: Ryant Febrian To: [email protected] Sent: Monday, September 18, 2006 9:08 AM Subject: Re: [indo-oracle] tanya : install oracle 9i ini sedikit script bila ingin membuat database secara manual. atau bisa jg pake dbca CREATE DATABASE "coba" MAXINSTANCES 8 MAXLOGHISTORY 1 MAXLOGFILES 16 MAXLOGMEMBERS 3 MAXDATAFILES 100 DATAFILE 'C:\oracle\oradata\coba\system01.dbf' SIZE 300M REUSE AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SYSAUX DATAFILE 'C:\oracle\oradata\coba\sysaux01.dbf' SIZE 120M REUSE AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED DEFAULT TEMPORARY TABLESPACE TEMP TEMPFILE 'C:\oracle\oradata\coba\temp01.dbf' SIZE 20M REUSE AUTOEXTEND ON NEXT 640K MAXSIZE UNLIMITED UNDO TABLESPACE "UNDOTBS1" DATAFILE 'C:\oracle\oradata\coba\undotbs01.dbf' SIZE 200M REUSE AUTOEXTEND ON NEXT 5120K MAXSIZE UNLIMITED CHARACTER SET WE8MSWIN1252 NATIONAL CHARACTER SET AL16UTF16 LOGFILE GROUP 1 ('C:\oracle\oradata\coba\redo01.log') SIZE 10240K, GROUP 2 ('C:\oracle\oradata\coba\redo02.log') SIZE 10240K, GROUP 3 ('C:\oracle\oradata\coba\redo03.log') SIZE 10240K USER SYS IDENTIFIED BY "oracle" USER SYSTEM IDENTIFIED BY "oracle"; Frans Winowatan <[EMAIL PROTECTED]> wrote: tolong pada milist jika ada yang punya panduan lengkap mengenai membuat database di oracle 9i secara manual (tidak pada saat instalasi) mohon di informasikan pada aku. baik dalam file maupun website thx 4 u Frans [Non-text portions of this message have been removed] --------------------------------- Do you Yahoo!? Get on board. You're invited to try the new Yahoo! Mail. [Non-text portions of this message have been removed] [Non-text portions of this message have been removed] --------------------------------- All-new Yahoo! Mail - Fire up a more powerful email and get things done faster. [Non-text portions of this message have been removed] -- -----------I.N.D.O - O.R.A.C.L.E--------------- Keluar: [EMAIL PROTECTED] Website: http://indo-oracle.blogspot.com Mirror: http://indooracle.wordpress.com ----------------------------------------------- Bergabung dengan Indonesia Thin Client User Groups, Terminal Server, Citrix, New Moon Caneveral, di: http://indo-thin.blogspot.com Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/indo-oracle/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/indo-oracle/join (Yahoo! ID required) <*> To change settings via email: mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
