Oracle

INSTALLING ORACLE 11.2.0.4 ON X86 64 BIT LINUX RHEL – REQUIREMENTS? (FROM AND BY ORACLE) APPLIES TO: Oracle Database – Standard Edition – Version 11.2.0.4 to 11.2.0.4 [Release 11.2]Oracle Database – Enterprise Edition – Version 11.2.0.4 to 11.2.0.4 [Release 11.2]Linux x86-64 PURPOSEThis note explains the requirements that need to be met for a successful installation …

INSTALLING ORACLE 11.2.0.4 ON X86 64 BIT LINUX RHEL – REQUIREMENTS – ORACLE DOC Read More »

ORA-04045 What is being done? I had Oracle 9.2.0.5.0 databaseI had a remote 9.0.1.3.1 database I was testing replication. I saw some invalid SYSTEM schema replication objects in 9.0.1.3.1 database.When I tried to validate them I got errors, which I have not saved, to a log file. Thought it fit to re-run the catalog and …

ORA-04045 Read More »

ORA-04030 AND ORA-04031  ORA-04031 indicates that shared pool configuration is not sufficient to meet that instance requirements. So, shared pool is to be increased. ORA-04031 can be caused if the User profile is NOT as required by Oracle on Oracle Sun Solaris, AIX and HP. I have not used True Unix and hence I do …

ORA-04030 AND ORA-04031 Read More »

MV LOG Determine why that log table is growing First, determine why the MV log is growing. This is most likely linked to a registered MView that no longer exists or has not been refreshed for a long time (for example, MViews set to refresh manually or a large time intervals, as well as MViews …

MV LOG Read More »

MULTITENANT ARCHITECTURE AND MULTI-PROCESS AND MULTI-THREADED  Information sourced from Oracle Docs. The multitenant architecture capability enables an Oracle database to function as a multitenant container database (CDB). A CDB includes zero, one, or many customer-created pluggable databases (PDBs). A PDB is a portable collection of schemas, schema objects, and non-schema objects that appears to an Oracle Net …

MULTITENANT ARCHITECTURE AND MULTI-PROCESS AND MULTI-THREADED Read More »

METADATA VIEWS Oracle_10gR2_Metadata Views PDF

MANAGE TEMPORARY FILES FOR THE DATABASE  Command ALTER DATABASE (1) Required PrivilegesYou must have the ALTER DATABASE system privilege.To specify the RECOVER clause, you must also have the SYSDBA system privilege. Creating a New Datafile: Example The following statement creates a new datafile tbs_f04.dbf based on the file tbs_f03.dbf. Before creating the new datafile, you …

MANAGE TEMPORARY FILES FOR THE DATABASE Read More »

MAINTENANCE MODE Avada includes blank pages so you can build all kinds of awesome stuff, like a maintenance mode page! [/fusion_text][separator style_type=”none” top_margin=”50″ bottom_margin=”” sep_color=”” icon=”” width=”” class=”” id=””] [/fullwidth]

LOGICAL STRUCTURES http://sed.sourceforge.net/sedfaq.html DBA LINKS The Knowledge center for Oracle Professionals Documentation OTN BOOKS LINKS O’Reilly Book List Oracle Press Discount Bookstore (Bookspool)

LINKShttp://sed.sourceforge.net/sedfaq.html DBA LINKS The Knowledge center for Oracle Professionals Documentation OTN BOOKS LINKS O’Reilly Book List Oracle Press Discount Bookstore (Bookspool)