Oracle XE : To get started

This post is how to get started with an underlying DB (oracle XE) and the required connection from Jdeveloper. Oracle XE is light weighted and suffice for all development work for ADF and other fusion middleware technology tech stack.

To download and install

1. Follow this link to download Oracle XE 11g release 2:  http://www.oracle.com/technetwork/products/express-edition/downloads/index.html (It has link for both windows and Linux edition)
2. To Install  : Unzip OracleXE112_Win32 and run setup.exe from DISK1 folder.
3. To start the Database 
1. On Windows: Click Start, point to Programs (or All Programs), point to Oracle Database 11g Express Edition, and then select Start Database.
2. On Linux with Gnome: In the Applications menu, point to Oracle Database 11g Express Edition, and then select Start Database. 
3. On Linux with KDE: Click the icon for the K Menu, point to Oracle Database 11g Express Edition, and then select Start Database.
4. OR, At the operating system prompt, enter the following command to start the SQL Command Line and connect to the database:

   SQLPLUS / AS SYSDBA 

5. At the SQL Command Line prompt, enter the following command:
   

   SQL> STARTUP 

6. Use the same SQL prompt to create the DB objects and when done type EXIT to come out of the SQL prompt.
4. To Stop the Database 

1. On Windows: Click Start, point to Programs (or All Programs), point to Oracle Database 11g Express Edition, and then select Stop Database.
2. On Linux with Gnome: In the Applications menu, point to Oracle Database 11g Express Edition, and then select Stop Database.
3. On Linux with KDE: Click the icon for the K Menu, point to Oracle Database 11g Express Edition, and then select Stop Database.
4. OR, At the operating system prompt, enter the following command to start the SQL Command Line and connect to the database:

   SQLPLUS / AS SYSDBA

5. At the SQL Command Line prompt, enter the following command: SQL> SHUTDOWN IMMEDIATE 

To get connected to Oracle XE from Jdeveloper11g , following default setting works :

Webcenter - Why and What

Why Webcenter 

• Earlier internet pages were static. They used to provide information and with reader used to build only one way communication. New age internet on the contrary is more dynamic, interactive and allows readers to change the content of web page while they are reading.  We refer it as Web 2.0.
• Web 2.0 site allows users to interact and collaborate with each other. For example, Discussion forums, wikis, blogs, RSS feeds, social networking sites etc.
• With change of face of internet, the need has also arise of making website that are more interactive, dynamic and allows two way communication. Oracle webcenter helps building such applications.

What is Webcenter 

• Oracle WebCenter provides design time and runtime tools for building enterprise portals, transactional websites, and social networking sites. 
• It provides faster and effective ways of building Web 2.0 applications.
• Sample Oracle webcenter applications are intranets, extranets, dashboards, blogs, wikis, community discussion forums etc.
• Oracle Webcenter comes as a complete suite which has server and services (that allows web2.0 features) and frameworks like Oracle Webcenter portlets.

Pic courtesy : Oracle Webcenter Developer Guide

Webcenter Architecture

• Oracle Webcenter Portal Framework allows creation of dynamic portals
• Oracle Webcenter services offres varied range of functionality and can be consumed portals
• Composers allowed run time customization of pages.
• Webcenter spaces allows social collaborations