11 G2oracle数据库安装,oracle 11.2R2 数据库静默安装

末蓝、 2023-01-18 09:06 197阅读 0赞

此文是静默安装单机版oracle数据库，如需安装集群模式，或datagruad模式，修改db\_install.rsp相对应的参数值

oracle 11.2R2 数据库静默安装

1.准备环境

linux操作系统(linux x86 环境：Asianux server 3,4 sp2,3;oracle linux 4,5,6;redhat 4,5,6;suse 10,11;

On Linux x86-64:Asianux server 3,4;oracle linux 4,5,6,7;redhat 4,5,6,7;suse 10,11,12;注：centos和redhat是一家，所以centos也是可以安装的版本和redhat一样就好)

oracle 环境要求：

最小内存1G

磁盘最小 5G

2.测试环境

linux x86-64环境

oracle 11.2R2

3.创建oracle用户

\#groupadd oinstall

\#groupadd dba

\#useradd -g oinstall -G dba oracle

\#id oracle

\#yum install -y binutils-2.20.51.0.2-5.11.el6.i686 \\

compat-libcap1-1.10-1.i686 \\

compat-libstdc++-33-3.2.3-69.el6.i686 \\

gcc-4.4.4-13.el6.i686 \\

gcc-c++-4.4.4-13.el6.i686 \\

glibc-2.12-1.7.el6.i686 \\

glibc-devel-2.12-1.7.el6.i686 \\

ksh \\

libgcc-4.4.4-13.el6.i686 \\

libstdc++-4.4.4-13.el6.i686 \\

libstdc++-devel-4.4.4-13.el6.i686 \\

libaio-0.3.107-10.el6.i686 \\

libaio-devel-0.3.107-10.el6.i686 \\

make-3.81-19.el6.i686 \\

sysstat-9.0.4-11.el6.i686

\#vim /etc/sysctl.conf

fs.aio-max-nr = 1048576

fs.file-max = 6815744

kernel.shmall = 2097152

kernel.shmmax = 4294967295

kernel.shmmni = 4096

kernel.sem = 250 32000 100 128

net.ipv4.ip\_local\_port\_range = 9000 65500

net.core.rmem\_default = 262144

net.core.rmem\_max = 4194304

net.core.wmem\_default = 262144

net.core.wmem\_max = 1048576

\#sysctl -p

oracle hard nofile 65536

oracle hard nproc 16384

oracle soft nofile 1024

oracle soft nproc 2047

inst\_group=oinstall

inventory\_loc=/u01/app/oraInventory

\#mkdir /u01/app/

\#mkdir /u01/app/oraInventory

\#mkdir -p /u01/app/product/11.2.0/dbhome\_1

\#chown -R oracle.oinstall /u01/

\#chmod -R 775 /u01/

\#vim /home/oracle/.baserc

export ORACLE\_BASE=/u01/app

export ORACLE\_HOME=$ORACLE\_BASE/product/11.2.0/dbhome\_1

export ORACLE\_SID=ora1

export INVENTORY\_LOCATION=$ORACLE\_BASE/oraInventory

export PATH=$ORACLE\_HOME/bin:$PATH

\#rz

\#cd /u01/

\#ls

linux.x64\_11gR2\_database\_1of2.zip

linux.x64\_11gR2\_database\_2of2.zip

$ cd /u01/

$ unzip linux.x64\_11gR2\_database\_1of2.zip linux.x64\_11gR2\_database\_2of2.zip

$ cd database/response

$ cp \* /opt/

$ cat db\_install.rsp |grep -v '\#'|grep -v ^$

oracle.install.responseFileVersion=/oracle/install/rspfmt\_dbinstall\_response\_schema\_v11\_2\_0

oracle.install.option=INSTALL\_DB\_SWONLY

ORACLE\_HOSTNAME=odc

UNIX\_GROUP\_NAME=oinstall

INVENTORY\_LOCATION=/u01/app/oraInventory

SELECTED\_LANGUAGES=en,zh\_CN

ORACLE\_HOME=/u01/app/product/11.2.0/dbhome\_1

