问题背景环境
操作系统：suse linux 11 sp1
数据库：oracle 10.2.0.5
问题：不能使用em管理器，但是10.2.0.1是可以用的，打了补丁就不行了。
问题解决办法：
此为oracle数据库在该版本的BUG，Oracle专门发布了补丁8350262来解决这一问题。此bug在1222603.1有详细描述。也就意味着以后升级到10204或10205版本，如果要使用em，补丁8350262成为了必打之补丁。
oracle官方的描述如下：
In Enterprise Manager Database Control with Oracle Database 10.2.0.4 and 10.2.0.5, the root certificate used to secure communications via the Secure Socket Layer (SSL) protocol will expire on 31-Dec-2010 00:00:00. The certificate expiration will cause errors if you attempt to configure Database Control on or after 31-Dec-2010. Existing Database Control configurations are not affected by this issue.
___________________________________________________________________________________
版权所有，文章允许转载，但必须以链接方式注明源地址，否则追究法律责任!
Author: laven54 (lurou)
Email: laven54@163.com
Blog: http://blog.csdn.net/laven54
If you plan to configure Database Control with either of these Oracle Database releases, Oracle strongly recommends that you apply Patch 8350262 to your Oracle Home installations before you configure Database Control. Configuration of Database Control is typically done when you create or upgrade Oracle Database, or if you run Enterprise Manager Configuration Assistant (EMCA) in standalone mode.
大致意思是用于em通信的ssl由于在2010-12-31日00:00之后失效，导致之后的em安装将会报如下错误：
引用
2011-01-09 09:36:56 Thread-51125136 ERROR pingManager: nmepm_pingReposURL: Cannot connect to https://myhost:1158/em/upload/: retStatus=-1
2011-01-09 09:36:56 Thread-51125136 ERROR ssl: Open wallet failed, ret = 28750
2011-01-09 09:36:56 Thread-51125136 ERROR ssl: nmehlenv_openWallet failed
2011-01-09 09:36:56 Thread-51125136 ERROR http: 15: Unable to initialize ssl connection withserver, aborting connection attempt
p8350262_10204_Generic.ziphttp://dl.iteye.com/topics/download/cad88a9d-bb88-3b9b-8acd-daa3c5054f2e
p8350262_10205_Generic.ziphttp://dl.iteye.com/topics/download/c9e40628-cd05-33ef-b1df-ad5420a6d9f4
问题解决过程：
1、查看OPatch所在路径：
ebdbpro:/soft> env | grep ORA
ORA_CRS_HOME=/eb_db/oracle/product/10.2/crs
ORA_ASM_HOME=/eb_db/oracle/product/10.2/asm
ORA_NLS10=/eb_db/oracle/product/10.2/db/nls/data
ORACLE_SID=ebai
ORACLE_BASE=/opt/oracle
ORACLE_HOME=/eb_db/oracle/product/10.2/db
ebdbpro:/soft> cd $ORACLE_HOME/OPatch
ebdbpro:/eb_db/oracle/product/10.2/db/OPatch> ls
crs docs emdpatch.pl jlib ocm opatchopatch.iniopatch.plopatchprereqs
ebdbpro:/eb_db/oracle/product/10.2/db/OPatch> pwd
/eb_db/oracle/product/10.2/db/OPatch
ebdbpro:/eb_db/oracle/product/10.2/db/OPatch>
可执行文件opatch就再这个目录下面。
2、上传文件并进行解压：
ebdbpro:/soft> ls
10201_database_linux_x86_64.cpioDisk1README.htm
8350262 orarun-1.9-172.20.21.54.x86_64.rpm suse11_HA_64
8350262.bakp8202632_10205_Linux-x86-64.zip
database p8350262_10205_Generic.zip
ebdbpro:/soft>unzip p8350262_10205_Generic.zip
3、切换用户进行操作。opatch只允许oracle用户来进行操作。
ebdbpro:/soft/8350262 # su - oracle
ebdbpro:~> cd /soft
ebdbpro:/soft> ls
10201_database_linux_x86_64.cpio
8350262
8350262.bak
database
Disk1
orarun-1.9-172.20.21.54.x86_64.rpm
p8202632_10205_Linux-x86-64.zip
p8350262_10205_Generic.zip
README.htm
suse11_HA_64
ebdbpro:/soft> cd 8350262
ebdbpro:/soft/8350262> ls
etc files killDBConsole killDBConsole.pl README.txt
4、执行opatch小补丁安装操作：
ebdbpro:/soft/8350262> /eb_db/oracle/product/10.2/db/OPatch/opatch apply
Invoking OPatch 10.2.0.4.9
Oracle Interim Patch Installer version 10.2.0.4.9
Copyright (c) 2009, Oracle Corporation.All rights reserved.
Oracle Home: /eb_db/oracle/product/10.2/db
Central Inventory : /eb_db/oracle/oraInventory
from: /etc/oraInst.loc
OPatch version: 10.2.0.4.9
OUI version: 10.2.0.5.0
OUI location: /eb_db/oracle/product/10.2/db/oui
Log file location : /eb_db/oracle/product/10.2/db/cfgtoollogs/opatch/opatch2012-05-20_17-14-44PM.log
Patch history file: /eb_db/oracle/product/10.2/db/cfgtoollogs/opatch/opatch_history.txt
ApplySession applying interim patch '8350262' to OH '/eb_db/oracle/product/10.2/db'
Running prerequisite checks...
OPatch detected non-cluster Oracle Home from the inventory and will patch the local system only.
Backing up files and inventory (not for auto-rollback) for the Oracle Home
Backing up files affected by the patch '8350262' for restore. This might take a while...
Backing up files affected by the patch '8350262' for rollback. This might take a while...
Patching component oracle.sysman.agent.core, 10.2.0.5.0a...
Updating jar file "/eb_db/oracle/product/10.2/db/sysman/jlib/emCORE.jar" with "/sysman/jlib/emCORE.jar/oracle/sysman/eml/sec/fsc/FSWalletUtil.class"
Updating jar file "/eb_db/oracle/product/10.2/db/sysman/jlib/emCORE.jar" with "/sysman/jlib/emCORE.jar/oracle/sysman/eml/sec/rep/RepWalletUtil.class"
Updating jar file "/eb_db/oracle/product/10.2/db/sysman/jlib/emCORE.jar" with "/sysman/jlib/emCORE.jar/oracle/sysman/eml/sec/util/RootCert.class"
Updating jar file "/eb_db/oracle/product/10.2/db/sysman/jlib/emCORE.jar" with "/sysman/jlib/emCORE.jar/oracle/sysman/eml/sec/util/SecConstants.class"
Updating jar file "/eb_db/oracle/product/10.2/db/sysman/jlib/emd_java.jar" with "/sysman/jlib/emd_java.jar/oracle/sysman/eml/sec/fsc/FSWalletUtil.class"
Updating jar file "/eb_db/oracle/product/10.2/db/sysman/jlib/emd_java.jar" with "/sysman/jlib/emd_java.jar/oracle/sysman/eml/sec/rep/RepWalletUtil.class"
Updating jar file "/eb_db/oracle/product/10.2/db/sysman/jlib/emd_java.jar" with "/sysman/jlib/emd_java.jar/oracle/sysman/eml/sec/util/RootCert.class"
Updating jar file "/eb_db/oracle/product/10.2/db/sysman/jlib/emd_java.jar" with "/sysman/jlib/emd_java.jar/oracle/sysman/eml/sec/util/SecConstants.class"
ApplySession adding interim patch '8350262' to inventory
Verifying the update...
Inventory check OK: Patch ID 8350262 is registered in Oracle Home inventory with proper meta-data.
Files check OK: Files from Patch ID 8350262 are present in Oracle Home.
OPatch succeeded.
ebdbpro:/soft/8350262>
成功结束！
:) :) :)
5、删除之前安装过程中的无效em：
ebdbpro:/eb_db/oracle/product/10.2/db/OPatch> sqlplus / as sysdba
SQL*Plus: Release 10.2.0.5.0 - Production on Sun May 20 17:34:27 2012
Copyright (c) 1982, 2010, Oracle.All Rights Reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> DROP public synonym SETEMVIEWUSERCONTEXT;
Synonym dropped.
SQL> SQL> DROP PUBLIC SYNONYM MGMT_TARGET_BLACKOUTS;
Synonym dropped.
SQL> SQL> drop role MGMT_USER;
Role dropped.
SQL> SQL>DROP USER MGMT_VIEW CASCADE;
User dropped.
SQL> SQL> DROP USER SYSMAN CASCADE;
User dropped.
SQL> SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ebdbpro:/eb_db/oracle/product/10.2/db/OPatch>emca -deconfig dbcontrol db -repos drop
STARTED EMCA at May 20, 2012 5:35:17 PM
EM Configuration Assistant, Version 10.2.0.5.0 Production
Copyright (c) 2003, 2009, Oracle.All rights reserved.
Enter the following information:
Database SID: ebai
Database SID: Listener port number: 1521
Password for SYS user:
Password for SYSMAN user:
----------------------------------------------------------------------
WARNING : While repository is dropped the database will be put in quiesce mode.
----------------------------------------------------------------------
Do you wish to continue? [yes(Y)/no(N)]: Y
May 20, 2012 5:35:30 PM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /eb_db/oracle/product/10.2/db/cfgtoollogs/emca/ebai/emca_2012-05-20_05-35-17-PM.log.
May 20, 2012 5:35:30 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
WARNING: ORA-01017: invalid username/password; logon denied
May 20, 2012 5:35:30 PM oracle.sysman.emcp.ParamsManager checkListenerStatusForDBControl
WARNING: Error initializing SQL connection. SQL operations cannot be performed
May 20, 2012 5:35:30 PM oracle.sysman.emcp.EMDBPreConfig performDeconfiguration
WARNING: EM is not configured for this database. No EM-specific actions can be performed. Some of the possible reasons may be:
1) EM is configured with different hostname then physical host. Set environment variable ORACLE_HOSTNAME= and re-run EMCA script
2) ORACLE_HOSTNAME is set. Unset it and re-run EMCA script
May 20, 2012 5:35:31 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Dropping the EM repository (this may take a while) ...
May 20, 2012 5:35:31 PM oracle.sysman.emcp.EMReposConfig dropRepository
INFO: Dropping the EM repository (this may take a while) ...
May 20, 2012 5:35:31 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully dropped
Enterprise Manager configuration completed successfully
FINISHED EMCA at May 20, 2012 5:35:31 PM
6、重新创建em：
ebdbpro:/eb_db/oracle/product/10.2/db/OPatch>emca -config dbcontrol db -repos create
STARTED EMCA at May 20, 2012 5:35:42 PM
EM Configuration Assistant, Version 10.2.0.5.0 Production
Copyright (c) 2003, 2009, Oracle.All rights reserved.
Enter the following information:
Database SID: ebai
Database SID: 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 ................ /eb_db/oracle/product/10.2/db
Local hostname ................ ebdbpro
Listener port number ................ 1521
Database SID ................ ebai
Email address for notifications ...............
Outgoing Mail (SMTP) server for notifications ...............
-----------------------------------------------------------------
Do you wish to continue? [yes(Y)/no(N)]: Y
May 20, 2012 5:36:00 PM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /eb_db/oracle/product/10.2/db/cfgtoollogs/emca/ebai/emca_2012-05-20_05-35-42-PM.log.
May 20, 2012 5:36:01 PM oracle.sysman.emcp.EMReposConfig createRepository
INFO: Creating the EM repository (this may take a while) ...
May 20, 2012 5:36:50 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully created
May 20, 2012 5:36:53 PM oracle.sysman.emcp.util.DBControlUtil secureDBConsole
INFO: Securing Database Control (this may take a while) ...
May 20, 2012 5:37:31 PM oracle.sysman.emcp.util.DBControlUtil secureDBConsole
INFO: Database Control secured successfully.
May 20, 2012 5:37:31 PM oracle.sysman.emcp.util.DBControlUtil startOMS
INFO: Starting Database Control (this may take a while) ...
May 20, 2012 5:39:09 PM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: Database Control started successfully
May 20, 2012 5:39:09 PM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: >>>>>>>>>>> The Database Control URL is https://ebdbpro:1158/em <<<<<<<<<<<
Enterprise Manager configuration completed successfully
FINISHED EMCA at May 20, 2012 5:39:09 PM
ebdbpro:/eb_db/oracle/product/10.2/db/OPatch>
7、启动管理器：
ebdbpro:/eb_db/oracle/product/10.2/db/OPatch>emctl start dbconsole
TZ set to Asia/Shanghai
Oracle Enterprise Manager 10g Database Control Release 10.2.0.5.0
Copyright (c) 1996, 2010 Oracle Corporation.All rights reserved.
https://ebdbpro:1158/em/console/aboutApplication
- An instance of Oracle Enterprise Manager 10g Database Control is already running.
ebdbpro:/eb_db/oracle/product/10.2/db/OPatch>
##################################
中途的其他误操作过程，留下来参考，免得下次再犯：
ebdbpro:/eb_db/oracle/product/10.2/db/OPatch>
ebdbpro:/eb_db/oracle/product/10.2/db/OPatch> /eb_db/oracle/product/10.2/db/OPatch/opatch 8350262 apply
Invoking OPatch 10.2.0.4.9
Oracle Interim Patch Installer version 10.2.0.4.9
Copyright (c) 2009, Oracle Corporation.All rights reserved.
Syntax Error... Unrecognized Command or Option (8350262): 1st argument must be one of the following:
apply
napply
rollback
nrollback
lsinventory
lsinv
query
util
prereq
version
-help
-h
Please use the option 'opatch-help' to get correct syntax
OPatch failed with error code 14
ebdbpro:/eb_db/oracle/product/10.2/db/OPatch> /eb_db/oracle/product/10.2/db/OPatch/opatch 8350262
Invoking OPatch 10.2.0.4.9
Oracle Interim Patch Installer version 10.2.0.4.9
Copyright (c) 2009, Oracle Corporation.All rights reserved.
Syntax Error... Unrecognized Command or Option (8350262): 1st argument must be one of the following:
apply
napply
rollback
nrollback
lsinventory
lsinv
query
util
prereq
version
-help
-h
Please use the option 'opatch-help' to get correct syntax
OPatch failed with error code 14
##################################
___________________________________________________________________________________
版权所有，文章允许转载，但必须以链接方式注明源地址，否则追究法律责任!
Author: laven54 (lurou)
Email: laven54@163.com
Blog: http://blog.csdn.net/laven54
扫一扫
1833
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
