Pr.Pg Next Pg

Creating the simple database in 11g tutorials

 

  • For creating a simple database (e.g.: demodatabase) there are following steps such as:

  • Start Database Configuration Assistant.
    This procedure varies by platform. In Windows, for example, choose Start > All Programs > Oracle - OraDb11g_home2 > Configuration and Migration Tools > Database Configuration Assistant.

  • Click Next to skip the Welcome page.

  • On the Operations page, select Create a Database; then click Next.
    Database Configuration Assistant guides you through the steps needed to create a database

  • On the Database Templates page, select General Purpose or Transaction Processing; then click Next.

  • On the Database Identification page, type demodatabase in the Global Database Name and SID boxes; then click Next.

  • On the Management Options page, accept the default settings; then click Next.

  • On the Database Credentials page, set the user passwords (You Entered During Installation); then click Next.

  • On the Storage Options page, select File System; then click Next.

  • On the Database File Locations page, select Use Database File Locations from Template; then click Next.

  • On the Recovery Configuration page, accept the default settings; then click Next.

  • On the Database Content page, accept the default settings; then click Next.

  • On the Initialization Parameters page, select the following options; then click Next.

  • Memory tab: Select Typical and accept the default percentage. (This setting is appropriate to create a database with minimal user input.)

  • Sizing tab: Accept the default settings.

  • Character Sets tab: Accept the default settings.

  • Connection Mode tab: Select Dedicated Server mode. (This setting is appropriate when only a small number of clients will use the database.)

  • On the Security Settings page, accept the default settings; then click Next.

  • On the Automatic Maintenance Tasks page, accept the default settings; then click Next.

  • On the Database Storage page, accept the default settings; then click Next.

  • On the Create Options page, select Create Database; then click Finish.

  • In the Confirmation dialog box that appears, review the configuration options (and save them to an HTML file if you like); then click OK.

  • A progress box appears while Oracle creates the database.

  • Click Exit in the message box that appears when Oracle finishes creating the database.


Pr.Pg border                                              Next Pg