30 January 2015
Oracle OEM 12c 2-system upgrade - Notes on bugs/issues
The upgrade had quite a few bugs/problems, for which we couldn't find solutions either on Oracle support site or Google, therefore listing them here:
Error
Error during "Repository upgrade" with ORA-00955 with file severity_indexes.sql failing when command "create index em_violations_idx_08 ..." was run.
Workaround
drop index sysman.em_violations_idx_08;
Error
java.sql.SQLSyntaxErrorException "The host on which you are performing the Two system upgrade does not match with the host name you entered in the Enterprise Manager 12c Upgrade Console"
Workaround
Although Oracle support site said to check PRE_UPGC_MASTER_INFO table, the hostname in that table was correct. Problem was that we had lots of bugs previously in the installation, so somehow the whole installation got confused. We stopped that runInstaller, ran another, and the error didn't show up again.Error
ORA-00600: internal error code, arguments: [qcisSetPlsqlCtx:tzi init], [], [], [], [], [], [], [], [], [], [], []
Workaround
Increase parameters to at least 3G SGA, 1G PGA, 250 session cashed cursors.
Error
Empty temporary tablespace: TEMP
Workaround
Manually add TEMP tablespace (we had to add TEMP1, switch to that one, drop TEMP, create TEMP, switch back)
Error
ORA-00942 SCHEMA_VERSION_REGISTRY is missing. One of the log files are showing that OBG$MIG was missing, but that was a red herring.
Workaround
create or replace force view "SYSTEM"."SCHEMA_VERSION_REGISTRY"
(
"COMP_ID",
"COMP_NAME",
"MRC_NAME",
"MR_NAME",
"MR_TYPE",
"OWNER",
"VERSION",
"STATUS",
"UPGRADED",
"START_TIME",
"MODIFIED"
)
as
selectcomp_id,
comp_name,
mrc_name,
mr_name,
mr_type,
owner,
version,
status,
upgraded,
start_time,
modified
from SYSTEM.SCHEMA_VERSION_REGISTRY$
order by comp_id;
Error
MDS Schema Creation status: FAILURE
MDS Schema Creation is failed
Failed to create OPSS schema
$more emmdscreate.err
ERROR:MDS: ORA-00955: name is already used by an existing object
File:/data1/opt/oracle/middleware/oms/rcu/integration/mds/sql/cremdcmtbs.sql
Statement:create table MDS_PARTITIONS (
PARTITION_ID NUMBER NOT NULL,
PARTITION_NAME VARCHAR2(200) NOT NULL,
PARTITION_LAST_PURGE_TIME TIMESTAMP,
PARTITION_MT_STATE NUMBER
)
Creation of MDS schema fails
Workaround
Press "Retry". This solution was in Oracle Support.
Error
ERROR: Invalid username and/or password
LOG: Local Authentication Failed...Attempt PAM authentication...PAM failed with error: No account present for user
Workaround
After you click "Deploy and Configure Agents", chose "Override Oracle Home Preferred Credentials" instead of preferred. Probably due to new OMS 12c not having default preferred credentials.
