Home » RDBMS Server » Server Administration » Creating another database (Win 2003, Oracle 10.2.0)
Creating another database [message #303588] Fri, 29 February 2008 23:23 Go to next message
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 #303593 is a reply to message #303588] Fri, 29 February 2008 23:57 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

1. did you create password.
2. your pfile (init.ora) is not complete.
Re: Creating another database [message #303600 is a reply to message #303593] Sat, 01 March 2008 00:33 Go to previous messageGo to next message
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 #303607 is a reply to message #303600] Sat, 01 March 2008 01:36 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

...Where do I need to give the password?...
YOu need to create password file through ORAPWD utility.
search on forms/google for more details about ORAPWD utility.

...I was able to successfully create the database...
Good.

Re: Creating another database [message #303773 is a reply to message #303588] Sun, 02 March 2008 15:08 Go to previous message
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
Previous Topic: ORA-01034: ORACLE not available and ORA-27101
Next Topic: (urgent) How to repair corrupted index / block
Goto Forum:
  


Current Time: Thu Dec 08 04:23:51 CST 2016

Total time taken to generate the page: 0.20817 seconds