Database

  • SQL Server Support Timeline Excel Source and Power BI located on Github https://github.com/nolandavies/roadmap
    Posted 29 Mar 2019, 05:01 by Alan Nolan-Davies
  • Oracle Database Support Timeline Excel Source and Power BI located on Github https://github.com/nolandavies/roadmap
    Posted 29 Mar 2019, 06:12 by Alan Nolan-Davies
Showing posts 1 - 2 of 17. 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

  • Oracle18c Oracle Database 18c (18.3.0) Upgrade and Migration hands-on LabUpdated! 26-SEP-2018https://www.oracle.com/technetwork/community/developer-vm/vts-hol-2415742.html I'm ...
    Posted 17 Jan 2019, 02:14 by Alan Nolan-Davies
  • Virtualbox 4.2 4.1 is was the current production release, so lets try the 4.2 release candidatehttp://download.virtualbox.org/virtualbox/4.2.0_RC4/
    Posted 3 Mar 2015, 09:40 by Alan Nolan-Davies
Showing posts 1 - 2 of 4. View more »