Step 3: Verify Oracle initialization

Note: Unless you change it in Step 1, above, the default password for each username below is password.

After you run the scripts, perform the following steps to verify that databases and user roles have been created properly:

1. Open a Terminal or Command Prompt window that is running SQL*Plus or a similar client tool and connect to the Oracle database.

2. Log in as: hibuser

3. Verify that you can see the tables under hibernate.

4. If you installed Pentaho Operations Mart, verify that you can see the tables under pentaho_operations_mart.

5. Log in as: jcr_user

6. Verify that you can see the tables under jackrabbit.

   The jackrabbit tables may not appear until you have started Pentaho for the first time.

7. Log in as: pentaho_user

8. Verify that you can see the tables under quartz.

9. Exit from the tool.

You have initialized the Oracle Pentaho Repository database.