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 associated with the…
Read MoreCheck 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, schema from dba_registry where…
Read MoreOld 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…
Read MoreDescription 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…
Read MoreContainer 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…
Read MoreDescription: 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…
Read Moreset pages 5000 SET MARKUP HTML ON SPOOL ON PREFORMAT OFF ENTMAP ON – HEAD “<TITLE>EMPLOYEE REPORT</TITLE> – <STYLE type=’text/css’> – <!– BODY {background: #FFFFC6} –> – </STYLE>” – BODY…
Read Moreselect ‘alter database datafile’||’ ”’||file_name||””||’ resize ‘||round(highwater+2)||’ ‘||’m’||’;’ from ( select /*+ rule */ a.tablespace_name, a.file_name, a.bytes/1024/1024 file_size_MB, (b.maximum+c.blocks-1)*d.db_block_size/1024/1024 highwater from dba_data_files a , (select file_id,max(block_id) maximum from dba_extents group…
Read MoreSet lines 2000 col NAME for a45 col DESCRIPTION for a100 SELECT name,description from SYS.V$PARAMETER WHERE name LIKE ‘\_%’ ESCAPE ‘\’;
Read MoreDescription: 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…
Read More