如何手工重建10g database console
以下紅色字型表示要求我們輸入的資訊。
1) 使用emca -deconfig dbcontrol db命令刪除db console的配置:
[oracle@ocm ~]$ emca -deconfig dbcontrol db
STARTED EMCA at Sep 4, 2007 5:00:09 PM
EM Configuration Assistant, Version 10.2.0.1.0 Production
Copyright (c) 2003, 2005, Oracle. All rights reserved.
Enter the following information:
Database SID: prod
Do you wish to continue? [yes(Y)/no(N)]: yes
Sep 4, 2007 5:00:18 PM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /u01/app/oracle/product/10.2.0/db_1/cfgtoollogs/emca/prod/emca_2007-09-04_05-00-09-PM.log.
Sep 4, 2007 5:00:20 PM oracle.sysman.emcp.util.DBControlUtil stopOMS
INFO: Stopping Database Control (this may take a while) ...
Enterprise Manager configuration completed successfully
FINISHED EMCA at Sep 4, 2007 5:00:46 PM
2) 使用emca -repos drop刪除EM資訊庫
[oracle@ocm ~]$ emca -repos drop
STARTED EMCA at Sep 4, 2007 5:01:10 PM
EM Configuration Assistant, Version 10.2.0.1.0 Production
Copyright (c) 2003, 2005, Oracle. All rights reserved.
Enter the following information:
Database SID: prod
Listener port number: 1521
Password for SYS user:
Password for SYSMAN user:
Do you wish to continue? [yes(Y)/no(N)]: y
Sep 4, 2007 5:01:24 PM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /u01/app/oracle/product/10.2.0/db_1/cfgtoollogs/emca/prod/emca_2007-09-04_05-01-09-PM.log.
Sep 4, 2007 5:01:24 PM oracle.sysman.emcp.EMReposConfig dropRepository
INFO: Dropping the EM repository (this may take a while) ...
Sep 4, 2007 5:05:19 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully dropped
Enterprise Manager configuration completed successfully
FINISHED EMCA at Sep 4, 2007 5:05:19 PM
3) 使用emca -repos create來建立資訊庫
[oracle@ocm ~]$ emca -repos create
STARTED EMCA at Sep 4, 2007 5:06:42 PM
EM Configuration Assistant, Version 10.2.0.1.0 Production
Copyright (c) 2003, 2005, Oracle. All rights reserved.
Enter the following information:
Database SID: prod
Listener port number: 1521
Password for SYS user:
Password for SYSMAN user:
Password for SYSMAN user:
Do you wish to continue? [yes(Y)/no(N)]: y
Sep 4, 2007 5:06:53 PM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /u01/app/oracle/product/10.2.0/db_1/cfgtoollogs/emca/prod/emca_2007-09-04_05-06-42-PM.log.
Sep 4, 2007 5:06:53 PM oracle.sysman.emcp.EMReposConfig createRepository
INFO: Creating the EM repository (this may take a while) ...
Sep 4, 2007 5:12:17 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully created
Enterprise Manager configuration completed successfully
FINISHED EMCA at Sep 4, 2007 5:12:17 PM
4) 使用emca -config dbcontrol db建立配置資訊
[oracle@ocm ~]$ emca -config dbcontrol db
STARTED EMCA at Sep 4, 2007 5:13:16 PM
EM Configuration Assistant, Version 10.2.0.1.0 Production
Copyright (c) 2003, 2005, Oracle. All rights reserved.
Enter the following information:
Database SID: prod
Listener port number: 1521
Password for SYS user:
Password for DBSNMP user:
Password for SYSMAN user:
Email address for notifications (optional):
Outgoing Mail (SMTP) server for notifications (optional):
-----------------------------------------------------------------
You have specified the following settings
Database ORACLE_HOME ................ /u01/app/oracle/product/10.2.0/db_1
Database hostname ................ ocm
Listener port number ................ 1521
Database SID ................ prod
Email address for notifications ...............
Outgoing Mail (SMTP) server for notifications ...............
-----------------------------------------------------------------
Do you wish to continue? [yes(Y)/no(N)]: y
Sep 4, 2007 5:13:39 PM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /u01/app/oracle/product/10.2.0/db_1/cfgtoollogs/emca/prod/e mca_2007-09-04_05-13-16-PM.log.
Sep 4, 2007 5:13:40 PM oracle.sysman.emcp.DatabaseChecks performReposChecks
WARNING: 'shared_pool_size' must be greater than or equal to 80 MB.
Sep 4, 2007 5:13:55 PM oracle.sysman.emcp.util.DBControlUtil startOMS
INFO: Starting Database Control (this may take a while) ...
Sep 4, 2007 5:15:49 PM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: Database Control started successfully
Sep 4, 2007 5:15:57 PM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: >>>>>>>>>>> The Database Control URL is http://ocm:1158/em <<<<<<<<<<<
Enterprise Manager configuration completed successfully
FINISHED EMCA at Sep 4, 2007 5:15:58 PM
1) 使用emca -deconfig dbcontrol db命令刪除db console的配置:
[oracle@ocm ~]$ emca -deconfig dbcontrol db
STARTED EMCA at Sep 4, 2007 5:00:09 PM
EM Configuration Assistant, Version 10.2.0.1.0 Production
Copyright (c) 2003, 2005, Oracle. All rights reserved.
Enter the following information:
Database SID: prod
Do you wish to continue? [yes(Y)/no(N)]: yes
Sep 4, 2007 5:00:18 PM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /u01/app/oracle/product/10.2.0/db_1/cfgtoollogs/emca/prod/emca_2007-09-04_05-00-09-PM.log.
Sep 4, 2007 5:00:20 PM oracle.sysman.emcp.util.DBControlUtil stopOMS
INFO: Stopping Database Control (this may take a while) ...
Enterprise Manager configuration completed successfully
FINISHED EMCA at Sep 4, 2007 5:00:46 PM
2) 使用emca -repos drop刪除EM資訊庫
[oracle@ocm ~]$ emca -repos drop
STARTED EMCA at Sep 4, 2007 5:01:10 PM
EM Configuration Assistant, Version 10.2.0.1.0 Production
Copyright (c) 2003, 2005, Oracle. All rights reserved.
Enter the following information:
Database SID: prod
Listener port number: 1521
Password for SYS user:
Password for SYSMAN user:
Do you wish to continue? [yes(Y)/no(N)]: y
Sep 4, 2007 5:01:24 PM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /u01/app/oracle/product/10.2.0/db_1/cfgtoollogs/emca/prod/emca_2007-09-04_05-01-09-PM.log.
Sep 4, 2007 5:01:24 PM oracle.sysman.emcp.EMReposConfig dropRepository
INFO: Dropping the EM repository (this may take a while) ...
Sep 4, 2007 5:05:19 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully dropped
Enterprise Manager configuration completed successfully
FINISHED EMCA at Sep 4, 2007 5:05:19 PM
3) 使用emca -repos create來建立資訊庫
[oracle@ocm ~]$ emca -repos create
STARTED EMCA at Sep 4, 2007 5:06:42 PM
EM Configuration Assistant, Version 10.2.0.1.0 Production
Copyright (c) 2003, 2005, Oracle. All rights reserved.
Enter the following information:
Database SID: prod
Listener port number: 1521
Password for SYS user:
Password for SYSMAN user:
Password for SYSMAN user:
Do you wish to continue? [yes(Y)/no(N)]: y
Sep 4, 2007 5:06:53 PM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /u01/app/oracle/product/10.2.0/db_1/cfgtoollogs/emca/prod/emca_2007-09-04_05-06-42-PM.log.
Sep 4, 2007 5:06:53 PM oracle.sysman.emcp.EMReposConfig createRepository
INFO: Creating the EM repository (this may take a while) ...
Sep 4, 2007 5:12:17 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully created
Enterprise Manager configuration completed successfully
FINISHED EMCA at Sep 4, 2007 5:12:17 PM
4) 使用emca -config dbcontrol db建立配置資訊
[oracle@ocm ~]$ emca -config dbcontrol db
STARTED EMCA at Sep 4, 2007 5:13:16 PM
EM Configuration Assistant, Version 10.2.0.1.0 Production
Copyright (c) 2003, 2005, Oracle. All rights reserved.
Enter the following information:
Database SID: prod
Listener port number: 1521
Password for SYS user:
Password for DBSNMP user:
Password for SYSMAN user:
Email address for notifications (optional):
Outgoing Mail (SMTP) server for notifications (optional):
-----------------------------------------------------------------
You have specified the following settings
Database ORACLE_HOME ................ /u01/app/oracle/product/10.2.0/db_1
Database hostname ................ ocm
Listener port number ................ 1521
Database SID ................ prod
Email address for notifications ...............
Outgoing Mail (SMTP) server for notifications ...............
-----------------------------------------------------------------
Do you wish to continue? [yes(Y)/no(N)]: y
Sep 4, 2007 5:13:39 PM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /u01/app/oracle/product/10.2.0/db_1/cfgtoollogs/emca/prod/e mca_2007-09-04_05-13-16-PM.log.
Sep 4, 2007 5:13:40 PM oracle.sysman.emcp.DatabaseChecks performReposChecks
WARNING: 'shared_pool_size' must be greater than or equal to 80 MB.
Sep 4, 2007 5:13:55 PM oracle.sysman.emcp.util.DBControlUtil startOMS
INFO: Starting Database Control (this may take a while) ...
Sep 4, 2007 5:15:49 PM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: Database Control started successfully
Sep 4, 2007 5:15:57 PM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: >>>>>>>>>>> The Database Control URL is http://ocm:1158/em <<<<<<<<<<<
Enterprise Manager configuration completed successfully
FINISHED EMCA at Sep 4, 2007 5:15:58 PM
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/9842/viewspace-349433/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- oracle 10g flashback databaseOracle 10gDatabase
- Scheduler in Oracle Database 10g(轉)OracleDatabase
- 如何設定h2 console
- 如何做好手工測試?
- 教你如何在 elasticsearch 中重建索引Elasticsearch索引
- 如何在Mac上重建Spotlight索引Mac索引
- 禁用console
- js中console日誌詳解 | console groupJS
- 幽默:重建模、重建和重構
- 新手必看:如何在Mac上重建Spotlight索引Mac索引
- The database owner SID recorded in the master database differs from the database owner SID recorded in database 'DB_NAME'DatabaseAST
- 重建索引索引
- 索引重建索引
- MySQL 如何重建/恢復刪除的 sys SchemaMySql
- Containerd 的 Bug 導致容器被重建!如何避免?AI
- 手工測試如何打破壁障轉型升級
- Oracle Database Cloud - Database as a Service Quick StartOracleDatabaseCloudUI
- Error querying database. XXXXXXXXXXXXX, No database selected。ErrorDatabase
- Convert a Physical Standby Database into a Snapshot Standby DatabaseDatabase
- 如何在10g中修改資料庫字符集資料庫
- 10g RAC on AIXAI
- console 除錯技巧除錯
- console除錯命令除錯
- Console LDAP 配置解密LDA解密
- oracle重建ocrOracle
- Database TimeoutDatabase
- Database OverallDatabase
- database no shardingDatabase
- 如何使用Fdisk來快速重建隨身碟分割槽?Fdisk快速重建隨身碟分割槽的方法步驟
- 10G DG SWITCH OVER
- 前端console log之坑。。。前端
- C# Console.BeepC#
- console.不止有log
- Vue移除Console.log()Vue
- oracle重建索引(一)Oracle索引
- oracle重建索引(三)Oracle索引
- oracle DBA 角色重建Oracle
- oracle重建索引(二)Oracle索引