A client created an VM Cluster with four RAC nodes and eight ( 8 ) OCPU assigned in one of VM Clusters Compartment.
So questions are how many CPUs each RAC node has ? and How many databases can be created in this RAC environment based on current available OCPUs?
Read more of this content when you subscribe today.
In RAC environment, we cannot open PDB with the following messages:
SQL> alter pluggable database open instances=all; * ERROR at line 1: ORA-65054: Cannot open a pluggable database in the desired mode.
Check CDB still in Mount status:
SQL> alter session set container=CDB$ROOT; Session altered. SQL> show con_name CON_NAME —————————— CDB$ROOT QL> select name,open_mode from v$database; NAME OPEN_MODE ------ --------- TESTDB MOUNTED SQL> alter database open ; * ERROR at line 1: ORA-65054: Cannot open a pluggable database in the desired mode.
Read more of this content when you subscribe today.
After upgraded OEM from 13.2 to 13.4, the following errors appear on console GUI:
Bad Request
Your browser sent a request that this server could not understand.
Additionally, a 400 Bad Request error was encountered while trying to use an ErrorDocument to handle the request.
emcli errors:
$emcli login -username=sysman
Enter password
Error: Already logged in as user "SYSMAN". Use "emcli logout" to logout the current user.
$ emcli logout
Error: The connection to the OMS is broken or has been actively interrupted by the OMS (usually due to a communication timeout). Check the log files for further details
After upgrading the OMS to version 13.4, all Agents fail to upload with the following error:
$emctl upload agent
Oracle Enterprise Manager Cloud Control 13c Release 3
Copyright (c) 1996, 2018 Oracle Corporation. All rights reserved.
---------------------------------------------------------------
EMD upload error:full upload has failed: uploadXMLFiles skipped :: OMS version not checked yet. If this issue persists check trace files for ping to OMS related errors. (OMS_DOWN)
Securing the Agent reports the following errors:
$ emctl secure agent
Oracle Enterprise Manager Cloud Control 13c Release 3
Copyright (c) 1996, 2018 Oracle Corporation. All rights reserved.
Agent successfully stopped... Done.
Securing agent... Started.
Enter Agent Registration Password :
Agent successfully restarted... Done.
Securing agent... Failed.
$AGENT_INST_HOME/sysman/log/secure.log reports following errors:
[13-09-2021 22:11:49] USERINFO ::Securing agent... Started.
2021-09-13 22:12:04,154 [main] INFO agent.SecureAgentCmd main.309 - emdWalletSrcUrl: https://oem_slb:4900/empbs/wallets/emd
2021-09-13 22:12:04,160 [main] INFO agent.SecureAgentCmd secureAgent.392 - Querying HTTPS Upload Port of the OMS
2021-09-13 22:12:04,160 [main] INFO agent.SecureAgentCmd openPage.987 - Opening: https://oem_slb:4900/empbs/genwallet
2021-09-13 22:12:04,457 [main] INFO agent.SecureAgentCmd openPage.1014 - Response Status Code: 400
2021-09-13 22:12:04,458 [main] ERROR agent.SecureAgentCmd main.368 - Failed to secure the Agent:
java.lang.Exception: Didn't get a OK response from OMS
at oracle.sysman.emctl.secure.agent.SecureAgentCmd.openPage(SecureAgentCmd.java:1017)
at oracle.sysman.emctl.secure.agent.SecureAgentCmd.getOMSSecurePort(SecureAgentCmd.java:933)
at oracle.sysman.emctl.secure.agent.SecureAgentCmd.secureAgent(SecureAgentCmd.java:393)
at oracle.sysman.emctl.secure.agent.SecureAgentCmd.main(SecureAgentCmd.java:346)
$<gc_inst>/user_projects/domains/GCDomain/servers/ohs1/logs/ohs1.log reports following errors:
[2021-09-13T22:24:28.4358+10:00] [OHS] [ERROR:32] [OH99999] [ossl] [client_id: xx.xx.xx.xx] [host_id: oms_host1] [host_addr: xx.xx.xx.xx] [pid: 30107] [tid: 140213158373120] [user: oracle] [VirtualHost: oem_slb:0] OHS:2079 Client SSL handshake error, nzos_Handshake returned 28860(server oem_slb:443)
[2021-09-13T22:24:28.4358+10:00] [OHS] [ERROR:32] [OH99999] [ossl] [host_id: oms_host1] [host_addr: xx.xx.xx.xx] [pid: 30107] [tid: 140213158373120] [user: oracle] [VirtualHost: oem_slb:0] OHS:2171 NZ Library Error: SSL fatal alert
Read more of this content when you subscribe today.
The following errors appear from ExaCC Oracle 12.1.0.2 data pump impdp:
...
..
.
Processing object type SCHEMA_EXPORT/TABLE/TABLE
ORA-39126: Worker unexpected fatal error in KUPW$WORKER.LOAD_METADATA [SELECT process_order, flags, xml_clob, NVL(dump_fileid, :1), NVL(dump_position, :2), dump_length, dump_allocation, NVL(value_n, 0), grantor, object_row, object_schema, object_long_name, partition_name, subpartition_name, processing_status, processing_state, base_object_type, base_object_schema, base_object_name, base_process_order, property, size_estimate, in_progress, original_object_schema, original_object_name, creation_level, object_int_oid, metadata_io, option_tag FROM "IMP_USER"."SYS_IMPORT_SCHEMA_01" WHERE process_order between :3 AND :4 AND duplicate = 0 AND processing_state NOT IN (:5, :6, :7) ORDER BY process_order]
ORA-22990: LOB locators cannot span transactions
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPW$WORKER", line 11259
----- PL/SQL Call Stack -----
object line object
handle number name
0x4d745c700 27118 package body SYS.KUPW$WORKER
0x4d745c700 11286 package body SYS.KUPW$WORKER
0x4d745c700 4745 package body SYS.KUPW$WORKER
0x4d745c700 12063 package body SYS.KUPW$WORKER
0x4d745c700 2081 package body SYS.KUPW$WORKER
0x4dd854618 2 anonymous block
In procedure CREATE_MSG
KUPV$FT.MESSAGE_TEXT
KUPV$FT.MESSAGE_TEXT
In procedure SEND_MSG. Fatal=0
KUPC$QUEUE_INT.SEND
KUPC$QUEUE_INT.SEND
Processing object type SCHEMA_EXPORT/TABLE/TABLE
KUPF$FILE.CLOSE_CONTEXT
KUPF$FILE.CLOSE_CONTEXT
In procedure DETERMINE_FATAL_ERROR with ORA-22990: LOB locators cannot span transactions
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
. . imported "HR"."EMPLOYEE" 751.6 KB 3371 rows
. . imported "HR"."SALARY" 1.412 MB 2992 rows
...
..
.
Read more of this content when you subscribe today.
The following errors appear when running impdp operation which uses network link.
$ impdp imp_user/password@dbname directory=IMP_DIR logfile=imp_test.log tables=test network_link=DB_LINK
Import: Release 12.1.0.2.0 - Production on Fri Aug 27 14:44:25 2021
Copyright (c) 1982, 2014, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 12c EE Extreme Perf Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Advanced Analytics and Real Application Testing options
ORA-39006: internal error
ORA-39113: Unable to determine database version
ORA-06550: line 1, column 7:
PLS-00352: Unable to access another database 'DB_LINK'
ORA-06550: line 1, column 7:
PLS-00201: identifier 'SYS@DB_LINK' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
ORA-39097: Data Pump job encountered unexpected error -6550
Read more of this content when you subscribe today.
Make DBA Life Easy 