Re: How mounting two or more instance + OFA HowTo + others problems

Hi,

    In order to mount 2 or more instances, you should go with dbassist to create yous database and the name of the SID when prompt correspond to the global database name you gave when created with db assist.

Hope this helps!

--
Yanick Hudon
Programmeur Analyste
"Kankossa" <kily_at_my-deja.com> a écrit dans le message news:
2e16cdb7.0109050542.5b4f6854_at_posting.google.com...


> Hello,


>

> 1)I'm having two databases ORCL, TEST. I'm putting the neccessary

> entry in tnsnames.ora and listener.ora for the two databases.

> In oratab file, i'm putting a line for eache DB with "Y".

> The problem: I can connect only to one of my DB, for the second I got

> error message ora-01033. What is the problem please.

>

> 2) In the following a part of my initORCL.ora file.

>    for LOGFILE (as you can see below, this is also the case for

> controlfiles), I'm dispatching redolgfiles on three physically

> seperated drivers.

> My question is: can I do the same thing for DATAFILE? if Yes where I

> can? Juste before AUTOEXTEND ON? What about temp, tools, users,

> index... files can I dispatched them also as LOGFILE?

> dbassit, and OFA docs do not show what to do exactly.

>

> CREATE DATABASE ORCL

> controlfile reuse

> LOGFILE '/u01/oradata/ORCL/redolog_1.rdo' size 50M REUSE,

>         '/u02/oradata/ORCL/redolog_2.rdo' size 50M REUSE,

>         '/u03/oradata/ORCL/redolog_3.rdo' size 50M REUSE

>                 MAXLOGMEMBERS 3

>                 MAXLOGHISTORY 1

> DATAFILE '/u01/oradata/ORCL/system01.dbf' SIZE 300M REUSE

>                 AUTOEXTEND ON

>                 MAXDATAFILES 254

>                 MAXINSTANCES 1

>                 CHARACTER SET WE8ISO8859P1

>                 NATIONAL CHARACTER SET WE8ISO8859P1;

>

> Thanks