我在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两个脚本。