A Setting Up Database Connections

During your installation of, or upgrade to RDC Onsite, you configured the database connections on your reports servers and application servers. This chapter reviews the information in case you need to set up additional database connections.

There are two parts to establishing database connections. First, you must update the tnsnames.ora file to include the database. Second, you must use the OPAAdmin application to set up the necessary database connections to be used with RDC Onsite.

This chapter includes the following topics:

• Setting Up the SQL*Net Connections for Existing Databases

• Using the OPAAdmin Application to Set Up Database Connections

• Managing Users and Passwords for the OPAAdmin Application

A.1 Setting Up the SQL*Net Connections for Existing Databases

To establish the SQL*Net connections between the Web Server computer and the databases you have already created, modify the tnsnames.ora file to include entries for all the databases and Web Servers.

The tnsnames.ora file is located at ORACLE_AS10gR3_HOME.

A.2 Using the OPAAdmin Application to Set Up Database Connections

You use the OPAAdmin application:

• To define the database connections used by RDC Onsite.

• To specify the default database to be used by RDC Onsite.

  See Section 6.1.2, "Customizing the RDC Onsite URL" for information about how to connect to non-default databases.

The OPAAdmin application saves the information that you enter for each database into the OpaConfig.xml file on the Application Server.

The default user name for logging in to the OPAAdmin application is opaconfig. You specified the default password for the opaconfig user when you installed Oracle Clinical.

To change the password for the opaconfig user, reset a forgotten password, or create additional users, see Section A.3, "Managing Users and Passwords for the OPAAdmin Application."

To log in to the OPAAdmin application and set up database connections: 

1. Open a Web browser and enter your URL to the OPAAdmin application:

   https://server.domain/opaadmin/opaConfig.do

   where server.domain is the server and domain of the target Application Server 10gR3 (AS10gR3).

2. Enter the user name and password to log in to the OPAAdmin application.

   The default user name is opaconfig. You specified the default password when you installed Oracle Clinical.

   Once you log in, the OPAAdmin application displays the Database Configuration page.

   
   

3. Complete the following fields:

   • Name = Name of this database

   • Host = Host name of this database

   • Port = Port number of this database

   • SID = System ID (SID) for this database

4. Set the Default field as follows:

   • If you want this database to be the default database that RDC Onsite users will access, select true.

   • If you do not want this database to be the default, select false.

5. Enter the password for the existing BC4J_INTERNAL account. If you do not know this password, reset it in the database.

6. Enter the password for the TMS_BROWSER account only if TMS is installed. Otherwise, leave the TMS Browser Password field blank.

7. Save your changes.

A.3 Managing Users and Passwords for the OPAAdmin Application

You use Oracle Enterprise Manager 10g Application Server Control to manage the user accounts that can run the OPAAdmin application. As shown in Figure A-1, you can:

• Change the password for the opaconfig user

• Create additional users and passwords

• Change the passwords for other OPAAdmin users

• Delete users

Figure A-1 Managing Users and Passwords for the OPAAdmin Application

A.3.1 Navigating to the Users Page for the OPAAdmin Application

The Users page in Oracle Enterprise Manager 10g Application Server Control provides the options that let you change user passwords, add users, and delete users for the OPAAdmin application.

To access the Users page: 

1. Open a Web browser and enter your URL to the Oracle Application Server Forms and Reports Services Welcome page:

   computer-name.company-name.com

2. Click the Log on to Oracle Enterprise Manager 10g Application Server Control link to open the Application Server Home page.

3. Log in as user ias_admin with the password you set when you installed the Application Server.

4. Select the appropriate instance.

5. Click the opa OC4J instance.

6. Click the Applications tab.

7. Click the opaadmin link.

8. Click the Administration tab.

9. Expand the Security administration task, and then select the Go to Task icon for Security Provider.

10. Click the Realms tab.

11. Locate the jazn.com security realm, and then click the number in its Users column. The system opens the Users page for the OPAAdmin application. See Figure A-1.

A.3.2 Changing the Password for the opaconfig User

To change the password for the opaconfig user: 

1. Log in to Oracle Enterprise Manager 10g Application Server Control.

2. Navigate to the Users page. See Section A.3.1, "Navigating to the Users Page for the OPAAdmin Application" for details.

3. Click the opaconfig user name.

   1. Enter the old password, enter the new password, and then confirm your new password.

   2. Click Apply. Note that the user name remains opaconfig.

   If you have forgotten the password for the opaconfig user, you must return to the Users page, delete the opaconfig user, and then re-create the opaconfig user and password.

   
   

4. Restart the opa OC4J instance.

A.3.3 Creating a New User with Access to the OPAAdmin Application

To create a new user with access to the OPAAdmin application: 

1. Log in to Oracle Enterprise Manager 10g Application Server Control.

2. Navigate to the Users page. See Section A.3.1, "Navigating to the Users Page for the OPAAdmin Application" for details.

3. Click Create to add a new user.

   1. Enter a name for the user.

   2. Enter the password for the user account.

   3. Enter the password again to confirm.

4. Select OpaConfig in the Available Roles column, and then click Move to assign the privileges and properties of the OpaConfig role to the user.

   
   

5. Click OK.

6. Restart the opa OC4J instance.

A.3.4 Resetting a Forgotten Password for an OPAAdmin User

To reset a forgotten password for any OPAAdmin user: 

1. Log in to Oracle Enterprise Manager 10g Application Server Control.

2. Navigate to the Users page. See Section A.3.1, "Navigating to the Users Page for the OPAAdmin Application" for details.

3. Click the Trash icon to delete the user.

4. Click Create to re-create the user and new password.

5. Click Apply.

6. Restart the opa OC4J instance.

A.3.5 Revoking User Access to the OPAAdmin Application

To revoke a user's access to the OPAAdmin application: 

1. Log in to Oracle Enterprise Manager 10g Application Server Control.

2. Navigate to the Users page. See Section A.3.1, "Navigating to the Users Page for the OPAAdmin Application" for details.

3. Click the Trash icon for the user you want to delete.

4. Click Yes on the Confirmation page.

5. Restart the opa OC4J instance.