Siebel Installations > Importing and Exporting Repository files
This article is about exporting and importing repoitory files. Repository files are .dat files that contain tables from the Siebel database where Siebel object definitions are stored. You can see the contents of the repository using Siebel Tools. We need to create these repository files from development environment and import them to the production environment. Also during migration and upgrades we need to generate repository files.
Remote/Local clients also use repositories, these are different files and are not discussed in this article.
1) Universal configuration file - these are *.ucf files that are text files. If you open them, you will see that each line contains name -value pairs where variables are defined. We need to first generate these files so that we can export our repository or import them.
This article will describe how to do this in Solaris.
We need to get three values first - the path of the Siebel database server, the path of the Siebel server and the DSN name. Log into any server and get the two paths. It would be something like /installation_folder/siebel/8.1/siebsrvr/ or /installation_folder/siebel/siebsrvr/ by default for the siebel servers. For the database server it should be something like /installation_folder/siebel/8.1/dbsrvr/. Browse the folders and copy down these two paths.
We also need the DSN name. This can be done both from the GUI or from Server Manager console. From the GUI go to Siebel Thin client —> Administration – Server Configuration —> Servers —-> Components Here select your object manager e.g. Siebel eFinancials ENU and then to —> Select Parameters —> Search for parameter ‘ODBC Data Source’ —> get the Value.
From the Server Manager type -> list components show SV_NAME, CC_NAME, CC_ALIAS , CP_DISP_RUN_STATE
Copy the alias (CC_ALIAS) and Server (SV_NAME) values of the object manager e.g. SERVER_1 and eFinancials_ENU. Tpe this in the Server Manager comman line
list param %ODBC% for component eFinancials_ENU server SERVER_1 show PA_ALIAS, PA_VALUE, PA_NAME
The result will be like
PA_ALIAS PA_VALUE PA_NAME --------------------------- ---------------------- ------------------------------------------ CFGCorrespODBCDatasource Siebel Reports: Access Application Correspondence ODBC datasource CFGHoldExportODBCConnection False Application Export ODBC connection flag CFGLocalDbOdbcConnection Application Local ODBC Connection CFGReportsODBCDatasource Siebel Reports: Access Application Reports ODBC datasource CFGServerODBCDatasource Application Server ODBC datasource Connect SIEBEL_DSN ODBC Data Source
The name of our DSN is SIEBEL_DSN
We can now start creating the ucf file. Go to the siebsrvr folder and load siebenv.sh and cfgenv.sh files
cd to siebsrvr/bin folder. I have copied everything that was typed and the output below.
installation_folder/siebsrvr/bin> ssincfgw -is:javaconsole -console -args LANG=ENU MODEL_FILE=/dbsrvr.scm
InstallShield Wizard
Initializing InstallShield Wizard...
Preparing Java(tm) Virtual Machine... ................................... ................................... ................................... ................................... ................................... ................................... ................................... ................................... ................................... ................................... ................................... ................................... ................................... ................................... ................................... ................................... ................................... ................................... ................................... ................................... ............................. Running InstallShield Wizard...
------------------------------------------------------------------------------- [X] 1 - Configure Product in Live Mode [ ] 2 - Configure Product for Offline Deployment [ ] 3 - Exit Configuration Wizard
To select an item enter its number, or 0 when you are finished: [0]
Press 1 for Next, 3 to Cancel or 4 to Redisplay [1]
------------------------------------------------------------------------------- Directory where the Siebel Server is installed
Siebel Server Directory [/installation_folder/siebel/8.1/siebsrvr]
Press 1 for Next, 2 for Previous, 3 to Cancel or 4 to Redisplay [1]
------------------------------------------------------------------------------- Directory where the Siebel Database Server is installed
Siebel Database Server Directory [/installation_folder/siebel/8.1/dbsrvr]
Press 1 for Next, 2 for Previous, 3 to Cancel or 4 to Redisplay [1]
------------------------------------------------------------------------------- Choose the appropriate database platform
[ ] 1 - IBM DB2 UDB for Linux UNIX Windows [X] 2 - Oracle Database Enterprise Edition
To select an item enter its number, or 0 when you are finished: [0]
Press 1 for Next, 2 for Previous, 3 to Cancel or 4 to Redisplay [1]
------------------------------------------------------------------------------- [X] 1 - Install Database [ ] 2 - Upgrade Database [ ] 3 - Apply Additive Schema Changes [ ] 4 - Import/Export Repository [ ] 5 - Migrate Repository [ ] 6 - Run Database Utilities
To select an item enter its number, or 0 when you are finished: [0] 4
[ ] 1 - Install Database [ ] 2 - Upgrade Database [ ] 3 - Apply Additive Schema Changes [X] 4 - Import/Export Repository [ ] 5 - Migrate Repository [ ] 6 - Run Database Utilities
To select an item enter its number, or 0 when you are finished: [0]
Press 1 for Next, 2 for Previous, 3 to Cancel or 4 to Redisplay [1] 1
------------------------------------------------------------------------------- Select one of the repository options
[X] 1 - Import Repository [ ] 2 - Add language to an existing Repository [ ] 3 - Export Repository
To select an item enter its number, or 0 when you are finished: [0] 3
[ ] 1 - Import Repository [ ] 2 - Add language to an existing Repository [X] 3 - Export Repository
To select an item enter its number, or 0 when you are finished: [0]
Press 1 for Next, 2 for Previous, 3 to Cancel or 4 to Redisplay [1]
------------------------------------------------------------------------------- Enter a valid ODBC (Open Database Connectivity) Data Source Name to access the Siebel Database connection. Default value is Siebel_DSN.
ODBC Data Source Name [] SIEBEL_DSN
Press 1 for Next, 2 for Previous, 3 to Cancel or 4 to Redisplay [1] 1
------------------------------------------------------------------------------- Siebel Database User Name Siebel Database Password
Database User Name [] sadmin
Database Password:
Database Password--(confirm): Press 1 for Next, 2 for Previous, 3 to Cancel or 4 to Redisplay [1]
------------------------------------------------------------------------------- Siebel Database Table Owner Siebel Database Table Owner password
Database Table Owner [] siebel
Database Table Owner Password:
Database Table Owner Password--(confirm): Database Table Owner Password--(confirm):
Press 1 for Next, 2 for Previous, 3 to Cancel or 4 to Redisplay [1]
------------------------------------------------------------------------------- Corresponds to the name of the repository which will be exported
Export Repository Name [Siebel Repository]
Repository File Name [/installation_folder/siebel/8.1/dbsrvr/oracle/customer.dat] /installation_folder/siebel/8.1/dbsrvr/oracle/exprep.dat
Press 1 for Next, 2 for Previous, 3 to Cancel or 4 to Redisplay [1]
------------------------------------------------------------------------------- Please indicate if the target server will use the Oracle Parallel Indexing option:
[X] 1 - Does not use the Oracle Parallel Indexing option [ ] 2 - Uses the Oracle Parallel Indexing option
To select an item enter its number, or 0 when you are finished: [0] Press 1 for Next, 2 for Previous, 3 to Cancel or 4 to Redisplay [1]
------------------------------------------------------------------------------- Identifies an authorization ID designated for a group of Siebel users defined in a mainframe security package
Security Group ID / Grantee [SSE_ROLE]
Log Output Directory [exprep]
Press 1 for Next, 2 for Previous, 3 to Cancel or 4 to Redisplay [1]
------------------------------------------------------------------------------- Configuration is complete: your output will be saved under $SiebelRoot/siebsrvr/bin/master_<process>.ucf. To deploy the process you configured to the database please run the below command line: $SiebelRoot/siebsrvr/bin/srvrupgwiz /m master_<process>.ucf
To select an item enter its number, or 0 when you are finished: [0] Press 1 for Next, 2 for Previous, 3 to Cancel or 4 to Redisplay [1] title The Siebel Configuration Wizard will execute using the following settings:)
------------------------------------------------------------------------------- The Siebel Configuration Wizard will execute using the following settings:)
Siebel Server Directory : /installation_folder/siebel/8.1/siebsrvr Siebel Database Server Directory : /installation_folder/siebel/8.1/dbsrvr RDBMS Platform : Oracle Database Enterprise Edition Siebel Database Operation : Import/Export Repository Select Repository Operation : Export Repository ODBC Data Source Name : SIEBEL_DSN Database User Name : siebel Database Password : ******** Database Table Owner : siebel Database Table Owner Password : ******** Export Repository Name : Siebel Repository Repository File Name : /installation_folder/siebel/8.1/dbsrvr/oracle/exprep.dat Oracle Parallel Index : Does not use the Oracle Parallel Indexing option Security Group ID / Grantee : SSE_ROLE
Log Output Directory : exprep Configuration is complete: your output will be saved under $SiebelRoot/siebsrvr/bin/master_<process>.ucf. To deploy the process you configured to the database please run the below command line: $SiebelRoot/siebsrvr/bin/srvrupgwiz /m master_<process>.ucf :
Press 1 for Next, 2 for Previous, 3 to Cancel or 4 to Redisplay [1]
1. Yes 2. No
Do you want to execute configuration? [2] 1
Execution Successful.
------------------------------------------------------------------------------- [X] 1 - Configure Product in Live Mode [ ] 2 - Configure Product for Offline Deployment [ ] 3 - Exit Configuration Wizard
To select an item enter its number, or 0 when you are finished: [0]
Press 1 for Next, 3 to Cancel or 4 to Redisplay [1] 3
1. Yes 2. No
Do you want to exit? [2] 1
/installation_folder/siebel/8.1/siebsrvr/bin> ls -l *.ucf
-rw-r--r-- 1 siebel sse_role 810 May 31 15:26 master_exprep.ucf
We have our export ucf file. Generating the import ucf file is almost exactly the same. When you get this display
Press 1 for Next, 2 for Previous, 3 to Cancel or 4 to Redisplay [1] 1
------------------------------------------------------------------------------- Select one of the repository options
[X] 1 - Import Repository [ ] 2 - Add language to an existing Repository [ ] 3 - Export Repository
Just press enter. (We had selected 3 and pressed enter to get the export ucf file.)
2) Export the repository file It is just one command - ./srvrupgwiz /m master_exprep.ucf
You need to be in the siebsrvr/bin folder and should have loaded siebenv.sh and cfgenv.sh files
3) To import a repository, the command is ./srvrupgwiz /m master_imprep.ucf You need to be in the siebsrvr/bin folder and should have loaded siebenv.sh and cfgenv.sh files
When you start importing or exorting repositories, you should see an output in the screen that tells you which tables and how many row in each table has been imported.
Normally it takes a long time to export ot import a repository. You might want to put the process in the background and output the results to the nohup file.
|