Create an Oracle 9i Database and Listener

[KapilRaj]

Guys,

Can you give me steps to create a 9i database from scratch ?.

I have completed 9.2.0.1 install and also I have patched it to 9.2.0.4.

I have created the following,

Datafilesystem : - /oradata01
Archive Log Destination : - /archive01
Redologs : - /redo_logs01
SID Name :- TESTDB
Listener :- lsnr_a ( Want to listen only on 10.0.0.11)

The database will be used as a transaction database.

Let me know if you need more details to help me.

Regds,

Kaps

[Steven E. Protter · Accepted solution]

Shalom Kaps,

Listener
http://www.integrigy.com/info/Integrigy_OracleDB_Listener_Security.pdf

Creating an oracle database:
http://www.redhat.com/docs/manuals/csgfs/oracle-guide/s1-ora-db.html

Its a linux doc but the procedure is identical.

Just for grins, database security hardening.

http://www.oracle.com/technology/deploy/security/pdf/twp_security_checklist_db_database.pdf

SEP

[KapilRaj]

Thanks. I will have toi read these documents. I thought an oracle database creation would be something like a set of commands. Is it not ?.

Regards,

KapilRaj

[TwoProc]

First off,
You should really patch all the way to 9.2.0.7 (don't stop where you are). You won't get far in the security requirements documents at 9.2.0.4 anyways.

After you've got that done, you'll notice a program called "dbca", this is the "database creation assistant" - run this to help you create the database "creation" script (and it can even run it for you if you like).

Ditto for the listener creation. Use the "network assistant" which is the command "nwca".

These tools will get you rolling a lot faster, and you can use what they create for you as a starter template for learning how to do it all by hand, from scratch.

[Steven E. Protter]

John is right about the patch.

If you have no database going all the way to 9.2.0.7 is highly advisable.

The commands for creating a database don't change much version to version and shoud be in the docs.

SEP

[TwoProc]

You're right, it is really just two commands from sqlplus. "Create database..." and you'll then run a series of "alter tablespace temp..." commands. Then, you run a series of commands to fully round out the data dictionary and toolsets. But, these commands with all of their fun options can easily be 150 to 200 lines of stuff you'd have to figure out, which is all much easier to see what you're going for if you run the "dbca" assistant tool. Even if you have to run it several times as you learn what it is you're trying to do, it's fine, you can blow away your database and re-run till your heart's content.

I generally run the assistant, then take the resultant file, and edit it up the way I want it to work before running by hand (not allowing the dbca tool to run it for me). You'll learn more of what the system is doing and trying to accomplish this way.

Good luck!

[KapilRaj]

Does dbca and nwca need an Xserver as it was for the Installer ?

[TwoProc]

Yes, you'll need to have an X server configured, just like for the installer, because, like the installer, they are graphic java applications with gooey controls.

[Frank de Vries]

Normally the creation of a DB requires some
advanced planning, in terms of space, charset
, accounts to use etc. etc.
And then convert that into concrete commands.

Concrete example of a basic create db syntax for u:

startup nomount

create database "TESTDB"
maxinstances 5
maxlogfiles 16
maxdatafiles 150
archivelog
maxloghistory 200
character set "WE8ISO8859P1"
logfile
GROUP 1 '/archive01/redo1T.log' SIZE 30481K,
GROUP 2 '/archive01/redo2T.log' SIZE 30481K,
GROUP 3 '/archive01/redo3T.log' SIZE 30481K
datafile
'/oradata01/systemT_1.dbf ' size 125M;
disconnect
spool off

Then you can add your TEMP and ROLLBACK
tablespaces,
run the catalog.sql and procedure (catproc.sql) , you will find these under
$ORACLE_HOME/rdbms/admin.

But as was mentioned above , it is probably
easier to run dbca and follow it through

[Srikanth Arunachalam]

Hi,

You can use DBCA available under $ORACLE_HOME/bin. Perform the following :-
(1) export DISPLAY=:0.0 where the xhost can be started.

(2) cd $ORACLE_HOME/bin

(3) just type dbca and check the output on a screen.

Remember that you created all filesystem under root. Try creating mount point of /u01/app/oracle as ORACLE_BASE.
/u01/oracle as oracle user home directory. /u01/app/oracle/Ora_Home1 as ORACLE_HOME.

You will have to create mount point using LVM as follows (this is only a example) :-

$pvcreate â f /dev/rdsk/c5t0d0
$mkdir /dev/vg_appl
$mknod /dev/vg_appl/group c 64 0x010000
$vgcreate vg_appl /dev/dsk/c5t0d0
$strings /etc/lvmtab
$lvcreate â L 1024 â n appl vg_appl
$mkdir /u01/app/oracle
$newfs â F vxfs â o largefile /dev/vg_appl/rappl
$mount /dev/vg01/appl /u01/app/oracle.

Check up the device path (/dev/dsk/c5t0d0) , disk size and the minor number (0x010000) from your system administrator.

Thanks,
Srikanth