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

This is in continuation of my last post. So, before going through, please check this:

How to get export of Siebel database to a dump file

In my last post, we have exported siebel database in a dump file. Now we will import this dump file to another databse server.

Step 1:

Get ready dump file what we have exported in last post.

 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. Drop the user siebel only if the table space and index space on the source and target environment are same.

DROP USER SIEBEL CASCADE;

And re-create it again:

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. We can use user we have created while exporting database as well.

impdp <username>/<password> directory=my_dir dumpfile=exp_tab.dmp logfile=imp_tab.log full=y;

Open export log file and check for used export command, if it is imp then use below one:

imp username/password@hoststring file=filename.dmp log=filename.log full=y

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.

[su_divider style=”dotted”]

@AskmeSiebel