手工建库的步骤

1.环境变量的设置

2.建立所需目录

3.生成密码文件

4创建pfile参数文件

5.生成spfile参数文件

6.执行创建数据库语句

7.执行catalog.sql 和catpro.sql 脚本

8.最后的检查

具体执行步骤如下：
1.环境变量 .bash_profile 这个文件在根目录

$ORACLE_HOME=/u01/app/oralce/product/11.2.0/dbhome_1

$ORACLE_BASH=/u01/app/oracle

$ORACLE_SID=ENMO1
验证ORACLE_HOME和ORACLE_SID的正确性
$echo $ORACLE_HOME
$echo $ORACLE_SID

２建立所需目录
cd $ORACLE_BASH
mkdir -p admin/ENMO/adump

３生成密码文件
cd $ORACLE_BASH/dbs
orapwd file=orapwENMO passwd=oracle entries=30

４创建ｐｆｉｌｅ参数文件
cat init.ora |grep -v ^# |grep -v ^$ > initENMO.ora

调整参数文件

$ vi initENMOEDU.ora

db_name='ENMＯ'

memory_target=1G

processes = 150

audit_file_dest='/u01/app/oracle/admin/ENMOEDU/adump'

audit_trail ='db'

db_block_size=8192

db_domain=''

db_recovery_file_dest='/u01/app/oracle/fast_recovery_area'

db_recovery_file_dest_size=2G

diagnostic_dest='/u01/app/oracle'

dispatchers='(PROTOCOL=TCP) (SERVICE=ORCLXDB)'

open_cursors=300

remote_login_passwordfile='EXCLUSIVE'

undo_tablespace='UNDOTBS1'

control_files = (/u01/app/oracle/oradata/ENMOEDU/
control01.ctl, /u01/app/oracle/oradata/ENMOEDU/control02.ctl)

compatible ='11.2.0'

５生成参数文件ｓｐｆｉｌｅ
sqlplus / as sysdba
create spfile from pfile
startup nomount

６执行创建数据库语句

–根据官??档改写

? 官??档参考位置

Books →Administrator's Guide →2 Creating and Configuring an Oracle Database

→Creating a Database with the CREATE DATABASE Statement→

Step 9: Issue the CREATE DATABASE Statement

–需要调整的内容列表

? 1）修改数据库名字为“ENMOEDU”

? 2）修改SYS和SYSTEM?户的密码为“oracle”

? 3）修改数据?件和?志?件的路径名

调整后的创建数据库语句

CREATE DATABASE ENMOEDU

USER SYS IDENTIFIED BY oracle

USER SYSTEM IDENTIFIED BY oracle

LOGFILE

GROUP 1 ('/oracle/u01/app/oracle/oradata/ENMOEDU/redo01a.log') SIZE 100M,

GROUP 2 ('/oracle/u01/app/oracle/oradata/ENMOEDU/redo02a.log') SIZE 100M,

GROUP 3 ('/oracle/u01/app/oracle/oradata/ENMOEDU/redo03a.log') SIZE 100M

MAXLOGFILES 50

MAXLOGMEMBERS 5

MAXLOGHISTORY 1

MAXDATAFILES 100

CHARACTER SET AL32UTF8

NATIONAL CHARACTER SET AL16UTF16

EXTENT MANAGEMENT LOCAL

DATAFILE '/oracle/u01/app/oracle/oradata/ENMOEDU/system01.dbf' SIZE 325M REUSE

SYSAUX DATAFILE '/oracle/u01/app/oracle/oradata/ENMOEDU/sysaux01.dbf' SIZE 325M REUSE

DEFAULT TABLESPACE users

DATAFILE '/oracle/u01/app/oracle/oradata/ENMOEDU/users01.dbf'

SIZE 100MREUSE AUTOEXTEND ON MAXSIZE UNLIMITED

DEFAULT TEMPORARY TABLESPACE tempts1

TEMPFILE '/oracle/u01/app/oracle/oradata/ENMOEDU/temp01.dbf'

SIZE 20M REUSE

UNDO TABLESPACE undotbs

DATAFILE '/oracle/u01/app/oracle/oradata/ENMOEDU/undotbs01.dbf'

SIZE 200M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED

7.执行catalog.sql 和catpro.sql 脚本

SQL> @?/rdbms/admin/catalog.sql

SQL> @?/rdbms/admin/catproc.sql

8.最后的检查

SQL> select * from v$version;

启动数据库

如果一个环境下有两个数据库启动之前要指定一下

export ORACLE_SID=ENMO

sqlplus / as sysdba

ITPub博客

手工建库的过程

最新文章