oracle 9i for windows - create database

[naushi]

I did not find any folder for 9i so I picked this one.

In 8i you would create a database by creaitng a service first using the 'oradim' command' specifying where the init file is and then you go into svrmrgl to create the database with control file and log file details.

What is the deal in 9i. I see the database created by the Oracle utility has no init file. IS there a svrmgrl in 9i? How do you start and stop the instance/

Woudl appreciate any help Regards,
Naushi Hussain
Naushi.hussain@honeywell.com

 

[rcurva]

I believe it is still the same with Oracle 9i, you still need an init param file (init.ora) although you can have another option to use server param file to be more dynamic.

I am not sure though if 9i still provide the svrmgrl but you can make use of the sqlplus to create your database manually.

$ SQLPLUS /nolog

You can also use the GUI Database Config. Assistant to create your databse and use templates instead.

Here's a link:

http://technet.oracle.com/docs/prod...release2/server.920/a96521/create.htm#1000691

Robbie

"The rule is, not to besiege walled cities if it can possibly be avoided" -- Art of War