Oracle 10.2.0.4中 OEM bug 8350262

最新推荐文章于 2024-11-04 15:30:00 发布
最新推荐文章于 2024-11-04 15:30:00 发布
阅读量803 收藏
点赞数
分类专栏： Oracle Troubleshooting 文章标签： oracle patch database manager command jar
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/a3z2008/article/details/6703816
版权

1、发现问题

今天在OEL 4环境，从10.2.0.1升级至10.2.0.4，然后dbca建库，进度在91%的时候就不动了一直卡在那等了很久，最后报出来下面的错误~让我们来瞧瞧！


通过google搜索了下原来这是ORACLE在10.2.0.4和10.2.0.5的BUG,运气这么好，被我给碰上了~

根据提示打开emConfig.log日志文件

Vi/u01/app/oracle/product/10.2/db/cfgtoollogs/dbca/prod/emConfig.log

Aug 17,2011 10:12:30 AM oracle.sysman.emcp.util.OUIInventoryUtil setOUILoc

CONFIG:Setting oracle.installer.oui_loc to /u01/app/oracle/product/10.2/db/oui

Aug 17,2011 10:12:30 AM oracle.sysman.emcp.util.OUIInventoryUtil setOUILoc

CONFIG:Setting oracle.installer.oui_loc to /u01/app/oracle/product/10.2/db/oui

Aug 17,2011 10:12:33 AM oracle.sysman.emcp.util.CentralAgentUtilgetCentralAgentHomeAndURL

CONFIG:Central Agent home and URL: {}

Aug 17,2011 10:12:33 AM oracle.sysman.emcp.EMConfig restoreOuiLoc

CONFIG:Restoring oracle.installer.oui_loc to /u01/app/oracle/product/10.2/db/oui

Aug 17,2011 11:45:57 AM oracle.sysman.emcp.ParamsManager setParam

CONFIG:Setting param: LOG_FILE value:/u01/app/oracle/product/10.2/db/cfgtoollogs/dbca/prod/emConfig.log

Aug 17,2011 11:46:27 AM oracle.sysman.emcp.ParamsManager setParam

CONFIG:Setting param: HOST value: oel1

Aug 17,2011 11:46:27 AM oracle.sysman.emcp.ParamsManager setParam

CONFIG:Setting param: PORT value: 1521

Aug 17,2011 11:46:27 AM oracle.sysman.emcp.ParamsManager setParam

CONFIG:Setting param: SID value: prod

Aug 17,2011 11:46:27 AM oracle.sysman.emcp.ParamsManager setParam

CONFIG:Setting param: LISTENER value: LISTENER

Aug 17,2011 11:46:27 AM oracle.sysman.emcp.ParamsManager setParam

CONFIG:Setting param: LISTENER_OH value: /u01/app/oracle/product/10.2/db

Aug 17,2011 11:46:27 AM oracle.sysman.emcp.ParamsManager setFlag

CONFIG:Flag '-config' set to true

Aug 17,2011 11:46:27 AM oracle.sysman.emcp.ParamsManager setFlag

CONFIG:Flag 'db' set to true

Aug 17,2011 11:46:27 AM oracle.sysman.emcp.ParamsManager setParam

CONFIG:Setting param: EM_HOME value: /u01/app/oracle/product/10.2/db

Aug 17,2011 11:46:27 AM oracle.sysman.emcp.ParamsManager setParam

CONFIG:Setting param: DB_UNIQUE_NAME value: prod

Aug 17,2011 11:46:27 AM oracle.sysman.emcp.ParamsManager setParam

CONFIG:Setting param: SERVICE_NAME value: prod

Aug 17,2011 11:46:27 AM oracle.sysman.emcp.ParamsManager setParam

<product/10.2/db/cfgtoollogs/dbca/prod/emConfig.log"1500L, 138732C 1,1           Top

Aug 17,2011 10:12:30 AM oracle.sysman.emcp.util.OUIInventoryUtil setOUILoc

CONFIG:Setting oracle.installer.oui_loc to /u01/app/oracle/product/10.2/db/oui

