Repository Import/Export & DDL Sync From Command Line

Sadmins,

Repository Export/Import and DDL sync during migrations can we done in different ways. In windows servers most of us will use “Database Server Configuration Wizard” and Uxin/Linux we use direct .ucf files. But in effect all these are invoking some common commands based on the input values provided. I think it is easy to customize and use this command during the deployments.

Export Repository,

• repimexp /a E /g ALL /u sadmin /p ****** /c siebel_DSN /d SIEBEL /r "Siebel Repository" /f "<Path to be exported>/siebel.dat" /l "<SIEBEL_ROOT>/log/exprep/output/Siebel_export.log"

Import Repository,

• repimexp /a I /G ALL /c siebel_DSN /u sadmin /p ****** /d SIEBEL /r "Siebel Repository_<Date>" /f "<Repository Path>/siebel.dat" /l "<SIEBEL_ROOT>/log/imprep/output/Siebel_Import.log"

DDL Sync,

• <SIEBEL_ROOT>/bin/ddldict /u sadmin /p ****** /c siebel_DSN /d siebel /f /app/siebel/dbsrvr/oracle/schema.ddl /e y /a y /l <SIEBEL_ROOT>/log/ddlsync/output/expschem.log /n "Siebel Repository" /T DCIR

•  <SIEBEL_ROOT>/bin/ddlimp /u siebel /p ******* /c siebel_DSN /g SSE_ROLE /f /app/siebel/dbsrvr/oracle/schema.ddl /e n /B SBL_DATA /X SBL_INDX /R Y /s Y /l <SIEBEL_ROOT>/log/ddlsync/output/ddlsync1.log /9 Y

• <SIEBEL_ROOT>/bin/ddlimp /u siebel /p ****** /c siebel_DSN /g SSE_ROLE /f /app/siebel/dbsrvr/oracle/schema.ddl /e y /B SBL_DATA /X SBL_INDX /R Y /s Y /l <SIEBEL_ROOT>/log/ddlsync/output/ddlsync2.log /9 Y

·       /c – System DNS value for Siebel environment

·       /B – Table space name for data

·       /X – Table space name for Index

Have a Nice deployment... :)

Application Deployment Manager

                       Application Deployment Manager(ADM)

Introduction:

Siebel can automate movement of Repository related data between environments, but it cannot move application related data like,

• List of Values
• View
• Responsibilities
• Business Services
• Runtime Events

and many more things. We have to move them manually. Using ADM provided by Siebel can make admins life easier.

Note: ADM is only recommended if the amount of data that is to be moved is less, otherwise EIM is the preferred option.

Following are the process to execute the UI Session ADM,

• Go to Application Deployment Manager > Deployment Projects,

• Create a Project under Deployment Projects view,

• Add entities and apply appropriate Filter,

• Enable the project
  

• Go to Application Deployment Manager > Deployment Sessions and create new deployment session with new project,
  

• Deploy the project
  

• Provide the path and click the export button,
  

• The exported file will be in the specified folder,
  

• Move the all three files to the destination environment and Go to Application Deployment Manager > Deployment Sessions,
  

• Select “Deploy From File” or “Deploy From Local File” from the “Menu”,
  

• Provide the path and click “Import” button,
  

Some points that need to keep in mind,

• There should be a shared folder that should be accessible from both source and target environments.
• Don’t forget to check the Export to File checkbox
• If your servers are on Unix/Solaris environment then you need to provide path according to that e.g /opt/shared/ and if your Siebel server is on windows then you need to provide path like \\servername\sharedfoldername
• Path provided in Source environment should be only till the shared folder for example if you want that your file should go to /opt/shared/admfolder then you should then path you give is /opt/shared/admfolder/
• In the target environment you will provide complete the path including the filename that you want to import.

Have nice Deployments with ADM.... :)

Oracle Database Installation - Oracle 11g R2 (Windows)

Installing the Oracle 11g R2 database Using OUI in Windows

