技术不断飞速发展，各种云也在如火如荼的进行着，得空终于可以玩玩Oracle12c了，Oracle12c确实改了好多东西，当打算使用em 的时候，发现根本没有emctl等工具了，好不容易整出em界面，却反映很慢（如图一），等了半天出现错误（图二），信息如下：（版本，12.1.0.1.0 ole6.6)，原谅俺用的版本过低，也证明了刚出的东西bug确实多

图一

图二

查看数据库状态正常，查看后台日志，发现有一下错误信息：

点击(此处)折叠或打开

Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x5] [PC:0xB71F161, qervwRowProcedure()+113] [flags: 0x0, count: 1]
Errors in file /oracle/app/oracle/diag/rdbms/firsoul/firsoul/trace/firsoul_s007_6313.trc (incident=14458):
ORA-07445: exception encountered: core dump [qervwRowProcedure()+113] [SIGSEGV] [ADDR:0x5] [PC:0xB71F161] [Address not mapped to object] []
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Wed Aug 05 10:01:53 2015
Sweep [inc][14458]: completed
Wed Aug 05 10:01:57 2015
found dead shared server 'S007', pid = (7, 20)

通过网络查找，并无什么有效信息，mos还是好用的。搜索第一个出现的字眼就是BUG……
查看文档，部分信息：参考文档【Doc ID 1604062.1】

点击(此处)折叠或打开

All the other sections on the main page are displayed correctly , The other tabs such as configuration, storage, security, performance, etc., are also displayed properly.
This is Caused By Unpublished Bug 16527374 : [12100-LIN64-130318]CDB:ORA-07445:EM EXPRESS HOME GOT IO ERROR
Please Apply Patch 16527374

下载补丁包，安装。

点击(此处)折叠或打开

unzip p16527374_121010_Linux-x86-64.zip
cd 16527374/
shutdown immediate
---------
[oracle@my12c 16527374]$ /oracle/app/oracle/12.0.1/dbhome_1/OPatch/opatch apply
Oracle Interim Patch Installer version 12.1.0.1.0
Oracle Home : /oracle/app/oracle/12.0.1/dbhome_1
Central Inventory : /oracle/app/oraInventory
from : /oracle/app/oracle/12.0.1/dbhome_1/oraInst.loc
OPatch version : 12.1.0.1.0
OUI version : 12.1.0.1.0
Log file location : /oracle/app/oracle/12.0.1/dbhome_1/cfgtoollogs/opatch/16527374_Aug_05_2015_10_39_03/apply2015-08-05_10-39-02AM_1.log
Applying interim patch '16527374' to OH '/oracle/app/oracle/12.0.1/dbhome_1'
Verifying environment and performing prerequisite checks...
All checks passed.
Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/oracle/app/oracle/12.0.1/dbhome_1')
Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files...
Patching component oracle.rdbms, 12.1.0.1.0...
Verifying the update...
Patch 16527374 successfully applied
Log file location: /oracle/app/oracle/12.0.1/dbhome_1/cfgtoollogs/opatch/16527374_Aug_05_2015_10_39_03/apply2015-08-05_10-39-02AM_1.log
OPatch succeeded.
----
SQL> startup
ORACLE instance started.
Total System Global Area 1503199232 bytes
Fixed Size 2288584 bytes
Variable Size 973079608 bytes
Database Buffers 520093696 bytes
Redo Buffers 7737344 bytes
Database mounted.
Database opened.
SQL> alter pluggable database ljx open;
Pluggable database altered.
SQL> exec DBMS_XDB_CONFIG.setHTTPPort(8080);
PL/SQL procedure successfully completed.
----查看监听
[oracle@my12c 16527374]$ lsnrctl stat
LSNRCTL for Linux: Version 12.1.0.1.0 - Production on 05-AUG-2015 10:41:58
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.8.72)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 12.1.0.1.0 - Production
Start Date 05-AUG-2015 09:32:38
Uptime 0 days 1 hr. 9 min. 20 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /oracle/app/oracle/12.0.1/dbhome_1/network/admin/listener.ora
Listener Log File /oracle/app/oracle/diag/tnslsnr/my12c/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.8.72)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=my12c)(PORT=8080))(Presentation=HTTP)(Session=RAW))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=my12c)(PORT=5505))(Presentation=HTTP)(Session=RAW))
Services Summary...
Service "firsoul" has 1 instance(s).
Instance "firsoul", status READY, has 1 handler(s) for this service...
Service "firsoulXDB" has 1 instance(s).
Instance "firsoul", status READY, has 1 handler(s) for this service...
Service "ljx" has 1 instance(s).
Instance "firsoul", status READY, has 1 handler(s) for this service...
The command completed successfully

再次登录em控制台，可正常访问，如下图

OK 可以继续玩了

文盲筱烨 2015年8月5日

ITPub博客

【BUG】Oracle12c CDB:EM EXPRESS::ORA-07445

最新文章