技术不断飞速发展,各种云也在如火如荼的进行着,得空终于可以玩玩Oracle12c了,Oracle12c确实改了好多东西,当打算使用em 的时候,发现根本没有emctl等工具了,好不容易整出em界面,却反映很慢(如图一),等了半天出现错误(图二),信息如下:(版本,12.1.0.1.0 ole6.6),原谅俺用的版本过低,也证明了刚出的东西bug确实多
图一
图二
查看数据库状态正常,查看后台日志,发现有一下错误信息:
通过网络查找,并无什么有效信息,mos还是好用的。搜索 第一个出现的字眼就是BUG……
查看文档,部分信息: 参考文档【Doc ID 1604062.1】
下载补丁包,安装。
再次登录em控制台,可正常访问,如下图
OK 可以继续玩了
文盲筱烨 2015年8月5日
图一
图二
查看数据库状态正常,查看后台日志,发现有一下错误信息:
点击(此处)折叠或打开
- 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
- Copyright (c) 2012, Oracle Corporation. All rights reserved.
-
-
- 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
-
- Copyright (c) 1991, 2013, Oracle. All rights reserved.
-
- 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博客 ” ,链接:http://blog.itpub.net/29487349/viewspace-1762353/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/29487349/viewspace-1762353/