CONNECT / AS SYSDBA
STARTUP PFILE='C:\oracle\admin\init_test\orcl.ora' NOMOUNT;
CREATE DATABASE testOrcl
DATAFILE '/u02/oracle/testOrcl/system01.dbf' SIZE 100M
LOGFILE GROUP 1 ('/u01/oracle/testOrcl/redo1a.log','/u02/oracle/testOrcl/redo1b.log') SIZE 500K,
GROUP 2 ('/u01/oracle/testOrcl/redo2a.log','/u02/oracle/testOrcl/redo2b.log') SIZE 500K
CHARACTER SET ZHS16CGB231280;
ALTER DATABASE OPEN;
-- 刪除資料庫 (產生刪除腳本)
SPOOL C:\DROP_DATABASE.BAT
SELECT 'DEL '||NAME FROM V$DATAFILE;
SELECT 'DEL '||MEMBER FROM V$LOGFILE;
SPOOL OFF
REM create_ORACLE_SID.bat
SET ORACLE_SID=MYDB
DEL C:\ORACLE8I\DATABASE\PWDMYDB.ORA
C:\ORACLE8I\BIN\ORADIM -NEW -SID MYDB -INTPWD ORACLE -STARTMODE MANUAL -PFILE C:\ORACLE8I\ADMIN\MYDB\PFILE\INIT.ORA
C:\ORACLE8I\BIN\SVRMGRl @C:\...\MYDB\RUN.SQL
C:\ORACLE8I\BIN\SVRMGRl @C:\...\MYDB\RUN1.SQL
C:\ORACLE8I\BIN\ORADIM -EDIT -SID MYDB -STARTMODE AUTO
RUN.SQL 執行 CREATE DATABASE,RUN1.SQL 建立 Rollback Segment 等後續物件。
# 啟動資料庫
su - oracle
sqlplus /nolog
CONN / AS SYSDBA
STARTUP
# 啟動監聽
lsnrctl start
# 關閉資料庫
sqlplus /nolog
CONN / AS SYSDBA
SHUTDOWN IMMEDIATE
lsnrctl stop