ORACLE\_BASE=/u01/app/

oracle.install.db.InstallEdition=EE

oracle.install.db.isCustomInstall=false

oracle.install.db.customComponents=oracle.server:11.2.0.1.0,oracle.sysman.ccr:10.2.7.0.0,oracle.xdk:11.2.0.1.0,oracle.rdbms.oci:11.2.0.1.0,oracle.network:11.2.0.1.0,oracle.network.listener:11.2.0.1.0,oracle.rdbms:11.2.0.1.0,oracle.options:11.2.0.1.0,oracle.rdbms.partitioning:11.2.0.1.0,oracle.oraolap:11.2.0.1.0,oracle.rdbms.dm:11.2.0.1.0,oracle.rdbms.dv:11.2.0.1.0,orcle.rdbms.lbac:11.2.0.1.0,oracle.rdbms.rat:11.2.0.1.0

oracle.install.db.DBA\_GROUP=dba

oracle.install.db.OPER\_GROUP=oinstall

oracle.install.db.config.starterdb.type=GENERAL\_PURPOSE

oracle.install.db.config.starterdb.globalDBName=ora1

oracle.install.db.config.starterdb.SID=ora1

oracle.install.db.config.starterdb.characterSet=AL32UTF8

oracle.install.db.config.starterdb.memoryOption=true

oracle.install.db.config.starterdb.memoryLimit=512

oracle.install.db.config.starterdb.installExampleSchemas=false

oracle.install.db.config.starterdb.enableSecuritySettings=true

oracle.install.db.config.starterdb.password.ALL=oralce123!

oracle.install.db.config.starterdb.control=DB\_CONTROL

oracle.install.db.config.starterdb.gridcontrol.gridControlServiceURL=

oracle.install.db.config.starterdb.dbcontrol.enableEmailNotification=false

oracle.install.db.config.starterdb.automatedBackup.enable=false

oracle.install.db.config.starterdb.storageType=FILE\_SYSTEM\_STORAGE

oracle.install.db.config.starterdb.fileSystemStorage.dataLocation=FILE\_SYSTEM

oracle.install.db.config.starterdb.fileSystemStorage.recoveryLocation=FILE\_SYSTEM

SECURITY\_UPDATES\_VIA\_MYORACLESUPPORT=false

DECLINE\_SECURITY\_UPDATES=true \#这里的更新一定要是true，这是oracle 11.2r2的bug

$ ./runInstaller -silent -ignorePrereq -force -noconfig -responseFil /opt/db\_install.rsp

Starting Oracle Universal Installer...

Checking Temp space: must be greater than 415 MB. Actual 4211 MB Passed

Checking swap space: must be greater than 150 MB. Actual 32768 MB Passed

Preparing to launch Oracle Universal Installer from /tmp/OraInstall2011-03-02\_04-58-19PM. Please wait ...$ You can find the log of this install session at:

/u01/app/oraInventory/logs/installActions2017-12-15\_03-21-13PM.log

\#The following configuration scripts need to be executed as the "root" user.

\#!/bin/sh

\#Root scripts to run

/u01/app/oracle/product/11.2/dbhome\_1/root.sh

To execute the configuration scripts:

1. Open a terminal window

2. Log in as "root"

3. Run the scripts

4. Return to this window and hit "Enter" key to continue

Successfully Setup Software.

\#/u01/app/oracle/product/11.2/dbhome\_1/root.sh

\#cat /u01/app/product/11.2.0/dbhome\_1/install/root\_odc\_2017-12-15\_15-24-32.log

Running Oracle 11g root.sh script...

The following environment variables are set as:

ORACLE\_OWNER= oracle

ORACLE\_HOME= /u01/app/product/11.2.0/dbhome\_1

Creating /etc/oratab file...

Entries will be added to the /etc/oratab file as needed by

Database Configuration Assistant when a database is created

Finished running generic part of root.sh script.

Now product-specific root actions will be performed.

\#su - oracle

$ netca /silent /responsefile /opt/netca.rsp

Listener Control complete

Listener started successfully.

Listener configuration complete.

