Creating single instance database on Linux with Oracle clusterware

From: Maureen English <sxmte_at_email.alaska.edu>
Date: Wed, 19 Nov 2008 12:03:17 -0900
Message-ID: <49247F15.5030702@email.alaska.edu>


We have a Linux RHEL5 cluster on which we just installed Oracle Clusterware. oracle's home directory is on a shared filesystem, thus the rdbms installation is on a shared filesystem.

When trying to create a database, I originally got the following error

> SQL*Plus: Release 10.2.0.3.0 - Production on Tue Nov 18 13:12:41 2008
>
> Copyright (c) 1982, 2006, Oracle. All Rights Reserved.
>
> Error 45 initializing SQL*Plus
> Internal error

Our sysadmin upgraded/patched something on the system and I was then able to connect to sqlplus and execute a create database statement.

However, when I tried to execute catalog.sql, I got the error 45 again. The script where the error occurs is @@stdspec.sql when it is called from catalog.sql:

> 1351 function TO_TIME_TZ (RIGHT varchar2 character set any_cs)
> 1352 return TIME_TZ_UNCONSTRAINED;
> 1353 pragma BUILTIN('TO_TIME_TZ', 0, 15, 5);
> 1354 Error 45 initializing SQL*Plus
> Internal error

I just tried creating a database using dbca and got another error:

ORA-06553, PLS-213, package standard not accessible

Can anyone point me in the right direction here?

Note that glogin.sql has not been modified (doesn't have set serveroutput on). Also, I'm creating the datafiles on a separate filesystem, not in $ORACLE_HOME/oradata, and the scripts I was using have been used successfully on another RHEL5 machine (not a cluster, though).

I have an open SR with Oracle, and the sysadmin wants me to try this again after moving the Oracle installation to a local filesystem. That will sort of defeat the purpose of having the cluster, but I'm willing to try it to see what happens.

Any ideas/suggestions are most welcome.

Received on Wed Nov 19 2008 - 15:03:17 CST

Original text of this message