How to create a new database after initally installing oracle database 11g Express Edition

Question

I have installed Oracle Database 11g Express Edition on my pc  windows 7  and I have installed Oracle SQL Developer as well    I want to create a simple database to start with  maybe with one table or two and then use Oracle SQL Developer to insert data and query it   When I open Oracle SQL Developer  it asks me to create a new connection  therefore it assumes that a database has already been created    So my question is  how do I create an initial database in Oracle 11g

User · Answer

If you wish to create a new schema in XE, you need to create an USER and assign its privileges. Follow these steps:

Open the SQL*Plus Command-line

SQL> connect sys as sysdba

Enter the password

SQL> CREATE USER myschema IDENTIFIED BY Hga&dshja;
SQL> ALTER USER myschema QUOTA unlimited ON SYSTEM;
SQL> GRANT CREATE SESSION, CONNECT, RESOURCE, DBA TO myschema;
SQL> GRANT ALL PRIVILEGES TO myschema;

Now you can connect via Oracle SQL Developer and create your tables.

User · Answer

Save the following code in a batch file  ex  createOraDbWin bat   Change the parameter values like app name  ora dir etc    Run the file with administrative privileges  The batch file creates a basic oracle database   Note   May take much time  say around 30mins   REM ASSUMPTIONS rem oracle xe has been installed rem oracle home has been set rem oracle sid has been set rem oracle service is running  REM SET PARAMETERS set char set  al32utf8 set nls char set  al16utf16  set ora dir d  app db oracle set version 11 2 0 0 set app name xyz set db name  app name  db set db sid  db name  sid set db ins  db name  ins set sys passwd x3y5z7 set system passwd 1x4y9z  set max log files 32 set max log members 4 set max log history 100 set max data files 254 set max instances 1  set version dir  ora dir   version  set db dir  version dir   db name   set instl temp dir  db dir  instl script  set system dir  db dir  system set user dir  db dir  user set undo dir  db dir  undo set sys aux dir  db dir  sysaux set temp dir  db dir  temp set control dir  db dir  control  set pfile dir  db dir  pfile set data dir  db dir  data set index dir  db dir  index set log dir  db dir  log set backup dir  db dir  backup set archive dir  db dir  archive  set data dir  db dir  data set index dir  db dir  index set log dir  db dir  log set backup dir  db dir  backup set archive dir  db dir  archive set undo dir  db dir  undo set default dir  db dir  default  set system tbs  db name  system tbs set user tbs  db name  user tbs set sys aux tbs  db name  sys aux tbs set temp tbs  db name  temp tbs set control tbs  db name  control tbs  set data tbs  db name  data tbs set index tbs  db name  index tbs set log tbs  db name  log tbs set backup tbs  db name  backup tbs set archive tbs  db name  archive tbs set undo tbs  db name  undo tbs set default tbs  db name  default tbs  set system file  system dir   db name  system dbf set user file  user dir   db name  user dbf set sys aux file  sys aux dir   db name  sys aux dbf set temp file  temp dir   db name  temp dbf set control file  control dir   db name  control dbf  set data file  data dir   db name  data dbf set index file  index dir   db name  index dbf set backup file  backup dir   db name  backup dbf set archive file  archive dir   db name  archive dbf set undo file  undo dir   db name  undo dbf set default file  default dir   db name  default dbf  set log1 file  log dir   db name  log1 log set log2 file  log dir   db name  log2 log set log3 file  log dir   db name  log3 log  set init file  pfile dir  init db sid  ora set db create file  instl temp dir  createdb sql set db drop file dropdb sql  set db create log  instl temp dir  db create log set db drop log db drop log  set oracle sid  db sid   REM WRITE DROP DATABASE SQL COMMANDS TO FILE echo shutdown immediate  gt  db drop file  echo startup mount exclusive restrict  gt  gt  db drop file  echo drop database  gt  gt  db drop file   REM EXECUTE DROP DATABASE SQL COMMANDS FROM THE FILE     rem sqlplus -s   as sysdba     db drop file   gt  db drop log   REM DELETE WINDOWS ORACLE SERVICE rem oradim -delete -sid  db sid   REM CREATE DIRECTORY STRUCTURE md  system dir  md  user dir  md  sys aux dir  md  temp dir  md  control dir   md  pfile dir  md  data dir  md  index dir  md  log dir  md  backup dir  md  archive dir  md  undo dir  md  default dir  md  instl temp dir   REM WRITE INIT FILE PARAMETERS TO INIT FILE echo db name   db name   gt  init file  echo memory target 1024m gt  gt  init file  echo processes 150 gt  gt  init file  echo sessions 20 gt  gt  init file  echo audit file dest  user dir  gt  gt  init file  echo audit trail   db  gt  gt  init file  echo db block size 8192 gt  gt  init file  echo db domain    gt  gt  init file  echo diagnostic dest  db dir  gt  gt  init file  echo dispatchers   protocol tcp   service  app name xdb   gt  gt  init file  echo shared servers 4 gt  gt  init file  echo open cursors 300 gt  gt  init file  echo remote login passwordfile  exclusive  gt  gt  init file  echo undo management auto gt  gt  init file  echo undo tablespace   undo tbs   gt  gt  init file  echo control files      control dir  control1 ora     control dir  control2 ora   gt  gt  init file  echo job queue processes 4 gt  gt  init file  echo db recovery file dest size   10g gt  gt  init file  echo db recovery file dest  log dir  gt  gt  init file  echo compatible   11 2 0  gt  gt  init file   REM WRITE DB CREATE AND ITS RELATED SQL COMMAND TO FILE     echo startup nomount pfile   init file    gt  gt  db create file  echo  gt  gt  db create file   echo create database  db name  gt  gt  db create file  echo user sys identified by  sys passwd  gt  gt  db create file  echo user system identified by  system passwd  gt  gt  db create file  echo logfile group 1    log1 file    size 100m  gt  gt  db create file  echo group 2    log2 file    size 100m  gt  gt  db create file  echo group 3    log3 file    size 100m gt  gt  db create file  echo maxlogfiles  max log files  gt  gt  db create file  echo maxlogmembers  max log members  gt  gt  db create file  echo maxloghistory  max log history  gt  gt  db create file  echo maxdatafiles  max data files  gt  gt  db create file  echo character set  char set   gt  gt  db create file  echo national character set  nls char set   gt  gt  db create file  echo extent management local gt  gt  db create file  echo datafile   system file   size 325m reuse gt  gt  db create file  echo sysaux datafile   sys aux file   size 325m reuse gt  gt  db create file  echo default tablespace  default tbs  gt  gt  db create file  echo datafile   default file   gt  gt  db create file  echo size 500m reuse autoextend on maxsize unlimited gt  gt  db create file  echo default temporary tablespace  temp tbs  gt  gt  db create file  echo tempfile   temp file   gt  gt  db create file  echo size 20m reuse gt  gt  db create file  echo undo tablespace  undo tbs  gt  gt  db create file  echo datafile   undo file   gt  gt  db create file  echo size 200m reuse autoextend on maxsize unlimited  gt  gt  db create file  echo  gt  gt  db create file   echo    rdbms admin catalog sql gt  gt  db create file  echo  gt  gt  db create file   echo    rdbms admin catproc sql gt  gt  db create file  echo  gt  gt  db create file   echo create spfile from pfile   init file    gt  gt  db create file  echo  gt  gt  db create file   echo shutdown immediate  gt  gt  db create file  echo  gt  gt  db create file   echo startup  gt  gt  db create file  echo  gt  gt  db create file   echo show parameter spfile  gt  gt  db create file  echo  gt  gt  db create file   REM CREATE WINDOWS ORACLE SERVICE oradim -new -sid  db sid  -startmode auto  REM EXECUTE DB CREATE SQL COMMANDS FROM FILE sqlplus -s   as sysdba     db create file   gt  db create log   pause   Welcome your corrections and improvements

