oracle11g 手工建库步骤
来源:互联网 发布:喜欢贫乳 知乎 编辑:程序博客网 时间:2024/04/30 04:06
#create oracle instance parameter
vi initkevin.or
db_name='kevin'
memory_target=0
sga_max_size=5G
sga_target=3G
pga_aggregate_target=1g
processes = 150
audit_file_dest='/u01/app/oracle/admin/kevin/adump'
audit_trail ='db'
db_block_size=8192
db_domain=''
db_recovery_file_dest='/u01/app/oracle/flash_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='UNDOTBS'
control_files = ('/u01/app/oracle/oradata/kevin/disk1/controflie01.ctl', '/u01/app/oracle/oradata/kevin/disk2/controlfile02.ctl')
compatible ='11.2.0'
#create audit_file directory , db_recovery directory and orther directories
mkdir -p /u01/app/oracle/admin/kevin/adump
mkdir -p /u01/app/oracle/flash_recovry_area
mkdir -p /u01/app/oracle/oradata/kevin/disk1
mkdir -p /u01/app/oracle/oradata/kevin/disk1
#configure oracle user environment value
export ORACLE_SID=kevin
#create oracle password pfile
orapwd file=orapwdkevin password=oracle entries=3 force=y
#start nomount oracle database instance
startup nomount pifle=?/dbs/initkevin.ora
SQL> startup nomount pfile=?/dbs/initkevin.ora
ORACLE instance started.
Total System Global Area 5344731136 bytes
Fixed Size 2262656 bytes
Variable Size 2885683584 bytes
Database Buffers 2449473536 bytes
Redo Buffers 7311360 bytes
#create spfile from pfile
create spfile from pfile;
SQL>
SQL> create spfile from pfile;
File created.
#create database;
CREATE DATABASE kevin
USER SYS IDENTIFIED BY oracle
USER SYSTEM IDENTIFIED BY oracle
LOGFILE GROUP 1 ('/u01/app/oracle/oradata/kevin/disk1/redo01a.log','/u01/app/oracle/oradata/kevin/disk2/redo01b.log') SIZE 100M BLOCKSIZE 512,
GROUP 2 ('/u01/app/oracle/oradata/kevin/disk1/redo02a.log','/u01/app/oracle/oradata/kevin/disk2/redo02b.log') SIZE 100M BLOCKSIZE 512,
GROUP 3 ('/u01/app/oracle/oradata/kevin/disk1/redo03a.log','/u01/app/oracle/oradata/kevin/disk2/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/oracle/oradata/kevin/disk1/system01.dbf' SIZE 325M REUSE
SYSAUX DATAFILE '/u01/app/oracle/oradata/kevin/disk2/sysaux01.dbf' SIZE 325M REUSE
DEFAULT TABLESPACE users
DATAFILE '/u01/app/oracle/oradata/kevin/disk1/users01.dbf'
SIZE 500M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED
DEFAULT TEMPORARY TABLESPACE tempts1
TEMPFILE '/u01/app/oracle/oradata/kevin/disk2/temp01.dbf'
SIZE 20M REUSE
UNDO TABLESPACE undotbs
DATAFILE '/u01/app/oracle/oradata/kevin/disk3/undotbs01.dbf'
SIZE 200M REUSE AUTOEXTEND ON MAXSIZE 1024m;
#create oracle dictionary information
@?/rdbms/admin/catalog.sql
@?/rdbms/admin/catproc.sql
@?/sqlplus/admin/pupbld.sql
The database was created successfully
vi initkevin.or
db_name='kevin'
memory_target=0
sga_max_size=5G
sga_target=3G
pga_aggregate_target=1g
processes = 150
audit_file_dest='/u01/app/oracle/admin/kevin/adump'
audit_trail ='db'
db_block_size=8192
db_domain=''
db_recovery_file_dest='/u01/app/oracle/flash_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='UNDOTBS'
control_files = ('/u01/app/oracle/oradata/kevin/disk1/controflie01.ctl', '/u01/app/oracle/oradata/kevin/disk2/controlfile02.ctl')
compatible ='11.2.0'
#create audit_file directory , db_recovery directory and orther directories
mkdir -p /u01/app/oracle/admin/kevin/adump
mkdir -p /u01/app/oracle/flash_recovry_area
mkdir -p /u01/app/oracle/oradata/kevin/disk1
mkdir -p /u01/app/oracle/oradata/kevin/disk1
#configure oracle user environment value
export ORACLE_SID=kevin
#create oracle password pfile
orapwd file=orapwdkevin password=oracle entries=3 force=y
#start nomount oracle database instance
startup nomount pifle=?/dbs/initkevin.ora
SQL> startup nomount pfile=?/dbs/initkevin.ora
ORACLE instance started.
Total System Global Area 5344731136 bytes
Fixed Size 2262656 bytes
Variable Size 2885683584 bytes
Database Buffers 2449473536 bytes
Redo Buffers 7311360 bytes
#create spfile from pfile
create spfile from pfile;
SQL>
SQL> create spfile from pfile;
File created.
#create database;
CREATE DATABASE kevin
USER SYS IDENTIFIED BY oracle
USER SYSTEM IDENTIFIED BY oracle
LOGFILE GROUP 1 ('/u01/app/oracle/oradata/kevin/disk1/redo01a.log','/u01/app/oracle/oradata/kevin/disk2/redo01b.log') SIZE 100M BLOCKSIZE 512,
GROUP 2 ('/u01/app/oracle/oradata/kevin/disk1/redo02a.log','/u01/app/oracle/oradata/kevin/disk2/redo02b.log') SIZE 100M BLOCKSIZE 512,
GROUP 3 ('/u01/app/oracle/oradata/kevin/disk1/redo03a.log','/u01/app/oracle/oradata/kevin/disk2/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/oracle/oradata/kevin/disk1/system01.dbf' SIZE 325M REUSE
SYSAUX DATAFILE '/u01/app/oracle/oradata/kevin/disk2/sysaux01.dbf' SIZE 325M REUSE
DEFAULT TABLESPACE users
DATAFILE '/u01/app/oracle/oradata/kevin/disk1/users01.dbf'
SIZE 500M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED
DEFAULT TEMPORARY TABLESPACE tempts1
TEMPFILE '/u01/app/oracle/oradata/kevin/disk2/temp01.dbf'
SIZE 20M REUSE
UNDO TABLESPACE undotbs
DATAFILE '/u01/app/oracle/oradata/kevin/disk3/undotbs01.dbf'
SIZE 200M REUSE AUTOEXTEND ON MAXSIZE 1024m;
#create oracle dictionary information
@?/rdbms/admin/catalog.sql
@?/rdbms/admin/catproc.sql
@?/sqlplus/admin/pupbld.sql
The database was created successfully
1 0
- oracle11g 手工建库步骤
- oracle11g 手工建库
- oracle11g手工建库
- oracle10g手工建库步骤
- oracle11g手工建库需要注意的点
- Oracle 10g 快速手工建库步骤
- oracle-11g手工建库详细步骤
- 手工创建数据库oracle11g r2
- OEM手工配置步骤
- 手工注入一般步骤
- Oracle11g安装步骤详解
- Oracle11g安装步骤详解
- linux 安装oracle11g 步骤
- 完全卸载oracle11g步骤
- 完全卸载oracle11g步骤
- oracle11g完全卸载步骤
- Oracle11g安装步骤详解
- 完全卸载oracle11g步骤
- Android 屏幕旋转 处理 AsyncTask 和 ProgressDialog 的最佳方案
- ubuntu 中Adobe song 宋体的安装
- matlabR2010a的mex setup无法找到 vs2010编译器解决办法
- Hibernate 三种状态(瞬时,持久,脱管)的区分
- 使用DBCA创建Oracle数据库
- oracle11g 手工建库步骤
- android 设计思想
- 智能家居管理系统
- 关于php 下载图片 打不开的解决办法
- 千余民警大比武赛绝活儿
- 去掉最后一条 cell分割线l
- 个人MySQL杂记
- ThinkPHP3.1.3核心类 Cache.class.php
- Sort Colors