Joords Oracle DBA blog

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

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.

** Oracle R Enterprise ** Integrates the Open-Source Statistical Environment R with Oracle Database 11g.Oracle R Enterprise allows analysts and statisticians to run existing R applications and use the R client directly against data stored in Oracle Database 11g—vastly increasing scalability, performance and security. The combination of Oracle Database 11g and R delivers an enterprise-ready, deeply integrated environment for advanced analytics. Users can also use analytical sandboxes, where they can analyze data and develop R scripts for deployment while results stay managed inside Oracle Database. My first contact with R was by the blog post of Frits Hoogland " Using R and Oracle tracefiles "

I recieved last week that i have passed successful the completion of the Oracle DBA 11g Certified Master practicum. I will recieve my Oracle DBA 11g Certification Master fulfillment kit that includes the OCM certificate. This process will take global 6 weeks.

The Oracle Database Listener is the database server software component that manages the network traffic between the Oracle Database and the client. The Oracle Database Listener listens on a specific network port (default 1521) and forwards network connections to the Database. One of the most misunderstood security issues with the Oracle Database is the security of the Listener. The listener is one of the most critical components to database operations; It is responsible for the ability to have a client/server communication In dedicated mode it is responsible for creating a new process (or thread on Windows) on behalf of the client and setting up the communications On Windows each such server process actually speaks on a new tcpip port and the listener redirects the client to this port On Unix streaming continues on the original port The listener forks a new process The listener then closes its own fd-s; the new process continues to speak on the fd-s ...

Summary of the presentation  "Oracle Enterprise Manager Cloud Control 12c" by Rob Zoeteweij Result of 3 years development More than 500 enhancement requests included Code rewrite Enhanced user interface Management Oracle products via plug-ins New credentials model Personalisation support Customizable page layout Add / remove regions in page Specify data displayed in region Pre-defined homepage layouts Click on the link  Oracle Enterprise Manager Cloud Control 12c  to get the presentation.

OracleRemExecService is a service which is only used temporarily by the OUI It gets removed when OUI is finished with it, therefore, it will have a value of 'DISABLED' until a reboot - then it will simply be gone, ignore and leave this service untouched. The Oracle Windows service "OracleRemExecService" to execute various commands from Oracle applications like DBCA and GUI. The service itself relies on a named pipe to receive the commands.