| Creating another database [message #303588] |
Fri, 29 February 2008 23:23  |
durgadas.menon
Messages: 365
Registered: December 2007
Location: Nowhere
|
Senior Member |
|
|
Hi,
I am trying to create a second database on my machine. Here are the steps
- created a new service named MSE
- logged in sqlplus with /as sysdba username/password
- made a pfile (p.ora) with only three parameter
db_name =mse
instance_name=mse
compatible = 10.2.0.1
- startup nomount pfile = d:\p.ora
- alter system set db_create_file_dest= 'd:\files\data'
- alter system set db_create_online_log_dest_1= 'd:\files\log'
then Create database mse;
this gives an error Ora-01092 Oracle instance terminated. Disconnection forced
Any idea why this happens?
- Das
|
|
|
|
|
|
| Re: Creating another database [message #303600 is a reply to message #303593] |
Sat, 01 March 2008 00:33  |
durgadas.menon
Messages: 365
Registered: December 2007
Location: Nowhere
|
Senior Member |
|
|
Thanks for the reply
Where do I need to give the password? I am doing it manually so I was not asked for one. Let me know
you were right I had to specify the control_file, backgound_dump_ dest, user_dump_dest, undo_tablespace, undo_management clause..but I thought as I had specified OMF path Oracle will automatically put these in them.
I was able to successfully create the database
- Das
|
|
|
|
|
|
| Re: Creating another database [message #303773 is a reply to message #303588] |
Sun, 02 March 2008 15:08 |
alliejane
Messages: 59
Registered: July 2005
Location: Glasgow
|
Member |
|
|
| Quote: | Where do I need to give the password?
|
The password file is required to allow you to start/stop/backup etc the database remotely, also if your going to use DBConsole your going to need a password file as well.
It lets you login "as sysdba" when your not on the database server.
Alison
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
