Create Table – ORA-00907: missing right parenthesis — CHECK and DEFAULT Order Swapped

Posted on Mar 30, 2011 in Technical Tips | 0 comments

Most people, including myself, don’t memorize the syntax and associated options for every programming language. So, I was interested in determining what the issue was with the following create table command that one of my developers was having. He continued to receive the following error, regardless of what he did with parentheses:

ORA-00907: missing right parenthesis

CREATE TABLE AppItem (id INTEGER PRIMARY KEY NOT NULL,
name VARCHAR(100),
url VARCHAR(100),
required CHAR(1) CHECK (required IN('N','Y')) DEFAULT 'N',
img VARCHAR(100),
title VARCHAR(100),
description VARCHAR(100)
);

Being that the parentheses evened out, I first thought that the word required would be a reserved word in Oracle, so I tried changing that to is_required. No dice. After a little more fiddling — and only a few seconds before I would have turned to some documentation — I realized that the CHECK constraint needed to come after the DEFAULT value setting.

CREATE TABLE AppItem (id INTEGER PRIMARY KEY NOT NULL,
name VARCHAR(100),
url VARCHAR(100),
required CHAR(1) DEFAULT 'N' CHECK (required IN('N','Y')),
img VARCHAR(100),
title VARCHAR(100),
description VARCHAR(100)
);

Download Archived and Older Java SE and EE JDKs and JREs

Posted on Mar 25, 2011 in Technical Tips | 0 comments

We just had to download Java SE JDK 1.6.0_11 (6 Update 11) and finding the files was not as intuitive as we had hoped. So, navigate to this link and you will see a screen like below where you can download many previous releases. Hope this helps get you there more quickly.

WebLogic 11g (10.3.4) Install on Windows – WLS 11gR3

Posted on Jan 20, 2011 in Technical Tips | 0 comments

I documented the steps I took to complete an install of WebLogic 11g PS3 (10.3.4) — sometimes also called 11gR3 — on my Windows 7 Ultimate 64-bit OS. There is only a 32-bit version of WebLogic available for Windows, but it runs fine on Windows 7 64-bit and, as I understand, the same way with other version of the Windows OS as well (Vista, XP, Servers, etc.).

This walk-through covers:

• WebLogic 11g Install on Windows
• One Admin Server and one Managed Server

WebCenter 11g Book – Hello World Examples, Screenshots, and Tutorials

Posted on Dec 14, 2010 in News and Updates, Offerings, Technical Tips | 0 comments

Our WebCenter 11g book has been out a few weeks and I have heard some good reviews from people who have picked it up. This version 1 book will quickly get you started with WebCenter 11g, providing you step-by-step screenshots on creating your environment followed by a Hello World web service that is exposed to the web as a WebCenter portlet among other common business scenarios you may need to accomplish.

JDeveloper 11g Tutorial – Install Steps (11.1.1.3.0)

Posted on Sep 27, 2010 in Technical Tips | 0 comments

New versions of JDeveloper 11g have been released since the last step-by-step JDev install guide, so I thought I would post a quick refresher for anyone who wants that comfort of knowing they are seeing the screens they should expect to see as they march through the install. Enjoy; the product really is getting better and better everyday.

Installing JDeveloper 11g (11.1.1.3.0) on Windows

Oracle DBMS_SCHEDULER vs DBMS_JOB (Create, Run, Monitor, Remove)

Posted on Jul 23, 2010 in Technical Tips | 0 comments

DBMS_SCHEDULER is a newer, more complex job scheduling engine released in 10g, intended to replace DBMS_JOB going forward. DBMS_JOB, the older job scheduler, as of now is still available for quick and easy DB based job scheduling.

Job scheduling comprises the core of the functionality of DBMS_SCHUDULER, however here are some additional benefits available to DBMS_SCHEDULER:

• Logging of job runs (job history)
• Simple but powerful scheduling syntax (similar to but more powerful than cron syntax)
• Running of jobs outside of the database on the operating system (see below)
• Resource management between different classes of jobs
• Use of job arguments including passing of objects into stored procedures
• Privilege-based security model for jobs
• Naming of jobs and comments in jobs
• Stored, reusable schedules

TOAD for Oracle 9 or TOAD 10 – 64-bit Windows – ORA-12154: could not resolve the connect identifier specified or ORA-6413: connection not open

Posted on Feb 27, 2010 in Technical Tips | 63 comments

I recently downloaded the new 10.x version of TOAD and could not connect to my databases. Still running TOAD 9.x, no problem. This really threw me off for a minute, so I thought I would share the resolution.

You are likely running a 64-bit Windows OS and have installed TOAD into C:\Program Files (x86)\....

I simply copied over my entire Quest Software directory from C:\Program Files (x86)\... to C:\Program Files\..., and restarted the TOAD.exe. Everything is working great, without having to reinstall anything.

PS: Not sure who to blame here. Vendors (like Oracle and TOAD) should know Microsoft is capable of doing strange things with important directory names (using spaces and, in this case, “strange” characters like parentheses)…and of course, Microsoft should simply stop perpetuating the use of these characters in important directories.


UPDATE on 1/12/11: I had to install TOAD again today and noticed a message in the installer about directories with parentheses — glad to see Quest now added a note about it (see screenshot below).



Funny thing is, even though I installed to C:\Program Files\, there were still files created in C:\Program Files (x86)\ that I had to manually copy and paste over. This time, by the way, I cut and paste which also worked — so no files are actually needed in the C:\Program Files (x86)\ folders.

Oracle System Administration – Linux Commands (Red Hat)

Posted on Jun 4, 2009 in Technical Tips | 0 comments

Following is a sortable table of the most common Linux commands we use on a day-to-day basis while implementing and maintaining Oracle Fusion Middleware environments.