Skip Headers

Agile Product Lifecycle Management Database Install Guide Release 9.3.3 E39281-01 |
| Contents

Previous | Next |

# 6 Creating a RAC Database and Schema for Agile PLM

You can create a Real Application Clusters (RAC) database instance for Agile PLM using the Oracle Database Configuration Assistant (DBCA), and then create an Agile PLM schema in that database instance.

## 6.1 Creating an Oracle RAC Database Instance for Agile PLM

To create a RAC database instance:

1. Start the Oracle Database Configuration Assistant. (From the Start menu, navigate to All Programs > Oracle - <Oracle Home> > Configuration and Migration Tools, and choose Database Configuration Assistant). The Database Configuration Assistant: Welcome dialog appears.

2. Select the Oracle Real Application Clusters database option. Click Next.

3. In the Operations dialog, select Create a Database. Click Next.

4. In the Node Selection dialog, select all RAC nodes. Click Next.

5. In the Database Templates dialog, select Custom Database. Click Next.

6. In the Database Identification dialog, enter values for the Global Database Name and SID Prefix. For example, RAC.WORLD and RAC. Click Next.

7. In the Management Options dialog, click Next to accept the default selections. For more information on Oracle Enterprise Manager, see related documentation on the Oracle Technology Network (OTN) Web site `http://www.oracle.com/technetwork/documentation/agile-085940.html`.

8. In the Database Credentials dialog, choose the Use the Same Password for All Accounts option. You can change the passwords later. Enter a password and confirm it. Click Next.

9. In the Storage Options dialog, select your preferred storage option. The storage option that you have on your system is automatically detected and appears selected. Click Next. Based on your selection, the Database Configuration Assistant will present further options. Follow on-screen directions to configure storage details.

10. Next, select the database components you require. In the Database Content dialog, under Database Components, select the following:

    - Oracle Data Mining

    - Oracle Text

    - Enterprise Manager Repository (Optional)

      Click Next.

11. In the Database Services dialog, to accept the current configuration details, click Next.

    Note: At any stage, to change your selections, click Back and navigate to the appropriate dialog.

12. In the Initialization Parameters dialog, under Memory, select Custom. Provide desired SGA and PGA sizes or accept the default. Click Next.

13. In the Database Storage dialog, select the Tablespaces node. Create the following tablespaces in the instance.

    - AGILE_DATA1

    - AGILE_DATA2

    - AGILE_DATA3

    - AGILE_DATA4

    - AGILE_DATA5

    - AGILE_INDX1

    - AGILE_INDX2

    - AGILE_INDX3

    - AGILE_INDX4

    - AGILE_INDX5

    Note: Data files should be sized at least 1GB each with autoextend enabled, and must be named as listed above. You can store the datafile at any location on your hard drive. For guidance on sizing, refer to the tables in Disk I/O Configurations.

14. Review the storage parameters and click Next to accept.

15. In the Creation Options dialog, Create a Database is the default selection. Click Finish to accept database creation settings.

16. In the Summary screen, click OK to start the database creation process.

17. Once the database creation is complete, a dialog appears with details of the newly created database instance. Make a note of the information for your records. Within this dialog, click Password Management and do the following:

    a. Make sure that the CTXSYS account is not locked. If it is locked, log into Oracle as 'sys' or 'system' and execute the SQL command:

    alter user ctxsys account unlock;

    b. Set the following account passwords:

    § sys / oracle

    § system / manager

    § ctxsys / ctxsys

    You can change the passwords after schema creation is complete.

18. Click Exit. The RAC database instance creation is now complete.

## 6.2 Creating an Agile PLM Schema in an Existing RAC or Standalone Database Instance

The Oracle database stores data in virtual containers known as schemas. The Agile Database Configuration Utility creates the database, user account, and schema used by Agile. Additional schemas are not necessary; however, you can create additional Agile schemas with different user names if necessary.

Note: You should not use the Oracle Security Manager to create users.

To create a schema in the RAC Database Instance:

On UNIX:

1. Run agile9database.sh and choose the Generate Maintenance Scripts Only option to generate the Agile PLM 9.3.3 schema maintenance scripts.

2. Run recreateagile.sh to create the schema.

On Windows:

1. Run the database installer as described in Installing the Agile Database on Windows.

2. In the installer screen where you specify the Oracle SID, select the Generate Database Scripts Only check box. See Step 4 under Using the Agile Database Configuration Utility.

3. Follow onscreen instructions to generate scripts.

4. Run recreateagile.bat to create the schema.

There are three requirements around the package SYS.DBMS_SHARED_POOL for an Agile database. If the requirements are not met, and the package DBMS_SHARED_POOL does not exist in the SYS schema, you may receive a DBMS shared pool error or AGILE9_UTILS error.

To ensure that DBMS_SHARED_POOL requirements are met:

1. Log into the database as 'sys' user.

2. Run the following command:

       SQL> describe SYS.DBMS_SHARED_POOL

3. If you receive an error indicating that the object SYS.DBMS_SHARED_POOL does not exist, run the SQL script dbmspool.sql located atORACLE_HOME/RDBMS/admin.

4. As 'sys' user, grant execute privileges to the agile schema user.

       SQL> grant execute on SYS.DBMS_SHARED_POOL to AGILE;

   Where AGILE is the agile schema user.

5. Connect to the database as the agile schema user, and run the following command:

       SQL> create synonym DBMS_SHARED_POOL for SYS.DBMS.SHARED_POOL;

6. When the process completes, run the following command to compile the AGILE9_UTILS package:

       SQL> alter package agile9_utils compile body;

   The package should compile without errors. If the package compiles with errors, run the following command and correct the same:

       SQL> show errors

## 6.3 Database Post-Installation Tasks

This section describes mandatory and optional post-installation tasks to be completed, such as configuring Oracle network connectivity and setting up additional Oracle functionality.

### 6.3.1 Adding and Configuring a Listener

If this is the first time Oracle has been installed on the current computer, you need to add and configure a new database listener.

Note: If you are creating a new Agile database on the same machine, you only need to add the new database to the existing listener.

To add and configure a new Listener:

1. Start Oracle Net Manager:

   Ÿ On Windows, choose Start > All Programs > <ORACLE_HOME> > Configuration and Migration Tools > Net Manager.

   Ÿ On UNIX, run the command $ netmgr &.

2. In the Oracle Net Manager window, double-click the Local folder and select the Listeners folder.

3. Click Create in the toolbar to add a listener.

   The Choose Listener Name dialog box appears.

4. Click OK.

5. In the Listening Locations drop-down list, select Database Services.

6. Click Add Database.

   In the dialog box that appears, make the following changes:

   Global Database Name: agile9

   Oracle Home Directory: <ORACLE_HOME>

   SID: agile9

   Note: If you used a different global database name or different home directory during the database installation, change the information as appropriate.

7. Choose File > Save Network Configuration to save your changes.

8. Close Oracle Net Manager.

   To restart the database listener, open a Command Prompt window and type lsnrctl reload.

### 6.3.2 Adding and Configuring a Net Service

1. In the Oracle Net Manager window, double-click the Local folder and select the Service Naming folder.

2. Click Create in the toolbar to add a service name.

   The Net Service Name Wizard starts.

3. In the Net Service Name field, type the name of the computer where the Oracle database is located (usually the current computer). Click Next.

4. You are prompted to select a network protocol. Select TCP/IP (Internet Protocol) and click Next.

5. Type the name of the computer where Oracle is located in the Hostname field (the same name you typed in step 3). Accept 1521 as the default port number. Click Next.

6. Select Oracle8i or later as the service name, and type agile9 in the field. Click Next.

7. Click Test to test the service.

   The test initially fails because the default uses the incorrect login.

8. Click Change Login to reset the username and password.

9. Type agile in the Username field and tartan in the Password field. Click OK.

10. Click Test. You should now see a message indicating that the test was successful.

11. Click Close.

12. Click Finish to exit the Net Service Name Wizard.

13. From the Net Manager menu, choose File > Save Network Configuration to save the service name.

### 6.3.3 Setting Up Automatic Shutdown and Startup for the Database on UNIX

To set up the Oracle database to automatically shut down and start up when the host computer starts up and shuts down:

1. Log in the system as root.

2. Create a file named "dbora" in the /etc/init.d directory:

   # cat /home/oracle/agile9330db/dbora > /etc/init.d/dbora [Enter]

3. Link to the dbora file:

   # ln -s /etc/init.d/dbora /etc/rc0.d/K10dbora [Enter]

   # ln -s /etc/init.d/dbora /etc/rc2.d/S99dbora [Enter]

### 6.3.4 Setting Up Optional Oracle Functionality

This section describes how to set up Oracle Net Manager and Oracle Enterprise Manager for administrative purposes.

#### 6.3.4.1 Setting Up Oracle Net Manager

If you use the TNS_ADMIN environment variable to specify the location of Oracle Network Services configuration files (such as tnsnames.ora), move the files located in the $ORACLE_HOME/network/admin directory to the directory specified by TNS_ADMIN.

To set up Oracle Net Manager on UNIX:

1. Log in as root and change the ownership of the /var/opt/oracle directory:

   # chown -R oracle:dba /var/opt/oracle [Enter]

2. Switch to the Oracle user, and change to the $ORACLE_HOME/network/admin directory:

   # su - oracle [Enter]

   $ cd $ORACLE_HOME/network/admin [Enter]

3. Move all the files to the directory defined by environment parameter TNS_ADMIN, which is /var/opt/oracle:

   $ mv * /var/opt/oracle [Enter]

#### 6.3.4.2 Configuring Oracle Enterprise Manager

You can use Database Control to perform many database administration and management tasks including SQL performance tuning.

To configure the Oracle network connection:

1. On Windows: Choose Start > All Programs > Oracle - <ORACLE_HOME> > Configuration and Migration Tools > Database Configuration Assistant.

   On Unix: Run the command $ dbca &.

   The Welcome screen appears.

2. Click Next.

3. Choose Configure Database Options on the Operations page. Click Next.

   The Database page appears

4. Select the agile9 database you just created. Click Next.

   The Management Options page appears.

5. Check Configure the Database with Enterprise Manager. Click Next.

   The Database Content page appears.

6. Accept the defaults. Click Next.

   The Database Credentials page appears.

7. Enter a password for the DBSNMP and SYSMAN users. Click Next.

   The Connection Mode page appears.

8. Select Dedicated Server Mode. Click Finish.

9. Click OK for confirmation. Database configuration begins.

   When configuration completes, the Database Control URL displays. Make a note of this URL because it is used to log in to the database.

10. Click OK to close the Database Configuration Assistant.

11. Open a web browser and enter the Database Control URL.

12. Type the User Name and Password of the Agile database. Click Login.

13. Click I agree to accept the license agreement and display the Database Control page.

    You have now finished installing and configuring the Agile PLM Database.

### 6.3.5 Setting Lexer Preference

Based on your installation requirement, you have the option to choose either BASIC lexer or WORLD lexer. The default lexer is BASIC. To overcome FTS limitations related to character searches, customers using the Japanese lexer should change from BASIC to WORLD lexer.

To switch lexer preference:

1. Stop the application server.

2. Run the database installer with the Generate maintenance scripts option selected.

3. Edit recreateagile.bat to switch the lexer.

   Change: agile9_fts_prefs_lexer_basic.sql

   To: agile9_fts_prefs_lexer_world.sql

4. Run recreateagile.bat.

5. Import customer data.

6. Restart the application server.

### 6.3.6 Setting up Enterprise Data Quality Product Integration

To set up integration between the Enterprise Data Quality Product and Agile PLM:

1. Enable Oracle JVM.

2. Run the agile9pdq_setup file, located in the $ORACLE_BASE\admin\SID\create\agile directory.