Home > Siebel, Unix > Siebel schema export and import from one Siebel DB server to other

Siebel schema export and import from one Siebel DB server to other

This document would assist the user to export the Siebel data base dump from one environment and import the same into another environment.  The source and target database server have Oracle as their databases.

Step 1:

Exporting siebel database from source DB server environment:

Connect to the source DB server as oracle user.

[oracle@celbssdb6 ~]$ expdp system/password@DBname schemas=SIEBEL dumpfile=SBL_DEV_ddmmyyyy.dmp logfile=exp_SBL_DEV_ddmmyyyy.log compression=ALL parallel=4&

<The user need not specify the system password in the expdp command.  Without password when the command is run, it would prompt the user to enter the system password>

 Step 2:

Copy the DB dump file to the target DB server environment:

scp the file to target DB server as oracle user to the path /app/oracle/admin/<DBname>/<folder>

Step 3:

Connect to sqlplus on the target DB server as the user system.

Run the query

SQL> select * from siebel.dba_directories where directory_name=’DATA_PUMP_DIR’;

OWNER                          DIRECTORY_NAME

—————————— ——————————

DIRECTORY_PATH

——————————————————————————–

SYS                            DATA_PUMP_DIR

/app/oracle/admin/<DBname>/<folder>/

SQL>drop user SIEBEL cascade;

SQL>commit;

SQL>exit

Drop the user siebel only if the table space and index space on the source and target environment are same.

And re-create it again:

DROP USER SIEBEL CASCADE;

—–

CREATE USER SIEBEL
IDENTIFIED BY <password>
DEFAULT TABLESPACE SIEBEL_DATA
TEMPORARY TABLESPACE TEMP
PROFILE DEFAULT
ACCOUNT UNLOCK;
— 4 Roles for SIEBEL
GRANT SELECT_CATALOG_ROLE TO SIEBEL;
GRANT SCHEDULER_ADMIN TO SIEBEL;
GRANT SSE_ROLE TO SIEBEL;
GRANT TBLO_ROLE TO SIEBEL;
ALTER USER SIEBEL DEFAULT ROLE ALL;
— 2 Tablespace Quotas for SIEBEL
ALTER USER SIEBEL QUOTA UNLIMITED ON SIEBEL_DATA;
ALTER USER SIEBEL QUOTA UNLIMITED ON SIEBEL_INDEX;

—–

Step 4:

Stop the siebel server, gateway server and SWSE on the target environment.

Step 5:

Import the database dump file on the target DB server as oracle user.

impdp system/password@DBname schemas=SIEBEL dumpfile=SBL_DEV_ddmmyyyy.dmp logfile=imp_SBL_DEV_ddmmyyyy.log parallel=4

<The user need not specify the system password in the imppdp command.  Without password when the command is run, it would prompt the user to enter the system password>

After DB import change the password of SIEBEL user to the original password in the target environment.  If the password for the SIEBEL is same for both source and target DB server then leave it.

Step 6:

Start the SWSE, gateway and siebel servers on the target environment.

Step 7:

Run a full compile on the target environment and deploy the SRF & generate browser scripts.

Step 8:

Verify the database updates and changes in the target environment.

Advertisements
Categories: Siebel, Unix Tags: , ,
  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: