| ページ一覧 | ブログ | twitter |  書式 | 書式(表) |

MyMemoWiki

「Oracle 10g Database Control」の版間の差分

提供: MyMemoWiki
ナビゲーションに移動 検索に移動
 
1行目: 1行目:
==Oracle 10g Database Control==
+
==[[Oracle 10g Database Control]]==
 
[[Oracle Database10g]] |  
 
[[Oracle Database10g]] |  
===Database Controlの起動と停止===
+
===[[Database]] Controlの起動と停止===
 
====起動====
 
====起動====
 
  $emctl start dbconsole
 
  $emctl start dbconsole
 
  TZ set to Japan
 
  TZ set to Japan
  Oracle Enterprise Manager 10g Database Control Release 10.2.0.1.0   
+
  Oracle Enterprise Manager 10g [[Database]] Control Release 10.2.0.1.0   
  Copyright (c) 1996, 2005 Oracle Corporation.  All rights reserved.
+
  Copyright (c) 1996, 2005 [[Oracle]] Corporation.  All rights reserved.
 
  http://localhost.localdomain:1158/em/console/aboutApplication
 
  http://localhost.localdomain:1158/em/console/aboutApplication
  Starting Oracle Enterprise Manager 10g Database Control ................. started.  
+
  Starting Oracle Enterprise Manager 10g [[Database]] Control ................. started.  
 
  ------------------------------------------------------------------
 
  ------------------------------------------------------------------
 
  Logs are generated in directory /opt/oracle/app/oracle/product/10.2.0 /db_1/vboxfedora10_oradb1/sysman/log  
 
  Logs are generated in directory /opt/oracle/app/oracle/product/10.2.0 /db_1/vboxfedora10_oradb1/sysman/log  
15行目: 15行目:
 
  $ emctl status dbconsole
 
  $ emctl status dbconsole
 
  TZ set to Japan
 
  TZ set to Japan
  Oracle Enterprise Manager 10g Database Control Release 10.2.0.1.0   
+
  Oracle Enterprise Manager 10g [[Database]] Control Release 10.2.0.1.0   
  Copyright (c) 1996, 2005 Oracle Corporation.  All rights reserved.
+
  Copyright (c) 1996, 2005 [[Oracle]] Corporation.  All rights reserved.
 
  http://localhost.localdomain:1158/em/console/aboutApplication
 
  http://localhost.localdomain:1158/em/console/aboutApplication
  Oracle Enterprise Manager 10g is running.  
+
  [[Oracle]] Enterprise Manager 10g is running.  
 
  ------------------------------------------------------------------
 
  ------------------------------------------------------------------
 
  Logs are generated in directory /opt/oracle/app/oracle/product/10.2.0/db_1/vboxfedora10_oradb1/sysman/log  
 
  Logs are generated in directory /opt/oracle/app/oracle/product/10.2.0/db_1/vboxfedora10_oradb1/sysman/log  
25行目: 25行目:
 
  $ emctl stop dbconsole
 
  $ emctl stop dbconsole
 
  TZ set to Japan
 
  TZ set to Japan
  Oracle Enterprise Manager 10g Database Control Release 10.2.0.1.0   
+
  Oracle Enterprise Manager 10g [[Database]] Control Release 10.2.0.1.0   
  Copyright (c) 1996, 2005 Oracle Corporation.  All rights reserved.
+
  Copyright (c) 1996, 2005 [[Oracle]] Corporation.  All rights reserved.
 
  http://localhost.localdomain:1158/em/console/aboutApplication
 
  http://localhost.localdomain:1158/em/console/aboutApplication
  Stopping Oracle Enterprise Manager 10g Database Control ...  
+
  Stopping Oracle Enterprise Manager 10g [[Database]] Control ...  
 
   ...  Stopped.  
 
   ...  Stopped.  
  
 
===接続===
 
===接続===
====URL====
+
====U[[R]]L====
 
  http://ホスト名:ポート番号/em
 
  http://ホスト名:ポート番号/em
 
====ポート番号の確認====
 
====ポート番号の確認====
  $ cat $ORACLE_HOME/install/portlist.ini
+
  $ cat $O[[R]]ACLE_HOME/install/portlist.ini
  iSQL*Plus HTTP port number =5560
