oem12c_install_for_linux
一、状况描述
伴随着oracle database
12c的登场,作为DBA的工作好像越来越少,软件的功能更加智能化、人性化,不知是咱喜欢得瑟还是爱与表现,总喜欢打开的终端,在那无止境的敲打着代码,其实也挺累的。既然工具都出来了,那就用呗,效果直观还有利于管理,管理数据库不就更简单了吗。下面,咱看一下oem12c在linux的安装吧。
二、环境准备
Redhat5.4_x64+em12cr2p1+oracle11.2.0.4
在linux下安装oracle这里不再详细说明,安装之前需建好用户,配置相应系统参数、软件包。查看数据库是否可正常访问。
alter
system set processes= 500 scope=spfile;
alter
system set session_cached_cursors=500 scope=spfile;
alter
system set shared_pool_size=650M scope=spfile;
alter
system set job_queue_processes=22 scope=spfile;
alter
database add logfile size 320M;
alter
system set open_cursors=350 scope=spfile;
alter
system set sga_target=2g scope=spfile;
ALTER
SYSTEM SET pga_aggregate_target=1G SCOPE=SPFILE;
$ORACLE_HOME/bin/emca
-deconfig dbcontrol db -repos drop
三、安装过程
启动安装界面
如下图所示,由于是虚拟机安装,系统内存等不符合其安装要求,glibc软件版本低,
选择好安装目录,并填写操作系统的hostname
输入密码,至少8位,填写存储信息的数据库实例信息
检查oracle数据库参数是否符合安装要求
给出如下警告,提示你对数据库参数应设置的数值
数据库参数修改完成,查看
SQL> show parameter
processes
NAME TYPE VALUE
------------------------------------ -----------
------------------------------
aq_tm_processes integer
1
db_writer_processes integer
1
gcs_server_processes integer
0
global_txn_processes integer
1
job_queue_processes integer
1000
log_archive_max_processes integer
4
processes integer 301
---至少300
SQL> show parameter
memory
NAME TYPE VALUE
------------------------------------ -----------
------------------------------
hi_shared_memory_address integer
0
memory_max_target big integer
696M
memory_target big integer 696M
---确认
shared_memory_address integer
0
SQL> show parameter
session_c
NAME TYPE VALUE
------------------------------------ -----------
------------------------------
session_cached_cursors integer 201
-------至少200
SQL> show parameter
shared_p
NAME TYPE VALUE
------------------------------------ -----------
------------------------------
shared_pool_reserved_size big
integer 6501171
shared_pool_size big integer 0
------自动调整
SQL>
确认无误后点击安装
安装过程中,可点击 view log
查看安装日志
执行一下脚本
[root@oradb2 ~]#
/oracle/oem12c/oms/allroot.sh
Starting to execute allroot.sh
.........
Starting to execute
/oracle/oem12c/oms/root.sh ......
Running Oracle 11g root.sh
script...
The following environment variables
are set as:
ORACLE_OWNER= oracle
ORACLE_HOME=
/oracle/oem12c/oms
Enter the full pathname of the
local bin directory: [/usr/local/bin]:
The file "dbhome" already exists in
/usr/local/bin. Overwrite it? (y/n)
[n]:
The file "oraenv" already exists in
/usr/local/bin. Overwrite it? (y/n)
[n]:
The file "coraenv" already exists
in /usr/local/bin. Overwrite it? (y/n)
[n]:
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.
/etc exist
Creating /etc/oragchomelist
file...
/oracle/oem12c/oms
Finished execution of
/oracle/oem12c/oms/root.sh ......
Starting to execute
/oracle/agent/core/12.1.0.2.0/root.sh ......
Finished product-specific root
actions.
/etc exist
Finished execution of
/oracle/agent/core/12.1.0.2.0/root.sh ......
[root@oradb2 ~]#
完成安装,虚拟机下安装该软件用了2个多小时,提示em管理、控制登录地址。
下面是oem安装后主目录下内容(我们可以看出,服务是通过weblogic管理的)
管理OEM服务的界面
登录oms控制台
为EMREP数据库用户解锁并设置密码
SQL> alter user DBSNMP
identified by oracle account unlock;
User altered.
SQL>
可选择常用功能模块设置为主页
查看已添加主机(本机)
添加监控数据库
选择搜索列表
如上图所示,可添加描述信息,便于管理数据库
下图为数据库实例监控信息(由于浏览器版本低,下图通过远程登录显示内容),这样我们能直观看出EMREP数据库信息
OMS 停止和启动
[oracle@oradb2 bin]$ ./emctl stop
oms
Oracle Enterprise Manager Cloud
Control 12c Release 2
Copyright (c) 1996, 2012 Oracle
Corporation. All rights reserved.
Stopping WebTier...
WebTier Successfully
Stopped
Stopping Oracle Management
Server...
Oracle Management Server
Successfully Stopped
Oracle Management Server is
Down
[oracle@oradb2 bin]$ pwd
/oracle/oem12c/oms/bin
[oracle@oradb2 bin]$
[oracle@oradb2 bin]$ ./emctl start
oms
Oracle Enterprise Manager Cloud
Control 12c Release 2
Copyright (c) 1996, 2012 Oracle
Corporation. All rights reserved.
Starting Oracle Management
Server...
Starting WebTier...
WebTier Successfully
Started
Oracle Management Server
Successfully Started
Oracle Management Server is
Up
[oracle@oradb2 bin]$
下次咱们开始配置其他节点数据库,也请同志们多多给出批评、指正