Tuesday, October 20, 2009

Oracle SCM repository (Software Configuration Management) Installation

Creating database

Create a new database for SCM repository using dbca. (database name: DEVREP)
Change the open_cursors parameter to 3000.
Change the hash_area_size to 1048576

Preparing the database

1- Change the current working directory to the scripts folder
 
cd d:\Oracle_home\repadm61\admin

2- Launch sqlplus

d:\Oracle_home\bin\sqlplus /nolog

3- You should now connect to the database as the sysdba user (usually called sys),

SQL> connect sys/psw@host as sysdba

4- Run the script ckqa. The script will prompt for repository size and, name and location of repository database's datafiles

SQL> @ckqa

CONSTANT_GROW_INDEXES: C:\oracle\product\10.2.0\oradata\devrep\CONSTANT_GROW_INDEXES_TBS.dbf
CONSTANT_GROW_TABLES: C:\oracle\product\10.2.0\oradata\devrep\CONSTANT_GROW_TABLES_TBS.dbf
DEPENDENCY_INDEXES: C:\oracle\product\10.2.0\oradata\devrep\DEPENDENCY_INDEXES_TBS.dbf
DEPENDENCY_TABLES: C:\oracle\product\10.2.0\oradata\devrep\DEPENDENCY_TABLES_TBS.dbf
DIAGRAM_INDEXES: C:\oracle\product\10.2.0\oradata\devrep\DIAGRAM_INDEXES_TBS.dbf
DIAGRAM_TABLES: C:\oracle\product\10.2.0\oradata\devrep\DIAGRAM_TABLES_TBS.dbf
LOB_DATA: C:\oracle\product\10.2.0\oradata\devrep\LOB_DATA_TBS.dbf
RAPID_GROW_INDEXES: C:\oracle\product\10.2.0\oradata\devrep\RAPID_GROW_INDEXES_TBS.dbf
RAPID_GROW_TABLES: C:\oracle\product\10.2.0\oradata\devrep\RAPID_GROW_TABLES_TBS.dbf
SYSTEM_META_INDEXES: C:\oracle\product\10.2.0\oradata\devrep\SYSTEM_META_INDEXES_TBS.dbf
SYSTEM_META_TABLES: C:\oracle\product\10.2.0\oradata\devrep\SYSTEM_META_TABLES_TBS.dbf
TEMPORARY_INDEXES: C:\oracle\product\10.2.0\oradata\devrep\TEMPORARY_INDEXES_TBS.dbf
TEMPORARY_TABLES: C:\oracle\product\10.2.0\oradata\devrep\TEMPORARY_TABLES_TBS.dbf
VERSION_INDEXES: C:\oracle\product\10.2.0\oradata\devrep\VERSION_INDEXES_TBS.dbf
VERSION_TABLES: C:\oracle\product\10.2.0\oradata\devrep\VERSION_TABLES_TBS.dbf


REPOS_RBS: C:\oracle\product\10.2.0\oradata\devrep\REPOS_RBS_TBS.dbf
REPOS_TEMP: C:\oracle\product\10.2.0\oradata\devrep\REPOS_TEMP_TBS.dbf


5- At this point, ckqa will create a script ckparams.txt which you should install using ckcreate

SQL> @ckcreate

This will create the repository owner user, required roles and tablespaces necessary to proceed with the next step

6- Optionally run ckreport script to view report for the repository database preparation

SQL> @ckreport

7- To avoid running out of space during installation and usage of repository, it is recommended to turn on autoextend for all the datafiles created by the ckcreate script

SQL>alter database datafile 'C:\oracle\product\10.2.0\oradata\devrep\CONSTANT_GROW_INDEXES_TBS.dbf' autoextend on next 1M;

SQL> alter database datafile 'C:\oracle\product\10.2.0\oradata\devrep\CONSTANT_GROW_TABLES_TBS.dbf' autoextend on next 1M;

SQL> alter database datafile 'C:\oracle\product\10.2.0\oradata\devrep\DEPENDENCY_INDEXES_TBS.dbf' autoextend on next 1M;

SQL> alter database datafile 'C:\oracle\product\10.2.0\oradata\devrep\DEPENDENCY_TABLES_TBS.dbf' autoextend on next 1M;

SQL> alter database datafile 'C:\oracle\product\10.2.0\oradata\devrep\DIAGRAM_INDEXES_TBS.dbf' autoextend on next 1M;

SQL> alter database datafile 'C:\oracle\product\10.2.0\oradata\devrep\DIAGRAM_TABLES_TBS.dbf' autoextend on next 1M;

SQL> alter database datafile 'C:\oracle\product\10.2.0\oradata\devrep\LOB_DATA_TBS.dbf' autoextend on next 1M;

SQL> alter database datafile 'C:\oracle\product\10.2.0\oradata\devrep\RAPID_GROW_INDEXES_TBS.dbf' autoextend on next 1M;

SQL> alter database datafile 'C:\oracle\product\10.2.0\oradata\devrep\RAPID_GROW_TABLES_TBS.dbf' autoextend on next 1M;

SQL> alter database datafile 'C:\oracle\product\10.2.0\oradata\devrep\SYSTEM_META_INDEXES_TBS.dbf' autoextend on next 1M;

SQL> alter database datafile 'C:\oracle\product\10.2.0\oradata\devrep\SYSTEM_META_TABLES_TBS.dbf' autoextend on next 1M;

SQL> alter database datafile 'C:\oracle\product\10.2.0\oradata\devrep\TEMPORARY_INDEXES_TBS.dbf' autoextend on next 1M;

SQL> alter database datafile 'C:\oracle\product\10.2.0\oradata\devrep\TEMPORARY_TABLES_TBS.dbf' autoextend on next 1M;

SQL> alter database datafile 'C:\oracle\product\10.2.0\oradata\devrep\VERSION_INDEXES_TBS.dbf' autoextend on next 1M;

SQL> alter database datafile 'C:\oracle\product\10.2.0\oradata\devrep\VERSION_TABLES_TBS.dbf' autoextend on next 1M;

Installing the repository

1- The Repository Administration Utility (RAU) is used to install and maintain the repository.




On startup, the RAU will display a Connect dialog. You should log in as the repository administrator user, which was created automatically by the ckcreate script. The default username and password is repos_manager/manager.

2- After connecting, click the Install button to begin installation

When prompted Do you want to use Public Synonyms?, click Yes. This makes creation of new users much quicker.

3- In the Install a Repository instance dialog, you need to set all the drop down lists to the correct values. The dialog should look like this when you're done:





4- Now click Start, and repository installation will begin. This will take some time. When installation is complete, click Cancel in the Install a Repository instance dialog.

5- Next, enable support for versioning. Click the Enable Version Support... item in the RAU's Options menu. After doing this, you'll need to restart the RAU and reconnect to the repository.

6- Finally, set a couple of options that are recommended for using Oracle SCM with JDeveloper. Click the Edit Policies... menu item in the Options menu, and ensure your settings match those in the screenshot below.




Enable version control if used

To enable version control, proceed as follows:

1- In the Repository Administration Utility, choose Options > Enable Version Support.
2- Reply Yes to the "Do you wish to proceed?" message.
3- Click OK at the "Operation Complete" message.
4- Read the message about the use of the Repository Object Navigator and click OK.

The installation of SCM repository is complete now.


Adding users

1- You need to add a few other users to the repository before using it. Each repository user is a database user, which could be created as:


SQL> create user brian identified by brianpassword;
User created.

SQL> grant connect, resource to brian;
Grant succeeded.


2- Using the RAU, you should install the repository schema for this user. 

Click the Maintain Users button on the RAU's main screen, select the Users 

node in the tree and click the small Add button to the left of the tree: 



In the Oracle User Name dropdown, select the Oracle user to create a repository user for. You can then customize the privileges this user has. For a typical JDeveloper Oracle SCM user, you will want to allow management of everything except Users.



Click OK, and the user will be created.

REFERENCES

[1] http://radio.weblogs.com/0128037/stories/2003/10/21/oracleScmInstallationCheatSheet.html
[2] Oracle Designer Repository Installation Guide