Joords Oracle DBA blog

Static service name is an  important part in the failover and snapshot mechanisme by the Standby database for using as a HA and test enviroment. Oracle Net Service uses the TNSNAME to resolve the path to the database and initiates a connection to the listener at the target system using the service name in the TNSNAME entry. Command to change the snapshot database to physical standby database: DGMRL> CONVERT DATABASE "JOORDS_DR0" TO PHYSICAL STANDBY; During these operations the the snapshot database needs a restart of the database. When the database is down, the service that is specified by TNSNAME is not registerd so an Oracle Net Service connection cannot be made to the database.Result is a failed operation of the convert database to physical standby. Monitoring the listener.log will give you the information of the error. and what the request is ORA-12514: listener does not currently know of the service request in the connect descriptor

In Oracle 11g Oracle Application Express (APEX) is now a standard component in the Oracle 11g RDBMS. The APEX component is intergration with the Oracle Database and ensures that the application builts with Oracle APEX benefit from the reliability, security, scalability and availability offered by the Oracle database. Oracle Real Application Cluster (RAC) is recommended for applications that require High Availability (HA), scalability, and workload management. How can we intergrate the High Availability (HA), scalability, and workload management functionality to the APEX module in a RAC environment In this blog I descibe, how to use and configure APEX module in a RAC database environment. In a normal High Availability for database enviroment is the Oracle HTTP server an unprotected feature by the Oracle Clusterware.

Oracle has introduced LOBs for managing large unstructured data insite the Oracle database. The introduction of LOBS suffers from several drawbacks in Oracle version before Oracle 11g: The LOBs where created for mostly " write once, read many times" operations and couldn't handle frequent updates LOBs assumed low concurrent usage data Undo retianed by setting the retention and pctversion parameters, addidition management burden LOBs weren't expected to be very large in size LOBs size is uniform, max chunk size could only be 32KB LOBs were not planned with concurrent usage requirements in Oracle RAC in mind The reality has changed en today LOBs are quite large, and comes in all sizes. Oracle 11g introduced a complete new way of handeling unstructured data to address the concerns resulting from the way LOBs are currently implemented. The new introduced LOB data type is called : Oracle Securefiles. The old LOB data type wil be referenced by Oracle as BasicFil...