User · Answer

How do I create an initial database      You created a database when you installed XE   At some point the installation process  prompted you to enter a password for the SYSTEM account    Use that to connect to the XE database using the SQL commandline on the application menu     The XE documentation is online and pretty helpful   Find it here   It s worth mentioning that 11g XE has several limitations  one of which is only one database per server  So using the pre-installed database is the sensible option

User · Answer

When you installed XE     it automatically created a database called  XE     You can use your login  system  and password that you set to login      Key info  server   you defined  port  1521 database  XE username  system password   you defined   Also Oracle is being difficult and not telling you easily create another database   You have to use SQL or another tool to create more database besides  XE

User · Answer

This link  Creating the Sample Database in Oracle 11g Release 2 is a good example of creating a sample database   This link  Newbie Guide to Oracle 11g Database Common Problems should help you if you come across some common problems creating your database   Best of luck   EDIT  As you are using XE  you should have a DB already created  to connect using SQL Plus and SQL Developer etc  the info is here  Connecting to Oracle Database Express Edition and Exploring It   Extract      Connecting to Oracle Database XE from SQL Developer SQL Developer is a   client program with which you can access Oracle Database XE  With   Oracle Database XE 11g Release 2  11 2   you must use SQL Developer   version 3 0  This section assumes that SQL Developer is installed on   your system  and shows how to start it and connect to Oracle Database   XE  If SQL Developer is not installed on your system  see Oracle   Database SQL Developer User s Guide for installation instructions       Note       For the following procedure   The first time you start SQL Developer   on your system  you must provide the full path to java exe in step 1       For step 4  you need a user name and password       For step 6  you need a host name and port       To connect to Oracle Database XE from SQL Developer       Start SQL Developer       For instructions  see Oracle Database SQL Developer User s Guide       If this is the first time you have started SQL Developer on your   system  you are prompted to enter the full path to java exe  for   example  C  jdk1 5 0 bin java exe   Either type the full path after   the prompt or browse to it  and then press the key Enter       The Oracle SQL Developer window opens       In the navigation frame of the window  click Connections       The Connections pane appears       In the Connections pane  click the icon New Connection       The New Select Database Connection window opens       In the New Select Database Connection window  type the appropriate   values in the fields Connection Name  Username  and Password       For security  the password characters that you type appear as   asterisks       Near the Password field is the check box Save Password  By default  it   is deselected  Oracle recommends accepting the default       In the New Select Database Connection window  click the tab Oracle       The Oracle pane appears       In the Oracle pane       For Connection Type  accept the default  Basic        For Role  accept the default       In the fields Hostname and Port  either accept the defaults or type   the appropriate values       Select the option SID       In the SID field  type accept the default  xe        In the New Select Database Connection window  click the button Test       The connection is tested  If the connection succeeds  the Status   indicator changes from blank to Success       Description of the illustration success gif      If the test succeeded  click the button Connect       The New Select Database Connection window closes  The Connections pane   shows the connection whose name you entered in the Connection Name   field in step 4       You are in the SQL Developer environment       To exit SQL Developer  select Exit from the File menu

[oracle] How to create a new database after initally installing oracle database 11g Express Edition?

Examples related to oracle

Examples related to oracle11g

Examples related to oracle-sqldeveloper

Examples related to oracle-xe