Installing Oracle XE on Nodes


Oracle References


Now install the Oracle RPM (copy to /tmp on the server) and answer the installation questions appropriately.

Make sure that any hostnames located in file /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/admin/listener.ora are changed to "localhost" - if this is not changed a reconfigure of oracle is required if the application or server is cloned.


Verify Oracle XE Installation

Use your favorite internet browser and goto http://<newnode>:8080/htmldb

Once you get the Oracle login prompt then enter sys and the password.


Create users and roles

Create environment files in /etc/profile.d/

oraenv.sh

ORACLE_SID=XE;export ORACLE_SID
ORACLE_HOME=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server;export ORACLE_HOME
PATH=$ORACLE_HOME/bin:$PATH;export PATH

gnwenv.sh

VIEWPOINT=/home/vwpoint/viewPoint; export VIEWPOINT
LD_LIBRARY_PATH=/home/vwpoint/viewPoint/lib:$LD_LIBRARY_PATH; export LD_LIBRARY_PATH

Login to sqlplus as SYSTEM (remember password from installation above) and execute the following commands.


Extract live data from Production Node

Login to an existing production node (cablegnw is usually used) as the vwpoint user and extract the current database contents with the following command. Then copy the expDat.dmp file to the new node under the /usr/lib/oracle/xe folder.


Import live data from Production Node

Back on the new node login as the oraclexe user and cd to the folder called /usr/lib/oracle/xe.


If you have integrity constraint problems importing data into new production node, then run the following commands from sqlplus as the dvpointp user to delete all the old data.

Log out of sqlplus. Then as the oraclexe user begin importing 1 table at a time. You can do more than 1 at a time, but they must be in this relative order.


Create Public Synonyms

Obtain a copy of the createNodeSynonyms.sql file (copy to /tmp on the server) and load this into the database as the dvpointp user.


Set Oracle File Permissions

For FC9 the file permissions need to be changed for the Oracle executable. As root:

Installing Oracle XE on Nodes (last edited 2019-11-08 00:26:53 by EricC)