Yearly Archives: 2014

Automate the purging of the repository cache (Exalytics Linux)

So we have created a ram disk and you are now storing the repository cache, how can we automate the purging. 1.  First we will create a file that we can run that will 1st load the BI environment, then

Posted in Blog

Create a Ram Disk in Exalytics (LINUX)

So you have all your data in memory, how can you make it even faster. You can create what you call a RAM Disk, this is when you have allocated part of the memory to be used as a file

Posted in Blog

Dataguard Scripts

I have added some useful scripts under the Dataguard section.

Posted in Blog

Accelerate BI Apps Reporting Performance in Exalytics using the DAC

I’m sure most of us have some of these challenges but you can select particular data sets of your warehouse or if small entire data marts into memory. 1. Meaningful information from the systems, that we could action upon instantly

Posted in Blog

ASM Scripts

I have added some more handy ASM Scripts. Click Here

Posted in Blog

ORA-30012: undo tablespace ‘UNDOTBS01′ does not exist or of wrong type

I was recently recovering a backup of a standby database, the standby was from a primary that was a RAC with 2 nodes.  I had the following error: SQL> startup ORACLE instance started. Total System Global Area 3170893824 bytes Fixed

Posted in Blog

Adding New Redo Log Groups

An error occurs when deleting a logfile group after you have added new groups. SQL> alter database drop logfile group 3; alter database drop logfile group 3 * ERROR at line 1: ORA-01623: log 3 is current log for instance

Posted in Blog

Cannot mark instance UNNAMED_INSTANCE as enabled

  I was recently recovering a backup of a standby database, the standby was from a primary that was a RAC with 2 nodes.  I had the following error:   SQL> alter database open resetlogs; alter database open resetlogs *

Posted in Blog

Affiliations

Engagements

  • Oracle OpenWorld 2014
  • Gartner BI Summit 9/3/15-10/3/15
  • UKOUG Business Analytics SIG 12/3/15
  • UKOUG Conference 7/12/15-9/12/15
  • Oracle Ireland Conference 2016 3/3/16-4/3/16
  • UKOUG Systems 2016 12/5/16
  • Oracle OpenWorld 2016
  • POUG 2016 7/10/16
  • DOAG 2016 15/11/16
  • UKOUG 2016 5/12/16

Videos

Posts

  • 2017 (8)
  • 2016 (22)
  • 2015 (22)
  • 2014 (8)
  • 2013 (2)