Oracle Net Services configuration successful. The exit code is 0

$ lsnrctl status

LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 15-DEC-2017 17:17:50

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))

STATUS of the LISTENER

\------------------------

Alias LISTENER

Version TNSLSNR for Linux: Version 11.2.0.1.0 - Production

Start Date 15-DEC-2017 15:44:41

Uptime 0 days 1 hr. 33 min. 9 sec

Trace Level off

Security ON: Local OS Authentication

SNMP OFF

Listener Parameter File /u01/app/product/11.2.0/dbhome\_1/network/admin/listener.ora

Listener Log File /u01/app/diag/tnslsnr/odc/listener/alert/log.xml

Listening Endpoints Summary...

(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=odc)(PORT=1521)))

Services Summary...

Service "ora1" has 1 instance(s).

Instance "ora1", status READY, has 1 handler(s) for this service...

Service "ora1XDB" has 1 instance(s).

Instance "ora1", status READY, has 1 handler(s) for this service...

The command completed successfully

$ cat dbca.rsp |grep -v ^\# |grep -v ^$

\[GENERAL\]

RESPONSEFILE\_VERSION = "11.2.0"

OPERATION\_TYPE = "createDatabase"

\[CREATEDATABASE\]

GDBNAME = "ora1"

SID = "ora1"

TEMPLATENAME = "General\_Purpose.dbc"

TOTALMEMORY = "512"

$ dbca -silent -responseFile /opt/dbca.rsp

Completing Database Creation

66% complete

70% complete

73% complete

85% complete

96% complete

100% complete

Look at the log file "/u01/app/cfgtoollogs/dbca/orcl11g/orcl11g.log" for further details.

$ ps -ef | grep ora\_ | grep -v grep | wc -l

$ ps -ef | grep ora\_ | grep -v grep

oracle 67680 1 0 15:56 ? 00:00:00 ora\_pmon\_ora1

oracle 67682 1 0 15:56 ? 00:00:02 ora\_vktm\_ora1

oracle 67686 1 0 15:56 ? 00:00:00 ora\_gen0\_ora1

oracle 67688 1 0 15:56 ? 00:00:00 ora\_diag\_ora1

oracle 67690 1 0 15:56 ? 00:00:00 ora\_dbrm\_ora1

oracle 67692 1 0 15:56 ? 00:00:00 ora\_psp0\_ora1

oracle 67694 1 0 15:56 ? 00:00:02 ora\_dia0\_ora1

oracle 67696 1 0 15:56 ? 00:00:00 ora\_mman\_ora1

oracle 67698 1 0 15:56 ? 00:00:00 ora\_dbw0\_ora1

oracle 67700 1 0 15:56 ? 00:00:00 ora\_lgwr\_ora1

oracle 67702 1 0 15:56 ? 00:00:04 ora\_ckpt\_ora1

oracle 67704 1 0 15:56 ? 00:00:00 ora\_smon\_ora1

oracle 67706 1 0 15:56 ? 00:00:00 ora\_reco\_ora1

oracle 67708 1 0 15:56 ? 00:00:01 ora\_mmon\_ora1

oracle 67710 1 0 15:56 ? 00:00:01 ora\_mmnl\_ora1

oracle 67712 1 0 15:56 ? 00:00:00 ora\_d000\_ora1

oracle 67714 1 0 15:56 ? 00:00:00 ora\_s000\_ora1

oracle 67722 1 0 15:56 ? 00:00:00 ora\_qmnc\_ora1

oracle 67736 1 0 15:56 ? 00:00:01 ora\_cjq0\_ora1

oracle 67739 1 0 15:56 ? 00:00:00 ora\_q000\_ora1

oracle 67741 1 0 15:56 ? 00:00:00 ora\_q001\_ora1

oracle 67823 1 0 16:01 ? 00:00:00 ora\_smco\_ora1

oracle 69342 1 0 17:21 ? 00:00:00 ora\_w000\_ora1

$ sqlplus / as sysdba

SQL\*Plus: Release 11.2.0.1.0 Production on Fri Dec 15 17:22:35 2017

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> show user

