当前位置: 代码迷 >> Oracle认证考试 >> 人工创建数据库(非DBCA创建)解决方案
  详细解决方案

人工创建数据库(非DBCA创建)解决方案

热度:4566   发布时间:2013-02-26 00:00:00.0
人工创建数据库(非DBCA创建)
我在OCP/OCA认证考试指南全册里面找到的方法
C:\Documents and Settings\Administrator>mkdir c:\oracle\app
C:\Documents and Settings\Administrator>mkdir c:\oracle\app\admin\ocp1\adump

C:\Documents and Settings\Administrator>mkdir c:\oracle\app\admin\ocp1\dpdump

C:\Documents and Settings\Administrator>mkdir c:\oracle\app\admin\ocp1\pfile

C:\Documents and Settings\Administrator>mkdir c:\oracle\app\cfgtoollogs\dbca\ocp
1

C:\Documents and Settings\Administrator>mkdir c:\oracle\app\oradata\ocp1

C:\Documents and Settings\Administrator>set ORACLE_SID=ocp1

C:\Documents and Settings\Administrator>set PATH=%ORACLE_HOME%\bin;%PATH%

C:\Documents and Settings\Administrator>C:\ORACLE\app\product\11.2.0\db_3\BIN\or
adim.exe -new -sid OCP1 -startmode manual -spfile
这一步中,oradim.exe根本就没有这个文件,怎么去执行这个命令啊?还有后来要执行ocpstart.sql,这个文件没有创建的时候怎么会存在呢?
求指教!

------解决方案--------------------------------------------------------
用oradim创建实例之后,再建参数文件,然后启动实例startup nomount,运行
CREATE DATABASE mynewdb
USER SYS IDENTIFIED BY pz6r58
USER SYSTEM IDENTIFIED BY y1tz5p
LOGFILE GROUP 1 ('/u01/oracle/oradata/mynewdb/redo01.log') SIZE 100M,
GROUP 2 ('/u01/oracle/oradata/mynewdb/redo02.log') SIZE 100M,
GROUP 3 ('/u01/oracle/oradata/mynewdb/redo03.log') SIZE 100M
MAXLOGFILES 5
MAXLOGMEMBERS 5
MAXLOGHISTORY 1
MAXDATAFILES 100
MAXINSTANCES 1
CHARACTER SET US7ASCII
NATIONAL CHARACTER SET AL16UTF16
DATAFILE '/u01/oracle/oradata/mynewdb/system01.dbf' SIZE 325M REUSE
EXTENT MANAGEMENT LOCAL
SYSAUX DATAFILE '/u01/oracle/oradata/mynewdb/sysaux01.dbf' SIZE 325M REUSE
DEFAULT TABLESPACE tbs_1
DEFAULT TEMPORARY TABLESPACE tempts1
TEMPFILE '/u01/oracle/oradata/mynewdb/temp01.dbf' 
SIZE 20M REUSE
UNDO TABLESPACE undotbs 
DATAFILE '/u01/oracle/oradata/mynewdb/undotbs01.dbf'
SIZE 200M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED;
创建数据库,再运行catalog.sql\catproc.sql两个脚本。

  相关解决方案