Three methods for creating an Oracle database

1. Create, configure, or delete a database by running OracleDatabaseConfigurationAssistant (you can also enter dbca in the command line); 2. Create a database by running the command line

1. Create, configure, or delete a Database by running Oracle Database Configuration Assistant (you can also enter dbca in the command line); 2. Create a Database by running the command line

1. Create, configure, or delete a Database by running Oracle Database Configuration Assistant (you can also enter dbca in the command line );
2. Create a database using command line
3. Create, configure, or delete a database by running a custom batch processing script (or create_ORACLE_SID.bat (create_ORACLE_SID. SQL.
Details:
1. Create, configure, or delete a Database by running Oracle Database Configuration Assistant;

It is recommended that DBAs who are not familiar with the creation process use this method. They only need to configure according to the options % 26 #8220; next % 26 #8221; and finally generate the database creation script (we recommend that you keep it ), or directly create a database;
Advantage: the GUI method is easy to use;
Disadvantage: the creation process is slow;
2. Create a database using command line

CONNECT/AS SYSDBA
Startup pfile = 'C: oracleadmininit_testorcl.ora 'nomount;
Create database testOrcl DATAFILE '/u02/oracle/testOrcl/system01.dbf' SIZE 100 M
LOGFILE GROUP1 ('/u01/oracle/testOrcl/redo1a. log ',,
'/U02/oracle/testOrcl/redo1b. log') SIZE 500 K,
GROUP2 ('/u01/oracle/testOrcl/redo1a. log ',
'/U02/oracle/testOrcl/redo1b. log') SIZE 500 K
Character set ZHS16CGB231280;

-- Directly convert the database from the never-built status to the open status
Alter database open;

-- Drop a Database)
Spool c: DROP_DATABASE.BAT
SELECT 'del '| NAME: deletes database-related data files from v $ DATAFILE;
SELECT 'del '| MEMBER deletes data and restructured the log file from v $ LOGFILE;
Spool off;

Advantage: You can familiarize yourself with the creation instructions and principles;
Disadvantage: the configuration is simple, and the command line commands must be memorized;