oracle的環境配置-單獨建立資料庫執行個體

標籤：資料庫軟體   oracle   linux   

單獨建立資料庫執行個體

資料庫1    資料庫2
ORCL        LAW  ------RDBMS（服務）
  |                  |
-----------------------
    安裝資料庫軟體（DBMS）


單獨再建立一個RDBMS--LAW

[[email protected] ~]# xhost +
access control disabled, clients can connect from any host  --自動啟動了xmanager passive
[[email protected] ~]# su - oracle
[[email protected] ~]$ export DISPLAY="10.1.1.250:0.0"
[[email protected] ~]$ export LANG=en_US
[[email protected] ~]$ dbca   --注意：選擇字元集為UTF8  不建立LAW的OEM

[[email protected] ~]$ lsnrctl

LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 05-JUN-2014 14:31:51

Copyright (c) 1991, 2005, Oracle.  All rights reserved.

Welcome to LSNRCTL, type "help" for information.

LSNRCTL> status
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 10.2.0.1.0 - Production
Start Date                05-JUN-2014 11:30:50
Uptime                    0 days 3 hr. 1 min. 2 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/oracle/product/10.2.0/db_1/network/admin/listener.ora
Listener Log File         /u01/oracle/product/10.2.0/db_1/network/log/listener.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oracle3)(PORT=1521)))
Services Summary...
Service "LAW" has 1 instance(s).                                              --監聽的第一個執行個體LAW
  Instance "LAW", status READY, has 1 handler(s) for this service...
Service "LAWXDB" has 1 instance(s).
  Instance "LAW", status READY, has 1 handler(s) for this service...
Service "LAW_XPT" has 1 instance(s).
  Instance "LAW", status READY, has 1 handler(s) for this service...
Service "ORCL" has 1 instance(s).                                             --監聽的第二個執行個體ORCL
  Instance "ORCL", status READY, has 1 handler(s) for this service...
Service "ORCLXDB" has 1 instance(s).
  Instance "ORCL", status READY, has 1 handler(s) for this service...
Service "ORCL_XPT" has 1 instance(s).
  Instance "ORCL", status READY, has 1 handler(s) for this service...
Service "PLSExtProc" has 1 instance(s).
  Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully


                 ORCL          LAW（建立了不一定要在記憶體中存在，除非啟動它）
                  |             |
                  ---------------
                    |
                  listener：1521
                    |
---------Linux----port：1521---------
                    |
                  外部串連
----------------------------------------------------------------------------------------
手工配置LAW的OEM

0、臨時修改環境變數

[[email protected] ~]$ export ORACLE_SID=LAW

1、首先要啟動LAW執行個體

2、回合組態工具配置
[[email protected] ~]$ emca -config dbcontrol db -repos recreate

EMCA 開始於 2014-6-5 15:40:12
EM Configuration Assistant 10.2.0.1.0 正式版
著作權 (c) 2003, 2005, Oracle。著作權所有，並保留一切權利。

輸入以下資訊:
資料庫 SID: LAW
監聽程式連接埠號碼: 1521
SYS 使用者的口令:  
DBSNMP 使用者的口令:  
SYSMAN 使用者的口令:  
通知的電子郵件地址 (可選):
通知的發件 (SMTP) 伺服器 (可選):
-----------------------------------------------------------------

已指定以下設定

資料庫 ORACLE_HOME ................ /u01/oracle/product/10.2.0/db_1

資料庫主機名稱 ................ oracle3
監聽程式連接埠號碼 ................ 1521
資料庫 SID ................ LAW
通知的電子郵件地址 ...............
通知的發件 (SMTP) 伺服器 ...............

-----------------------------------------------------------------
是否繼續? [yes(Y)/no(N)]: Y
2014-6-5 15:40:31 oracle.sysman.emcp.EMConfig perform
資訊: 正在將此操作記錄到 /u01/oracle/product/10.2.0/db_1/cfgtoollogs/emca/LAW/emca_2014-06-05_03-40-12-下午.log。
2014-6-5 15:40:32 oracle.sysman.emcp.EMReposConfig dropRepository
資訊: 正在刪除 EM 資料檔案庫 (此操作可能需要一段時間)...
2014-6-5 15:40:32 oracle.sysman.emcp.EMReposConfig invoke
資訊: 已成功刪除資料檔案庫
2014-6-5 15:40:32 oracle.sysman.emcp.EMReposConfig createRepository
資訊: 正在建立 EM 資料檔案庫 (此操作可能需要一段時間)...
2014-6-5 15:41:59 oracle.sysman.emcp.EMReposConfig invoke
資訊: 已成功建立資料檔案庫
2014-6-5 15:42:01 oracle.sysman.emcp.util.DBControlUtil startOMS
資訊: 正在啟動 Database Control (此操作可能需要一段時間)...
2014-6-5 15:43:43 oracle.sysman.emcp.EMDBPostConfig performConfiguration
資訊: 已成功啟動 Database Control
2014-6-5 15:43:43 oracle.sysman.emcp.EMDBPostConfig performConfiguration
資訊: >>>>>>>>>>> Database Control URL 為 http://oracle3:5500/em <<<<<<<<<<<
已成功完成 Enterprise Manager 的配置
EMCA 結束於 2014-6-5 15:43:43

http://10.1.3.3:5500/em/console/aboutApplication
--------------------------------------------------------------------------------------------------------------------
刪除一個資料庫執行個體

[[email protected] ~]$ export ORACLE_SID=LAW
[[email protected] ~]$ dbca   --刪除執行個體LAW

oracle的環境配置-單獨建立資料庫執行個體