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]$

下次咱們開始配置其他節點數據庫,也請同志們多多給出批評、指正

總結

以上是生活随笔為你收集整理的linux安装oem环境,【OEM】 oem12c_install_for_linux的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。