linux上oracle11g 手动安装
来源:互联网 发布:网络怎样阅卷 编辑:程序博客网 时间:2024/06/05 22:52
系统环境光: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下面的三个文件创建三个文件即可。
- linux上oracle11g 手动安装
- 如何在Linux上安装oracle11g【亲测】
- LINUX上安装ORACLE11g grid组件
- linux(64)上oracle11g的安装
- Linux 上完全手动编译安装 Lighttpd
- Linux 上完全手动编译安装 Lighttpd
- fedora10 上oracle11g 安装
- CentOS上安装Oracle11g
- redhat上安装oracle11g
- win8s上oracle11g安装
- Oracle11G 在Linux上安装(静默安装)
- Oracle11G 在Linux上安装(静默安装)
- Maven管理Oracle11g JDBC驱动(手动安装oracle11g)详细版
- oracle11g 手动创建database全过程 (linux)
- linux 安装oracle11g 命令
- Oracle11g在Linux安装
- linux 安装oracle11g 步骤
- Linux 安装oracle11g
- 几道容易出错的指针题
- 习语言系列作品
- C/C++ 经典 面试题
- 安装cppdb
- java-管道流
- linux上oracle11g 手动安装
- leveldb源代码分析1
- 嵌入式学习的个人总结
- 《C陷阱与缺陷》 第五章 库函数
- MFC用ADO动态连接msado15.dll时问题
- C#执行带参数的存储过程一个事例
- MVC设计模式:将Web应用分三层
- Cadence Allegro 16.5 详细破解步骤
- Graphics->BitmapMesh