RSS Headlines

Database

  • RAC and DB Support Tools Bundle (Doc ID 1594347.1) Oracle's centre of expertise has been busy building tools to automatically monitor Oracle Databases that runs on the host.Many customers have put together their own collections of disparate ...
    Posted 17 Sep 2014 09:57 by Alan Nolan-Davies
  • Memory Resizing select START_TIME, component, oper_type, oper_mode, initial_size/1024/1024 "INITIAL", FINAL_SIZE/1024/1024 "FINAL", END_TIME from v$sga_resize_ops where component in ('DEFAULT buffer ...
    Posted 21 May 2014 04:15 by Alan Nolan-Davies
Showing posts 1 - 2 of 14. View more »

Enterprise Manager

  • EM11g install - RAC found on Single Instance Whilst running the EM11g installer I received an error telling me that the value of the initi parameter cluster_database was incorrect.As I was trying to install EM11g on ...
    Posted 7 Jun 2012 03:06 by Alan Nolan-Davies
  • Query OEM Targets in the Repository This query can be imported into SQL Developer to show a graph of the targets in the OEM Repository and then further detail in a child query.This runs against ...
    Posted 19 Mar 2012 10:53 by Alan Nolan-Davies
Showing posts 1 - 2 of 10. View more »

SQL Developer

  • SQl Developer on a PortableApps USB Key Install PortableApps.com on your USB keydownload SQL Developerextract SQL Developercopy extracted SQL Developer to USB Key in portableapps directoryright click in PortableApps menu and 'refresh ...
    Posted 21 Mar 2012 08:19 by Alan Nolan-Davies
  • Monitor Data Loads using SQL Developer Gauges How many times have you sat running select count(*) queries to see how your database loads are progressing.Using SQL Developer you can put this in a Database Chart called ...
    Posted 22 Jul 2011 07:57 by Alan Nolan-Davies
Showing posts 1 - 2 of 4. View more »



Grid Infrastructure

  • adding a new Node into the cluster Steps to run when adding a new node to the clusterin this case I am adding a new HP-UX 11.31 node to a cluster which has HP ...
    Posted 11 Aug 2011 08:04 by Alan Nolan-Davies
  • Installing Oracle11g Grid Infrastructure for a Cluster Process flow showing tasks per user
    Posted 22 Jul 2011 07:19 by Alan Nolan-Davies
Showing posts 1 - 2 of 6. View more »

Oracle Internet Directory

  • Upgrading OID to 11.1.1.5.0 to upgrade OID to 11.1.1.5.0 from OID 11.1.1.2.0 we need to do this in a couple of steps.upgrade OID software using ...
    Posted 28 Nov 2011 03:53 by Alan Nolan-Davies
  • ORA-28043: invalid bind credentials for DB-OID connection A user just got this error when trying to login to a database using his enterprise user account...$ sqlplus matt/password@pcmsndt2ERROR:ORA-28043: invalid bind credentials for DB ...
    Posted 23 Dec 2011 03:43 by Alan Nolan-Davies
Showing posts 1 - 2 of 2. View more »

Data Pump

  • Using ASM with DataPump 1. Create a Directory in ASM for the dumpfile$ su - grid$ asmcmd$ lsDATAFRAOCR_VOTING$ cd data$ mkdir dpdump2. Create an Oracle Directory in the database to ...
    Posted 22 Jul 2011 08:10 by Alan Nolan-Davies
Showing posts 1 - 1 of 1. View more »

Data Guard

  • Turning SQL Apply on & off The starting and stopping of SQL Apply is easiest achieved through Grid Controlhowever if Grid Control is not available... then you can achieve the same thing through DGMGRLDGMGRL ...
    Posted 22 Jul 2011 08:07 by Alan Nolan-Davies
Showing posts 1 - 1 of 1. View more »




VirtualBox

  • Virtualbox 4.2 4.1 is the current production release, so lets try the 4.2 release candidatehttp://download.virtualbox.org/virtualbox/4.2.0_RC4/
    Posted 12 Sep 2012 13:56 by Alan Nolan-Davies
  • Pre-Built Developer VM's Oracle have provided a whole range of pre-built VirtualBox images which make it incredibly easy to get to grips with their products straight away.for example say you wanted ...
    Posted 10 Aug 2011 08:38 by Alan Nolan-Davies
Showing posts 1 - 2 of 3. View more »