Re: Adding Second Database in oracle 10g

On 18 Mar 2006 00:27:37 -0800, "Raka" <rajesh.kanchan_at_gmail.com> wrote:

>Hi there,
>
>I am trying to add second database in oracle 10g on windows 2003 server
>but when ever i am trying to issue Create Database MYDBName .... it
>gives an error. database name do not match orcl.
>
>Please help me to create database using create database statement not
>using DBCA
>
>Rajesh

Which just means the database name doesn't match the SID. Nothing more nothing less. Surely you can rectify that by changing the SID?

Other than that: the scripts of your first database should have been saved in \oracle\admin\<sid>\scripts. Please work from there and change the script accordingly, if you don't manage to resolve it using dbca.

--
Sybrand Bakker, Senior Oracle DBA