[oracle@node2 dbs]$ export ORACLE_SID=MANUAL [oracle@node2 dbs]$ sqlplus / as sysdba SQL> startup nomount pfile='/u01/manual.ora' SQL>spool /u01/createdb.log SQL> CREATE DATABASE "MANUAL" MAXINSTANCES 8 MAXLOGHISTORY 1 MAXLOGFILES 16 MAXLOGMEMBERS 3 MAXDATAFILES 200 DATAFILE '/u01/app/oracle/oradata/MANUAL/system01.dbf'SIZE 200M REUSE EXTENT MANAGEMENT LOCAL SYSAUX DATAFILE '/u01/app/oracle/oradata/MANUAL/sysaux01.dbf'SIZE 200M REUSE SMALLFILE DEFAULT TEMPORARY TABLESPACE TEMP TEMPFILE'/u01/app/oracle/oradata/MANUAL/temp01.dbf'SIZE 200M REUSE SMALLFILE UNDO TABLESPACE "UNDOTBS1" DATAFILE'/u01/app/oracle/oradata/MANUAL/undotbs01.dbf'SIZE 100M REUSE CHARACTER SET ZHS16GBK NATIONAL CHARACTER SET AL16UTF16 LOGFILE GROUP 1 ('/u01/app/oracle/oradata/MANUAL/redo01.log')SIZE 100M, GROUP 2 ('/u01/app/oracle/oradata/MANUAL/redo02.log')SIZE 100M, GROUP 3 ('/u01/app/oracle/oradata/MANUAL/redo03.log')SIZE 100M USER SYS IDENTIFIED BY "ank88ank" USER SYSTEM IDENTIFIED BY "ank88ank"; spool off
[oracle@node2 MANUAL]$ pwd /u01/app/oracle/oradata/MANUAL [oracle@node2 MANUAL]$ ls -la total 844612 drwxr-xr-x 2 oracle oinstall 4096 Dec 2 20:49 . drwxr-x--- 5 oracle oinstall 4096 Dec 2 20:31 .. -rw-r----- 1 oracle oinstall 8339456 Dec 2 20:50 control01.ctl -rw-r----- 1 oracle oinstall 8339456 Dec 2 20:50 control02.ctl -rw-r----- 1 oracle oinstall 8339456 Dec 2 20:50 control03.ctl -rw-r----- 1 oracle oinstall 104858112 Dec 2 20:49 redo01.log -rw-r----- 1 oracle oinstall 104858112 Dec 2 20:49 redo02.log -rw-r----- 1 oracle oinstall 104858112 Dec 2 20:49 redo03.log -rw-r----- 1 oracle oinstall 209723392 Dec 2 20:49 sysaux01.dbf -rw-r----- 1 oracle oinstall 209723392 Dec 2 20:49 system01.dbf -rw-r----- 1 oracle oinstall 209723392 Dec 2 20:49 temp01.dbf -rw-r----- 1 oracle oinstall 104865792 Dec 2 20:49 undotbs01.dbf [oracle@node2 MANUAL]$