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 …
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 …
Mumbai – Free Performance Analysis Tool for Oracle Database Read More »
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 …
Easy Connect (EZCONNECT) Naming Method with Instance Name Read More »
I must admit that I rarely use the Oracle SQL Developer because I’m using SQL*Plus, Toad from Quest and PL/SQL Developer from Allround Automations as primary tools for database administration and PL/SQL programming. They’re already providing all functionalities I need. I have nothing against Oracle SQL Developer. Actually it is quite opposite. I really want …
Book Review: Oracle SQL Developer 2.1 by Sue Harper Read More »
It has been awhile since my last post. My pathetic excuses are all pretty much mentioned here. 🙂 Last month we’ve worked with the storage team to migrate the SAN storage of our Oracle 11gR1 database to a new one. The drive of migration is mainly for SAN consolidation which is, of course, ultimately for …
Online SAN Storage Migration for Oracle 11g RAC database with ASM Read More »
I found this tip from forum discussing about Oracle’s reserved words. You can use it to quickly view reserved words for both SQL and PL/SQL. SQL> help reserved RESERVED WORDS (PL/SQL) ———————– PL/SQL Reserved Words have special meaning in PL/SQL, and may not be used for identifier names (unless enclosed in “quotes”). An asterisk (*) …
