ERROR weblogic.store.PersistentStoreFatalException: [Store:280029]The store record 4 could not be found. Solution The issue can be caused by the corruption of the database, by .lok or .DAT files [...]

Check the OLAP option is enabled in database. select parameter, value from v$option where parameter = ‘OLAP’; PARAMETER VALUE OLAP  FALSE select comp_id, comp_name, version, status, [...]

Old disk group name   :      PROD New disk group name :       NEWDG  Check the databases are located in the Disk group srvctl config database -d clouddb Create a backup of spfile  create [...]

Description  In this case we are using standalone grid infrastructure and having an ACFS file system in it. In Standalone, ACFS does not start automatically so create rc.local script to load the [...]

Container and Pluggable database  SYMPTOMS The PDB$SEED is in restricted mode. CON_ID CON_NAME OPEN MODE RESTRICTED 2 PDB$SEED READ ONLY YES When we try to open the PDB$SEED it shows the below [...]

Description: We are restricting the logon time for a particular database user so the user can only access the database within defined periods. If the user attempts to logon during a non-defined [...]

set pages 5000 SET MARKUP HTML ON SPOOL ON PREFORMAT OFF ENTMAP ON – HEAD “<TITLE>EMPLOYEE REPORT</TITLE> – <STYLE type=’text/css’> – [...]

select ‘alter database datafile’||’ ”’||file_name||””||’ resize ‘||round(highwater+2)||’ ‘||’m’||’;’ from [...]

Set lines 2000 col NAME for a45 col DESCRIPTION for a100 SELECT name,description from SYS.V$PARAMETER WHERE name LIKE ‘\_%’ ESCAPE ‘\’;

Description: It shows how to set up the database security so that users cannot log into the database outside defined time-window. Here we are using Event Triggers. Steps to be followed :. Step 1 [...]