Posts

PDB is in READ WRITE, but it stays in RESTRICTED mode.

Issue: PDB is in Restricted mode.

Today we have upgraded 11g datbase to 12c and plugged in container.

After running noncdb_to_pdb.sql we tried to open PDB,

PDB status Restricted is  YES..


CDB$ROOT@AGIIPRDC> sho pdbs

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         3 RQBIPRDPDB1                            READ WRITE YES



Reason:
Rows with type ERROR and status PENDING from pdb_plug_in_violations
select name, cause, type, message, status from pdb_plug_in_violations where type = 'ERROR' and status != 'RESOLVED'  order by name, time;


CDB$ROOT@AGIIPRDC> set linesize 150 col name for a15 col cause for a15 col message for a50
select name, cause, type, message, status from pdb_plug_in_violations where type = 'ERROR' and status != 'RESOLVED'  order by name, time;CDB$ROOT@AGIIPRDC> CDB$ROOT@AGIIPRDC> CDB$ROOT@AGIIPRDC> CDB$ROOT@AGIIPRDC> CDB$ROOT@AGIIPRDC>
NAME    …

ORA-00600: internal error code, arguments: [qksvcGetGuardCol:2], [100313], [0] After upgraded to 12C

Error: ORA-00600: internal error code, arguments: [qksvcGetGuardCol:2], [100313], [0], [], [], [], [], [], [], [], [], []

We have upgraded Database from 11.2.0.2 to 12.2.0.1 from Exadata ASM to Normal File system.

and plugged into container.

Everything went fine .. but we encountered ORA-600 error with Few ETL Tables .

select  count(*) from table  is working fine..but select * from table is failing.

CDB$ROOT@EBTUPRDC> select count(*) from "EBAOREP"."F_POLICY_CT_TRANS";

  COUNT(*)
----------
   9208566

select * from is failing with ORA-600 Error.

CDB$ROOT@EBTUPRDC> select * from EBTUS_GS.T_AS_MAILING_ADDRESS;
select * from EBTUS_GS.T_AS_MAILING_ADDRESS
*
ERROR at line 1:
ORA-00600: internal error code, arguments: [qksvcGetGuardCol:2], [228717], [0],
[], [], [], [], [], [], [], [], []




Solution:  We Exported Failed Tables from source database and imported into Upgraded 12c database.

Solution Provided by Oracle support :  ORA-600 [qkebCreateColById:1] After upgraded to …

ORA-65139: Mismatch between XML metadata file and data file

Error:

CDB$ROOT@EBTUPRDC> CREATE PLUGGABLE DATABASE EBTUSPRDPDB1 using '/home/oracle/EBTUSPRDC.xml' nocopy tempfile reuse;
CREATE PLUGGABLE DATABASE EBTUSPRDPDB1 using '/home/oracle/EBTUSPRDC.xml' nocopy tempfile reuse
*
ERROR at line 1:
ORA-65139: Mismatch between XML metadata file and data file
/u05/odb/ORADATA_1/EBTUSPRDC/datafile/system.1531.807800993 for value of fcpsb
(2230502002 in the plug XML file, 2230505492 in the data file)




Fix: Don't open Non-CDB database until we complete pdb creation other wise we will get above error.

Shutdown immediate;
startup mount;
alter database open read only;

create xml file.

shutdown immediate;


Connect to CDB and Create Pluggable database .


12c Non-CDB to Container PDB with NOCOPY Option

12c NON-CDB to Container PDBSteps for Non-CDB:
EBTUSPRD@EBTUSPRD> shutdown immediate; Database closed. Database dismounted. ORACLE instance shut down. EBTUSPRD@EBTUSPRD> startup mount ORACLE instance started. Total System Global Area 3355443200 bytes Fixed Size                  8626240 bytes Variable Size            1040191424 bytes Database Buffers         2164260864 bytes Redo Buffers              142364672 bytes Database mounted. EBTUSPRD@EBTUSPRD> alter database open read only; Database altered.
Create XML file:
BEGIN   DBMS_PDB.DESCRIBE(     pdb_descr_file => '/home/oracle/EBTUSPRDC.xml'); END; / PL/SQL procedure successfully completed.

Shutdown NON-CDB:
EBTUSPRD@EBTUSPRD> shutdown immediate; Database closed. Database dismounted. ORACLE instance shut down.
Steps for Container Database:
SET SERVEROUTPUT ON DECLARE   compatible CONSTANT VARCHAR2(3) :=       CASE DBMS_PDB.CHECK_PLUG_COMPATIBILITY(             pdb_descr_file => '/home/oracle/EBTUSPRDC.xml&#…

Unable to get logical block size for spfile in alert log

We have created new database in shared environment using dbca, we Suddenly started seeing "ERROR: Unable to get logical block size for spfile" errors in few databases. 




ERROR: Unable to get logical block size for spfile '+DATA/aedvam01/spfileaedvam01.ora'. Wed Jul 19 02:21:07 2017
Work around:
sho parameter spfile
 +DATA/AEDVAM01/PARAMETERFILE/spfile.1401.919658705 
Create alias using correct name spfileaedvam01.ora
Set environment to ASM Instance.
. oraenv +ASM1
asmcmd


mkalias +DATA/AEDVAM01/PARAMETERFILE/spfile.1401.919658705 +DATA/aedvam01/spfileaedvam01.ora


BEA-000337:Weblogic stuck thread detected: [STUCK] ExecuteThread

Image
Issue:
We are getting weblogic stuck thread alerts “Incident (BEA-000337 [WebLogicServer]) detected in /u01/app/oracle/oem12c/gc_inst/user_projects/domains/GCDomain/servers/EMGC_OMS2/adr/diag/ofm/GCDomain/EMGC_O” from our OMS Servers..
Logfile: /u01/app/oracle/oem12c/gc_inst/user_projects/domains/GCDomain/servers/EMGC_OMS2/adr/diag/ofm/GCDomain/EMGC_OMS2/alert/log.xml
Errors in directory: /u01/app/oracle/oem12c/gc_inst/user_projects/domains/GCDomain/servers/EMGC_OMS2/adr/diag/ofm/GCDomain/EMGC_OMS2/incident/incdir_622  (incident=622): stuck thread detected: [STUCK] ExecuteThread: '70' for queue: 'weblogic.kernel.Default (self-tuning)'

Fix:
EM 12c: Enterprise Manager 12c Cloud Control Crashes Regularly with Logged Error: BEA-000337 ExecuteThread for OMS [ID 2229322.1]

To increase the Stuck Thread Max Time to a higher value (i.e 1800 seconds) :

1. Log onto the WLS Administration server.
2. Click on Environment in the top right side menu and expand Servers. …

ORA-28086: The data redaction policy expression has an error

Image
Error:
ERROR at line 1:
ORA-28086: The data redaction policy expression has an error.
ORA-06512: at "SYS.DBMS_REDACT_INT", line 3
ORA-06512: at "SYS.DBMS_REDACT", line 42
ORA-06512: at line 1

When we try to run same as sys user it is working perfectly fine, but as a normal user it is failing with below errors.




No Privileges issue because AVO user had DBA Privilege ..

Versions confirmed as being affected12.1.0.2 (Server Patch Set)11.2.0.4
Fixed:The fix for 20693579 is first included in12.2.0.1 (Base Release)
Cause :
Bug 20693579 - DBMS_REDACT.ADD_POLICY fails with ORA-28086 when CURSOR_SHARING is force (Doc ID 20693579.8)To Bottom
Bug 20693579  DBMS_REDACT.ADD_POLICY fails with ORA-28086 when CURSOR_SHARING is force  This note gives a brief overview of bug 20693579.
 The content was last updated on: 17-FEB-2017
Click here for details of each of the sections below.
Affects:Product (Component)Oracle Server (Rdbms)Range of versions believed to be affectedVersions >= 12.1 but BEL…