linux上oracle11g 手动安装
时间:2011-11-24
来源:互联网
系统环境光:redhat5.5数据库版本:oracle110201环境变量同oracle10g一样,参照:http://blog.csdn.net/dream19881003/article/details/6938261不一样的是需要设置不同的路径设置归档路径mkdir -p /opt/oracle/arch备份路径mkdir -p /opt/oracle/bak
配置多路路径mkdir -p /opt/oracle/bak/controlfile mkdir -p /opt/oracle/bak/redologfile创建文件路径mkdir -p /opt/oracle/oradata/orcl设置路径的跟10g的有些不同参数文件内容如下:db_name='ORCL' pga_aggregate_target=1500M sga_target=500M processes = 150 db_block_size=8192 db_domain='' audit_trail=none db_recovery_file_dest='/opt/oracle/flash_recovery_area' db_recovery_file_dest_size=10G log_archive_dest_1='LOCATION=/opt/oracle/arch' log_archive_dest_2='LOCATION=/opt/oracle/bak' log_archive_format='log%t_%s_%r.arc' dispatchers='(PROTOCOL=TCP) (SERVICE=ORCLXDB)' open_cursors=300 remote_login_passwordfile='EXCLUSIVE' # You may want to ensure that control files are created on separate physical # devices control_files = ('/opt/oracle/bak/controlfile/cont1.ctl', '/opt/oracle/oradata/orcl/contl2.ctl')
compatible ='11.2.0' undo_management=auto undo_retention=7200 db_flashback_retention_target=7200 db_file_multiblock_read_count=16启动数据库到nomount阶段创建spfile文件create spfile from pfile;执行创建数据库的脚步SQL>@createdb11.sql内容如下:CREATE DATABASE orcl USER SYS IDENTIFIED BY orcl USER SYSTEM IDENTIFIED BY orcl LOGFILE GROUP 1 ('/opt/oracle/oradata/orcl/redo01.log','/opt/oracle/bak/redologfile/redo01.log') SIZE 100M,GROUP 2 ('/opt/oracle/oradata/orcl/redo02.log','/opt/oracle/bak/redologfile/redo02.log') SIZE 100M,GROUP 3 ('/opt/oracle/oradata/orcl/redo03.log','/opt/oracle/bak/redologfile/redo03.log') SIZE 100M MAXLOGFILES 5 MAXLOGMEMBERS 5 MAXLOGHISTORY 1 MAXDATAFILES 300 CHARACTER SET ZHS16GBK NATIONAL CHARACTER SET AL16UTF16 EXTENT MANAGEMENT LOCAL DATAFILE '/opt/oracle/oradata/orcl/system01.dbf' SIZE 500M REUSE SYSAUX DATAFILE '/opt/oracle/oradata/orcl/sysaux01.dbf' SIZE 325M REUSE DEFAULT TABLESPACE users DATAFILE '/opt/oracle/oradata/orcl/users01.dbf' SIZE 500M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED DEFAULT TEMPORARY TABLESPACE tempts1 TEMPFILE '/opt/oracle/oradata/orcl/temp01.dbf' SIZE 200M REUSE UNDO TABLESPACE undotbs DATAFILE '/opt/oracle/oradata/orcl/undotbs01.dbf' SIZE 200M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED;创建数据字典@$ORACLE_HOME/rdbms/admin/catalog.sql;@$ORACLE_HOME/rdbms/admin/catproc.sql;
配置oracle的网络执行netmgr<最简单的方式>也可以参照sample下面的三个文件创建三个文件即可。
配置多路路径mkdir -p /opt/oracle/bak/controlfile mkdir -p /opt/oracle/bak/redologfile创建文件路径mkdir -p /opt/oracle/oradata/orcl设置路径的跟10g的有些不同参数文件内容如下:db_name='ORCL' pga_aggregate_target=1500M sga_target=500M processes = 150 db_block_size=8192 db_domain='' audit_trail=none db_recovery_file_dest='/opt/oracle/flash_recovery_area' db_recovery_file_dest_size=10G log_archive_dest_1='LOCATION=/opt/oracle/arch' log_archive_dest_2='LOCATION=/opt/oracle/bak' log_archive_format='log%t_%s_%r.arc' dispatchers='(PROTOCOL=TCP) (SERVICE=ORCLXDB)' open_cursors=300 remote_login_passwordfile='EXCLUSIVE' # You may want to ensure that control files are created on separate physical # devices control_files = ('/opt/oracle/bak/controlfile/cont1.ctl', '/opt/oracle/oradata/orcl/contl2.ctl')
compatible ='11.2.0' undo_management=auto undo_retention=7200 db_flashback_retention_target=7200 db_file_multiblock_read_count=16启动数据库到nomount阶段创建spfile文件create spfile from pfile;执行创建数据库的脚步SQL>@createdb11.sql内容如下:CREATE DATABASE orcl USER SYS IDENTIFIED BY orcl USER SYSTEM IDENTIFIED BY orcl LOGFILE GROUP 1 ('/opt/oracle/oradata/orcl/redo01.log','/opt/oracle/bak/redologfile/redo01.log') SIZE 100M,GROUP 2 ('/opt/oracle/oradata/orcl/redo02.log','/opt/oracle/bak/redologfile/redo02.log') SIZE 100M,GROUP 3 ('/opt/oracle/oradata/orcl/redo03.log','/opt/oracle/bak/redologfile/redo03.log') SIZE 100M MAXLOGFILES 5 MAXLOGMEMBERS 5 MAXLOGHISTORY 1 MAXDATAFILES 300 CHARACTER SET ZHS16GBK NATIONAL CHARACTER SET AL16UTF16 EXTENT MANAGEMENT LOCAL DATAFILE '/opt/oracle/oradata/orcl/system01.dbf' SIZE 500M REUSE SYSAUX DATAFILE '/opt/oracle/oradata/orcl/sysaux01.dbf' SIZE 325M REUSE DEFAULT TABLESPACE users DATAFILE '/opt/oracle/oradata/orcl/users01.dbf' SIZE 500M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED DEFAULT TEMPORARY TABLESPACE tempts1 TEMPFILE '/opt/oracle/oradata/orcl/temp01.dbf' SIZE 200M REUSE UNDO TABLESPACE undotbs DATAFILE '/opt/oracle/oradata/orcl/undotbs01.dbf' SIZE 200M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED;创建数据字典@$ORACLE_HOME/rdbms/admin/catalog.sql;@$ORACLE_HOME/rdbms/admin/catproc.sql;
配置oracle的网络执行netmgr<最简单的方式>也可以参照sample下面的三个文件创建三个文件即可。
作者: 璇玑CTO 发布时间: 2011-11-24
作者: fairexchange 发布时间: 2011-12-12
相关阅读 更多
热门阅读
-
office 2019专业增强版最新2021版激活秘钥/序列号/激活码推荐 附激活工具
阅读:74
-
如何安装mysql8.0
阅读:31
-
Word快速设置标题样式步骤详解
阅读:28
-
20+道必知必会的Vue面试题(附答案解析)
阅读:37
-
HTML如何制作表单
阅读:22
-
百词斩可以改天数吗?当然可以,4个步骤轻松修改天数!
阅读:31
-
ET文件格式和XLS格式文件之间如何转化?
阅读:24
-
react和vue的区别及优缺点是什么
阅读:121
-
支付宝人脸识别如何关闭?
阅读:21
-
腾讯微云怎么修改照片或视频备份路径?
阅读:28