Two methods are available for creating a new database: the Database Configuration Assistant (DBCA) GUI application and the CREATE DATABASE SQL statement. For simplicity we'll use the DBCA. You can read about creating a database using the SQL interface in Chapter 2 of the Oracle Database Administrators Guide.
To use the configuration assistant, export your display (if your not on the console) and run dbca:
bash-2.05$ export DISPLAY=10.10.1.100:0 bash-2.05$ pwd /u01/app/oracle/product/10.1.0/db_1/bin bash-2.05$ ./dbca
We'll then use the following steps in the GUI.
After the database has been created, you can go examine the files it created.
bash-2.05# cd /u02/oradata/test bash-2.05# ls -alh total 1451556 drwxr-xr-x 2 oracle oinstall 512 Oct 5 16:43 . drwxr-xr-x 4 oracle dba 512 Oct 5 16:40 .. -rw-r----- 1 oracle oinstall 2.7M Oct 5 16:53 control01.ctl -rw-r----- 1 oracle oinstall 2.7M Oct 5 16:53 control02.ctl -rw-r----- 1 oracle oinstall 2.7M Oct 5 16:53 control03.ctl -rw-r----- 1 oracle oinstall 10M Oct 5 16:53 redo01.log -rw-r----- 1 oracle oinstall 10M Oct 5 16:46 redo02.log -rw-r----- 1 oracle oinstall 10M Oct 5 16:51 redo03.log -rw-r----- 1 oracle oinstall 210M Oct 5 16:53 sysaux01.dbf -rw-r----- 1 oracle oinstall 430M Oct 5 16:53 system01.dbf -rw-r----- 1 oracle oinstall 20M Oct 5 16:43 temp01.dbf -rw-r----- 1 oracle oinstall 25M Oct 5 16:53 undotbs01.dbf -rw-r----- 1 oracle oinstall 5.0M Oct 5 16:46 users01.dbf
There will also be files in your oracle admin directory (OFA path: /u01/app/oracle/admin/(sid)) and the dbs directory (OFA path: /u01/app/oracle/product/10.1.0/db_1/dbs).
If you want to play with Enterprise Manager, you can do so now. Go to the URL listed in the final dialog of the dbca session. At the login screen use the username "sys", the password "passwd" (as we specified during creation) and from the drop down choose "SYSDBA". Once you login you'll get a licensing information screen, agree to the terms to keep playing. After this you'll get the full Enterprise Manager experience. You'll see that the database has already been started and is up. On the "Administration" tab you can really play with some nifty things. You can create nearly any database component here without ever touching SQL*Plus.
If you playing with the Enterprise Manager (EM), go ahead and shutdown the database so we can see how to start it up using SQL*Plus.