Playing around with XE on Ubuntu Feisty and creating an XE instance via a script - which XE has (called dbcreate.sh in the bin dir).
However, it fails. With an error does not make any sense to me. How/why/where is the STANDARD package required for the CREATE DATABASE statement? And how to correct it...
The gory details:
SQL> connect / as sysdba
Connected to an idle instance.
SQL> startup nomount pfile=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/dbs/initXE.ora
ORACLE instance started.
Total System Global Area 146800640 bytes
Fixed Size 1257668 bytes
Variable Size 58724156 bytes
Database Buffers 83886080 bytes
Redo Buffers 2932736 bytes
SQL>
SQL> whenever sqlerror exit;
SQL>
SQL> create database
2 maxinstances 1
3 maxloghistory 2
4 maxlogfiles 16
5 maxlogmembers 2
6 maxdatafiles 30
7 datafile '/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/dbs/system.dbf'
8 size 256M reuse
9 extent management local
10 sysaux datafile '/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/dbs/sysaux.dbf'
11 size 256M reuse
12 default temporary tablespace temp tempfile '/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/dbs/temp.dbf'
13 size 32M reuse
14 undo tablespace undo datafile '/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/dbs/undots1.dbf'
15 size 62M reuse
16 character set us7ascii
17 national character set al16utf16
18 set time_zone='00:00'
19 controlfile reuse
20 logfile '/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/dbs/log1.dbf' size 50m reuse
21 , '/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/dbs/log2.dbf' size 50m reuse
22 , '/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/dbs/log3.dbf' size 50m reuse
23 user system identified by oracle
24 user sys identified by oracle
25 /
ERROR:
ORA-06553: PLS-213: package STANDARD not accessible
Yes, a couple of minor mods to the create db statement as I do not like using autoextending. But when I reverted to the original script (me learned hard lesson of always make backup ;) ), it gives the same error. Thus it could/should not be that.
As a sanity check, I ran another dbcreate script we have for creating an Oracle SE instance (we have this same SE instance + server app code installed on 18+ platforms and thus created a standard installer for it). I had to modify the pfile to comply to XE limitations. And this dbcreate script (which works fine for SE) fails with its CREATE DATABASE statement and the same error about the STANDARD package not being "accessible".
An environment issue? I sourced $ORACLE_HOME/bin/oracle_env.sh before running the dbcreate.sh....
What am I missing? (besides hair and more coffee?)