Archive for the ‘Oracle’ Category

Disable Auditing In A 11G Database

November 18th, 2017, posted in Oracle Queries
Share

In a RAC Database :

 

SQL> ALTER SYSTEM SET audit_trail=NONE SCOPE=spfile sid='*';
System altered.
SQL>

Note : Restart the database to have the change take affect, or do a rolling restart, one instance at a time.




In a Single Instance Database :

 

SQL> ALTER SYSTEM SET audit_trail=NONE SCOPE=spfile ;
System altered.
SQL>

Note : Restart the database to have the change take affect.

Share

Oracle Database 12cR2 Documentation

November 15th, 2017, posted in Oracle
Share

Finally Oracle 12cR2 documentation is here

Also All Books for Oracle® Database Online is here 

Oracle Database 12cR2 Documentation,Oracle Database 12cR2,Documentation,Oracle Database 12c,Oracle Database 12c download,download Oracle Database 12c,Oracle Database download,download Oracle Database,Oracle 12c download,download Oracle 12c,Oracle 12.2 is Now Available on E-delivery,Oracle 12.2, Now Available on E-delivery,Oracle 12.2 is Now Available,E-delivery,

 

Share

Oracle 12.2 is Now Available on E-delivery

November 13th, 2017, posted in Linux OS, Oracle
Share

Oracle Just Announced the availability of Oracle database 12cR2 Exadata/SuperCluster On their website, In Case you want to upgrade

You can download oracle Enterprise edition 12cR2 from Oracle E delivery
 Here 

Follow the steps :-

Oracle Database 12c,Oracle Database 12c download,download Oracle Database 12c,Oracle Database download,download Oracle Database,Oracle 12c download,download Oracle 12c,Oracle 12.2 is Now Available on E-delivery,Oracle 12.2, Now Available on E-delivery,Oracle 12.2 is Now Available,E-delivery,

Oracle Database 12c,Oracle Database 12c download,download Oracle Database 12c,Oracle Database download,download Oracle Database,Oracle 12c download,download Oracle 12c,Oracle 12.2 is Now Available on E-delivery,Oracle 12.2, Now Available on E-delivery,Oracle 12.2 is Now Available,E-delivery,

Share

Oracle Database 12c Release 2

November 12th, 2017, posted in Linux OS, Oracle
Share
Oracle Database 12c,Oracle Database 12c download,download Oracle Database 12c,Oracle Database download,download Oracle Database,Oracle 12c download,download Oracle 12c,Oracle Database 12c Release 2 is now available for Linux, Oracle Solaris SPARC, Oracle Solaris Intel 
To Download Just access here 
Share

Find The Inventory Organizations Assigned To Ones Operating Unit

November 6th, 2017, posted in Oracle Queries
Share
SELECT hou.NAME operating_unit_name,Oracle : Size Of Database,Oracle,Size Of Database,Database,data files, redo log files, control files, temporary files,Oracle data files,Oracle redo log files,Oracle control files,Oracle temporary files,Enabling And Checking the Status of Flashback On Database,Oracle Database,Oracle DBA,Enabling Flashback On Database,Checking the Status of Flashback On Database, Status of Flashback On Database, Enable Flashback On Database, Enabling Flashback On Database,Enable Flashback On Oracle Database, Enabling Flashback On Oracle Database,
hou.short_code,
hou.organization_id operating_unit_id,
hou.set_of_books_id,
hou.business_group_id,
ood.organization_name inventory_organization_name,
ood.organization_code Inv_organization_code,
ood.organization_id Inv_organization_id,
ood.chart_of_accounts_id
FROM hr_operating_units hou,
org_organization_definitions ood
WHERE 1 = 1
AND hou.organization_id = ood.operating_unit
ORDER BY hou.organization_id ASC;
Share