USER is "SYS"

SQL> select name ,dbid,open\_mode from v$database;

NAME DBID OPEN\_MODE

\--------- ---------- --------------------

ORA1 1439683635 READ WRITE

SQL> col COMP\_ID format a8

SQL> col COMP\_NAME format a35

SQL> col VERSION format a12

SQL> col schema format a12

SQL> col OTHER\_SCHEMAS format a45

SQL> select comp\_id,comp\_name,version,schema,other\_schemas from dba\_registry order by 1;

COMP\_ID COMP\_NAME VERSION SCHEMA

\-------- ----------------------------------- ------------ ------------

OTHER\_SCHEMAS

\---------------------------------------------

AMD OLAP Catalog 11.2.0.1.0 OLAPSYS

APEX Oracle Application Express 3.2.1.00.10 APEX\_030200

FLOWS\_FILES

APS OLAP Analytic Workspace 11.2.0.1.0 SYS

COMP\_ID COMP\_NAME VERSION SCHEMA

\-------- ----------------------------------- ------------ ------------

OTHER\_SCHEMAS ---------------------------------------------

CATALOG Oracle Database Catalog Views 11.2.0.1.0 SYS

CATJAVA Oracle Database Java Packages 11.2.0.1.0 SYS

CATPROC Oracle Database Packages and Types 11.2.0.1.0 SYS

APPQOSSYS,DBSNMP,DIP,ORACLE\_OCM,OUTLN,SYSTEM

COMP\_ID COMP\_NAME VERSION SCHEMA

\-------- ----------------------------------- ------------ ------------

OTHER\_SCHEMAS---------------------------------------------

CONTEXT Oracle Text 11.2.0.1.0 CTXSYS

EM Oracle Enterprise Manager 11.2.0.1.0 SYSMAN

EXF Oracle Expression Filter 11.2.0.1.0 EXFSYS

COMP\_ID COMP\_NAME VERSION SCHEMA

\-------- ----------------------------------- ------------ ------------

OTHER\_SCHEMAS---------------------------------------------

JAVAVM JServer JAVA Virtual Machine 11.2.0.1.0 SYS

ORDIM Oracle Multimedia 11.2.0.1.0 ORDSYS

MDSYS,ORDDATA,ORDPLUGINS,SI\_INFORMTN\_SCHEMA

OWB OWB 11.2.0.1.0 OWBSYS

COMP\_ID COMP\_NAME VERSION SCHEMA

\-------- ----------------------------------- ------------ ------------

OTHER\_SCHEMAS---------------------------------------------

OWM Oracle Workspace Manager 11.2.0.1.0 WMSYS

RUL Oracle Rules Manager 11.2.0.1.0 EXFSYS

SDO Spatial 11.2.0.1.0 MDSYS

COMP\_ID COMP\_NAME VERSION SCHEMA

\-------- ----------------------------------- ------------ ------------

OTHER\_SCHEMAS---------------------------------------------

XDB Oracle XML Database 11.2.0.1.0 XDB

ANONYMOUS,XS$NULL

XML Oracle XDK 11.2.0.1.0 SYS

XOQ Oracle OLAP API 11.2.0.1.0 SYS

18 rows selected.

SQL>shutdown immediate;

SQL> startup mount;

SQL> alter database archivelog; --开启归档日志

SQL> alter database flashback on; --设置闪回区

SQL> alter database open;

SQL> execute utl\_recomp.recomp\_serial();

SQL> alter system archive log current;

11 G2oracle数据库安装,oracle 11.2R2 数据库静默安装

发表评论取消回复

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

相关阅读

相关 Oracle11g数据库快速安装

相关 11 G2oracle数据库安装,oracle 11.2R2 数据库静默安装

相关 Oracle数据库安装-Oracle 11g

相关静默安装oracle 11g

相关 oracle11g数据库的安装

相关安装Oracle 11g数据库

相关 Linux静默安装oracle11gR2

相关静默安装Oracle11G

相关 oracle 11g 静默安装

相关 Oracle数据库第一课2——Oracle数据库的安装步骤、安装Oracle 11g