Creating single instance database on Linux with Oracle clusterware
- From: Maureen English <sxmte@xxxxxxxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Wed, 19 Nov 2008 12:03:17 -0900
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.
- Maureen
--
//www.freelists.org/webpage/oracle-l
Other related posts:
