PeterNic
03-15-2007, 12:03 AM
Not that anyone doubted that Oracle database server would work on AppLogic, but it took more than a year for someone to actually want it there. Here it is: we have our first installation of Oracle in an appliance on a grid.
Oracle 10g XE (express edition) (http://www.oracle.com/technology/products/database/xe/index.html) installed successfully on a Grid Server on CentOS (GSC) application.
The installation went per Oracle's instructions... almost. The first install didn't work because the hostname configured on GSC wasn't resolving correctly -- the installation reported success, and so did orcale-xe configure. However, there was no APEX listening on port 8080; even though the db listener was active on port 1521, sqlplus failed after authenticating the user, saying the server was either initializing or shutting down.
Once the hostname was fixed (by putting the name in /etc/hosts or actually in DNS), the RPM removed and reinstalled from scratch, everything went smoothly. Both the command line SQL (sqlplus) and the APEX web-based control panel worked (after allowing port 8080 through the GSC firewall).
Now, the only thing left is for someone who groks Oracle to build a catalog class with properties and terminals (and, of course, let's check the license terms for distributing the catalog appliance).
Regards,
-- Peter
Oracle 10g XE (express edition) (http://www.oracle.com/technology/products/database/xe/index.html) installed successfully on a Grid Server on CentOS (GSC) application.
The installation went per Oracle's instructions... almost. The first install didn't work because the hostname configured on GSC wasn't resolving correctly -- the installation reported success, and so did orcale-xe configure. However, there was no APEX listening on port 8080; even though the db listener was active on port 1521, sqlplus failed after authenticating the user, saying the server was either initializing or shutting down.
Once the hostname was fixed (by putting the name in /etc/hosts or actually in DNS), the RPM removed and reinstalled from scratch, everything went smoothly. Both the command line SQL (sqlplus) and the APEX web-based control panel worked (after allowing port 8080 through the GSC firewall).
Now, the only thing left is for someone who groks Oracle to build a catalog class with properties and terminals (and, of course, let's check the license terms for distributing the catalog appliance).
Regards,
-- Peter