CentOS54下安装Oracle11gWord文档下载推荐.docx

CentOS54下安装Oracle11gWord文档下载推荐.docx

《CentOS54下安装Oracle11gWord文档下载推荐.docx》由会员分享，可在线阅读，更多相关《CentOS54下安装Oracle11gWord文档下载推荐.docx（12页珍藏版）》请在冰豆网上搜索。

libstdc++-devel-4.1.2

make-3.81

sysstat-7.0.2

unixODBC-2.2.11

unixODBC-devel-2.2.11

调整内核参数，在/etc/sysctl.conf文件中添加下列参数，并使用sysctl-p命令使其生效

kernel.shmall=268435456

kernel.shmall=2097152

kernel.shmmax=536870912

kernel.shmmni=4096

kernel.sem=25032000100128

net.ipv4.ip_local_port_range=900065500

net.core.rmem_default=262144

net.core.rmem_max=4194304

net.core.wmem_default=262144

net.core.wmem_max=1048586

fs.file-max=6553600

添加Oracle用户和相关的组

[root@oracle~]#groupaddoinstall

[root@oracle~]#groupadddba

[root@oracle~]#mkdir/u01

[root@oracle~]#useradd-goinstall-Gdba-d/u01/oracleoracle

[root@oracle~]#passwdoracle

[root@oracle~]#chown-Roistall:

dba/u01

三．设置Oracle用户环境变量

[oracle@oracle~]$cat.bash_profile

#.bash_profile

#Getthealiasesandfunctions

if[-f~/.bashrc];

then

.~/.bashrc

fi

#Userspecificenvironmentandstartupprograms

PATH=$PATH:

$HOME/bin

exportPATH

ORACLE_BASE=/u01

ORACLE_HOME=$ORACLE_BASE/oracle

ORACLE_SID=sales

PATH=$ORACLE_HOME/bin:

$PATH

exportORACLE_BASEORACLE_HOMEORACLE_SIDPATH

[oracle@oracle~]$env|grepORA

ORACLE_HOME=/u01/oracle

四．开始安装

1：

解压出Linux版Oracle安装包，并将database复制到/u01/oracle目录下，运行/u01/oracle/database目录下的安装脚本runinstaller

[root@oracle~]#/u01/oracle/oraInventory/orainstRoot.sh

Changingpermissionsof/u01/oracle/oraInventoryto770.

Changinggroupnameof/u01/oracle/oraInventorytooinstall.

Theexecutionofthescriptiscomplete

[root@oracle~]#/u01/oracle/root.sh

RunningOracle11groot.shscript...

Thefollowingenvironmentvariablesaresetas:

ORACLE_OWNER=oracle

ORACLE_HOME=/u01/oracle

Enterthefullpathnameofthelocalbindirectory:

[/usr/local/bin]:

Copyingdbhometo/usr/local/bin...

Copyingoraenvto/usr/local/bin...

Copyingcoraenvto/usr/local/bin...

Creating/etc/oratabfile...

Entrieswillbeaddedtothe/etc/oratabfileasneededby

DatabaseConfigurationAssistantwhenadatabaseiscreated

Finishedrunninggenericpartofroot.shscript.

Nowproduct-specificrootactionswillbeperformed.

Finishedproduct-specificrootactions.

五．安装数据库

运行netca,配置网络参数

[oracle@oracle~]$ps-ef

oracle117681008:

04?

00:

00:

01/u01/oracle/bin/tnslsnrLISTENER

root117762276008:

05?

00sshd:

oracle[priv]

oracle1177811776008:

oracle@pts/4

2:

运行dbca，安装数据库

oracle124551008:

25?

00ora_pmon_sales

oracle124571008:

00ora_vktm_sales

oracle124611008:

00ora_diag_sales

oracle124631008:

00ora_dbrm_sales

oracle124651008:

00ora_psp0_sales

oracle124691008:

01ora_dia0_sales

oracle124711008:

03ora_mman_sales

oracle124731008:

03ora_dbw0_sales

oracle124751008:

04ora_lgwr_sales

oracle124771008:

01ora_ckpt_sales

oracle124791008:

01ora_smon_sales

oracle124811008:

00ora_reco_sales

oracle124831008:

07ora_mmon_sales

oracle124851008:

01ora_mmnl_sales

oracle124871008:

00ora_d000_sales

oracle124891008:

00ora_s000_sales

oracle124991008:

00ora_fbda_sales

oracle125011008:

00ora_smco_sales

oracle125031008:

00ora_qmnc_sales

oracle125051008:

00ora_w000_sales

oracle125191008:

00ora_q000_sales

oracle125211008:

00ora_q001_sales

oracle125991008:

26?

02ora_cjq0_sales

oracle153981008:

32pts/200:

00/u01/oracle/perl/bin/perl/u01/o

oracle15412153981808:

02:

05/u01/oracle/jdk/bin/java-server

oracle1543515398208:

17/u01/oracle/bin/emagent

oracle155241008:

33?

05oraclesales（LOCAL=NO）

oracle157081008:

00oraclesales（LOCAL=NO）

oracle1574111008:

01:

03oraclesales（LOCAL=NO）

oracle158451008:

04oraclesales（LOCAL=NO）

oracle160031008:

35?

00ora_w001_sales

oracle160421008:

36?

01oraclesales（LOCAL=NO）

oracle160521008:

oracle160551108:

06oraclesales（LOCAL=NO）

oracle160761008:

02oraclesales（LOCAL=NO）

oracle160791608:

31oraclesales（LOCAL=NO）

oracle160851008:

oracle160871008:

oracle161381008:

oracle161401008:

oracle1614311108:

50oraclesales（LOCAL=NO）

oracle1709111779008:

44pts/400:

00ps-ef

[oracle@oracle~]$sqlplus/nolog

SQL*Plus:

Release11.1.0.6.0-ProductiononMonSep2808:

45:

462009

Copyright（c）1982,2007,Oracle.Allrightsreserved.

SQL>

conn/assysdba

Connected.

启动脚本

#!

/bin/bash

ORACLE_DESC="

Oracle11g"

case"

$1"

in

'

start'

）

echo"

Starting${ORACLE_DESC}"

lsnrctlstart

dbstart$ORACLE_HOME

emctlstartdbconsole

echo

;

stop'

shuttingdown${ORACLE_DESC}"

emctlstopdbconsole

lsnrctlstop

dbshut$ORACLE_HOME

restart'

restarting${ORACLE_DESC}"

$0stop

$0start

*）

usage:

$0{start|stop|restart}"

exit1

esac

exit0