Oracle DBA课程系列笔记(2)

简介:

第二章 Oracle使用

 

 OEM 修复

[oracle@oraserv db_1]$ emctl start dbconsole
TZ set to US/Pacific
OC4J Configuration issue. /u01/app/oracle/product/10.2.0/db_1/oc4j/j2ee/OC4J_DBConsole_oraserv_orcl not found.
[oracle@oraserv db_1]$ emca -repos recreate
 
STARTED EMCA at Feb 18, 2011 4:30:11 AM
EM Configuration Assistant, Version 10.2.0.1.0 Production
Copyright (c) 2003, 2005, Oracle. All rights reserved.
 
Enter the following information:
Database SID: orcl
Listener port number: 1521
Password for SYS user: oracle
Password for SYSMAN user: oracle
Password for SYSMAN user: 
Do you wish to continue? [yes(Y)/no(N)]: y
Feb 18, 2011 4:30:26 AM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /u01/app/oracle/product/10.2.0/db_1/cfgtoollogs/emca/orcl/emca_2011-02-18_04-30-11-AM.log.
Feb 18, 2011 4:30:26 AM oracle.sysman.emcp.EMReposConfig dropRepository
INFO: Dropping the EM repository (this may take a while) ...
                                                                                                    Feb 18, 2011 4:32:34 AM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully dropped
Feb 18, 2011 4:32:35 AM oracle.sysman.emcp.EMReposConfig createRepository
INFO: Creating the EM repository (this may take a while) ...
 
INFO: Repository successfully created
Enterprise Manager configuration completed successfully
FINISHED EMCA at Feb 18, 2011 4:37:47 AM
 
 
[oracle@oraserv db_1]$ emca -config dbcontrol db
 
STARTED EMCA at Feb 18, 2011 4:40:13 AM
EM Configuration Assistant, Version 10.2.0.1.0 Production
Copyright (c) 2003, 2005, Oracle. All rights reserved.
 
Enter the following information:
Database SID: orcl
Listener port number: 1521
Password for SYS user: oracle
Password for DBSNMP user: oracle
Password for SYSMAN user: oracle
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 ................ oraserv
Listener port number ................ 1521
Database SID ................ orcl
Email address for notifications ...............
Outgoing Mail (SMTP) server for notifications ...............
 
-----------------------------------------------------------------
Do you wish to continue? [yes(Y)/no(N)]: y
Feb 18, 2011 4:40:42 AM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /u01/app/oracle/product/10.2.0/db_1/cfgtoollogs/emca/orcl/emca_2011-02-18_04-40-13-AM.log.
Feb 18, 2011 4:40:43 AM oracle.sysman.emcp.DatabaseChecks performReposChecks
WARNING: 'shared_pool_size' must be greater than or equal to 80 MB. 
                                                                                                    Feb 18, 2011 4:40:52 AM oracle.sysman.emcp.ParamsManager getLocalListener
WARNING: Error retrieving listener for oraserv
Feb 18, 2011 4:40:57 AM oracle.sysman.emcp.util.DBControlUtil startOMS
INFO: Starting Database Control (this may take a while) ...
 
Feb 18, 2011 4:42:47 AM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: Database Control started successfully
Feb 18, 2011 4:42:47 AM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: >>>>>>>>>>> The Database Control URL is  http://oraserv:5500/em <<<<<<<<<<<
Enterprise Manager configuration completed successfully
FINISHED EMCA at Feb 18, 2011 4:42:47 AM
 
修复后
 
[oracle@oraserv db_1]$ emctl start dbconsole
TZ set to US/Pacific
Oracle Enterprise Manager 10g Database Control Release 10.2.0.1.0 
Copyright (c) 1996, 2005 Oracle Corporation. All rights reserved.
 - An instance of Oracle Enterprise Manager 10g Database Control is already running.
[oracle@oraserv db_1]$ emctl stop dbconsole
TZ set to US/Pacific
Oracle Enterprise Manager 10g Database Control Release 10.2.0.1.0 
Copyright (c) 1996, 2005 Oracle Corporation. All rights reserved.
Stopping Oracle Enterprise Manager 10g Database Control ...
 ... Stopped.
[oracle@oraserv db_1]$ emctl start dbconsole
TZ set to US/Pacific
Oracle Enterprise Manager 10g Database Control Release 10.2.0.1.0 
Copyright (c) 1996, 2005 Oracle Corporation. All rights reserved.
Starting Oracle Enterprise Manager 10g Database Control ..................... started.
------------------------------------------------------------------
Logs are generated in directory /u01/app/oracle/product/10.2.0/db_1/oraserv_orcl/sysman/log
[oracle@oraserv db_1]$
 









本文转自 客居天涯 51CTO博客,原文链接:http://blog.51cto.com/tiany/791724,如需转载请自行联系原作者
目录
相关文章
|
7月前
|
运维 Oracle 容灾
Oracle dataguard 容灾技术实战(笔记),教你一种更清晰的Linux运维架构
Oracle dataguard 容灾技术实战(笔记),教你一种更清晰的Linux运维架构
|
6月前
|
Oracle 关系型数据库 数据库
oracle基本操作笔记分享
oracle基本操作笔记分享
45 0
|
7月前
|
Oracle 关系型数据库
oracle基本笔记整理及案例分析2
oracle基本笔记整理及案例分析2
|
7月前
|
Oracle 关系型数据库
oracle基本笔记整理及案例分析1
oracle基本笔记整理及案例分析1
|
7月前
|
SQL Oracle 关系型数据库
oracle笔记整理2
oracle笔记整理2
|
7月前
|
SQL Oracle 关系型数据库
oracle基本笔记整理
oracle基本笔记整理
|
SQL Oracle 关系型数据库
Oracle笔记1
Oracle笔记1
138 0
|
SQL Oracle 关系型数据库
docker快速部署oracle19c、oracle12c,测试环境问题复现demo快速搭建笔记
docker快速部署oracle19c、oracle12c,测试环境问题复现demo快速搭建笔记
1903 0
|
人工智能 运维 Oracle
ChatGPT能代替Oracle DBA吗?用Oracle OCP(1z0-083)的真题测试一下(文末投票)
ChatGPT已经通过了很多考试,姚远老师是Oracle OCP和MySQL OCP讲师,我很好奇ChatGPT能不能通过Oracle OCP的考试呢?让我们拿Oracle 19c OCP考试(1z0-082)的真题对ChatGPT进行一个测试。
183 0
|
人工智能 运维 Oracle
ChatGPT能代替Oracle DBA吗?用Oracle OCP(1z0-083)的真题测试一下。
第1道题ChatGPT就做错了,姚远老师心里不禁窃喜,看来ChatGPT也不咋地,我们也许不会失业,让我们来看看第一道题的题目
167 0