Home > Oracle, Siebel > Copy Production data to Development environment Part -2-

Copy Production data to Development environment Part -2-

1) Data can be exported while the Production database server is on if you are using Oracle 11x.
2) To import data, we need to first shut down Siebel server
/install_folder/siebel/8.1/siebsrvr
. ./siebenv.sh
cd bin
./stop_server -r /install_folder/siebel/8.1/siebsrvr -e ENT_NAME SERVER_NAME
After that ask DBA to import this data.
3) DBA should change the passwords for GUESTCST, SADMIN and SIEBEL. GUESTCST is the default anpnymous user, it could be different in your case.
4) Run these commands against the database after that (we used SQL Developer)
Truncate table S_WFA_INST_WAIT;
Truncate table S_WFA_INSTANCE;
Truncate table S_WFA_INSTP_LOG;
Truncate table S_WFA_INST_LOG;
Truncate table S_WFA_INST_PROP;
Truncate table S_ESCL_ACTN_REQ;
Truncate table S_ESCL_LOG;
Truncate table S_ESCL_STATE;
Truncate table S_ESCL_REQ;
Truncate table S_DOCK_TXN_LOG;
Truncate table S_COMM_REQ;
commit;

5) We now need to change SADMIN and SIEBEL passwords in Siebel application
precondition (Siebel server should be in stopped state, gateway should be running)

Changing SADMIN password
log into servermanager

./srvrmgr -g IP_ADDRESS:2320 -u SADMIN -p PASSWORD -e ENT_NAME
change enterprise parameter Password=PASSWORD (new sadmin password)
change enterprise parameter TableOwnPass=PASSWORD (new Siebel password)
IP_ADDRESS is the gateway server i.p.

list enterprise parameter TableOwnPass show PA_SETLEVEL
this value should not be ”Never set”. It was 0 after change

remove, move or rename this file
/install_folder/siebel/8.1/siebsrvr/sys/svc.siebsrvr.ENT_NAME:SERVER_NAME
type (make sure you have siebenv.sh loaded first)
siebctl -r /install_folder/siebel/8.1/siebsrvr -S siebsrvr -i ENT_NAME:SERVER_NAME -a -g “-g IP_ADDRESS:2320 -e ENT_NAME -s SERVER_NAME -u sadmin” -e PASSWORD -L ENU

IP_ADDRESS is the gateway server i.p. address
Now we need to restart gateway.
Go to
/package_folder/siebel/8.1/gtwysrvr

siebel@servername:/install_folder/siebel/8.1/gtwysrvr> . ./siebenv.sh
siebel@servername:/install_folder/siebel/8.1/gtwysrvr> cd bin
siebel@servername:/install_folder/siebel/8.1/gtwysrvr/bin> stop_ns
siebel@servername:/install_folder/siebel/8.1/gtwysrvr/bin> start_ns

to check if gateway is running type
siebel@servername:/install_folder/siebel/8.1/gtwysrvr/bin> ps -ef | grep siebsvc
siebel 19836 29152 0 11:03:53 pts/1 0:00 grep siebsvc
siebel 18536 25550 0 11:01:05 pts/1 0:04 siebsvc -s gtwyns -a /f /install_folder/siebel/8.1/gtwysrvr/sys/siebns.dat /t 232
6) Changing GUESTCST password

first we need to find out where these passwords are stored. the configuration files (eapps.cfg can be renamed or there may be multiple files with this name)
The only file that is constant is magnus.conf files. There could be more than one magnus.conf file that is being used (e.g. one for the ssl and one for non ssl).
Open these files and search for string config-file
Currently the correct configuration files are
for non ssl
config-file=”/apps/servername/javaweb/sweapp/bin/eapps.cfg”
for ssl
config-file=”/apps/servername/javaweb/sweapp/bin/eapps_ssl.cfg”

Get the new password for GUESTCST from DBA. Log into siebel server
cd /install_folder/siebel/8.1/siebsrvr
. ./siebenv.sh
cd bin
apps/package_folder/siebel/8.1/siebsrvr/bin>encryptstring PASSWORD
I3OFbQV5a3gBAAAFCg==apps/package_folder/siebel/8.1/siebsrvr/bin>

Copy the first part i.e. I3OFbQV5a3gBAAAFCg==

Open eapps.cfg and eapps_ssl.cfg files and in the password field paste this new password.
e.g.
[defaults]
EncryptedPassword = True
AnonUserName = GUESTCST
AnonPassword = I3OFbQV5a3gBAAAFCg==
After this restart Web Servers. Go to the web server root for the servers, in this case we have two root folders. One
is for ssl , another for non ssl.

siebel@webservername:/apps/servername/javaweb/https-ta-sfa> ./stop
siebel@webservername:/apps/servername/javaweb/https-ta-sfa-ssl> ./stop

siebel@webservername:/apps/servername/javaweb/https-ta-sfa> ./start
siebel@webservername:/apps/servername/javaweb/https-ta-sfa-ssl> ./start

