Re: A danger in cloning databases

unique passwords in listener.ora files prevents this.

Kimberly Smith wrote:

> Been there, done that;-)
>
> -----Original Message-----
> Sent: Wednesday, July 11, 2001 7:57 AM
> To: Multiple recipients of list ORACLE-L
>
> Many of you probably know this already, but it took me by surprise (and
> caused no end of grief) so I thought I'd warn people.
>
> I cloned our 8.0.4 production database onto another machine for some testing
> we were doing (copy of entire Oracle filesystem, copied hot backup over) and
> started it up with no problems.
>
> What I didn't realize when I ran my shutdown script (which also stops the
> listener) was that I hadn't changed the hostname in listener.ora. It
> stopped the listener on the production box!
>
> Had you asked me before this happened I wouldn't have expected it to work
> that way, but a number of irate users and managers testify to the fact that
> it does. I restarted the listener as soon as anyone thought to notify me of
> the problem (it says something about the processes here that it was 45
> minutes after I restarted the listener that that our Help Desk contacted me
> me about the problem, I first heard about it from a developer).
>
> Sigh, learn something new every day.
> Hope someone out there benefits from my mistake.
>
> Jay Miller
> --

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Paul Drake
  INET: paled_at_home.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).