3 Installation Notes

3.2.1 Before Running the OracleAS Personalization Schema Creation Wizard

The database administrator will need to allow remote SYS access for the duration of the schema creation process.

Documentation on updating the database init.ora parameters can be found in the Database Administrator Authentication section of the Database Administrator's Guide (http://download.oracle.com/otndoc/oracle9i/901_doc/server.901/a90117/dba.htm#10431). <<<find the lastest equivalent link>>>

Remote SYS access can be tested using the following command on the system where you installed Oracle Application Server Business Intelligence:

   sqlplus "SYS/<password@GlobalDatabaseName> AS SYSDBA"

where password is the SYS password on the remote database and GlobalDatabaseName is the database alias in the tnsnames.ora file.

The DBA will need to collect the following information for the Mining Object Repository (MOR), the Recommendation Engine Repository (RE), and the Mining Table Repository (MTR) before starting the Java application to configure the required database schemas.

(Note the following: When you specify the data file names for the tablespaces, the names must be the fully qualified names for the data files on the local file system where the Oracle database is running. You must replace the <full path> prompt with the directory name for the data file.)

MOR (Mining Object Repository)

1. SYS password for the database

2. JDBC connect information

   • Host

   • Port

   • SID

3. Schema name for the MOR (default: OPMOR)

4. Password for the MOR

5. Fully qualified file name of the tablespace data file for the MOR

6. Fully qualified file name of the tempspace data file for the MOR

7. Email address for replies from notification messages

RE (Recommendation Engine Repository)

1. SYS password for the database

2. JDBC connect information

   1. Host

   2. Port

   3. SID

3. Schema Name for the RE (default: RE)

4. Password for the RE

5. Fully qualified file name of the tablespace data file for the RE

MTR (Mining Table Repository)

1. SYS password for the database

2. JDBC connect information

   • Host

   • Port

   • SID

3. Schema name for the MTR (default: MTR); importing the movie data forces the name DEMO_MTR

4. Password for the MTR

5. Fully qualified file name of the tablespace data file for the MTR

3.2.2 Running the OracleAS Personalization Creation Wizard

After collecting the required information, log in to the Oracle Application Server system where you installed Oracle Application Server Business Intelligence and run the following command:

(UNIX)
prompt> $ORACLE_HOME/mp/admin/opconfig.sh

(Windows)
prompt> cd %ORACLE_HOME%\mp\admin
prompt> opconfig.bat 

3.2.3 After Running OracleAS Personalization Schema Creation Wizard

Once the schemas have been successfully created, remote SYS access can be safely disabled. However, if there is a need to configure more REs, remote SYS will need to be reestablished.

Use the Oracle Enterprise Manager 10g to restart OC4J, Business Intelligence, and Forms. The OracleAS Personalization Admin UI will not allow you to log in until you have restarted OC4J.