+
  iSQL*Plus [[HTTP]] port number =5560
  Enterprise Manager Console HTTP Port (oradb1) = 1158
+
  Enterprise Manager Console [[HTTP]] Port (oradb1) = 1158
 
  Enterprise Manager Agent Port (oradb1) = 3938
 
  Enterprise Manager Agent Port (oradb1) = 3938
  Enterprise ManagerコンソールのHTTPポート(oradb1) = 1158
+
  Enterprise Managerコンソールの[[HTTP]]ポート(oradb1) = 1158
 
  Enterprise Managerエージェントのポート(oradb1) = 3938
 
  Enterprise Managerエージェントのポート(oradb1) = 3938
 
====ログイン====
 
====ログイン====
56行目: 56行目:
  
 
====起動====
 
====起動====
=====データベースが停止した状態でDatabase Controlへログインした状態=====
+
=====データベースが停止した状態で[[Database]] Controlへログインした状態=====
 
[[File:0834_dbstart01.jpg]]
 
[[File:0834_dbstart01.jpg]]
=====OSユーザとOracleユーザの入力を求められる=====
+
=====OSユーザと[[Oracle]]ユーザの入力を求められる=====
 
[[File:0835_dbstart02.jpg]]
 
[[File:0835_dbstart02.jpg]]
  

2020年2月16日 (日) 04:29時点における最新版

Oracle 10g Database Control

Oracle Database10g |

Database Controlの起動と停止

起動

$emctl start dbconsole
TZ set to Japan
Oracle Enterprise Manager 10g Database Control Release 10.2.0.1.0  
Copyright (c) 1996, 2005 Oracle Corporation.  All rights reserved.
http://localhost.localdomain:1158/em/console/aboutApplication
Starting Oracle Enterprise Manager 10g Database Control ................. started. 
------------------------------------------------------------------
Logs are generated in directory /opt/oracle/app/oracle/product/10.2.0 /db_1/vboxfedora10_oradb1/sysman/log 

状態確認

$ emctl status dbconsole
TZ set to Japan
Oracle Enterprise Manager 10g Database Control Release 10.2.0.1.0  
Copyright (c) 1996, 2005 Oracle Corporation.  All rights reserved.
http://localhost.localdomain:1158/em/console/aboutApplication
Oracle Enterprise Manager 10g is running. 
------------------------------------------------------------------
Logs are generated in directory /opt/oracle/app/oracle/product/10.2.0/db_1/vboxfedora10_oradb1/sysman/log 

停止

$ emctl stop dbconsole
TZ set to Japan
Oracle Enterprise Manager 10g Database Control Release 10.2.0.1.0  
Copyright (c) 1996, 2005 Oracle Corporation.  All rights reserved.
http://localhost.localdomain:1158/em/console/aboutApplication
Stopping Oracle Enterprise Manager 10g Database Control ... 
 ...  Stopped. 

接続

URL

http://ホスト名:ポート番号/em

ポート番号の確認

$ cat $ORACLE_HOME/install/portlist.ini
iSQL*Plus HTTP port number =5560
Enterprise Manager Console HTTP Port (oradb1) = 1158
Enterprise Manager Agent Port (oradb1) = 3938
Enterprise ManagerコンソールのHTTPポート(oradb1) = 1158
Enterprise Managerエージェントのポート(oradb1) = 3938

ログイン

SYS,SYSMAN,SYSTEMとしてログオンすると、「データベース」ページが表示される 0833 dbctl01.jpg

リスナーの起動と停止

データベースページのホームから、リスナーを選択

0839 lsnr01.jpg

開始または停止

0840 lsnr02.jpg

OSユーザとしてログオンを行う

0841 lsnr03.jpg

データベースの起動と停止

起動

データベースが停止した状態でDatabase Controlへログインした状態

0834 dbstart01.jpg

OSユーザとOracleユーザの入力を求められる

0835 dbstart02.jpg

停止

停止を押下

0836 dbstop01.jpg

即時停止(shoutdown immediate)がデフォルト

0837 dbstop02.jpg

拡張オプションを選択で、モードを選択できる

0838 dbstop03.jpg