Posts

Showing posts from August, 2012

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.