Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: domains
Man, the init.ora is not the problem, you just do a "startup
pfile=initPROD1.ora"
for one and "startup pfile=initPROD2.ora" for the other. initPROD1.ora and
initPROD2.ora are copies differing only in the parameter control_files,
which should address the corresponding (and hopefully different) control
files of prod (original) and prod (copy).
What I think will get you in trouble is an error you will almost surely get
when trying to mount the second DB: ORA-<don´t remember>: A database with
the same name already mounted. (or something like it, trusting my memory).
I got around it by taking the copy to another machine (unimportant) with
another installation of the Oracle software (very important), and because
the databases exported to sqlnet by your listener.ora file are identified
by oracle_sid (same for both) AND oracle_home (which is different in both),
they coexist beautifully...
Another means would be issue an "alter database backup controlfile to
trace", and get a script which you modify to try to change the database´s
global name: create controlfile reuse set dbname anotherprod resetlogs...
(only works specifying resetlogs), and as you are there renaming the files
in the create controlfile to reflect the copies´ location. I tried it and
the fool didn´t cope with my downsized datafiles, so I had to use the first
means. Details of the foolish server behaviour when I come back from
holidays (2 weeks), so if you would like to reply to me, use e-mail, since
I´ll lose many newsgroup´s messages (no computers on vacations) :b
Bruno.
Wachs Rene <Rene.Wachs_at_ezv.admin.ch> wrote in article <32D4DB66.7B07_at_ezv.admin.ch>...
> Theoretically it's possible to define a DB_DOMAIN like this :
> application_name.hostname.organisation
> sales.unix_1.abc
> so it's also possible to have 2 DB's with the same name on the same
> server :
>
> DB_NAME = prod
>
> With the Domain one will be prod.sales.unix_1.abc
> the second will be prod.cust.unix_1.abc
>
> I know, this is a bad concept, but possible. In this case how to name
> the init.ora-File (both can't be called initPROD.ora) and how to startup
> both databases ?
Received on Fri Jan 17 1997 - 00:00:00 CST