Oracle手动建库安装部署超具体教程

• 步调1 指定SID
  
• 步调2 确定Oracle环境的环境变量
  
• 步调3 设置Oracle的口令认证方式
  
• 步调4 创建初始化参数文件
  
• 步调5 毗连数据库实例
  
• 步调6 创建spfile文件
  
• 步调7 启动实例
  
• 步调8 使用CREATE DATABASE语句建库
  
• 步调9 创建额外的空间
  
• 步调10 执行脚本构建数据字典视图
  
• 参考文献
  

Oracle_SID
复制代码

ORACLE_SID=prod
export ORACLE_SID
复制代码

Oracle_SID
复制代码

ORACLE_HOME
复制代码

PATH
复制代码

[oracle@db1 oradata]$ mkdir -p /u01/app/oradata/prod 
[oracle@db1 oradata]$ mkdir -p $ORACLE_BASE/admin/prod/adump
[oracle@db1 dbs]$ mkdir -p /u01/app/flash_recovery_area
复制代码

ORACLE_BASE=/u01/app
ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1
#ORACLE_SID=oradb
ORACLE_SID=prod
export ORACLE_BASE ORACLE_HOME ORACLE_SID
PATH=$ORACLE_HOME/bin:$PATH
export PATH
alias sqlplus='rlwrap sqlplus'
alias rman='rlwrap rman'
复制代码

ORACLE_SID
复制代码

[oracle@db1 ~]$ source .bash_profile 
[oracle@db1 ~]$ echo $ORACLE_SID
prod
复制代码

$ORACLE_HOME/sqlplus/admin/glogin.sql
set sqlprompt _user'@'_connect_identifier> 
复制代码

[oracle@db1 ~]$ cd $ORACLE_HOME/dbs
[oracle@db1 dbs]$ orapwd file=orapwPROD password=oracle entries=30
复制代码

cd $ORACLE_HOME/dbs
复制代码

init.ora
复制代码

db_name='ORCL'
memory_target=1G
processes = 150
audit_file_dest='<ORACLE_BASE>/admin/orcl/adump'
audit_trail ='db'
db_block_size=8192
db_domain=''
db_recovery_file_dest='<ORACLE_BASE>/flash_recovery_area'
db_recovery_file_dest_size=2G
diagnostic_dest='<ORACLE_BASE>'
dispatchers='(PROTOCOL=TCP) (SERVICE=ORCLXDB)'
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 = (ora_control1, ora_control2)
compatible ='11.2.0'
复制代码

  


• :%s#orcl#prod#gi
  复制代码

  替换内里的

  orcl
  复制代码

  的字符串。其中

  i
  复制代码

  命令不区分巨细写。  
  

• :%s#ora_control1#/u01/app/oradata/prod/control01.ctl#g
  复制代码

  替换

  ora_control1
  复制代码

  的字符串。  
  

• :%s#ora_control2#/u01/app/oradata/prod/control02.ctl#g
  复制代码

  替换

  ora_control2
  复制代码

  的字符串。  
  

• :%s#<ORACLE_BASE>#/u01/app#g
  复制代码

  替换

  <ORACLE_BASE>
  复制代码

  的字符串。  
  

• :wq
  复制代码

  命令保存设置。
  

initprod.ora 
复制代码

db_name='prod'
memory_target=1G
processes = 150
audit_file_dest='/u01/app/admin/prod/adump'
audit_trail ='db'
db_block_size=8192
db_domain=''
db_recovery_file_dest='/u01/app/flash_recovery_area'
db_recovery_file_dest_size=2G
diagnostic_dest='/u01/app'
dispatchers='(PROTOCOL=TCP) (SERVICE=prodXDB)'
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/oradata/prod/control01.ctl, /u01/app/oradata/prod/control02.ctl)
compatible ='11.2.0'
复制代码

[oracle@db1 dbs]$ sqlplus /nolog
@> connect sys as sysdba
Enter password: 
Connected to an idle instance.
SYS@prod> 
复制代码

