oracle 11g手工建库步骤（初学者）

最新推荐文章于 2021-04-09 21:47:17 发布

weixin_30256901

最新推荐文章于 2021-04-09 21:47:17 发布

阅读量167

点赞数

文章标签：数据库

原文链接：http://www.cnblogs.com/7798456shunqian/p/7510218.html

版权

要建立的数据库ORACLE_SID=test1
sys和system的密码为oracle
1、建立相应的目录
mkdir /u01/app/oracle/oradata/test1
mkdir /u01/app/oracle/fast_recovery_area/test1
mkdir -p /u01/app/oracle/admin/test1/{a,dp}dump

2、指定oracle_sid
export ORACLE_SID=test1

3、确定当前用户的环境变量
echo $ORACLE_HOME
echo $ORACLE_SID
echo $PATH

4、选择数据库的认证方式，这里选择口令文件验证。
orapwd file=orapwtest password=oracle

5、为数据库添加一个参数文件。
cd $ORACLE_HOME/dbs
cp init.ora inittest.ora
vi inittest.ora (添加以下的内容)

db_name='test1'
memory_target=1G
processes = 150
audit_file_dest='/u01/app/oracle/admin/test1/adump'
audit_trail ='db'
db_block_size=8192
db_domain='oracle.com'
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=test1XDB)'
open_cursors=300
remote_login_passwordfile='EXCLUSIVE'
undo_tablespace='UNDOTBS1'
# You may want to ensure that control files are created on separate physical
# devices
control_files =
('/u01/app/oracle/oradata/test1/contorl01.ctl','/u01/app/oracle/fast_recovery_area/test1/control02.ctl')
compatible ='11.2.0'

6、连接到实例
sqlplus / as sysdba

7、打开实例到nomount状态
startup nomount;

8、创建建库语句，执行建库语句
cd
vi createdbtest.sql (添加以下的语句，也可以直接在sqlplus里面执行)
CREATE DATABASE test1
USER SYS IDENTIFIED BY oracle
USER SYSTEM IDENTIFIED BY oracle
LOGFILE GROUP 1 ('/u01/app/oracle/oradata/test1/redo01a.log') SIZE 100M BLOCKSIZE 512,
GROUP 2 ('/u01/app/oracle/oradata/test1/redo02a.log') SIZE 100M BLOCKSIZE 512,
GROUP 3 ('/u01/app/oracle/oradata/test1/redo03a.log') SIZE 100M BLOCKSIZE 512
MAXLOGFILES 5
MAXLOGMEMBERS 5
MAXLOGHISTORY 1
MAXDATAFILES 100
CHARACTER SET US7ASCII
NATIONAL CHARACTER SET AL16UTF16
EXTENT MANAGEMENT LOCAL
DATAFILE '/u01/app/oracle/oradata/test1/system01.dbf' SIZE 325M REUSE
SYSAUX DATAFILE '/u01/app/oracle/oradata/test1/sysaux01.dbf' SIZE 325M REUSE
DEFAULT TABLESPACE users
DATAFILE '/u01/app/oracle/oradata/test1/users01.dbf'
SIZE 500M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED
DEFAULT TEMPORARY TABLESPACE tempts1
TEMPFILE '/u01/app/oracle/oradata/test1/temp01.dbf'
SIZE 20M REUSE
UNDO TABLESPACE undotbs1
DATAFILE '/u01/app/oracle/oradata/test1/undotbs01.dbf'
SIZE 200M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED;