Analysis on three methods of building Oracle database

1. Create, configure, or delete the database by running Oracle Database Configuration Assistant (you can also enter dbca at the command line);
2. Build a database on the command line
3. Create, configure, or delete a database by running a custom batch script (or create_ORACLE_SID. bat (create_ORACLE_SID. sql).

Detailed description:
1. Create, configure, or delete a database by running Oracle Database Configuration Assistant;
It is recommended that DBA, which is not familiar with the creation process, use this method, only need to configure according to the option "Next Step", and finally generate the creation script of the database (it is recommended to keep it), or create the database directly;
Advantages: GUI method is convenient to use;
Disadvantages: However, the creation process is somewhat slow;

2. Build a database on 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;
-- Transition the database directly from the unbuilt state to the open state 
  ALTER DATABASE OPEN;
-- Delete a database (Dropping a Database)
  SPOOL C:DROP_DATABASE.BAT
  SELECT 'DEL '||NAME  Delete database related data files  FROM V$DATAFILE;
  SELECT 'DEL '||MEMBER  Delete the data reconstruction log file  FROM V$LOGFILE;
  SPOOL OFF;

Advantages: You can be familiar with the creation instructions and creation principles;
Disadvantages: Simple configuration, requiring memorization of command line instructions;

3. Create by running a custom batch or SQL script (create_ORACLE_SID. bat or create_ORACLE_SID. sql)

--create_ORACLE_SID.bat
  set ORACLE_SID= ORACLE_SID.
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 SET 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; 

Operation of Oracle under Linux Platform

The following operations on Oracle are all carried out under Linux platform!
1.su Oracle
2.sqlplus /logon
3. connect test/test assysdba (test/test is the Oracle user and password)
4.startup
5.lsnrctl
Preferred startup database
su - Oracle
sqlplus /nolog
conn /as sysdba
startup
Then start listening:
Enter/opt/Oracle/product/9. 2.0/bin/
lsnrctl start
Run the shudown command to close the database
[Oracle @ wing/Oracle] $sqlplus "/as sysdba"//Log in to the database as an sysdba user
SQL > shutdown

Start the Oracle 9i database
[Oracle@wing bin]$ sqlplus " /as sysdba"
SQL > startup

Start the Oracle 9i listener
Oracle listener mainly provides interface for client connection
[Oracle@wing bin]$ lsnrctl
LSNRCTL > start

Close the Oracle 9i listener
[Oracle@wing bin]$ lsnrctl
LSNRCTL > stop

First see if the Oracle_SID environment variable is set correctly.
9i:
$ sqlplus /nolog
SQL > connect / as sysdba
SQL > startup
$ lsnrctl start
8i:
$ svrmgrl
SVRMGR > connect internal
SVRMGR > startup
$ lsnrctl start
Where is the error reported? ?
1 As long as you set these two places ~
/etc/oratab
ora2:/Oracle/app/Oracle/product/8.1.7:Y
/etc/inittab
oralce:2:wait:/bin/su - Oracle -c '/Oracle/app/Oracle/product/8.1.7/bin/lsnrctl start'
Oracle:2:wait:/bin/su - Oracle -c '/Oracle/app/Oracle/product/8.1.7/bin/dbstart'

Startup steps:
su - Oracle
[Oracle@websvr1 Oracle]$ sqlplus /nolog
SQL > connect / as sysdba
SQL > startup
SQL > quit
[Oracle@websvr1 Oracle]$ lsnrctl start
You can use [Oracle @ websvr1 Oracle] $lsnrctl status to see if listening has started

Close step:
su - Oracle
[Oracle@websvr1 Oracle]$ lsnrctl stop
[Oracle@websvr1 Oracle]$ sqlplus /nolog
SQL > connect / as sysdba
SQL > shutdown immediate
SQL > quit