Error installing Gallery Core

I'm not able to decipher your debug code because you don't output the sqlstatement causing the error. Directly after your CREATE

create or replace function BIT_OR(input number) return number
parallel_enable aggregate using BIT_OR_IMPL;

I receive an ORA 900 error.

The function is created and valid, so I'm assuming the ORA900 isn't caused by the function creation.

However, I did notice a table missing later in the output.

oci8po error: [942: ORA-00942: table or view does not exist

So, from your debug output, it looks like your CREATE TABLE g2_FactoryMap failed.

DEBUG output follows:
-----------------------------------------
Unable to install the core module
Unable to activate the core module

Stack Trace:
Error (ERROR_STORAGE_FAILURE)

* in modules/core/classes/GalleryStorage/DatabaseStorage.class at line 1136 (gallerystatus::error)
* in modules/core/classes/GalleryStorage.class at line 220 (oracledatabasestorage::search)
* in modules/core/classes/Gallery.class at line 189 (gallerystorage::search)
* in modules/core/classes/helpers/GalleryPluginHelper_simple.class at line 424 (gallery::search)
* in modules/core/classes/helpers/GalleryPluginHelper_simple.class at line 301 (gallerypluginhelper_simple::fetchpluginlist)
* in modules/core/classes/GalleryCoreApi.class at line 262 (gallerypluginhelper_simple::fetchpluginstatus)
* in modules/core/classes/GalleryPlugin.class at line 136 (gallerycoreapi::fetchpluginstatus)
* in modules/core/classes/GalleryModule.class at line 275 (galleryplugin::activate)
* in install/steps/InstallCoreModuleStep.class at line 90 (coremodule::activate)
* in install/index.php at line 168 (installcoremodulestep::loadtemplatedata)

Debug Output:

file_exists(/var/www/g2data//cache/entity)
file_exists(/var/www/g2data//cache/layout)
file_exists(/var/www/g2data//cache/module)
file_exists(/var/www/g2data//cache/derivative)

(oci8po): ALTER SESSION SET NLS_DATE_FORMAT='YYYY-MM-DD'

(oci8po): select lower(table_name), table_type from cat where table_type
in ('TABLE', 'VIEW')

file_exists(/var/www/html/gallery2/modules/core/classes/helpers/../../../../modules/core/module.inc)
file_exists(/var/www/html/gallery2/modules/core/classes/GalleryStorage/../../../../modules/core/classes/GalleryStorage/DatabaseStorage/schema/platform/oracle)
opendir(/var/www/html/gallery2/modules/core/classes/GalleryStorage/../../../../modules/core/classes/GalleryStorage/DatabaseStorage/schema/platform/oracle)
readdir(Resource id #53)
readdir(Resource id #53)
readdir(Resource id #53)
readdir(Resource id #53)
readdir(Resource id #53)
readdir(Resource id #53)
readdir(Resource id #53)
readdir(Resource id #53)
readdir(Resource id #53)
readdir(Resource id #53)
readdir(Resource id #53)
readdir(Resource id #53)
readdir(Resource id #53)
readdir(Resource id #53)
readdir(Resource id #53)
readdir(Resource id #53)
readdir(Resource id #53)
readdir(Resource id #53)
readdir(Resource id #53)
readdir(Resource id #53)
readdir(Resource id #53)
readdir(Resource id #53)
readdir(Resource id #53)
readdir(Resource id #53)
readdir(Resource id #53)
readdir(Resource id #53)
readdir(Resource id #53)
readdir(Resource id #53)
readdir(Resource id #53)
readdir(Resource id #53)
readdir(Resource id #53)
readdir(Resource id #53)
readdir(Resource id #53)
readdir(Resource id #53)
readdir(Resource id #53)
readdir(Resource id #53)
readdir(Resource id #53)
readdir(Resource id #53)
readdir(Resource id #53)
readdir(Resource id #53)
readdir(Resource id #53)
readdir(Resource id #53)
readdir(Resource id #53)
closedir(Resource id #53)

(oci8po): select lower(table_name), table_type from cat where table_type
in ('TABLE', 'VIEW')

fopen(/var/www/html/gallery2/modules/core/classes/GalleryStorage/../../../../modules/core/classes/GalleryStorage/DatabaseStorage/schema/platform/oracle/Schema.sql,
r, 0)
feof(Resource id #55)
fgets(Resource id #55, 4096)
feof(Resource id #55)
fgets(Resource id #55, 4096)
feof(Resource id #55)
fgets(Resource id #55, 4096)
feof(Resource id #55)
fgets(Resource id #55, 4096)
feof(Resource id #55)
fgets(Resource id #55, 4096)
feof(Resource id #55)
fgets(Resource id #55, 4096)
feof(Resource id #55)
fgets(Resource id #55, 4096)
feof(Resource id #55)
fgets(Resource id #55, 4096)
feof(Resource id #55)
fgets(Resource id #55, 4096)
feof(Resource id #55)
fgets(Resource id #55, 4096)
feof(Resource id #55)
fgets(Resource id #55, 4096)
feof(Resource id #55)
fgets(Resource id #55, 4096)
feof(Resource id #55)
fgets(Resource id #55, 4096)
feof(Resource id #55)
fgets(Resource id #55, 4096)
feof(Resource id #55)
fgets(Resource id #55, 4096)
feof(Resource id #55)
fgets(Resource id #55, 4096)
feof(Resource id #55)
fgets(Resource id #55, 4096)
feof(Resource id #55)
fgets(Resource id #55, 4096)
feof(Resource id #55)
fgets(Resource id #55, 4096)
feof(Resource id #55)
fgets(Resource id #55, 4096)
feof(Resource id #55)
fgets(Resource id #55, 4096)
feof(Resource id #55)
fgets(Resource id #55, 4096)
feof(Resource id #55)
fgets(Resource id #55, 4096)
feof(Resource id #55)
fgets(Resource id #55, 4096)
feof(Resource id #55)
fgets(Resource id #55, 4096)
feof(Resource id #55)
fgets(Resource id #55, 4096)
feof(Resource id #55)
fgets(Resource id #55, 4096)
feof(Resource id #55)
fgets(Resource id #55, 4096)
feof(Resource id #55)
fgets(Resource id #55, 4096)
feof(Resource id #55)
fgets(Resource id #55, 4096)
feof(Resource id #55)
fgets(Resource id #55, 4096)
feof(Resource id #55)
fgets(Resource id #55, 4096)
feof(Resource id #55)
fgets(Resource id #55, 4096)
feof(Resource id #55)
fgets(Resource id #55, 4096)
feof(Resource id #55)
fgets(Resource id #55, 4096)
feof(Resource id #55)
fgets(Resource id #55, 4096)
feof(Resource id #55)
fgets(Resource id #55, 4096)
feof(Resource id #55)
fgets(Resource id #55, 4096)
feof(Resource id #55)
fgets(Resource id #55, 4096)
feof(Resource id #55)
fgets(Resource id #55, 4096)
feof(Resource id #55)
fgets(Resource id #55, 4096)
feof(Resource id #55)
fgets(Resource id #55, 4096)
feof(Resource id #55)
fgets(Resource id #55, 4096)
feof(Resource id #55)
fgets(Resource id #55, 4096)
feof(Resource id #55)

(oci8po): -- This file was automatically generated from an XSL template,
which is
-- why it looks so ugly. Editing it by hand would be a bad idea.
--

CREATE TABLE g2_Schema (
g_name
VARCHAR2(
128
)

NOT NULL

,
g_major
INTEGER

NOT NULL

,
g_minor
INTEGER

NOT NULL

)

(oci8po): ALTER TABLE g2_Schema
ADD PRIMARY KEY (g_name)

(oci8po): INSERT INTO g2_Schema (
g_name,
g_major,
g_minor
) VALUES (
'Schema',
1,
0
)

(oci8po): CREATE SEQUENCE g2_SequenceLock START WITH 1

(oci8po): CREATE SEQUENCE g2_SequenceId START WITH 1

(oci8po): SELECT g_name, g_major, g_minor FROM g2_Schema

fopen(/var/www/html/gallery2/modules/core/classes/GalleryStorage/../../../../modules/core/classes/GalleryStorage/DatabaseStorage/schema/platform/oracle/CreateBitOr.sql,
r, 0)
feof(Resource id #62)
fgets(Resource id #62, 4096)
feof(Resource id #62)
fgets(Resource id #62, 4096)
feof(Resource id #62)
fgets(Resource id #62, 4096)
feof(Resource id #62)
fgets(Resource id #62, 4096)
feof(Resource id #62)
fgets(Resource id #62, 4096)
feof(Resource id #62)
fgets(Resource id #62, 4096)
feof(Resource id #62)
fgets(Resource id #62, 4096)
feof(Resource id #62)
fgets(Resource id #62, 4096)
feof(Resource id #62)
fgets(Resource id #62, 4096)
feof(Resource id #62)
fgets(Resource id #62, 4096)
feof(Resource id #62)
fgets(Resource id #62, 4096)
feof(Resource id #62)
fgets(Resource id #62, 4096)
feof(Resource id #62)
fgets(Resource id #62, 4096)
feof(Resource id #62)
fgets(Resource id #62, 4096)
feof(Resource id #62)
fgets(Resource id #62, 4096)
feof(Resource id #62)
fgets(Resource id #62, 4096)
feof(Resource id #62)
fgets(Resource id #62, 4096)
feof(Resource id #62)
fgets(Resource id #62, 4096)
feof(Resource id #62)
fgets(Resource id #62, 4096)
feof(Resource id #62)
fgets(Resource id #62, 4096)
feof(Resource id #62)
fgets(Resource id #62, 4096)
feof(Resource id #62)
fgets(Resource id #62, 4096)
feof(Resource id #62)
fgets(Resource id #62, 4096)
feof(Resource id #62)
fgets(Resource id #62, 4096)
feof(Resource id #62)
fgets(Resource id #62, 4096)
feof(Resource id #62)
fgets(Resource id #62, 4096)
feof(Resource id #62)
fgets(Resource id #62, 4096)
feof(Resource id #62)
fgets(Resource id #62, 4096)
feof(Resource id #62)
fgets(Resource id #62, 4096)
feof(Resource id #62)
fgets(Resource id #62, 4096)
feof(Resource id #62)
fgets(Resource id #62, 4096)
feof(Resource id #62)
fgets(Resource id #62, 4096)
feof(Resource id #62)
fgets(Resource id #62, 4096)
feof(Resource id #62)
fgets(Resource id #62, 4096)
feof(Resource id #62)
fgets(Resource id #62, 4096)
feof(Resource id #62)
fgets(Resource id #62, 4096)
feof(Resource id #62)
fgets(Resource id #62, 4096)
feof(Resource id #62)
fgets(Resource id #62, 4096)
feof(Resource id #62)
fgets(Resource id #62, 4096)
feof(Resource id #62)
fgets(Resource id #62, 4096)
feof(Resource id #62)
fgets(Resource id #62, 4096)
feof(Resource id #62)
fgets(Resource id #62, 4096)
feof(Resource id #62)
fgets(Resource id #62, 4096)
feof(Resource id #62)
fgets(Resource id #62, 4096)
feof(Resource id #62)
fgets(Resource id #62, 4096)
feof(Resource id #62)
fgets(Resource id #62, 4096)
feof(Resource id #62)
fgets(Resource id #62, 4096)
feof(Resource id #62)
fgets(Resource id #62, 4096)
feof(Resource id #62)
fgets(Resource id #62, 4096)
feof(Resource id #62)

(oci8po): -- Create BIT_OR aggregate function (requires Oracle 9i or
higher)

create or replace type BIT_OR_IMPL as object (
val NUMBER,
static function ODCIAggregateInitialize(sctx IN OUT BIT_OR_IMPL)
return number,
member function ODCIAggregateIterate(self IN OUT BIT_OR_IMPL,
value IN number) return number,
member function ODCIAggregateTerminate(self IN OUT BIT_OR_IMPL,
returnValue OUT number, flags IN number) return number,
member function ODCIAggregateMerge(self IN OUT BIT_OR_IMPL,
ctx2 IN BIT_OR_IMPL) return number
)

(oci8po): create or replace type body BIT_OR_IMPL is
static function ODCIAggregateInitialize(sctx IN OUT BIT_OR_IMPL)
return number is
begin
sctx := BIT_OR_IMPL(0);
return ODCIConst.Success;
end;
member function ODCIAggregateIterate(self IN OUT BIT_OR_IMPL,
value IN number) return number is
begin
self.val := (self.val + value) - BitAND(self.val, value);
return ODCIConst.Success;
end;
member function ODCIAggregateTerminate(self IN OUT BIT_OR_IMPL,
returnValue OUT number, flags IN number) return number is
begin
returnValue := self.val;
return ODCIConst.Success;
end;
member function ODCIAggregateMerge(self IN OUT BIT_OR_IMPL,
ctx2 IN BIT_OR_IMPL) return number is
begin
self.val := (self.val + ctx2.val) - BitAND(self.val, ctx2.val);
return ODCIConst.Success;
end;
end;

(oci8po): create or replace function BIT_OR(input number) return number
parallel_enable aggregate using BIT_OR_IMPL;

oci8po error: [900: ORA-00900: invalid SQL statement
] in EXECUTE("-- Extra semicolons above ensure executed statements
includes a semicolon at the end
-- (one is stripped off when this file is split into multiple blocks)")

(oci8po): -- Extra semicolons above ensure executed statements includes a
semicolon at the end
-- (one is stripped off when this file is split into multiple blocks)

Warning: ociexecute(): OCIStmtExecute: ORA-00900: invalid SQL
statement
in /var/www/html/gallery2/lib/adodb/drivers/adodb-oci8.inc.php on
line 869

900: ORA-00900: invalid SQL statement

adodb_oci8po._execute(-- Extra semicolons above
ensure executed statements includes a ..., false) % line 833, file: adodb.inc.php
adodb_oci8po.execute(-- Extra semicolons above ensure
executed statements includes a ...) %
line 1702, file: DatabaseStorage.class
oracledatabasestorage._executesqlfile(/var/www/html/gallery2/modules/core/classes/GalleryStorage/../.....) % line 1511, file: DatabaseStorage.class
oracledatabasestorage.configurestore(core) % line 338, file: GalleryStorage.class
gallerystorage.configurestore(core) % line 132, file: GalleryModule.class

realpath(/var/www/html/gallery2/modules/core/classes/../../../)
oci8po error: [942: ORA-00942: table or view does not exist
] in EXECUTE("
SELECT
g2_FactoryMap.g_classType,
g2_FactoryMap.g_className,
g2_FactoryMap.g_implId,
g2_FactoryMap.g_implPath,
g2_FactoryMap.g_hints
FROM
g2_FactoryMap
ORDER BY
g2_FactoryMap.g_orderWeight ASC
")

(oci8po):
SELECT
g2_FactoryMap.g_classType,
g2_FactoryMap.g_className,
g2_FactoryMap.g_implId,
g2_FactoryMap.g_implPath,
g2_FactoryMap.g_hints
FROM
g2_FactoryMap
ORDER BY
g2_FactoryMap.g_orderWeight ASC

Warning: ociexecute(): OCIStmtExecute: ORA-00942: table or view
does not exist
in /var/www/html/gallery2/lib/adodb/drivers/adodb-oci8.inc.php on
line 869

942: ORA-00942: table or view does not exist

adodb_oci8po._execute(
SELECT
g2_FactoryMap.g_classT..., false) % line 833, file: adodb.inc.php
adodb_oci8po.execute(
SELECT
g2_FactoryMap.g_classT..., Array[0]) % line 1128, file: DatabaseStorage.class
oracledatabasestorage.search(
SELECT
[GalleryFactoryMap::cl..., Array[0],
Array[0]) % line 220, file: GalleryStorage.class
gallerystorage.search(
SELECT
[GalleryFactoryMap::cl..., Array[0],
Array[0]) % line 189, file: Gallery.class
gallery.search(
SELECT
[GalleryFactoryMap::cl...) % line 99, file: GalleryFactoryHelper_simple.class

oci8po error: [942: ORA-00942: table or view does not exist
] in EXECUTE("
SELECT
g2_PluginMap.g_pluginId,
g2_PluginMap.g_active
FROM
g2_PluginMap
WHERE
g2_PluginMap.g_pluginType = ?
")

(oci8po):
SELECT
g2_PluginMap.g_pluginId,
g2_PluginMap.g_active
FROM
g2_PluginMap
WHERE
g2_PluginMap.g_pluginType = ?
[ (0=>'module') ]

Warning: ociexecute(): OCIStmtExecute: ORA-00942: table or view
does not exist
in /var/www/html/gallery2/lib/adodb/drivers/adodb-oci8.inc.php on
line 869

942: ORA-00942: table or view does not exist

adodb_oci8po._execute(
SELECT
g2_PluginMap.g_pluginId,
..., Array[1]) % line 829, file:
adodb.inc.php
adodb_oci8po.execute(
SELECT
g2_PluginMap.g_pluginId,
..., Array[1]) % line 1128, file:
DatabaseStorage.class
oracledatabasestorage.search(
SELECT
[GalleryPluginMap::pluginId],
..., Array[1], Array[0]) % line 220,
file: GalleryStorage.class
gallerystorage.search(
SELECT
[GalleryPluginMap::pluginId],
..., Array[1], Array[0]) % line 189,
file: Gallery.class
gallery.search(
SELECT
[GalleryPluginMap::pluginId],
..., Array[1]) % line 424, file: GalleryPluginHelper_simple.class

realpath(/var/www/html/gallery2/modules/core/classes/../../../)
oci8po error: [942: ORA-00942: table or view does not exist
] in EXECUTE("
SELECT
g2_FactoryMap.g_classType,
g2_FactoryMap.g_className,
g2_FactoryMap.g_implId,
g2_FactoryMap.g_implPath,
g2_FactoryMap.g_hints
FROM
g2_FactoryMap
ORDER BY
g2_FactoryMap.g_orderWeight ASC
")

(oci8po):
SELECT
g2_FactoryMap.g_classType,
g2_FactoryMap.g_className,
g2_FactoryMap.g_implId,
g2_FactoryMap.g_implPath,
g2_FactoryMap.g_hints
FROM
g2_FactoryMap
ORDER BY
g2_FactoryMap.g_orderWeight ASC

Warning: ociexecute(): OCIStmtExecute: ORA-00942: table or view
does not exist
in /var/www/html/gallery2/lib/adodb/drivers/adodb-oci8.inc.php on
line 869

942: ORA-00942: table or view does not exist

adodb_oci8po._execute(
SELECT
g2_FactoryMap.g_classT..., false) % line 833, file: adodb.inc.php
adodb_oci8po.execute(
SELECT
g2_FactoryMap.g_classT..., Array[0]) % line 1128, file: DatabaseStorage.class
oracledatabasestorage.search(
SELECT
[GalleryFactoryMap::cl..., Array[0],
Array[0]) % line 220, file: GalleryStorage.class
gallerystorage.search(
SELECT
[GalleryFactoryMap::cl..., Array[0],
Array[0]) % line 189, file: Gallery.class
gallery.search(
SELECT
[GalleryFactoryMap::cl...) % line 99, file: GalleryFactoryHelper_simple.class

Suspecting that the CREATE TABLE scripts failed was correct. Had nothing to do with the function creation.

Rerunning
GalleryFactoryMap.sql and GalleryPluginParameterMap.sql
in
gallery2/modules/core/classes/GalleryStorage/DatabaseStorage/schema/platform/oracle
after substitions removed the errors. I have yet to get a main page though.