Database
-
Oracle PSU's for 11.2.0.1 on Unix
Patch
PSU
Includes CPU
9352237
11.2.0.1.1
Apr-10
9654983
11.2.0.1.2
Jul-10
9952216
11.2.0.1.3
Oct-10
10248516
11 ...
Posted 29 Dec 2011 03:16 by Alan Nolan-Davies
-
Oracle Database Desupport Dates
Details of the Oracle Database Releases can be found on Oracle Support Note: 161818.1 - summarised here Database VersionOracle11gR2 11.2.0.x Oracle11gR1 11.1.0.xOracle10gR2 ...
Posted 22 Jul 2011 07:33 by Alan Nolan-Davies
Enterprise Manager
-
Cloning the Oracle EM11g Agent
Copy the software to the new node./runInstaller -clone -forceClone ORACLE_HOME=<full path of Oracle home> ORACLE_HOME_NAME=<Oracle home name> -noconfig -silent OMS_HOST=<oms_host> OMS ...
Posted 25 Nov 2011 02:17 by Alan Nolan-Davies
-
EM12c Install Screenshots
Posted 19 Oct 2011 06:14 by Alan Nolan-Davies
SQL Developer
-
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
-
Monitor Archivelog Generation
I've just created a new Physical Standy for one of the Oracle Databases.Using the query below I have put this into a SQL Developer report as a BAR ...
Posted 22 Jul 2011 07:30 by Alan Nolan-Davies
|
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
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
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
|
VirtualBox
-
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
-
Download Virtual Box
Oracle's Virtualbox allows you to run guest operating systems on your local desktop, for Free!You can download the application here http://www.oracle.com/technetwork/server-storage/virtualbox ...
Posted 25 Jul 2011 13:07 by Alan Nolan-Davies
|
|