Home » RDBMS Server » Server Utilities » Creating database...Urgent
Creating database...Urgent [message #71109] Tue, 10 September 2002 10:06 Go to next message
Rekha
Messages: 9
Registered: September 2000
Junior Member
Hello,

I am trying to create a new database. On my machine there are already 2 databases. This is the 3rd one to be created.

I have done the the following pre requirements for creating the database.
1) created the dumbs directory
2)init.ora (modified)
3)scripts for creating the database are ready

Now my question is about orapwd.
1) Do we have to run the password file password.sh ?
If yes how ?
2)Is the password file created on its own when the
database is run like control file?
3)Do I also need to create orapwd directory under
file ?

Thanks in advance for your time and help

regards,
Rekha
Re: Creating database...Urgent [message #71125 is a reply to message #71109] Wed, 11 September 2002 10:06 Go to previous message
Roy
Messages: 30
Registered: May 2002
Member
The best thing is to use 'dbassist' 8i or 'dbca' for oracle 9i to create the scripts. Make sure you selected custom database creation and fill in all the designated path values for files. One the script is created open them all and replace all 'SID' with $1 where $1 is the commandline argument. Usually the first script invokes all other. This way you don't have to manually do much work.
Previous Topic: How can I import data from a file?
Next Topic: copy users using imp/exp (constraints/triggers question)
Goto Forum:
  


Current Time: Sat May 04 07:01:25 CDT 2024