>> Installing DataBase and SQL Developer

Step 5 of 8


Its purely ones choice to use a particular database. you can use MYSQL provided with the ATG package or to use Oracle's XE which is a FREE package available in Oracles Site or some thing else.

I chose Oracle XE.

Step 6 of 8

SAL developer is a package available in Oracle Site for free. It is an User interface to interact with the DataBase.

6.1 Configuring Data Base:

6.1.1 Open Sql Developer and Create a new Connection. And make this as SYSDBA. Test the connection , Save and Connect.



If you Desire to use switching Data Sources create 4 schemas/users one for production, one for publishing, 2 for switching datasources. As iam trying to show CRS application, using similar naming Conventions. Create CRS_A, CRS_B, CRS_PRODUCTION, CRS_PUBLISHING users.

6.1.2 Go to Connections>> SYS >> other users , right click and select “create user”



6.1.3 Give Roles and Prevellages to the user using the roles tab and previllages tab.

6.1.4 Select the Quota in the Quotas tab as users.

6.1.5 Run the SQl generated in SQL tab and Close. 

CREATE ALL THE FOUR SCHEMAS.



Running CIM