Database Notes
-
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
-
Query Audited Logons
SELECT USERNAME, OS_USERNAME, USERHOST, action_name, decode(RETURNCODE,0,'Logon Accepted',1017,'Failed - Invalid username/password',28000,'Failed - the account is locked',28001,'Failed - the password has expired',RETURNCODE ...
Posted 22 Jul 2011 07:56 by Alan Nolan-Davies
-
Move Sys.AUD$ in Oracle11g
It’s recommended to create a new Tablespace for holding the
Audit generated logs in the table SYS.AUD$ rather than leave it in the
SYSTEM tablespace
However when Oracle ...
Posted 22 Jul 2011 07:36 by Alan Nolan-Davies
-
DBMS_AUDIT_MGMT
Oracle recommend using the DBMS_AUDIT_MGMT package to move the sys.aud$ table from the System Tablespace to another.I created a new Tablespace called AUDIT_DATA and then ...
Posted 22 Jul 2011 07:32 by Alan Nolan-Davies
| |
|
