Database administration (server only)‌

Working with multiple Oracle instances‌

If you are running multiple Oracle instances, review the following steps:

If you already have Oracle instances running on the server and you have created a new Oracle instance, merge the old and the new Oracle configuration files.
Ensure that the Oracle service name entry (for example dim14) is available to each client:
- For each client hosted on a UNIX or Linux system, copy or merge either of these database server files to the client:
```
/etc/tnsnames.ora
```
```
/var/opt/oracle/tnsnames.ora
```
- For each Windows server, enter the service-name (database alias) on the server using the server's Net Configuration Assistant utility.

Enable the NET8 TNS listener process to start for client connections by adding the following line to the dmstartup script:
```
su $ORAUSER -c 'sh -c ". $installdir/dmprofile;
  $ORACLE_HOME/bin/lsnrctl start"'
```

Register base databases‌

Every base database must be registered with Dimensions CM using the dmpasswd utility. The Dimensions installer registers the base database you choose during installation and a default password is assigned. The default password for the "Typical, Stream Development" or "Typical, Non- Stream Development" process models is cm_typical.

Run the following command to register other base databases:

dmpasswd <basedb>@<connect_string> -add -pwd <password>

Run this command to change the default base database password:

dmpasswd <basedb>@<connect_string> -mod

Install Dimensions published views‌‌

Published views are installed with the "Typical, Stream Development" or "Typical, Non-Stream Development" sample process models. To re-install and re-grant published views to report users:

Enter the following commands:

delv <basedb> 
insv <basedb>
grtv <basedb> <basedb_report_user_name>

For example:

grtv intermediate intermediate_rept 
grtv cm_typical_rept

This initial invocation of grtv results in an error stream starting with:

SQL-1E36-40(00B0FE60) ORA-
  00955: name is already used by an existing object

You can safely ignore this error.

Enter the following command:

rekv <basedb> <basedb_report_user_name>

After a short period, the following message appears:

Report views have been successfully revoked.

Enter the following command:

grtv <basedb> <basedb_report_user_name>

The following message appears:

Report views have been successfully granted.

Repeat this procedure for all report users in every base database on your Dimensions CM server.

For details, see the Administration Guide and the Reports Guide.

Database administration acceptance tests‌

These tests require you to use Dimensions CM DBA utilities as an authorized DBA user. For details on these commands, see the Administration Guide.

Run the dmdba spac command and verify that the output is correct.
Run the dmdba lsdb command and verify that the output is correct.
Run the Dimensions CM UREG and XREG commands to verify that you can create and drop users.