admin 管理员组

文章数量: 1086019


2024年12月29日发(作者:matlab线性拟合函数)

数据版软件安装

1,

安装oracle 11G 所需要的操作系统环境包

The following, or later versions, of the operating systems are required for Oracle Database

11g Release 2 (11.2):

AIX 5L V5.3 TL 09 SP1 ("5300-09-01"), 64 bit kernel

AIX 6.1 TL 02 SP 1 ("6100-02-01), 64-bit kernel

AIX 7.1 TL 0 SP 1 ("7100-00-01"), 64-bit kernel

AIX 7.2 TL 0 SP1 ("7200-00-01"), 64-bit kernel

The following operating system filesets are required for AIX 5L:

fstat 5.3.9.0

or later

at

ols

.10.1.0.0

or later

.10.1.0.0

or later

3.2.1.8

or later

The following operating system filesets are required for AIX 6.1:

fstat 6.1.2.1

or later

at

ols

.10.1.0.0

or later

.10.1.0.0

or later

3.2.1.8

or later

The following operating system filesets are required for AIX 7.1:

fstat

at

ols

.11.1.0.2

or later

• 3.3.0.11

or later

The following operating system filesets are required for AIX 7.2:

fstat

at

ols

.13.1.2.0

or later

.13.1.2.0

or later

2,

创建oracle用户

The following local operating system groups and users are required if you are installing

Oracle Database:

The Oracle Inventory group (

oinstall

)

The OSDBA group (

dba

)

The Oracle software owner (

oracle

)

# smit mkgroup 创建oinstall和dba组

# smit mkuser 创建oracle用户,同时把oracle的主组设置为oinstall,属组设置为dba

# passwd oracle 给一个密码

# id oracle

uid=202(oracle) gid=201(oinstall) groups=202(dba)

3,

修改系统参数

ulimit

settings :

Limit

Soft FILE size

Soft CPU time

Soft DATA segment

Soft STACK size

Recommended Value

-1 (Unlimited)

-1 (Unlimited)

-1 (Unlimited)

-1 (Unlimited)

Soft Real Memory size -1 (Unlimited)

Processes (per user) -1 (Unlimited)

kernel parameters :

Parameter

maxuprocs

ncargs

tcp_ephemeral_low

tcp_ephemeral_high

udp_ephemeral_low

udp_ephemeral_high

Recommended Value

16384

128

32768

65535

32768

65535

aio_maxreqs

value:

AIX 6.1:

# ioo –o aio_maxreqs

aio_maxreqs = 65536

On AIX 5.3:

# lsattr -El aio0 -a maxreqs

maxreqs 65536 Maximum number of REQUESTS True

4,

创建安装目录

# mkdir -p /u01/app/

# chown -R oracle:oinstall /u01/app/

# chmod -R 775 /u01/app/

5,

运行

Run the

script:

1. Switch user to

root

:

2. $ su -

3. password:

4. #

5. Complete one of the following steps, depending on the location of the installation

files:

o

If the installation files are on DVD, enter a command similar to the following,

where

directory_path

is the disc mount point directory or the path of

the

db

directory on the DVD:

o # /directory_path/rootpre/

o

If the installation files are on the hard disk, change the directory to the path

where

exists and enter the following command:

o # ./

6. Exit from the root account:

7. # exit

6,

安装数据库软件

运行数据库安装命令

$ /mount_point/db/runInstaller

安装数据库软件

Screen

Configure

Security

Updates

Download

Software

Updates

Recommended Action

是否设置自动升级。

Click Next.

Starting with Oracle Database 11

g

Release 2

(11.2.0.2), you can use the Software Updates

feature to dynamically download and apply

latest updates. Select one of the following

options and click Next:

Screen Recommended Action

o

Apply Software

If you selected Use pre-downloaded software updates in the

previous screen, select Apply all updates, and then

Updates

click Next.

Select

Installation

Option

Select Create and configure a

database from the following list of

available options, then click Next:

o

Create and configure a database

o

Install database software only

o

Upgrade an existing database

System Class Select Server Class from the following

options to install the database, and

click Next.

.

Select Single instance database

installation for the type of database

installation you want to perform, and

click Next.

Grid

Installation

Options

Select Install Select Typical Install as the installation

Type type from the following options, and

click Next:

Typical Install

Confirm Password: Reenter, and confirm the password for

Configuration

the privileged database account.

Click Next to continue.

Create

Inventory

This screen is displayed only during the

first installation of Oracle products on a

system.

Specify the full path of the Oracle Inventory directory.

Ensure that the operating system group selected

is

oinstall

. Click Next to continue.

Screen

Perform

Prerequisite

Checks

Recommended Action

Verify that all the prerequisite checks

succeed, and then click Next.

Oracle Universal Installer checks the system to verify that it

is configured correctly to run Oracle software. If you have

completed all the preinstallation steps in this guide, all the

checks should pass.

If a check fails, then review the cause of the failure listed for

that check on the screen. If possible, rectify the problem and

rerun the check. Alternatively, if you are satisfied that your

system meets the requirements, then you can select the

check box for the failed check to manually verify the

requirement.

Note: Oracle recommends that you use caution in checking

the Ignore All option. If you check this option, then Oracle

Universal Installer may not confirm that your system can

install Oracle Database successfully.

Summary Review the information displayed on this

screen, and then click Install.

Note: Starting with Oracle Database 11g Release 2 (11.2),

you can save all the installation steps into a response file by

clicking Save Response File. Later, this file can be used for

a silent installation.

Install Product This screen states the progress of a database

installation. After the database is

installed, you are prompted to execute some

root configuration script for new inventory

as the

root

user. Click Next.

This screen then displays the status information for the

configuration assistants that configure the software and

create a database.

Finally, a message is displayed after the Database

Configuration Assistant process is complete. Click OK.

Execute the

script as the

root

user to complete

the installation and click OK.

Screen

Finish

Recommended Action

This screen is shown automatically when all

the configuration tools are successful.

Click Close.

安装方法与静默安装不同的是在我们先安装oracle软件,再安装数据库(当

然你也可以同时一起安装)我们这里选择与静默安装有所不同,也是两种安装方

式的不同之处。进入/u01/app/oracle/database 目录下运行./runInstaller ,出现如

下图形界面,我们也开始了oracle 11gR2的安装

在第一个画面中我们看系统的环境而定,如果我们是内部的生产系统,不接

入公网我们不需要填写你的oracle support的用户面和密码,这个是用于oracle

官方内部给客户发送补丁更新和服务请求的,这里我们直接跳过,点击”Next“,

然后继续我们的安装。

跳入以下界面中,我们看到三种安装方式,第一种是安装oracle并创建数据

库,第二种是只安装数据库软件,第三是更新一个已存在的数据库,这里我们选

择与静默安装的不同我们这里可以选择第二项只安装数据库软件。

继续“Next”

我们这里两项中选择单库单实例安装,选择第一个,继续下一步

我们看到三种不同版本的数据库,我们选择Enterprise Edition企业版本安装。

继续

到一下界面我们配置oracle base的路径与oracle home的路径,这里其实不需

要配置,

Oracle本身会读取环境变量的内容帮我们填写,我们只需查看是否正确即可,继

续下一步

看到这一步我们也是需要查看之前在操作系统创建的dba、oinstall两个组,以

下是oracle推荐的组的使用方式和

权限的设计,我们选择即可

下一步我们跳入oracle对操作系统环境的检测,我们这里平稳通过。通过继续

下一步

我们开始安装。。。。。。。等待!!!

安装完成后,弹出一个窗口让我们用root用户执行两个脚本我们按照提供的路

径去运行即可,这里oracle软件就安装完成了!

我们继续安装oracle数据库,还是用OUI通用工具dbca来执行数据库的安装,

在命令中输

$ dbca

我们来到如下界面

四个选项中我们选择第一个“Create a Database”创建一个数据库,继续下一步

我们三个选项中选择第一个通用安装,这里我们也可以选择custom database。

继续下一步

数据库的名字我们把Global database name与SID可以相同,我们安装的是单实例这里

可以一致,这里解释一下两者的区别SID: 数据库至少由一个实例引用,该实例由Oracle

系统标识符(SID)唯一地标识,以区别其他实例。Global database name 是扩展物理数

据库名字DB_name的方式,防止多个数据库出现的同名。

来到如下界面我们这里可以选择configure Enterprise Manager,这里不是必选项,看需

求,automatic maintenance tasks 我们保持默认,提示你是否开启自动维护模式

下一步我们选择数据库用户的管理密码,这里我们使用同样的管理密码,密码设

置有要求必须为大小写字母加数字

下面我们配置数据文件的存储类型和位置,我们目前选择默认file system

(JFS2),如果有远端的存储阵列我们可以ASM方式管理

我们继续下一步,看到选择oracle 快速恢复区域设置,这不是个必选项,我们跳

过oracle的特性,这个特性的

选择也要看需求而定。Enable archiving这里也不是必选项,以后也可以配置数

据是否要归档,这里也跳过

下一步我们继续配置数据库的内存、字符集,分配内存时我们需要平衡os和数

据库SGA和PGA的内存总和,这里

我们设置多少要看项目需求,在实验机器上我们分配的是memory_target是

2024MB,sizing选择数据块的大小为8byte,

process默认,character sets字符集选择为zhs16GBk,国际字符集默认,

connection mode 也是默认选择专用模式,我们下一步

来到这个界面,完成oracle数据库安装的基本配置后,我们点击finish,开始自动安装

点击“Finish" 开始安装

oracle 11gr2安装成功。

数据库卸载

从Oracle 11gR2开始,Oracle推荐使用deinstall来卸载Oracle数据库。

交互过程如下:

$ORACLE_HOME/deinstall/deinstall

Checking for required files and bootstrapping ...

Please wait ...

Location of logs /tmp/deinstall2017-09-11_02-50-04PM/logs/

############ ORACLE DEINSTALL & DECONFIG TOOL START ############

######################### CHECK OPERATION START

#########################

## [START] Install check configuration ##

Checking for existence of the Oracle home location /u01/app/oracle/product/11.2.0/db_1

Oracle Home type selected for deinstall is: Oracle Single Instance Database

Oracle Base selected for deinstall is: /u01/app/oracle

Checking for existence of central inventory location /u01/app/oraInventory

Checking for sufficient temp space availability on node(s) : 'DB074'

## [END] Install check configuration ##

Network Configuration check config START

Network de-configuration trace file location: /tmp/deinstall2017-09-11_02-50-

04PM/logs/netdc_check2017-09-11_

Specify all Single Instance listeners that are to be de-configured [LISTENER]:(这里需要确认

监听器名称,默认值没问题,直接回车)

Network Configuration check config END

Database Check Configuration START

Database de-configuration trace file location: /tmp/deinstall2017-09-11_02-50-

04PM/logs/databasedc_check2017-09-11_

Use comma as separator when specifying list of values as input

Specify the list of database names that are configured in this Oracle home [cams]:(这里需

要确认数据库名称,默认值没问题,直接回车)

###### For Database 'cams' ######

Single Instance Database

The diagnostic destination location of the database: /u01/app/oracle/diag/rdbms/cams

Storage type used by the Database: FS

Database file location:

/u01/app/oracle/oradata/cams,/u01/app/oracle/fast_recovery_area/cams,/home/oracle/cam

s/tablespace

Fast recovery area location: /u01/app/oracle/fast_recovery_area/CAMS

database spfile location: /u01/app/oracle/product/11.2.0/db_1/dbs/

The details of database(s) cams have been discovered automatically. Do you still want to

modify the details of cams database(s)? [n]:(这里需要确认数据库详细信息,默认值没问

题,不需要修改,直接回车)

Database Check Configuration END

Enterprise Manager Configuration Assistant START

EMCA de-configuration trace file location: /tmp/deinstall2017-09-11_02-50-

04PM/logs/emcadc_check2017-09-11_

Checking configuration for database cams

Enterprise Manager Configuration Assistant END

Oracle Configuration Manager check START

OCM check log file location : /tmp/deinstall2017-09-11_02-50-

04PM/logs//ocm_

Oracle Configuration Manager check END

######################### CHECK OPERATION END

#########################

####################### CHECK OPERATION SUMMARY

#######################

Oracle Home selected for deinstall is: /u01/app/oracle/product/11.2.0/db_1

Inventory Location where the Oracle home registered is: /u01/app/oraInventory

Following Single Instance listener(s) will be de-configured: LISTENER

The following databases were selected for de-configuration : cams

Database unique name : cams

Storage used : FS

Will update the Enterprise Manager configuration for the following database(s): cams

No Enterprise Manager ASM targets to update

No Enterprise Manager listener targets to migrate

Checking the config status for CCR

Oracle Home exists with CCR directory, but CCR is not configured

CCR check is finished

Do you want to continue (y - yes, n - no)? [n]: y(输入y,然后回车)

A log of this session will be written to: '/tmp/deinstall2017-09-11_02-50-

04PM/logs/deinstall_deconfig2017-09-11_'

Any error messages from this session will be written to: '/tmp/deinstall2017-09-11_02-50-

04PM/logs/deinstall_deconfig2017-09-11_'

######################## CLEAN OPERATION START

########################

Enterprise Manager Configuration Assistant START

EMCA de-configuration trace file location: /tmp/deinstall2017-09-11_02-50-

04PM/logs/emcadc_clean2017-09-11_

Updating Enterprise Manager Database Control configuration for database cams

Updating Enterprise Manager ASM targets (if any)

Updating Enterprise Manager listener targets (if any)

Enterprise Manager Configuration Assistant END

Database de-configuration trace file location: /tmp/deinstall2017-09-11_02-50-

04PM/logs/databasedc_clean2017-09-11_

Database Clean Configuration START cams

This operation may take few minutes.

Database Clean Configuration END cams

Network Configuration clean config START

Network de-configuration trace file location: /tmp/deinstall2017-09-11_02-50-

04PM/logs/netdc_clean2017-09-11_

De-configuring Single Instance listener(s): LISTENER

De-configuring listener: LISTENER

Stopping listener: LISTENER

Warning: Failed to stop listener. Listener may not be running.

Deleting listener: LISTENER

Listener deleted successfully.

Listener de-configured successfully.

De-configuring

Backup files de-configured successfully.

The network configuration has been cleaned up successfully.

Network Configuration clean config END

Oracle Configuration Manager clean START

OCM clean log file location : /tmp/deinstall2017-09-11_02-50-

04PM/logs//ocm_

Oracle Configuration Manager clean END

Setting the force flag to false

Setting the force flag to cleanup the Oracle Base

Oracle Universal Installer clean START

Detach Oracle home '/u01/app/oracle/product/11.2.0/db_1' from the central inventory on

the local node : Done

Delete directory '/u01/app/oracle/product/11.2.0/db_1' on the local node : Done

Delete directory '/u01/app/oraInventory' on the local node : Done

Delete directory '/u01/app/oracle' on the local node : Done

Oracle Universal Installer cleanup was successful.

Oracle Universal Installer clean END

## [START] Oracle install clean ##

Clean install operation removing temporary directory '/tmp/deinstall2017-09-11_02-50-

04PM' on node 'DB074'

## [END] Oracle install clean ##

######################### CLEAN OPERATION END

#########################

####################### CLEAN OPERATION SUMMARY

#######################

Updated Enterprise Manager configuration for database cams

Successfully de-configured the following database instances : cams

Following Single Instance listener(s) were de-configured successfully: LISTENER

Cleaning the config for CCR

As CCR is not configured, so skipping the cleaning of CCR configuration

CCR clean is finished

Successfully detached Oracle home '/u01/app/oracle/product/11.2.0/db_1' from the central

inventory on the local node.

Successfully deleted directory '/u01/app/oracle/product/11.2.0/db_1' on the local node.

Successfully deleted directory '/u01/app/oraInventory' on the local node.

Successfully deleted directory '/u01/app/oracle' on the local node.

Oracle Universal Installer cleanup was successful.

(在deinstall工具执行完之后,需要用root完成删除的内容)

Run 'rm -rf /etc/' as root on node(s) 'DB074' at the end of the session.

Run 'rm -rf /opt/ORCLfmap' as root on node(s) 'DB074' at the end of the session.

Run 'rm -rf /etc/oratab' as root on node(s) 'DB074' at the end of the session.

Oracle deinstall tool successfully cleaned up temporary directories.

##################################################################

#####

############# ORACLE DEINSTALL & DECONFIG TOOL END #############

根据最后的提示信息,切换到root用户,删除相应的文件

rm -rf /etc/

rm -rf /opt/ORCLfmap

rm -rf /etc/oratab

Oracle数据库软件已经删除完毕。


本文标签: 数据库 安装 选择