linux g 手动安装,linux上oracle11g 手动安装

Love The Way You Lie 2022-10-20 12:27 225阅读 0赞

系统环境光：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 g 手动安装,linux上oracle11g 手动安装

发表评论取消回复

还没有评论，来说两句吧...

相关阅读

相关 oracle 10g手动建库,Oracle 10g 手动建库

相关 CentOS Linux下安装Oracle11G

相关 linux g 手动安装,linux上oracle11g 手动安装

相关 Linux下安装oracle11g

相关 Oracle 11g安装

相关 Linux环境安装oracle 11g数据库

相关 Oracle 11g 安装

相关如何在Linux上安装oracle11g【亲测】

相关 linux环境下安装oracle11g

相关 linux下安装oracle 11g