New database steps: 1. Create, configure, or delete the database (input DBCA) by running Oracle Database Configuration Assistant; 2. Create a database with the command line 3. Run the custom batch script (or CREATE_Oracle_sid.bat (create_oracle_sid.sql) to create
1. Create, configure, or delete the database by running Oracle Database Configuration Assistant; (C: Oracleora81binlaunch.exe C: Oraclera81ssistantsDbca dbassist.cl) It is recommended that the DBA that is not familiar with the creation process uses this method, only need to configure according to the "Next" Finally, the creation script of the database is generated (recommended), or create a database directly; the advantage: the GUI method is easy to use; the disadvantage: the creation process is slightly slow;
2. Establish a database with the command line
CONNECT / AS SYSDBA STARTUP PFILE = 'C: oracleadmininit_testorcl.ora' NOMOUNT; CREATE DATABASE testOrcl DATAFILE '/u02/oracle/testOrcl/system01.dbf' SIZE 100M LOGFILE GROUP1 ( '/u01/oracle/testOrcl/redo1a.log', '/u02/oracle/testorcl/redo1b.log') Size 500k, Group2 ('/u01/oracle/testorcl/redo1a.log', '/u02/oracle/testorcl/redo1b.log') size 500k character set zHS16CGB231280;
- Convert the database directly from the unbenated state to the open state alter database open;
- Delete Database (Dropping a Database) Spool C: DROP_DATABASE.BAT SELECT 'DEL' || Name Remove Database Required Data File from V $ DataFile; SELECT 'DEL' || MEMBER Delete Data Reconstruction Log File from v $ logfile; Spool OFF;
Advantages: You can familiarize yourself with the creation of instructions, create principles; shortcomings: Configure simple, require maturation command line instructions;
3. Self-defined batch script (or create_ORACLE_SID.bat (create_ORACLE_SID.sql)) to create --create_ORACLE_SID.bat set ORACLE_SID = ORACLE_SID by running del C:. ORACLE8IdatabasepwdORACLE_SID.ora C: ORACLE8Ibinoradim -new -sid ORACLE_SID -intpwd. oracle -startmode manual -pfile C: ORACLE8IadminORACLE_SIDpfileinit.ora C: ORACLE8Ibinsvrmgrl @C: WINNTProfilesAdministratorLbORACLE_SIDrun.sql C: ORACLE8Ibinsvrmgrl @C: WINNTProfilesAdministratorLbORACLE_SIDrun1.sql C: ORACLE8Ibinoradim -edit -sid ORACLE_SID -startmode auto - ORACLE_SIDrun.sql spool C: ORACLE8IadminORACLE_SIDcreatecreatedb set echo on connect INTERNAL / oracle startup nomount pfile = C: ORACLE8IadminORACLE_SIDpfileinit.ora CREATE DATABASE ORACLE_SID LOGFILE 'C: ORACLE8IoradataORACLE_SIDredo01.log' SIZE 1024K, 'C: ORACLE8IoradataORACLE_SIDredo02.log' SIZE 1024K MAXLOGFILES 32 MAXLOGMEMBERS 2 MAXLOGHISTORY 1 DATAFILE 'C: ORACLE8IoradataORACLE_SIDsystem01. DBF 'Size 50m Reuse MaxDataFiles 254 MaxInstances 1 Character Set ZHT16BIG5 National Character SE T zht16big5; spool off
--ORACLE_SIDrun1.sql spool C: ORACLE8IadminORACLE_SIDcreatecreatedb1 set echo on connect INTERNAL / oracle ALTER DATABASE DATAFILE 'C: ORACLE8IoradataORACLE_SIDsystem01.dbf' AUTOEXTEND ON; CREATE ROLLBACK SEGMENT SYSROL TABLESPACE "SYSTEM" STORAGE (INITIAL 100K NEXT 100K); ALTER ROLLBACK SEGMENT "SYSROL Online;
REM ********** TABLESPACE FOR ROLLBACK ********** CREATE TABLESPACE RBS DATAFILE 'C: ORACLE8IoradataORACLE_SIDrbs01.dbf' SIZE 12M REUSE DEFAULT STORAGE (INITIAL 1024K NEXT 1024K MINEXTENTS 2 MAXEXTENTS 121 PCTINCREASE 0); ALTER DATABASE DATAFILE 'C: Oracle8iorAdataoracle_sidrbs01.dbf' AutoExtend ON;
Rem **************** ALTER TABLESPACE SYSTEM Default Storage (Initial 100K Next 100K Minelt Storage (Initial 100k Next 100k Minelt Storage) 1); remote 1); Rem ******** ** TABLESPACE FOR USER ********** CREATE TABLESPACE USERS DATAFILE 'C: ORACLE8IoradataORACLE_SIDusers01.dbf' SIZE 3M REUSE DEFAULT STORAGE (INITIAL 50K NEXT 50K MINEXTENTS 1 MAXEXTENTS 121 PCTINCREASE 1); ALTER DATABASE DATAFILE 'C: Oracle8iorradataoracle_sidusers01.dbf 'AutoExtend ON;
REM ********** TABLESPACE FOR TEMPORARY ********** CREATE TABLESPACE TEMP DATAFILE 'C: ORACLE8IoradataORACLE_SIDtemp01.dbf' SIZE 50M REUSE DEFAULT STORAGE (INITIAL 100K NEXT 100K MINEXTENTS 1 MAXEXTENTS 121 PCTINCREASE 0) Temporary; Alter Database DataFile 'C: Oracle8iorAdataoracle_sidTemp01.dbf' AutoExtend ON;
REM ********** TABLESPACE FOR INDEX ********** CREATE TABLESPACE INDX DATAFILE 'C: ORACLE8IoradataORACLE_SIDindx01.dbf' SIZE 10M REUSE DEFAULT STORAGE (INITIAL 50K NEXT 50K MINEXTENTS 1 MAXEXTENTS 121 PCTINCREASE 1); ALTER DATABASE DATAFILE 'C: Oracle8iraDataOracle_sidindx01.dbf' AutoExtend ON;
REM ********** TABLESPACE FOR OEM_REPOSITORY ********** CREATE TABLESPACE OEM_REPOSITORY DATAFILE 'C: ORACLE8IoradataORACLE_SIDoemrep01.dbf' SIZE 5M REUSE AUTOEXTEND ON NEXT 25M MAXSIZE 80M MINIMUM EXTENT 128K DEFAULT STORAGE ( Initial 128k Next 128k MineXtents 1 maxextents unlimited pctincrease 0);
