Edition Based Redifinition - The key to online application upgrade
Download the demo EBR zip file
Posts
DBMS_PARALLEL_EXECUTE - base table to be broken down into smaller chunks which can be run in parallel
DBMS_PARALLEL_EXECUTE package contains API's to chunk a table into smaller units and execute those chunks in parallel. The DBMS_PARALLEL_EXECUTE package allows a workload associated with a base table to be broken down into smaller chunks which can be run in parallel. This process involves several distinct stages. I was forgotten the power of this " Do-it- yourself (DIY) parallelism by Asktom " now available as package "DBMS_PARALLEL_EXECUTE "since version 11g
Secure External Password Store (SEPS) - keeping the password secret from other users on the client OS.
One of the problem is hard coded oracle passwords in batch scripts executed by schedulers. Often used is using function to get a password from a file located on the system. This file could be encrypted or plain text. With this function it is possible to hide the password in script and on OS platform. Do you know Secure External Password Store
Create Database using dbca result: TNS-04612: Null RHS for service_name
When creating a (cluster) database using DBCA it can result into an error. One of those errors can be TNS-04404, TNS-04414 & TNS-04612 errors. Testing the service with tnsping or sqlplus works fine. TNS-04414: File error caused by: TNS-04612: Null RHS for “service_name”
Adding a new node to an existing cluster results in PRKC-1025 error
The PRKC-1025 error is encountered when adding a new node to an existing cluster using the following command in Oracle release 10g and 11g: ./addNode.sh -silent "CLUSTER_NEW_NODES={joords4}" "CLUSTER_NEW_VIRTUAL_HOSTNAMES={joords4-vip}" -debug -logLevel finest" This command create the following output : SEVERE: 4/9/12 3:55:03 AM IST: Abnormal program termination. An internal error has occured. Please provide the following files to Oracle Support : "/opt/oracle/oraInventory/logs/addNodeActions2012-04-09_03-54-34AM.log" "/opt/oracle/oraInventory/logs/oraInstall2012-04-09_03-54-34AM.err" "/opt/oracle/oraInventory/logs/oraInstall2012-04-09_03-54-34AM.out" INFO: 4/9/10 3:55:03 AM IST: User Selected: Yes/OK From the oraInstall[date-timestamp]AM.err we notice the following errors: oracle.ops.mgmt.cluster.SharedDeviceException: PRKC-1025 : Failed to create a file under the filepath /opt because the filepath is not executable or w...
Disable the automatic startup of the Oracle Clusterware (CRS|HAS) software
Sometimes, you need for maintenace reasons or others to disable the automatic startup of the Oracle Clusterware software. For that, we use the following commands crsctl disable/enable has crsctl disable/enable crs In some situations, it is interesting, to know in which file the information can be found for enable/disable of automatic startup of the Oracle Clusterware configuration. The configuration is stored in the repository
Oracle q-quote (Quoting Character Literals)
By default you must quote character literals in single-quotes, as in 'Hello'. This technique can sometimes be inconvenient if the text itself contains single quotes. Oracle 10g allows you to define your own string delimiters to remove the need to double up any single quotes. Any character that is not present in the string can be used as the delimiter. The Q-quote mechanism, which enables you to specify q or Q followed by a single quote and then another character to be used as the quote delimiter.