Home » RDBMS Server » Server Administration » create database
create database [message #185434] Tue, 01 August 2006 14:07 Go to next message
alanm
Messages: 282
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.

Re: create database [message #185435 is a reply to message #185434] Tue, 01 August 2006 14:10 Go to previous messageGo to next message
joy_division
Messages: 4640
Registered: February 2005
Location: East Coast USA
Senior Member
What if you simply did this:
startup
Re: create database [message #185436 is a reply to message #185434] Tue, 01 August 2006 14:12 Go to previous messageGo to next message
alanm
Messages: 282
Registered: March 2005
Senior Member

Hi,
I did and at the moment I dont have a control file
Re: create database [message #185592 is a reply to message #185436] Wed, 02 August 2006 08:38 Go to previous messageGo to next message
joy_division
Messages: 4640
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 Go to previous message
alanm
Messages: 282
Registered: March 2005
Senior Member

Thnaks, I have managed to sort.

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


Current Time: Sat Dec 03 13:52:12 CST 2016

Total time taken to generate the page: 0.13807 seconds