Aug 17,2011 10:12:30 AM oracle.sysman.emcp.util.OUIInventoryUtil setOUILoc

CONFIG:Setting oracle.installer.oui_loc to /u01/app/oracle/product/10.2/db/oui

Aug 17,2011 10:12:33 AM oracle.sysman.emcp.util.CentralAgentUtilgetCentralAgentHomeAndURL

CONFIG:Central Agent home and URL: {}

Aug 17,2011 10:12:33 AM oracle.sysman.emcp.EMConfig restoreOuiLoc

CONFIG:Restoring oracle.installer.oui_loc to /u01/app/oracle/product/10.2/db/oui

Aug 17,2011 11:45:57 AM oracle.sysman.emcp.ParamsManager setParam

CONFIG:Setting param: LOG_FILE value:/u01/app/oracle/product/10.2/db/cfgtoollogs/dbca/prod/emConfig.log

Aug 17,2011 11:46:27 AM oracle.sysman.emcp.ParamsManager setParam

CONFIG:Setting param: HOST value: oel1

Aug 17,2011 11:46:27 AM oracle.sysman.emcp.ParamsManager setParam

CONFIG:Setting param: PORT value: 1521

Aug 17,2011 11:46:27 AM oracle.sysman.emcp.ParamsManager setParam

CONFIG:Setting param: SID value: prod

Aug 17,2011 11:46:27 AM oracle.sysman.emcp.ParamsManager setParam

CONFIG:Setting param: LISTENER value: LISTENER

Aug 17,2011 11:46:27 AM oracle.sysman.emcp.ParamsManager setParam

CONFIG:Setting param: LISTENER_OH value: /u01/app/oracle/product/10.2/db

Aug 17,2011 11:46:27 AM oracle.sysman.emcp.ParamsManager setFlag

CONFIG:Flag '-config' set to true

Aug 17,2011 11:46:27 AM oracle.sysman.emcp.ParamsManager setFlag

CONFIG:Flag 'db' set to true

Aug 17,2011 11:46:27 AM oracle.sysman.emcp.ParamsManager setParam

CONFIG:Setting param: EM_HOME value: /u01/app/oracle/product/10.2/db

Aug 17, 201111:46:27 AM oracle.sysman.emcp.ParamsManager setParam

CONFIG:Setting param: DB_UNIQUE_NAME value: prod

Aug 17,2011 11:46:27 AM oracle.sysman.emcp.ParamsManager setParam

CONFIG:Setting param: SERVICE_NAME value: prod

Aug 17,2011 11:46:27 AM oracle.sysman.emcp.ParamsManager setParam

CONFIG:Setting param: ORACLE_HOME value: /u01/app/oracle/product/10.2/db

Aug 17,2011 11:46:27 AM oracle.sysman.emcp.ParamsManager setFlag

CONFIG:Flag '-cluster' set to true

Aug 17,2011 11:46:27 AM oracle.sysman.emcp.util.ClusterUtil areNodesAlive

CONFIG:Alive node cache contents: []

Aug 17,2011 11:46:27 AM oracle.sysman.emcp.util.ClusterUtil areNodesAlive

CONFIG:oel1 not found in alive node cache

Aug 17,2011 11:46:27 AM oracle.sysman.emcp.util.ClusterUtil areNodesAlive

CONFIG:oel2 not found in alive node cache

Aug 17,2011 11:46:29 AM oracle.sysman.emcp.util.ClusterUtil areNodesAlive

CONFIG:Node: oel1 is accessible.

Aug 17,2011 11:46:29 AM oracle.sysman.emcp.util.ClusterUtil areNodesAlive

CONFIG:Node: oel2 is accessible.

Aug 17,2011 11:46:29 AM oracle.sysman.emcp.ParamsManager getInaccessibleNodeList

CONFIG:All nodes are up. Nodes: [oel1, oel2]

Aug 17,2011 11:46:29 AM oracle.sysman.emcp.ParamsManager getInaccessibleSidList

CONFIG:All nodes are up. Nodes: [oel1, oel2] Sids: [prod1, prod2]

 

