How mounting two or more instance + OFA HowTo + others problems
Date: 5 Sep 2001 06:42:15 -0700
Message-ID: <2e16cdb7.0109050542.5b4f6854_at_posting.google.com>
Hello,
[Quoted] 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 Received on Wed Sep 05 2001 - 15:42:15 CEST