Archive | Database

Oracle 11g SQL Error Logging

We’re working on the installation scripts for an internal PL/SQL applications. Multiple scripts are called from the main one. To capture errors from script execution, normally the spool syntax will be used in the scripts to pipe out all executions into log files, and then later the deployment team members will examine them using find/search […]

Continue Reading 5

Mumbai – Free Performance Analysis Tool for Oracle Database

I found this tool via Karl Arao’s TiddlyWiki under the Performance Database Tools.  This free tool written by Marcus Mönnig called Mumbai has many nifty features focusing on data visualization including session profiling, alert & trace file viewing, 10046 tracing/viewing within the tool, etc. It also integrates with snapper and orasrp. Here are some introductory […]

Continue Reading 1

Easy Connect (EZCONNECT) Naming Method with Instance Name

Oftentimes I use the Easy Connect (EZCONNECT) to connect to a new database just to quickly verify database connectivity. The syntax I usually use is as follows: CONNECT username/password@[//]host[:port][/service_name] CONNECT scott/tiger@host1-vip:1522/RACDB In RAC, this will connect to whatever instance based on the service’s load balancing goal. I just learned that with the 11g net services […]

Continue Reading 3

Migration of the 11g R1 OCR and Voting disks to different paths when Cluster Ready Service (CRS) is off-line

During a new setup of our 11g R1 (11.1.0.7) on Solaris platform, initially the system is provided with only single path to disks (LUNs) on SAN. Later the sys admins would like to enable the multipathing. 🙁 Obviously, it is expected that the disk paths will be changed. This will not only affect the ASM […]

Continue Reading 1

Powered by WordPress. Designed by WooThemes