2、Oracle 对这个bug原因的说明：

       In Enterprise Manager DatabaseControl with Oracle Database 10.2.0.4 and 10.2.0.5, the root certificate used to securecommunications via the Secure Socket Layer (SSL) protocol will expire on31-Dec-2010 00:00:00. Thecertificate expiration will cause errors if you attempt to configure DatabaseControl on or after 31-Dec-2010. Existing Database Controlconfigurations are not impacted by this issue.

       If you plan to configure Database Control with either of theseOracle Database releases, Oraclestrongly recommends that you apply Patch 8350262 to your Oracle Homeinstallations before you configure Database Control. Configuration of Database Control istypically done when you create or upgrade Oracle Database, or if you runEnterprise Manager Configuration Assistant (EMCA) in standalone mode.

Note the following:

       （1）The issue impacts configuration ofDatabase Control with Oracle Database 10.2.0.4 and 10.2.0.5 only. It does notimpact database creation or upgrade.

       （2）The issue does not impact existingDatabase Control configurations.

       （3）Application of Patch 8350262 does not require any databasedowntime

 

3、解决问题

ORACLE 给出的建议操作步骤如下：

Recovering from Configuration Errors on a Single InstanceDatabase

单实例

Recovering from Configuration Errors on a Single InstanceDatabase
1. Ignore any errors and continue with the installation or upgrade. Thedatabase will be created without errors.

2. Apply Patch 8350262 to your Oracle Home installation usingOPatch.

opatch apply

Invoking OPatch 10.2.0.4.2

Oracle Interim Patch Installer version 10.2.0.4.2
Copyright (c) 2007, Oracle Corporation. All rights reserved.

Oracle Home : /myhost
Central Inventory : /scratch/pchebrol/oraInventory
from : /etc/oraInst.loc
OPatch version : 10.2.0.4.2
OUI version : 10.2.0.4.0
OUI location : /myhost/oui
Log file location : /myhost/cfgtoollogs/opatch/opatch2011-01-02_11-00-00AM.log

ApplySession applying interim patch '8350262' to OH '/myhost'

Running prerequisite checks...

OPatch detected non-cluster Oracle Home from the inventory andwill patch the local system only.

Backing up files and inventory (not for auto-rollback) for theOracle Home
Backing up files affected by the patch '8350262' for restore. This might take awhile...
Backing up files affected by the patch '8350262' for rollback. This might takea while...

Patching component oracle.sysman.agent.core, 10.2.0.4.0a...
Updating jar file "/myhost/sysman/jlib/emCORE.jar" with
"/sysman/jlib/emCORE.jar/oracle/sysman/eml/sec/fsc/FSWalletUtil.class"
Updating jar file "/myhost/sysman/jlib/emCORE.jar" with
"/sysman/jlib/emCORE.jar/oracle/sysman/eml/sec/rep/RepWalletUtil.class"
Updating jar file "/myhost/sysman/jlib/emCORE.jar" with
"/sysman/jlib/emCORE.jar/oracle/sysman/eml/sec/util/RootCert.class"
Updating jar file "/myhost/sysman/jlib/emCORE.jar" with
"/sysman/jlib/emCORE.jar/oracle/sysman/eml/sec/util/SecConstants.class"
Updating jar file "/myhost/sysman/jlib/emd_java.jar" with"/sysman/jlib/emd_
java.jar/oracle/sysman/eml/sec/fsc/FSWalletUtil.class"
Updating jar file "/myhost/sysman/jlib/emd_java.jar" with"/sysman/jlib/emd_
java.jar/oracle/sysman/eml/sec/rep/RepWalletUtil.class"
Updating jar file "/myhost/sysman/jlib/emd_java.jar" with"/sysman/jlib/emd_
java.jar/oracle/sysman/eml/sec/util/RootCert.class"
Updating jar file "/myhost/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 inventorywith proper meta-data.
Files check OK: Files from Patch ID 8350262 are present in Oracle Home.

OPatch succeeded.

3. After applying the patch, force stop the Database Control(dbconsole) process using the killDBConsole script bundled with the patch. Notethat the dbconsole process cannot be stopped using the emctl stop dbconsolecommand, as EMCTL is unable to connect to the process.

