Child pages
  • How to install the Respository on Oracle Express (XE) 11.2

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Tip

The server's hostname (short and fully qualified domain name) must be in /etc/hosts. If is not set, then the Web Manaagement interface will not work correctly.

Step-by-step guide

  1. Install the collector (smr-server-4.0-linux), but skip the configuration step.
  2. Setup your environment (this is just to setup Oracle):

    Code Block
    $ source /u01/app/oracle/product/11.2.0/xe/bin/oracle_env.sh
  3. Create SiteMaestro tablespaces (my password is 'dba', replace with what you picked when you configured Oracle). 

    Tip

    Edit the "ora_ts.sql" script if you wish to change the location of the data files before running this step

    Code Block
    $ cd /opt/collector
    $ sqlplus system/dba
    SQL> start ora_ts
  4. Set passwords not to expire

    Code Block
    alter profile DEFAULT limit password_life_time UNLIMITED;
  5. Create 'sitemaestro' user (this can be whatever you wish)

    Code Block
    $ sqlplus system/dba
    SQL> create user sitemaestro identified by sitemaestro default tablespace sitemaestro_data;
    SQL> grant dba to sitemaestro
    SQL> exit
  6. Create schema (tables and indexes):

    Code Block
    $ cd /opt/collector
    $ sqlplus sitemaestro/sitemaestro
    SQL> start ora_schema
  7. Create views:

    Code Block
    $ cd /opt/collector
    $ sqlplus sitemaestro/sitemaestro
    SQL> start ora_views
  8. Create stored procedures:

    Code Block
    $ cd /opt/collector
    $ sqlplus sitemaestro/sitemaestro
    SQL> start ora_sf
  9. Configure the collector

    Code Block
    $ su -
    $ service smcollector stop
    # cd /opt/collector
    # ./configure.sh
    
    ----------------------------------------------
    
    SiteMaestro Repository
    Set Configuration
    ----------------------------------------------
    Using: /bin/awk
    Using: /bin/echo
    The connection string can be in either TNS or EZConnect format
    TNS Format: user/password@tnsname
    EZConnect Format: user/password@//server[:port]/servicename
    Connect String [] > sitemaestro/sitemaestro@//localhost/xe
    Property [Repository.db1] 'connect_string' updated to 'sitemaestro/sitemaestro@//localhost/xe'
    Backup 'collector.conf' to 'collector.conf-upg'
    1 update(s)
    12/30/2011 16:35:25: Licensed to Customer (000-000-000-000) Exp=03/01/2012 (62 days)
    12/30/2011 16:35:25: Configuration: 12/30/2011 16:35:25, rev=1
    12/30/2011 16:35:25: Testing Repository 'Repository.db1'
    12/30/2011 16:35:26: [ConnectionTest] Connected to Oracle as sitemaestro@, SessID=110021
    12/30/2011 16:35:26: [ConnectionTest] Disconnected from Oracle
    CONNECTION SUCCESSFUL
    Bind to Interface [ANY] > 
    Bind to Port [7777] >
    Only one Repository server should be set to purge data.
    Purge data with this server (y/n) [y] >
    Configuring /etc/init.d/smcollector..
    Property [Collector] 'interface' updated to '0.0.0.0'
    Backup 'collector.conf' to 'collector.conf-upg'
    1 update(s)
    Property [Collector] 'port' updated to '7777'
    Backup 'collector.conf' to 'collector.conf-upg'
    1 update(s)
    Property [Purge.db1] 'enabled' updated to 'true'
    Backup 'collector.conf' to 'collector.conf-upg'
    1 update(s)
    Configuration Complete
    Code Block
    # service smcollector start

...