Simpler Navigation for Servers and Operating Systems
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
General
cancel
Showing results for 
Search instead for 
Did you mean: 

Create an Oracle 9i Database and Listener

SOLVED
Go to solution
KapilRaj
Honored Contributor

Create an Oracle 9i Database and Listener

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
Nothing is impossible
9 REPLIES
Steven E. Protter
Exalted Contributor
Solution

Re: Create an Oracle 9i Database and Listener

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
Steven E Protter
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
KapilRaj
Honored Contributor

Re: Create an Oracle 9i Database and Listener

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
Nothing is impossible
TwoProc
Honored Contributor

Re: Create an Oracle 9i Database and Listener

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.
We are the people our parents warned us about --Jimmy Buffett
Steven E. Protter
Exalted Contributor

Re: Create an Oracle 9i Database and Listener

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
Steven E Protter
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
TwoProc
Honored Contributor

Re: Create an Oracle 9i Database and Listener

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!
We are the people our parents warned us about --Jimmy Buffett
KapilRaj
Honored Contributor

Re: Create an Oracle 9i Database and Listener

Does dbca and nwca need an Xserver as it was for the Installer ?
Nothing is impossible
TwoProc
Honored Contributor

Re: Create an Oracle 9i Database and Listener

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.
We are the people our parents warned us about --Jimmy Buffett
Frank de Vries
Respected Contributor

Re: Create an Oracle 9i Database and Listener

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

Look before you leap
Srikanth Arunachalam
Trusted Contributor

Re: Create an Oracle 9i Database and Listener

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