To execute the killDBConsole script:

Set the ORACLE_HOME and ORACLE_SID environment variables. 
Execute <PATCH_HOME>/killDBConsole. 
Note for Windows Platform Only:

It is not necessary to force stop the dbconsole process on theWindows platform, because the process will
already be in a stopped state at the end of the failed configuration attempt.

The killDBConsole script output is shown below:

$ <PATCH_HOME>/killDBConsole
ORACLE_HOME=/myhost/db_1
ORACLE_SID=caem31
State directory = /myhost/db_1/staxd10_caem31
WatchDog PID = 802932
DBconsole PID = 577716
EMAgent PID = 512156
Killing WatchDog (pid=802932) ...
Successfully killed process 802932
Killing DBConsole (pid=577716) ...
Successfully killed process 577716
Killing EMAgent (pid=512156) ...
Successfully killed process 512156

4. Re-secure Database Control with the following command:

<ORACLE_HOME>/bin/emctl secure dbconsole -reset

You will be prompted twice to confirm that the Root key must beoverwritten. In both cases, enter upper-case "Y" as the response. Anyother response (including lower-case "y") will cause the command toterminate without completing. If this happens, the command can be re-invoked.

$ ./emctl secure dbconsole -reset
Oracle Enterprise Manager 10g Database Control Release 10.2.0.4.0
Copyright (c) 1996, 2007 Oracle Corporation. All rights reserved.
https://myhost:5501/em/console/aboutApplication
Enter Enterprise Manager Root Password :
DBCONSOLE already stopped... Done.
Agent is already stopped... Done.
Securing dbconsole... Started.
Checking Repository... Done.
Checking Em Key... Done.
Checking Repository for an existing Enterprise Manager Root Key...
WARNING! An Enterprise Manager Root Key already exists in
the Repository. This operation will replace your Enterprise
Manager Root Key.
All existing Agents that use HTTPS will need to be
reconfigured if you proceed. Do you wish to continue and
overwrite your Root Key
(Y/N) ?
Y
Are you sure ? Reset of the Enterprise Manager Root Key
will mean that you will need to reconfigure each Agent
that is associated with this OMS before they will be
able to upload any data to it. Monitoring of Targets
associated with these Agents will be unavailable until
after they are reconfigured.
(Y/N) ?
Y
Generating Enterprise Manager Root Key (this takes a minute)... Done.FetchingRoot Certificate from
the Repository... Done.
Updating HTTPS port in emoms.properties file... Done.
Generating Java Keystore... Done.
Securing OMS ... Done.
Generating Oracle Wallet Password for Agent.... Done.
Generating wallet for Agent ... Done.
Copying the wallet for agent use... Done.
Storing agent key in repository... Done.
Storing agent key for agent ... Done.
Configuring Agent...
Configuring Agent for HTTPS in DBCONSOLE mode... Done.
EMD_URL set in /myhost/myhost/sysman/config/emd.properties
Done.
Configuring Key store.. Done.
Securing dbconsole... Sucessful.

5. Re-start Database Control with the following command:

<ORACLE_HOME>/bin/emctl start dbconsole

 

RAC环境

Recovering from Configuration Errorsin an Oracle Real Application Clusters (RAC) Environment
1. Ignore any errors and continue with the upgrade, so that the database isupgraded without errors.

2. Apply Patch 8350262 to yourOracle Home installation. Note that the OPatch utility will apply the patch toall nodes in the cluster, as shown below:

../OPatch/opatch apply
Invoking OPatch 10.2.0.4.2

Oracle Interim Patch Installerversion 10.2.0.4.2
Copyright (c) 2007, Oracle Corporation. All rights reserved.

Oracle Home :/myhost/oracle/product/10.2.0/db_1
Central Inventory : /myhost/app/oraInventory
from : /etc/oraInst.loc
OPatch version : 10.2.0.4.2
OUI version : 10.2.0.4.0
OUI location : /myhost/oracle/product/10.2.0/db_1/oui
Log file location :/myhost/oracle/product/10.2.0/db_1/cfgtoollogs/opatch/opatch2011-01-01_
21-30-27PM.log

