手工建库的步骤
1.环境变量的设置
2.建立所需目录
3.生成密码文件
4创建pfile参数文件
5.生成spfile参数文件
6.执行创建数据库语句
7.执行catalog.sql 和catpro.sql 脚本
8.最后的检查
具体执行步骤如下:
1.环境变量 .bash_profile 这个文件在根目录
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
验证ORACLE_HOME和ORACLE_SID的正确性
$echo $ORACLE_HOME
$echo $ORACLE_SID
2建立所需目录
cd $ORACLE_BASH
mkdir -p admin/ENMO/adump
cd $ORACLE_BASH
mkdir -p admin/ENMO/adump
3生成密码文件
cd $ORACLE_BASH/dbs
orapwd file=orapwENMO passwd=oracle entries=30
cd $ORACLE_BASH/dbs
orapwd file=orapwENMO passwd=oracle entries=30
4创建pfile参数文件
cat init.ora |grep -v ^# |grep -v ^$ > initENMO.ora
cat init.ora |grep -v ^# |grep -v ^$ > initENMO.ora
调整参数文件
$ vi initENMOEDU.ora
db_name= 'ENMO '
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'
db_name= 'ENMO '
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'
5生成参数文件spfile
sqlplus / as sysdba
create spfile from pfile
startup nomount
sqlplus / as sysdba
create spfile from pfile
startup nomount
6执行创建数据库语句
–根据官??档改写
? 官??档参考位置
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”
? 官??档参考位置
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 100M REUSE 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
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 100M REUSE 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 脚本
8.最后的检查
SQL> select * from v$version;
启动数据库
如果一个环境下有两个数据库 启动之前要指定一下
export ORACLE_SID=ENMO
sqlplus / as sysdba
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/30166976/viewspace-1486684/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/30166976/viewspace-1486684/