Siebel Installations > Copy Production data to Development environment
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 12.132.32.128:2320 -u SADMIN -p PASSWORD -e ENT_NAME change enterprise parameter Password=PASSWORD (new sadmin password) change enterprise parameter TableOwnPass=PASSWORD (new Siebel password) 12.132.32.128 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 12.132.32.128:2320 -e ENT_NAME -s SERVER_NAME -u sadmin" -e PASSWORD -L ENU
12.132.32.128 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 12.132.32.128:2320 SERVER_NAME 12.132.32.128 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 - Czech
To select an item enter its number, or 0 when you are finished: [0] 1
[X] 1 - English (American) [ ] 2 - Czech
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]
|