Managing oracle 9i Database

[Landan]

This is my first step in Managing oracle database.I want a complete code to Create database in Oracle 9i version.Can You explain me about different type of supporting files that are being used in managing the database. What are the need of these files ?? How many ways of creating the database in Oracle 9i. Why we move to the Start up mount and start up no mount.

[Zecho]

There are two ways to creating the Database in Oracle 9i :

1. Manual Creation of Database.
2. Using DBCA (Database Configuration Assistant)


Create a Newly and fresh directory structure for the database. After that, copy the init.ora file into a new file called init<SID>.ora into new Folder.

Now you are ready with a parameter file and don't remember the SID that you have defined with the parameter file.
If you are a windows user type :
Set ORACLE_SID = <SID>

and if Unix operating system then Type:
Export ORACLE_SID = <SID>

Now follow these steps:

sqlplus / as sysdba

startup nomount pfile = ‘<directory>\init<SID>.ora’

CREATE DATABASE Zechodb
Maxinstances 1
Maxloghistory 1
Maxlogfiles 8
Maxlogmembers 10
Maxdatafiles 20
Datafile ‘<directory>\Parentdbfile.dbf’
size 300M reuse autoextend on next 15M maxsize unlimited

national character set AL16UFT16
logfile
group 1 (‘<directory>\redo1.log’) size 50M
group 2 (‘<directory>\redo2.log’) size 50M
group 3 (‘<directory>\redo3.log’) size 50M
default temporary tablespace tmp
tempfile ‘<directory>\tempdbfile.dbf’
extent management local uniform size 1M
undo tablespace Undotbs datafile ‘<directory>\Undodatafile.dbf’
size 125M reuse autoextend on next 15M maxsize unlimited;

After all these thing, you need to execute some SQL files that will create some views.

@<directory>\catalog.sql
@<directory>\catproc.sql
@<directory>\catexp.sql

Change your password of database for security purpose.

[Reegan]

The Oracle database also provide a way to create your database very easily.
There is no need to go and create directory and file. Just click on the buttons and your database will be in front of you after some moments.

Now we are going to create a database in oracle 9i using DBCA (Database configuration Assistant):

1. Type DBCA in the terminal and a wizard would be open for you.
2. There are so many option you would see and select According to your Use.
3. Actually the every category of database has different steps of creation.
4. select one of them. for Example : "General purpose".
5. Click on the next button below .
6. Insert the name of the database in the Text box .
7. Specify the parameter that you wanted to set for the instance and configure the different parameters
8. After another next your creation of database would be started
9. Just wait for some moments,after that you would be prompted for the password of Administrator of the database.

After all open the terminal and type :

Export ORACLE_SID=<SID> //For Linux Users
Set ORACLE_SID=<SID> // For Windows Users

and then type sqlplus '/ as sysdba' and start your database.

[opaper]

There are different stages of managing of database.You can divert your database according to use and troubleshooting phases and we are discussing here about two stages of the database: Mount and nomount.

Oracle instance starts in this way:
==> Shut down=>nomount=>mount=>open=
ll ll
===============================
Mount : Mount stage of the database used when the recovery of database is being performed.In this stage the oracle server process reads the control file and make enable the database for recovery process.
This command can change the database mode in mount stage :
SQL>Startup Mount

Nomount : Nomount is rarely used in the normal processing of database.It is used when we create the database and in this stage the oracle server process reads the parameter file.But we can divert our database using this command:
SQL> Startup nomount