There are two methods that you can use to install the Oracle software: basic and advanced. Choose the basic installation method to quickly the install the software with minimal user input. The advanced installation method enables you to perform a custom installation.

A.	Basic Installation
B.	Advanced Installation

Follow the steps below to install the Oracle software and create a database using the advanced installation method,

1. At the Configure Security Updates window, enter your e-mail address and Oracle Support password and click Next.

If you choose to not supply your email address and Oracle Support password, uncheck the check box, leave both text boxes empty, and then click Next. When prompted, click Yes.

At the Installation Option window, select Create and configure a database and click Next. 

At the System Class window (Select according to requirements), select Server Class and click Next.

At the Grid Options window, select Single instance database installation and click Next.

At the Install Type window, select Advanced install and click Next.

At the Product Languages window, select the required languages and then click Next.

At the Database Edition window, make sure that Enterprise Edition is selected and click Next.

At the Installation Location window, accept the defaults (Can be modified according to requirements) and click Next.

At the Configuration Type window, make sure the type of database is set to General Purpose / Transaction Processing for normal Siebel server requirements and click Next.

At the Database Identifier window, the Default SID will be “orcl” and can be chanced.

At the Configuration Options window, for the memory tab, you can accept the defaults. Click the Character sets tab.

Change the setting to Use Unicode (AL32UTF8) and then click Next.

At the Management Options window, accept the defaults and click Next.

At the Database Storage window, accept the defaults and click Next

At the Backup and Recovery window, accept the defaults and click Next.

At the Schema Passwords window, Provide same or different Oracle Recommended password for all accounts and confirm the password.  Click Next.

In the Next step, the OUI will check the system requirements and prerequisites

.

Click the Finish button to start configuration of database and listener.

Check the Services to make sure the database and listener is started and running.

Siebel Web Architecture - Overview

The Siebel Web Architecture

At a high level, the Siebel Web architecture consists of:

•  Siebel Web Clients that access and display the business data
• A Gateway Name Server that stores configuration information
• A Web server that handles interactions with the Web Clients and distributes requests to the Siebel Servers
• Servers that manage the business data and provide batch and interactive services for clients
• A relational database and file system that store business data

Web Usage Login Scenario

Siebel Web Client (browser) sends the URL to the Web server

 URL specifies:

• Either HTTP or HTTPS protocol
• Web server machine name
• Application and language

 URL initially connects to a Siebel-specific virtual directory on the Web server

·         Virtual directories are created as part of the Siebel installation

·         Virtual directory forwards request to the Siebel Web Server Extension (SWSE) installed on the Web server

·         SWSE uses the eapps.cfg configuration file to obtain connection parameters

Eapps.cfg specifies the location of the server, server connection broker port, Enterprise, and Object Manager information for initial connection

•  For multi-server installations provides load balancing information
• Also provides generic login information for initial “anonymous” access to database

Siebel Gateway Name Server

Stores component definitions and assignments, operational parameters, and connectivity information

•  For example, connect strings to query servers for server/component availability
•  Information stored in siebns.dat file on Gateway Name Server

Siebel Enterprise

• Is a logical collection of Siebel Servers that support users and access a single database server and the Siebel file system
• Logically groups Siebel Servers for common administration via Siebel Server Manager
• Supports sharing of common configuration information

Siebel Servers

Execute tasks to manage the business data

• Programs known as server components perform specific functions or jobs for the server
•  For example:
•  Importing and exporting data
• Configuring the database to monitor for user-defined conditions
•  Processing of client requests

•  Tasks may run interactively, in the background, or as batch jobs

Siebel File System

Is one or more shared directories that store files used by Siebel applications

•  Files are compressed in a proprietary format to save space and provide security
•  Examples: Product literature, sales tools, presentations, user profiles

Database Server

• Stores data used by Siebel applications in a predefined database schema
• Single database for Enterprise provides data consistency for users
•  Data is accessed by components through a data manager layer

• Supports a variety of third-party relational database management systems (RDBMS)