Translations of this page:

Sctc Installation


Before you can install Sctc, it is necessary to have 3 tablespaces.

  • Data tablespace
  • Temporary tablespace.
  • Index tablespace (that can be the one dedicated to the datas)

It is mandatory to get a user with the Oracle DBA privileges.

Installation of Sctc

We will see the different steps needed to deploy the application faq.

  1. Log in with the DBA user.
  2. Run the script SCTC_INSTALL.sql

Installation script

 SQL> @c:\sctc\installer\SCTC_INSTALL.sql 

The script will need the inputs for the following informations

  • Log Section
    • A directory to write the log file of the installation.
  • PORTAL Section
    • The portal objects owner (PORTAL by default)
    • The password of the portal objects owner
    • Connection information to the database. (Aka TNSNAMES)
    • Information on your version (if your version is more recent than then enter TRUE)
  • Sctc user Section
    • User name that will own the new faq objects
    • His password
    • His default tablespace
    • His temporary tablespace
    • His index tablespace
  • Sctc configuration Section
    • The URL to access the website (for example: http://localhost)
    • The Dad's portal (eg /portal/pls/portal for a Portal 10gR2)
    • The URL to access the SSO (eg http://sso.localhost:7777/pls/orasso)
    • The directory on the server containing images of sctc (directory must be a subdirectory of the directory $MIDTIER_HOME/portal/images)
    • The path that will be necessary to take to enter Sctc (eg /sctc)
  • Sctc customization Section
    • Page Title
    • Sctc administrator group
    • The default language of Sctc

Entering this information will be followed by the execution of the scripts and the necessary basic configuration.

Apache Configuration

At the end of the installation, the installation script will provide the Rewriting rules for Apache server.

Here are the steps to follow to install them :

  • Open log file generated during installation (sctc_installation.log). The informations are at step 14 ( “Creating mod_rewrite part”)
  • Copy these rules at the end of the httpd.conf file of the Midtier.
  • Restart the http Midtier process to take into account the new rules.

WebCache Configuration

The final step is to configure WebCache server with those steps

  • Go to the site of the midtier website (eg http://localhost:18101)
  • Click on WebCache component
  • Click on administration link
  • Click on the Rules link
  • Click on the Create button
  • Important information must be entered in the Chooser part.
  • In the “url” part, select Regular expression and then put ”/sctc|/portal/pls/portal/sctc_app” (where /sctc is the path that you provide during the install, and sctc_app is the Sctc objects owner)
  • Select the option “Do not cache”
  • Select the option “Expires: As specified in the header HTTP, Regenerate: Immediately”
  • SSelect the option “Compress for all browsers, except Netscape 4.X”
  • Click on Ok
  • Move this rule to the first position
  • Restart Webcache
sctc/installation.txt · Last modified: 2009/08/11 11:44 (external edit)
[unknown button type]
Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Noncommercial-Share Alike 4.0 International