OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » create database

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

create database [message #185434]

Tue, 01 August 2006 14:07

alanm
Messages: 284
Registered: March 2005

Senior Member

this will sound really daft but I have copied and run the create database script from an existing database and got a file which I hope to run on a new server. I have this create db script from metalink. however when I run this I get the message saying oracle is not available. anyone got any ideas on how to resolve this.

I have an ORACLE_HOME, and ORACLE SID and an ORACLE_BASE. when I connect to sqlplus '/ as sysdba' I connect to an idle instance.

Report message to a moderator

Re: create database [message #185435 is a reply to message #185434]

Tue, 01 August 2006 14:10

joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA

Senior Member

What if you simply did this:
startup

Report message to a moderator

Re: create database [message #185436 is a reply to message #185434]

Tue, 01 August 2006 14:12

alanm
Messages: 284
Registered: March 2005

Senior Member

Hi,
I did and at the moment I dont have a control file

Report message to a moderator

Re: create database [message #185592 is a reply to message #185436]

Wed, 02 August 2006 08:38

joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA

Senior Member

What CREATE DATABASE command are you talking about? The init.ora file would define the locations of the control files. Maybe the script you have does not have this?

[Updated on: Wed, 02 August 2006 08:57]

Report message to a moderator

Re: create database [message #185615 is a reply to message #185434]

Wed, 02 August 2006 12:17

alanm
Messages: 284
Registered: March 2005

Senior Member

Thnaks, I have managed to sort.

Report message to a moderator

Previous Topic:	CoreDump generartion ...
Next Topic:	need script

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 10:28:37 CDT 2024