ApplySession applying interim patch'8350262' to OH '/myhost/oracle/product/10.2.0/db_1'

Running prerequisite checks...

OPatch detected the node list andthe local node from the inventory. OPatch will patch the local
system then propagate the patch to the remote nodes.

Backing up files and inventory (notfor auto-rollback) for the Oracle Home
Backing up files affected by the patch '8350262' for restore. This might take awhile...
Backing up files affected by the patch '8350262' for rollback. This might takea while...

Patching componentoracle.sysman.agent.core, 10.2.0.4.0a...
Updating jar file "/myhost/oracle/product/10.2.0/db_1/sysman/jlib/emCORE.jar"with
“/sysman/jlib/emCORE.jar/oracle/sysman/eml/sec/fsc/FSWalletUtil.class"
Updating jar file"/myhost/oracle/product/10.2.0/db_1/sysman/jlib/emCORE.jar" with
"/sysman/jlib/emCORE.jar/oracle/sysman/eml/sec/rep/RepWalletUtil.class"
Updating jar file"/myhost/oracle/product/10.2.0/db_1/sysman/jlib/emCORE.jar" with
"/sysman/jlib/emCORE.jar/oracle/sysman/eml/sec/util/RootCert.class"
Updating jar file"/myhost/oracle/product/10.2.0/db_1/sysman/jlib/emCORE.jar" with
"/sysman/jlib/emCORE.jar/oracle/sysman/eml/sec/util/SecConstants.class"
Updating jar file"/myhost/oracle/product/10.2.0/db_1/sysman/jlib/emd_java.jar" with
"/sysman/jlib/emd_java.jar/oracle/sysman/eml/sec/fsc/FSWalletUtil.class"
Updating jar file "/myhost/oracle/product/10.2.0/db_1/sysman/jlib/emd_java.jar"with
"/sysman/jlib/emd_java.jar/oracle/sysman/eml/sec/rep/RepWalletUtil.class"
Updating jar file"/myhost/oracle/product/10.2.0/db_1/sysman/jlib/emd_java.jar" with
"/sysman/jlib/emd_java.jar/oracle/sysman/eml/sec/util/RootCert.class"
Updating jar file"/myhost/oracle/product/10.2.0/db_1/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 inventorywith proper meta-data.
Files check OK: Files from Patch ID 8350262 are present in Oracle Home.

Patching in rolling mode.

Updating nodes 'myhost'
Apply-related files are:
FP = :/myhost/oracle/product/10.2.0/db_1/.patch_storage/8350262_Sep_14_2010_04_59_44/rac/copy_
files.txt"
DP ="/myhost/oracle/product/10.2.0/db_1/.patch_storage/8350262_Sep_14_2010_04_59_44/rac/copy_
dirs.txt"
MP = "/myhost/oracle/product/10.2.0/db_1/.patch_storage/8350262_Sep_14_2010_04_59_44/rac/make_
cmds.txt"
RC ="/myhost/oracle/product/10.2.0/db_1/.patch_storage/8350262_Sep_14_2010_04_59_44/rac/remote_
cmds.txt"

Instantiating the file"/myhost/oracle/product/10.2.0/db_1/.patch_storage/8350262_Sep_14_2010_04_59_
44/rac/copy_files.txt.instantiated" by replacing $ORACLE_HOME in"/myhost/oracle/product/10.2.0/db_
1/.patch_storage/8350262_Sep_14_2010_04_59_44/rac/copy_files.txt" withactual path.
Propagating files to remote nodes...
Instantiating the file "/myhost/oracle/product/10.2.0/db_1/.patch_storage/8350262_Sep_14_2010_04_59_
44/rac/copy_dirs.txt.instantiated" by replacing $ORACLE_HOME in"/myhost/oracle/product/10.2.0/db_
1/.patch_storage/8350262_Sep_14_2010_04_59_44/rac/copy_dirs.txt" withactual path.
Propagating directories to remote nodes...

OPatch succeeded.


