oracle 11g手动创建数据库
说明，首先要先在Oracle官网下载好，Oracle11g的安装包，在安装时，由于是自己试验部舛匀砖察属，所以最好选安装，个人版，不过企业版，标准版也可以，安上后选择单实例就好，并且切记是只安装软件，不能选择配置数据库，我们这里要讲的是手动安装的方法。完上上面工作之后，下面开始
1 准备参数文件initMYDB.ora 路径E:\app\wangxiaobo\admin\mydb\pfile\initMYDB.ora
内容如下：
Create database "mydb"
maxinstances 4
maxloghistory 1
maxlogfiles 16
maxlogmembers 3
maxdatafiles 10
logfile group 1'E:\app\wangxiaobo\oradata\mydb\redo01.log' size 10M,group 2'E:\app\wangxiaobo\oradata\mydb\redo02.log' size 10M
datafile 'E:\app\wangxiaobo\oradata\mydb\system01.dbf'size 50M
autoextend on next 10M extent management local
sysaux datafile'E:\app\wangxiaobo\oradata\mydb\sysaux01.dbf' size 50M
autoextend on next 10M
default temporary tablespace temp
tempfile 'E:\app\wangxiaobo\oradata\mydb\temp.dbf' size 10M autoextendon next 10M
undo tablespace UNDOTBS1 datafile'E:\app\wangxiaobo\oradata\mydb\undotbs1.dbf' size 20M
character set ZHS16GBK
national character set AL16UTF16
user sys identified by sys
user system identified by system ;
3 创建必要的目录用批处理文档
mkdir E:\app\hemingway\admin\mydb\adump
mkdir E:\app\hemingway\admin\mydb\bdump
mkdir E:\app\hemingway\admin\mydb\cdump
mkdir E:\app\hemingway\admin\mydb\dpdump
mkdir E:\app\hemingway\admin\mydb\udump
mkdir E:\app\hemingway\admin\mydb\pfile
mkdir E:\app\hemingway\oradata\mydb
mkdir E:\app\hemingway\flash_recovery_area\mydb
SQL>
修改E:\app\wangxiaobo\product\11.2.0\dbhome_1\NETWORK\ADMIN\listener.ora添加为：
# This is a sample listener.ora that contains the NET8parameters that are
# needed to connect to an HS Agent
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME= CLRExtProc)
(ORACLE_HOME= E:\app\wangxiaobo\product\11.2.0\dbhome_1)
(PROGRAM =extproc)
(ENVS ="EXTPROC_DLLS=ONLY:E:\app\wangxiaobo\product\11.2.0\dbhome_1\bin\oraclr11.dll")
)
(SID_DESC =
(SID_NAME= mydb)
(SID_NAME= mydb)
(ORACLE_HOME= E:\app\wangxiaobo\product\11.2.0\dbhome_1)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION=
(ADDRESS =(PROTOCOL = IPC)(KEY = EXTPROC1521))
(ADDRESS =(PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
)
ADR_BASE_LISTENER = E:\app\wangxiaobo
#CONNECT_TIMEOUT_LISTENER = 0
另外还要修改
E:\app\wangxiaobo\product\11.2.0\dbhome_1\NETWORK\ADMIN\tnsnames.ora为
# This is a sample tnsnames.ora that contains the NET8parameters that are
# needed to connect to an HS Agent
dg4odbc =
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521))
(CONNECT_DATA=(SID=dg4odbc))
(HS=OK)
)
LISTENER_ORCL =
(ADDRESS =(PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
ORACLR_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST=
(ADDRESS =(PROTOCOL = IPC)(KEY = EXTPROC1521))
)
(CONNECT_DATA =
(SID =CLRExtProc)
(PRESENTATION = RO)
)
)
ORCL =
(DESCRIPTION =
(ADDRESS =(PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(CONNECT_DATA =
(SERVER =DEDICATED)
(SERVICE_NAME = orcl)
)
MYDB =
(DESCRIPTION =
(ADDRESS =(PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(CONNECT_DATA =
(SERVER =DEDICATED)
(SERVICE_NAME = mydb)
)
)
LISTENER_ORCL =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
LISTENER_MYDB =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
11 创建spfile
SQL> create spfile frompfile='E:\app\wangxiaobo\admin\mydb\pfile\initMYDB.ora';
文件已创建。
SQL> shutdown
数据库已经关闭。
已经卸载数据库。
ORACLE 例程已经关闭。
SQL> connSYS/rootroot as sysdba
已连接到空闲例程。
SQL> startup
ORACLE 例程已经启动。
Total System Global Area 778387456 bytes
Fixed Size 1374808 bytes
Variable Size 234882472 bytes
Database Buffers 536870912 bytes
Redo Buffers 5259264 bytes
数据库装载完毕。
数据库已经打开。
注：rdbms文件里的内容来E:\app\Administrator\product\11.2.0\dbhome_1\RDBMS\ADMIN的复制。别的相应文件有的也是来自复制sample示例，后经过修改
SQL> create table st(sno int,m char);
表已创建。
SQL> desc st;
名称是否为空? 类型
------------------------------------------------- ----------------------
SNONUMBER(38)
MCHAR(1)
SQL>
这样一个名字叫mydb的数据库就创建完成了，也祝愿大家可以顺利完成。