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数据库软件已经删除完毕。
版权声明:本文标题:aix oracle11 grid安装,卸载 内容由网友自发贡献,该文观点仅代表作者本人, 转载请联系作者并注明出处:http://roclinux.cn/p/1735549516a1675788.html, 本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容,一经查实,本站将立刻删除。
发表评论