[oracle@db1 dbs]$ sqlplus /nolog
@> conn /as sysdba
Connected to an idle instance.
SYS@prod> 
复制代码

SYS@prod> CREATE SPFILE FROM PFILE;
复制代码

STARTUP NOMOUNT
复制代码

/u01/app/oradata/prod
复制代码

CREATE DATABASE prod
 USER SYS IDENTIFIED BY oracle
 USER SYSTEM IDENTIFIED BY oracle
 LOGFILE GROUP 1 ('/u01/app/oradata/prod/redo01a.log','/u01/app/oradata/prod/redo01b.log') SIZE 100M BLOCKSIZE 512,
  GROUP 2 ('/u01/app/oradata/prod/redo02a.log','/u01/app/oradata/prod/redo02b.log') SIZE 100M BLOCKSIZE 512,
  GROUP 3 ('/u01/app/oradata/prod/redo03a.log','/u01/app/oradata/prod/redo03b.log') SIZE 100M BLOCKSIZE 512
 MAXLOGFILES 5
 MAXLOGMEMBERS 5
 MAXLOGHISTORY 1
 MAXDATAFILES 100
 CHARACTER SET AL32UTF8
 NATIONAL CHARACTER SET AL16UTF16
 EXTENT MANAGEMENT LOCAL
 DATAFILE '/u01/app/oradata/prod/system01.dbf' SIZE 325M REUSE
 SYSAUX DATAFILE '/u01/app/oradata/prod/sysaux01.dbf' SIZE 325M REUSE
 DEFAULT TABLESPACE users
 DATAFILE '/u01/app/oradata/prod/users01.dbf'
 SIZE 500M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED
 DEFAULT TEMPORARY TABLESPACE tempts1
 TEMPFILE '/u01/app/oradata/prod/temp01.dbf'
 SIZE 20M REUSE
 UNDO TABLESPACE undotbs1
 DATAFILE '/u01/app/oradata/prod/undotbs01.dbf'
 SIZE 200M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED;
复制代码

[oracle@db1 ~]$ chmod 755 create_database.sql 
[oracle@db1 ~]$ sqlplus "/as sysdba"
SYS@prod> @create_database.sql
Database created.
复制代码

CREATE TABLESPACE apps_arp LOGGING 
 DATAFILE '/u01/app/oradata/prod/apps_arp01.dbf' 
 SIZE 500M REUSE AUTOEXTEND ON NEXT 1280K MAXSIZE UNLIMITED 
 EXTENT MANAGEMENT LOCAL;
-- create a tablespace for indexes, separate from user tablespace (optional)
CREATE TABLESPACE indx_arp LOGGING 
 DATAFILE '/u01/app/oradata/prod/indx_arp01.dbf' 
 SIZE 100M REUSE AUTOEXTEND ON NEXT 1280K MAXSIZE UNLIMITED 
 EXTENT MANAGEMENT LOCAL;
复制代码

SYSDBA
复制代码

[oracle@db1 ~]$ sqlplus /nolog
@> conn /as sysdba
Connected.
SYS@prod>
复制代码

@?/rdbms/admin/catalog.sql
@?/rdbms/admin/catproc.sql
@?/rdbms/admin/utlrp.sql
复制代码

SYSTEM
复制代码

[oracle@db1 ~]$ sqlplus /nolog
@> conn system/oracle
Connected.
SYSTEM@prod> @?/sqlplus/admin/pupbld.sql
复制代码

[oracle@db1 ~]$ sqlplus /nolog
@> conn / as sysdba
Connected.
SYS@prod> @?/rdbms/admin/utlsampl.sql
复制代码

[oracle@db1 ~]$ sqlplus "/as sysdba"
SYS@prod> select INSTANCE_NAME,STATUS from v$instance;

INSTANCE_NAME STATUS
---------------- ------------
prod  OPEN
复制代码