Oracle VM Site Review - Oracle VM Health Check
view counter

PL/SQL Feed

Oracle PL/SQL (Procedural Language/Structured Query Language) resources, news, and support articles.

What’s ORACLE_UNQNAME?

It started with a three part question: What’s the URL to run the DB Console for Oracle Database 11gR2 on Windows 7, and what’s the ORACLE_UNQNAME and why isn’t it defined by the installation. The first part is easy (shown further below), but the second and third parts were more involved.

The ORACLE_UNQNAME is an operating system environment variable that holds the database’s unique name value. You can find it with the following query as the SYSTEM user (through SQL*Plus):

Verifying a Perl Socket

Using a lowercase hostname is typical but I got sloppy on a Windows 7 installation, after all Windows is case insensitive, and I used a mixed case hostname. It raised an interesting error when installing Oracle Database 11g Release 2.

Repeat until understood


Click the SQL for scripts

MySQL Workbench Scripts

It’s always interesting when somebody asks why they got an error message, and especially sweet when you’re working on something related that lets you answer the question. They were using MySQL Workbench and wanted to know why they couldn’t open a SQL script file by clicking on the Scripting menu option.

Ryan a Smart and Courageous Policy Wonk?

Here's a list of some of the people and organizations who have publicly questioned the brilliance, honesty, seriousness, and/or courage of Paul Ryan’s policy proposals (with thanks to Eric Alterman of the Nation):

Analysts at the nonpartisan Congressional Budget Office

The Endowment effect


Click the SQL for scripts

SQL Developer JVM Fix

It’s amazing the moving parts in Oracle Database 11g, and the ones that I don’t use after installation for a while often reach out to teach me something new. That’s what happened when I went to launch SQL Developer on my Windows 7 Professional 64-bit installation.

view counter