Stel install 10gr3 with oracle xe


Software can be downloaded from eDelivery:

• http://edelivery.oracle.com/EPD/GetUserInfo/get_form

Content Server 10gR3

• Select a product pack: Oracle Fusion Middleware
• Description: Oracle® Enterprise Content Management 10g Release 3 (10.1.3) Media Pack
• Name: Oracle Content Server 10gR3 (10.1.3.3.3)
  

Database 10 XE

• Product Pack: Oracle Database
  
• Oracle® Express Release 6.3.4.0 Media Pack
• Oracle® Express Server Multi-Language Edition (MLE) Version 6.3.4.0 for MS Windows NT

and

• Oracle® Express Client Multi-Language Edition (MLE) Version 6.3.4.0 for Microsoft Windows NT.

To be honest, I haven't tried with these two versions of the database, the copy of the database I used was got from a friend...but update this wiki if it doesn't work!

References

• This page has an excellent description of all installation tasks.
  

Install

Install Apache as per: Install apache for ucm
Create a new user and table space as per:Installing Oracle XE for UCM When you run the text based installer.

• the SID should be xe ( lower case )
• Don't choose to specify a user to start the content server or admin processes

As a one time step do the following. You only ever have to do the following once. Each additional content server you install doesn't require this step.
In order to allow two or more content servers to access the same Oracle XE instance do the following:

• Log into the Oracle XE web interface as SYS and go to SQL ->SQL Commands ->Enter SQL Command
• Enter the following command and click Run:

ALTER SYSTEM SET PROCESSES=150 SCOPE=SPFILE

• Restart the Oracle XE Service
• Verify the issue has been resolved.

Finally install your content server with the command line installer. Below are the settings that I used as an example.

Review install settings. . .
Content Server Core Folder: c:/stellent/10g_3 (IMPORTANT! NO TRAILING SLASH HERE...)
Java virtual machine: Sun Java 1.5.0_11 JDK
Content Server Native Vault Folder: c:/stellent/10g_3/vault/
Content Server Weblayout Folder: c:/stellent/10g_3/weblayout/
Proxy authentication through another server: no
Install admin server: yes
Web Browser Path: c:/program files/internet explorer/iexplore.exe
Content Server locale: English-US
Content Server Port: 4446
Admin Server Port: 4486
Incoming connection address filter: 127.0.0.1
Web Server Relative Root: /10g_3/
Company Mail Server: mail
Administrator E-Mail Address: sysadmin@mail
Web Server HTTP Address: ftnote
Content Server Instance Name: 10g_3
Content Server Instance Label: 10g_3
Content Server Description: Content Server 10g_3
Web Server: Apache
Content Server Database: Oracle
Manually configure JDBC settings for this database: false
Oracle Server Hostname: localhost
Oracle Listener Port Number: 1521
Oracle User: s10g_3_user
Oracle Password: tmjYHYhuQJF3EoTF6DYche+sgf5SNC4fdnWQjZ4KzsU=
Oracle Instance Name: xe
Configure the JVM to find the JDBC driver in a specific jar file: false
Attempt to create database tables: yes
Use Unicode text fields: no
Components:
CheckSCSHealth,comptool,ConfigMigrationUtility,PopUpCalendar,CoreWebdav,WebUrlMa
pPlugin,WsdlGenerator,YahooUserInterfaceLibrary
Configure the Administration Server service: auto
Configure the admin service to run as a specific user: false
Configure admin service to be dependent on another service: false
Configure the Content Server service: auto
Configure the service to run as a specific user: false
Configure service to be dependent on another service: false
Disable 8.3 filename creation: false

UnInstall

To uninstall a content server instance, complete the following steps:

1. Open a command prompt window and navigate to the bin directory of the content server that you want to uninstall, for example c:\stellent\idcm1\bin.
2. Enter Installer UnregisterAll and press [Enter].

UNIX

Setup the startup scripts: I chose to call the script idcserver_ctrl_idc because I have many instances on this same host and I'll have one startup script for each one and append _<server_instance> for each one. I don't think the following will work because the server needs to be started by the stellent user, that's why the section below was created, but it still has problems as noted in red.

[root@vl-ucm1 ~]# cd /u01/oracle/ucm/server/etc/
[root@vl-ucm1 etc]# ln -s idcserver_ctrl /etc/init.d/idcserver_ctrl_idc
[root@vl-ucm1 etc]# ln -s /etc/init.d/idcserver_ctrl_idc /etc/rc2.d/S99idcserver_ctrl_idc
[root@vl-ucm1 etc]# ln -s /etc/init.d/idcserver_ctrl_idc /etc/rc2.d/K01idcserver_ctrl_idc

• Create a file: /etc/init.d/stellent with the following contents: (change the folders as appropriate)

This script leaves a pid file which causes the content server not to restart... can't seem to get rid of the pid
file on shutdown! too bad.
#!/bin/bash
#
# /etc/rc.d/init.d/
#
# chkconfig: 3 98 99
# description: Stellent Content Server


# Source function library.
. /etc/init.d/functions

UCM_DIR=/spare_disk/oracle/ucm/server
PIDFILE=$UCM_DIR/etc/pid

start() {
if [ -f $PIDFILE ]; then
echo ucm already running:
exit 2;
else
cmd="$UCM_DIR/etc/idcserver_start"
cmd="su -m stellent -c '$cmd'"
eval "$cmd"
fi
}


stop() {
echo "Shutting down :"
if [ -f $PIDFILE ]; then
cmd="$UCM_DIR/etc/idcserver_stop"
cmd="su -m stellent -c '$cmd'"
eval "$cmd"

else
echo "Server not running"
fi

return
}

case "$1" in
start)
start
;;
stop)
stop
;;
status)

;;
restart)
stop
start
;;
*)
echo "Usage: {start|stop|status|reload|restart}"
exit 1
;;
esac
exit $?

• Set the owner and group of the file to root and sys, respectively.

chown root:sys stellent

• Set the access permissions of the file.

chmod 754 stellent

• Add the file to the startup script locations using chkconfig

chkconfig --add stellent