Adding XML-DB feature to existing oracle database

Using DBCA to add new database feature to existing oracle database is common way. To do that, just simply launch DBCA graphical interface, choose “Configure Database Options”, and then follow the screen to finish it.

However, sometimes you might find that the radio box “Configure Database Options” is grayed out, as shown below.

dbca-adding-new-feature-grayedout

To enable “Configure Database Options”, one line need to be added to file oratab, which usually sit under /var/opt/oracle.

dbname:/oracle/product/database/11.2.0.4/dbhome_1:Y

Once above line is added, you will see “Configure Database Options” is enabled after you launch DBCA.

dbca-adding-new-feature

But, that’s not all. Because, you might experience further error such as below.

mismatching-casesensitive-dbname

Actually, this error is absolutely misleading one. You probably go for research and work on system parameter. But, it’s very likely that the dbname in file oratab doesn’t match the tnsname because it’s case sensitive. To avoid the happening of this error, simply make dbname in file oratab and tnsname identical without case sensitivity issue.

Posted in Oracle Case Study, Oracle Point | Tagged , | Leave a comment

Oracle Grid Control Enterprise Manager Troubleshooting

Grid Control Performance: How to Troubleshoot OMS 10g Crash / Restart Issues?(Doc ID 964469.1)

Troubleshooting the Metric Collection Error for a Database Instance Target in Enterprise Manager 12c Cloud Control(Doc ID 1533617.1)
    
Enterprise Manager 12c: How to run the “Targets Status Diagnostics Report” to Troubleshoot Target Status Availability Issues (up, down, metric collection error,pending,unreachable) for all Targets(Doc ID 1546575.1)

Database System Targets showing Metric Collection Error and have no members(Doc ID 1678729.1)

Troubleshooting the “Metric Collection Error” status for a Listener Target in Enterprise Manager 12c Cloud Control(Doc ID 1533938.1)

EM 12c : How to Collect a Dump of the Availability History of a Target with the EMDIAG Repvfy kit ?(Doc ID 1545566.1)

EM 12c: Troubleshooting Guide for Enterprise Manager 12.1.0.1 Cloud Control Management Agent Startup Failures(Doc ID 1554981.1)

Posted in My Reference | Tagged | Leave a comment

“ORA-24333 zero iteration count” with Ellucian Banner

1-WM7GPE: GSADSUM creating new account results in ORA-24333 zero iteration count

Defect 1-J4KHDD -Forms 11.1.1.x -GSASECR error, ‘DO_EXEC_SQL failed : ORA-24333:zero iteration count’ when creating a new user as a copy of an existing one

1-3BVZ4J: GSASECR Copy userid errors – *ERROR* DO_EXEC_SQL failed: ORA-00911: invalid character ORA-06512: at ”GENERAL.ISSUE_GRANT”, line 1 ORA-06512: at line 1.   

1-EP2WLB: GSASECR Copy userid errors ERROR DO_EXEC_SQL failed ORA-24333 zero iteration count

Posted in My Reference | Tagged | Leave a comment