3. After applying the patch, force stop the Database Control (dbconsole)process by executing the
killDBConsole script bundled with the patch on each node in the cluster. Notethat the dbconsole
process cannot be stopped using the emctl stop dbconsole command, as EMCTL isunable to connect
to the process.

To execute the killDBConsole script:

Set the ORACLE_HOME and ORACLE_SIDenvironment variables. 
Execute <PATCH_HOME>/killDBConsole 
Note for Windows Platform Only:
It is not necessary to force stop the dbconsole process on the Windowsplatform, because the process will
already be in a stopped state at the end of the failed configuration attempt.

The killDBConsole script output isshown below:

$ <PATCH_HOME>/killDBConsole
ORACLE_HOME=/myhost/catest/db_1
ORACLE_SID=caem31
State directory = /myhost/catest/db_1/staxd10_caem31
WatchDog PID = 802932
DBconsole PID = 577716
EMAgent PID = 512156
Killing WatchDog (pid=802932) ...
Successfully killed process 802932
Killing DBConsole (pid=577716) ...
Successfully killed process 577716
Killing EMAgent (pid=512156) ...
Successfully killed process 512156


4. Re-secure Database Control on the first cluster node with the followingcommand:


<ORACLE_HOME>/bin/emctl secure dbconsole -reset

You will be prompted twice toconfirm that the Root key must be overwritten. In both cases, enter upper-case"Y" as the response. Any other response (including lower-case"y") will cause the command to terminate without completing. If thishappens, the command can be re-invoked.

$ ./emctl secure dbconsole -reset
Oracle Enterprise Manager 10g Database Control Release 10.2.0.4.0
Copyright (c) 1996, 2007 Oracle Corporation. All rights reserved.
https://myhost:5501/em/console/aboutApplication
Enter Enterprise Manager Root Password :
DBCONSOLE already stopped... Done.
Agent is already stopped... Done.
Securing dbconsole... Started.
Checking Repository... Done.
Checking Em Key... Done.
Checking Repository for an existing Enterprise Manager Root Key...
WARNING! An Enterprise Manager Root Key already exists in
the Repository. This operation will replace your Enterprise
Manager Root Key.
All existing Agents that use HTTPS will need to be
reconfigured if you proceed. Do you wish to continue and
overwrite your Root Key
(Y/N) ?
Y
Are you sure ? Reset of the Enterprise Manager Root Key
will mean that you will need to reconfigure each Agent
that is associated with this OMS before they will be
able to upload any data to it. Monitoring of Targets
associated with these Agents will be unavailable until
after they are reconfigured.
(Y/N) ?
Y
Generating Enterprise Manager Root Key (this takes a minute)... Done.FetchingRoot Certificate from
the Repository... Done.
Updating HTTPS port in emoms.properties file... Done.
Generating Java Keystore... Done.
Securing OMS ... Done.
Generating Oracle Wallet Password for Agent.... Done.
Generating wallet for Agent ... Done.
Copying the wallet for agent use... Done.
Storing agent key in repository... Done.
Storing agent key for agent ... Done.
Configuring Agent...
Configuring Agent for HTTPS in DBCONSOLE mode... Done.
EMD_URL set in /myhost/sysman/config/emd.properties
Done.
Configuring Key store.. Done.
Securing dbconsole... Sucessful.

5. Re-secure Database Control on theremaining cluster nodes with the following command. Note that the -reset switchis not included with this command:

<ORACLE_HOME>/bin/emctl securedbconsole

[myhost bin]$ ./emctl securedbconsole
Oracle Enterprise Manager 10g Database Control Release 10.2.0.4.0
Copyright (c) 1996, 2007 Oracle Corporation. All rights reserved.
https://myhost:1158/em/console/aboutApplication
Enter Enterprise Manager Root password :
Enter a Hostname for this OMS : myhost
DBCONSOLE already stopped... Done.
Agent is already stopped... Done.
Securing dbconsole... Started.
Checking Repository... Done.
Checking Em Key... Done.
Checking Repository for an existing Enterprise Manager Root Key... Done.
Fetching Root Certificate from the Repository... Done.
Updating HTTPS port in emoms.properties file... Done.
Generating Java Keystore... Done.
Securing OMS ... Done.
Generating Oracle Wallet Password for Agent.... Done.
Generating wallet for Agent ... Done.
Copying the wallet for agent use... Done.
Storing agent key in repository... Done.
Storing agent key for agent ... Done.
Configuring Agent...
Configuring Agent for HTTPS in DBCONSOLE mode... Done.
EMD_URL set in /myhost/oracle/product/10.2.0/db_1/myhost/sysman/c
onfig/emd.properties
Done.
Configuring Key store.. Done.
Securing dbconsole... Sucessful.

6. Re-start Database Control byexecuting the following command on each node in the cluster:

<ORACLE_HOME>/bin/emctl startdbconsole

 






海的记忆
关注
专栏目录
oracle 10.2.0.4 X64.zip
09-06
8. **XMLDB**：Oracle 10.2.0.4加强了对XML数据的支持，提供了一个内置的XML数据库引擎，可以直接在数据库中存储、检索和处理XML文档。 9. **安全管理**：该版本强化了数据库的安全性，包括用户权限管理、审计、...
Oracle 10.2.0.4 X64客户端.zip
09-06
4. **Documentation**: 压缩包中的"doc"目录可能包含Oracle 10.2.0.4的官方文档，这些文档为用户提供详细的使用指南、参考手册和故障排查信息，帮助用户理解和操作Oracle客户端。 5. **Response File**: "response...
oracle 10.2.0.4安装包 windows
06-10
oracle 10.2.0.4安装包 windows
oracle linux 10.2.0.4安装包
06-15
oracle linux 10.2.0.4安装包
Redhat linux5.6下Oracle 10g （10.2.0.1）安装及升级到10.2.0.4.doc
02-24
Redhat linux5.6下Oracle 10g （10.2.0.1）安装及升级到10.2.0.4
启动数据库ORA-00119，ORA-00132报错
05-04 5091
前几天在11g R2单机环境做goldengate测试时，在某次启动数据库时报了如下错误： SQL> startup; 　　ORA-00119: invalid specification for system parameter LOCAL_LISTENER 　　ORA-00132: syntax error or unresolved network name ’LISTENER_ORC
Exception java.lang.UnsatisfiedLinkError libXp.so.6: cannot open shared object file
05-22 1695
今天在一台REDHAT 5上安装ORACLE 9i的数据库，版本9206，当执行runInstaller时出现Exception java.lang.UnsatisfiedLinkError libXp.so.6: cannot open shared object file报错 [oracle@oracle Disk1]$ ./runInstaller Starting Oracle Uni
外汇数据库导数据ora-01400错误小计
04-16 1186
外汇源端和目标段的数据库版本都是11.2.0.1 使用exp、imp导入导出 导入目标库时会报ora-01400的错误 IMP-00019: row rejected due to ORACLE error1400 IMP-00003: ORACLE error 1400 encountered ORA-01400: cannot insert NULL into("TEST"."A
民生银行工作流系统数据库连接不上
04-16 539
民生银行工作流的一个数据库连接不上但现场后通过以下方式进行了排查，后发现由于监听文件太大所致。 1.  排查 过程   1)       ping ip能通 2)       telnet到机器上 数据库server正常 3)       查看监听 发现监听程序没有启动 4)       重启监听  客户端能够连接正常   2. 分析 1） 检查lsnrctl status 正常
ORA-29807错误
04-18 497
今天装一台9i的数据库，软件从9.2.0.4升级到9.2.0.8后用DBCA建库，出现ORA-29807的错误 经查metalink是一个已知的BUG：2686156，并且这个bug可以被忽略，我们可以单击ignore继续安装 有这样一段话： ORA-29807: specified operator does not exist  This is a known issue
BUG:3877515 - Logminer Returning No Records
05-08 485
Logminer Not Returning Any Records [ID 291574.1] Applies To Oracle Server - Enterprise Edition - Version: 10.1.0.2 This problem can occur on any platform. Symptoms Logminer not returning
如何一键完成20个Oracle实例运维脚本部署
xiaofan23z的专栏
10-31 864
在没有商业的集中管理平台的情况下，如何快速的部署监控或者运维脚本，是一个值得探讨的问题，这里博主以一个简单的示例来演示如何快速一次性给20个实例部署运维脚本。这台部署服务器要和所有数据库实例网络通，ssh端口通，我这里选择了EMCC服务器，为了管理实例EMCC服务器已经和所有数据库实例打通了网络。是一个用于在命令行中非交互式提供 SSH 密码的工具，特别适合自动化脚本。这里只是一个范例，如果脚本需要定制化修改，也可以通过抓取主机上的信息来自动修改脚本实现批量部署，希望能帮助到大家。到目标主机检查部署情况。
漏洞挖掘 | 基于mssql数据库的sql注入
最新发布
2401_82664371的博客
11-04 473
sql注入漏洞挖掘主要还是需要了解各类型的数据库怎么操作，数据库的系统表有哪些，对应的函数有哪些，对过滤机制的绕过手法（虽然本次漏洞挖掘没有涉及到绕过），建议有时间还是需要深入学习一下各类数据库，不仅对漏洞挖掘有帮助，反之对以后可能需要涉及到的安全开发也有很大帮助，比如如何过滤危险函数啊，如何清洗用户输入的数据啊等最后也是拿下两个中危。
Oracle 数据库历史备份数据恢复验证
Ahern_的博客
10-31 436
控制文件恢复完成，这里可以选择交叉验证备份删除无效备份，也可以忽略，由于我们使用的备份文件的路径与控制文件路径一致，就不需要单独将备份注册到控制文件中去。验证 ASM 管理的数据库的历史备份恢复至单实例数据库（主要目的在于验证历史备份是否可用的一次恢复演练）到此，数据库恢复遇到的错误已经全部解决，重启数据库再次验证均成功，数据库也顺利完成历史备份的恢复演练。本次对...核心库的历史备份进行了恢复演练测试，恢复演练测试通过，证明历史数据库备份可用。根据数据库情况选择恢复测试的环境。3、 从备份恢复控制文件。
Oracle 大表添加索引的最佳方式
qq_22201881的博客
10-31 698
补充方法1：由于创建索引时需要对表进行全表扫描,可以适当考虑调大db_file_multiblock_read_count的值， db_file_multiblock_read_count影响Oracle在读取数据时一次读取的最大block数量，在进行一些数据量比较大的操作时，可以适当 调整当前session的db_file_multiblock_read_count值，会在IO上节省节省一些时间。打扫战场：添加完索引后，把打扫一下战场，把战场恢复到操作之前，因此我们要把调整的参数进行恢复到原来的样子。
【Oracle APEX开发小技巧10】CSS样式控制交互式报表列宽和自动换行效果
clover_oreo的博客
11-01 315
在实际开发中使用交互式报表可能会出现某些字段的列宽过长，某些字段的列宽只有缩到一角的情况，那么如何解决这种情况呢？有没有方法可以控制交互式报表的列宽呢？长度固定，不再是被挤到一角。页设置-页-CSS-内嵌。
存储过程及部分练习笔记
qq_42217078的博客
10-30 1059
select Roomid 班级,round(avg(degree),2) 班级平均成绩 into gebanjunfen from student。select if((degree+0) > 85,"考得好","考得不好") 考试状态 into jieguo from student。select Roomid 班级, round(avg(degree),2) 班级平均成绩 from student。-- 3:创建一个存储过程，根据所给的班级的编号，统计该班人数，并将人数以输出变量返回给用户。
图文深入介绍Oracle DB link（一）
qq_45732829的博客
10-31 1007
本文图文深入介绍Oracle DB link，先介绍基本概念。
Oracle10.2.0.1到10.2.0.4数据库升级指南
"Oracle数据库10.2.0.1到10.2.0.4的升级过程记录" 本文档详细记录了一次Oracle数据库从10.2.0.1版本升级到10.2.0.4版本的实践过程。升级数据库是一个重要的任务，特别是在生产环境中，必须确保数据安全并遵循严格的...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值