7) change SRF/Browser Scripts if the deployment version is different

8) Start siebel server and log in as SADMIN

cd /install_folder/siebel/8.1/siebsrvr
. ./siebenv.sh
cd bin
./start_server -r /install_folder/siebel/8.1/siebsrvr -e ENT_NAME -L ENU -g IP_ADDRESS:2320 SERVER_NAME
IP_ADDRESS is the gateway server i.p. address

8) Update triggers in Siebel

First remove triggers, then generate them
To generate DB Triggers perform next steps:
1. Log On to Siebel Application.
2. Through Site Map navigate to view Administration ? Server Management > Jobs
3. In list applet Jobs create new record
4. In field Component Job select value Generate Triggers
5. In bottom applet Job Parameters create new records and set parameters by below name – value key:
a. EXEC ? True
b. Privileged User ? siebel
c. Privileged User Password ? <siebel password>
d. Remove ? TRUE
6. Submit created Job by clicking button Submit on applet Jobs

for the second time, run the same job except for point d. Instead of TRUE, put false and run the job again.
After that from SQL Developer/SQL Plus

update siebel.s_srm_req_param set value = ”removepass” where value = ”siebel_password”;
commit;

This update is needed because of a Siebel security issue. When you generate triggers, Siebel stores the password of user Siebel
in the database without encryption. Any siebel user can view this running an SQL.

9) Go to Administration -> Web Services, select Outbound Web Services

Delete all the URLs in the second applet, change them to http://localhost
If you have active Web Services in Development environment, you need to set the correct URLs for all active web services.

10) After that go to some screens and check if everything is ok.
11) We need to do some other cleaup activities – the ucf file used to generate ddlsync uses both siebel and sadmin passwords.
Deployments will not work if the ddlsync fails. This is how we can generate a new ddlsync file

Log in as siebel, go to siebsrvr directory /install_folder/siebel/8.1/siebsrvr

Load siebenv.sh

siebel@servername:/install_folder/siebel/8.1/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] 1
[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 [/install_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 [/install_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] 6
[ ] 1 – Install Database
[ ] 2 – Upgrade Database
[ ] 3 – Apply Additive Schema Changes
[ ] 4 – Import/Export Repository
[ ] 5 – Migrate Repository
[X] 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]

——————————————————————————-
Select one of the following Database utilities options

[X] 1 – Synchronize Schema Definition
[ ] 2 – Universal Time Code Conversion
[ ] 3 – Multilingual List of Value Conversion

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]

——————————————————————————-
Choose whether the Siebel Database you are synchronizing with the physical
schema is UNICODE or not.

[ ] 1 – UNICODE Database
[X] 2 – Non-UNICODE Database

To select an item enter its number, or 0 when you are finished: [0] 1
[X] 1 – UNICODE Database
[ ] 2 – Non-UNICODE Database

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]

——————————————————————————-
Select the base language (also called primary language) from the list

[ ] 1 – English (American)
[X] 2 – Turkish

To select an item enter its number, or 0 when you are finished: [0] 1
[X] 1 – English (American)
[ ] 2 – Turkish

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 [] DSN_NAME
Press 1 for Next, 2 for Previous, 3 to Cancel or 4 to Redisplay [1]

——————————————————————————-
Siebel Database User Name
Siebel Database Password

Database User Name []
Siebel Database Password

Database User Name [] SADMIN
Database Password: heslo
Database Password–(confirm): heslo
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: heslo
Database Table Owner Password–(confirm): heslo
Press 1 for Next, 2 for Previous, 3 to Cancel or 4 to Redisplay [1]

——————————————————————————-
Index Table Space Name
Table Space Name

Index Table Space Name [] SIB_INDEX
Table Space Name [] SIB_DATA
Press 1 for Next, 2 for Previous, 3 to Cancel or 4 to Redisplay [1]

——————————————————————————-
Name of the repository you want to synchronize with the physical schema

Repository Name [Siebel Repository]
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 [ddlsync]
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 : /install_folder/siebel/8.1/siebsrvr
Siebel Database Server Directory : /install_folder/siebel/8.1/dbsrvr
RDBMS Platform : Oracle Database Enterprise Edition
Siebel Database Operation : Run Database Utilities
Database Utility Selection : Synchronize Schema Definition
Database Encoding : UNICODE Database
Base Language : English (American)
Language Selection : ENU
ODBC Data Source Name : DSN_NAME
Database User Name : SADMIN
Database Password : ********
Database Table Owner : siebel
Database Table Owner Password : ********
Index Table Space Name : SIB_INDEX
Table Space Name : SIB_DATA
Repository Name : Siebel Repository
Oracle Parallel Index : Does not use the Oracle Parallel Indexing option
Security Group ID / Grantee : SSE_ROLE
Log Output Directory : ddlsync
Configuration is complete: your output will be saved under

Press ENTER to read the text [Type q to quit]

$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] 3
[ ] 1 – Configure Product in Live Mode
[ ] 2 – Configure Product for Offline Deployment
[X] 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]

Advertisements
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: