Friday, June 28, 2013

Learn something wtih 12c and enjoy bug life

I often spend a bit time with reading and test new software. Oracle Database 12c is out. That's a good idea for learning. I believe like that. I found people talk about Oracle Multitenant (Pluggable Database) and I know a little bit about it. I plan to write Pluggable Databases with thai language on Blog. Yes, not yet.
As Oracle Multitenant, How to manage it? Which tools? SQL*Plus, Oracle Enterprise Manager Cloud Control (Cloud Control) and Oracle Database Configuration Assistant (DBCA).
Oh! Don't forgot. Good Tool - Oracle SQL Developer ^________________^
How about EM12c Express? Forgot it. It doesn't support Oracle Multitenant. If you create database 12c as Container Database + EM12c Express. On EM12c Express page - Check "Storage", You will not see "Tablespaces" menu.
Anyway, You might get some error in alert log. After creating 12c database as Container Database (+ EM12c Express).
and then tested Login EM12c Express. Oops!
Note: I definitely believe EM12c Express not support Oracle Multitenant Management.
Fri Jun 28 16:00:48 2013
Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x5] [PC:0xB71F161, qervwRowProcedure()+113] [flags: 0x0, count: 1]
Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_s001_2142.trc  (incident=19524):
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.
Fri Jun 28 16:00:49 2013
Sweep [inc][19524]: completed
Fri Jun 28 16:01:38 2013
found dead shared server 'S001', pid = (36, 20)
Fri Jun 28 16:01:38 2013
Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x5] [PC:0xB71F161, qervwRowProcedure()+113] [flags: 0x0, count: 1]
Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_s002_2144.trc  (incident=19532):
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.
Fri Jun 28 16:01:51 2013
Sweep [inc][19532]: completed

I think It's all right. Disabled EM12c Express and use another tool to manage it. In work case, Open SR.
By the way, I tested EM12c Express with NON Container Database. It's all right and Perfect!

No comments: