[prev in list] [next in list] [prev in thread] [next in thread]
List: hpux-admin
Subject: [HPADM] Cloning Oracle SID software ($ORACLE_HOME) with BCVs
From: "Abramson, Stuart" <SAbramson () Wabtec ! com>
Date: 2003-11-21 21:02:00
[Download RAW message or body]
Hpux-admins:
> We used to "clone" our Production Oracle Instance to a BCV Reporting
> Instance by only "BCV-ing" the data files.
>
> We set up the oracle software on the BCV server for a SID called REPORT,
> and we left it there. Over time, REPORT didn't get patched, etc, and
> wasn't an exact copy of PROD.
>
> We now want to BCV the Oracle software, in $ORACLE_HOME as well as the
> data.
>
> So, I'm looking at changing SID names, port numbers, hostnames, file
> system names in the Oracle software directories from PROD to REPORT, every
> time I split the Oracle software:
>
> $ORACLE_HOME/dbs/initSID.ora
>
> $ORACLE_HOME/network/admin/listener.ora
> $ORACLE_HOME/network/admin/tnsnames.ora
>
> Is there an Oracle utility that does this for you?:
>
> OracleClone OLDSID NEWSID
>
> Does anyone have a list of the places that you have to change?
>
> Hasn't someone done this before?
>
> Stuart
>
>
> Stuart Abramson | Off: 412/825-1434 | Cell: 412/417-1567 | email:
> sabramson@wabtec.com
>
>
***** CONFIDENTIALITY NOTE *****
The content contained in this e-mail transmission is legally privileged and \
confidential information intended only for the use of the individual or entity named \
herein. If the reader of this transmission is not the intended recipient, you are \
hereby notified that any dissemination, distribution, or copying of this transmission \
is strictly prohibited.
[Attachment #3 (text/html)]
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2654.45">
<TITLE>Cloning Oracle SID software ($ORACLE_HOME) with BCVs</TITLE>
</HEAD>
<BODY>
<P><FONT COLOR="#0000FF" SIZE=2 FACE="Courier">Hpux-admins:</FONT>
</P>
<BR>
<P><FONT SIZE=2 FACE="Courier">We used to "clone" our Production Oracle \
Instance to a BCV Reporting Instance by only "BCV-ing" the data \
files.</FONT> </P>
<P><FONT SIZE=2 FACE="Courier">We set up the oracle software on the BCV server for a \
SID called REPORT, and we left it there. Over time, REPORT didn't get patched, \
etc, and wasn't a</FONT><FONT COLOR="#0000FF" SIZE=2 FACE="Courier">n \
exact</FONT><FONT SIZE=2 FACE="Courier"> copy of PROD.</FONT></P>
<P><FONT SIZE=2 FACE="Courier">We now want to BCV the Oracle software</FONT><FONT \
COLOR="#0000FF" SIZE=2 FACE="Courier">, in $ORACLE_HOME</FONT><FONT SIZE=2 \
FACE="Courier"> as well as the data.</FONT> </P>
<P><FONT SIZE=2 FACE="Courier">So, I'm looking at changing SID names, port numbers, \
hostnames, file system names in the Oracle software directories from PROD to REPORT, \
every time I split the Oracle software:</FONT></P> <UL>
<P> <FONT SIZE=2 FACE="Courier"> \
$ORACLE_HOME/dbs/initSID.ora</FONT> </P>
<P> <FONT SIZE=2 FACE="Courier"> \
$ORACLE_HOME/network/admin/listener.ora</FONT> \
<BR> <FONT SIZE=2 FACE="Courier"> \
$ORACLE_HOME/network/admin/tnsnames.ora</FONT> </P>
</UL>
<P><FONT SIZE=2 FACE="Courier">Is there an Oracle utility that does this for \
you?:</FONT> </P>
<P> <FONT SIZE=2 FACE="Courier"> \
OracleClone OLDSID NEWSID</FONT> </P>
<P><FONT SIZE=2 FACE="Courier">Does anyone have a list of the places that you have to \
change?</FONT> </P>
<P><FONT SIZE=2 FACE="Courier">Hasn't someone done this before?</FONT>
</P>
<P> <FONT SIZE=2 \
FACE="Courier">Stuart</FONT> <UL>
<P><FONT SIZE=2 FACE="Courier"> </FONT>
</P>
</UL>
<P><B><FONT COLOR="#0000FF" SIZE=2 FACE="Arial">Stuart Abramson | Off: \
412/825-1434 | Cell: 412/417-1567 | email: \
sabramson@wabtec.com</FONT></B> </P>
<BR>
<BR>
***** CONFIDENTIALITY NOTE *****<BR>
The content contained in this e-mail transmission is legally privileged and \
confidential information intended only for the use of the individual or entity named \
herein. If the reader of this transmission is not the intended recipient, you are \
hereby notified that any dissemination, distribution, or copying of this transmission \
is strictly prohibited.<BR> </BODY>
</HTML>
--
---> Please post QUESTIONS and SUMMARIES only!! <---
To subscribe/unsubscribe to this list, contact majordomo@dutchworks.nl
Name: hpux-admin@dutchworks.nl Owner: owner-hpux-admin@dutchworks.nl
Archives: ftp.dutchworks.nl/pub/digests/hpux-admin (FTP, browse only)
http://www.dutchworks.nl/htbin/hpsysadmin (Web, browse & search)
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic