ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

CA Access Control database during upgrade to r12, r12SP1, r12.5.

book

Article ID: 52960

calendar_today

Updated On:

Products

CA Workload Automation AE - Business Agents (AutoSys) CA Workload Automation AE - Scheduler (AutoSys) Workload Automation Agent

Issue/Introduction

Description:

seosdb cannot be hot swapped during upgrade.

Solution:

CA Access Control's seosdb cannot be hot swapped during upgrade to r12 and above. This means that database files cannot just be copied over, the seosdb folder. They must be exported by dbmgr and then imported.

To Export the database:

Create a script that will duplicate the rule set by running the dbmgr utility on the database: 

# cd /opt/CA/eTrustAccessControl/seosdb                            
# dbmgr -export -l -f /tmp/lang_script

Execute the dbmgr utility to create a flat file containing data from the old database: 

# cd /opt/CA/eTrustAccessControl/seosdb                              
# dbmgr -migrate -r /tmp/flat_file

To Import:

Import the script generated previously to populate the new database: 

# cd /opt/CA/AccessControl/seosdb                                      
# selang -l -f /tmp/lang_script

Load the data from the flat file into the Access Control database: 

# cd /opt/CA/AccessControl/seosdb                                      
# dbmgr -migrate -w /tmp/flat_file

If you are doing an upgrade install, this will automatically be done for you. It is good practice to also do this before the upgrade to have a backup copy of the data.

Environment

Release:
Component: SEOSNT
Powered by Wolken Software