Portal, Express Beta Version 6.1 Operating systems: i5/OS, Linux,Windows

Create users

This section provides information on setting up users for Oracle to work with WebSphere Portal Express.

• You should have completed Installing Oracle.
• If WebSphere Portal Express Version 6.1 and an earlier version of WebSphere Portal Express coexist, the database user IDs for WebSphere Portal Express Version 6.1 must be different than earlier versions to avoid conflicts during installation.

Ensure that you create users and grant the appropriate privileges in Oracle before configuring WebSphere Portal Express to work with Oracle.

Take care to create users in an environment that has the same settings as the actual runtime environment. For example, avoid creating a user in an English environment if you plan to use that user in a Turkish environment.

1. Create the users in the WebSphere Portal Express databases

   1. Log in to the database in which you want to create the new users.
   2. Create the users that you need in the appropriate databases by entering the following command in the SQL*Plus tool, where user_tablespace is the default tablespace that is identified by the database administrator to store user objects and temp_tablespace is identified to store temporary objects:

      SQL> create user username identified by password
      default tablespace user_tablespace
      temporary tablespace temp_tablespace;

2. Log in by entering the command $ sqlplus in SQL*Plus:
3. Enter the command user-name: username/password@dbname, where username is an existing administrative user in the database. For example: system/manager@wpsdb will log the administrative user system with a password of manager into the wpsdb database.
4. Create the WebSphere Portal Express user dbdomain.DbUser, where dbdomain is replaced by release, community, customization, JCR. All names must be in lower case.

   The following example uses the default user tablespace and the default temporary tablespace. Explicitly specify these tablespaces if you do not want to use the defaults.

   SQL> create user releaseusr identified by password;
   SQL> create user communityusr identified by password;
   SQL> create user customizationusr identified by password;
   SQL> create user icmadmin identified by password;
   

5. Connect to the content database by entering the command SQL> connect.
6. Enter the following, where username is an existing administrative user in the database. user-name: username/password@dbname For example, system/manager@jcrdb will log the administrative user system with a password of manager into the Oracle database.
7. Create the Oracle users by entering the following: When creating the icmadmin user, grant all necessary privileges. If you do not grant privileges, you will receive the error ICMADMIN lacks CREATE SESSION Privilege logon denied when you try to connect with the icmadmin user:

   SQL> create user icmadmin identified by password default tablespace users temporary tablespace temp;

8. In the database directory, create the data directory data and the index directoryindex.
9. Create the tablespaces.

   1. Find and edit the SQL script jcr_ora_tablespaces.sql in the directory portal_server_root/installer/wp.config/config/work/db/oracle.
   2. In the define section, replace the following variables with the values from your environment:

      jcrdb

      Name of the database you created to store user data.

      logfile

      Location to store the log file.

      dbpath

      Directory where you created the database.

   3. Set the size, autoextend, and maxsize values according to your environment. For example, you may want to change the maxsize to a set value rather than UNLIMITED. Consult your Database Administrator for more info.
   4. Execute the following SQL script: Notes:

      • The DBA or a user with sufficient credentials (CREATE tablespace) must execute the script.
      • The script will prompt for the database username and password.

      # sqlplus
      SQL > @jcr_ora_tablespaces.sql

10. Connect to the Feedback database:

    1. Enter the following command:

       SQL> connect

    2. Enter user-name: username/password@dbname where username is an existing administrative user in the database. For example, system/manager@fdbkdb will log the administrative user system with a password of manager into the fdbkdb database.
11. Create the Feedback user:

    SQL> create user feedback identified by password default tablespace users temporary tablespace temp;

12. Connect to the LikeMinds database:

    SQL> connect

13. Enter user-name: username/password@dbname, where username is an existing administrative user in the database. For example, system/manager@lmdb will log the administrative user system with a password of manager into the lmdb database.
14. Create the LikeMinds user:

    SQL> create user lmdbusr identified by password default tablespace users temporary tablespace temp;

15. Log out of the command line tool using the command SQL> exit.