Migrating to Oracle ASM with EM

Steps could be found at : https://docs.oracle.com/cd/E11882_01/server.112/e18951/asm_em.htm#OSTMG94276 In case you forgot to click the “View Status” in step 9, you can still access the following URL to retrieve job status: https://%5Byour_server_id%5D:5500/em/console/jobs/jobsTable What’s behind the scene The operation was divided into two phases: preparation and migration. In preparation, RMAN performs backup as copy and switches logfile:… Continue reading Migrating to Oracle ASM with EM

Understanding Character Set in Oracle

When we’re woking with multiple character sets (such as GBK and UTF-8), Chinese characters (or other languages) might be displayed in some odd codes. Therefore we need to pay attention to the underlying principles of character sets. In computing, a character encoding is used to represent a repertoire of characters by some kind of an… Continue reading Understanding Character Set in Oracle

Resolving OC4J Configuration issue

[oracle@node1 ~]$ emctl start console OC4J Configuration issue. /u01/app/11.2.0/grid/sysman/j2ee not found. We need to reconfigure db console: [oracle@node1 ~]$ emca -config dbcontrol db STARTED EMCA at Sep 1, 2015 5:10:09 AM EM Configuration Assistant, Version 11.2.0.3.0 Production Copyright (c) 2003, 2011, Oracle. All rights reserved. Enter the following information: Database SID: mydb    <– input… Continue reading Resolving OC4J Configuration issue