RE: Database Cloning

On Tue, 30 May 2000, Miguel Urosa wrote:

> And what about your $TNSADMIN variable value to indicate path of
> TNSNAMES.ORA?.
The same thing still happens !?

>
> HTH
>
> > -----Mensaje original-----
> > De: Sajid Iqbal [SMTP:sajid_at_u-net.net]
> > Enviado el: martes 30 de mayo de 2000 16:10
> > Para: Multiple recipients of list ORACLE-L
> > Asunto: RE: Database Cloning
> >
> >
> > Yes the SID name is the same as the production so I've changed the machine
> > server name !
> >
> > --
> > U-NET Ltd a VIA NET.WORKS Inc company
> > Sajid Iqbal | Mail : sajid_at_u-net.net
> > Database DBA/Developer | Ext : 4485
> > U-NET Ltd | ICQ : 43903417
> > Warrington, Cheshire, UK |
> >
> >
> > On Tue, 30 May 2000, Deshpande, Kirti wrote:
> >
> > > Have you modified your TNSNAMES.ora on the PC to point to correct SID
> > name
> > > on a correct Server? Also, have you made modified your LISTENER.ORA file
> > on
> > > the Server to begin listening for the test SID name?
> > >
> > > - Kirti
> > >
> > > > -----Original Message-----
> > > > From: Sajid Iqbal [SMTP:sajid_at_u-net.net]
> > > > Sent: Tuesday, May 30, 2000 7:11 AM
> > > > To: ORACLE-L_at_fatcity.com; oracle_at_telelists.com;
> > oracledba_at_lazydba.com
> > > > Subject: Database Cloning
> > > >
> > > > Hi
> > > >
> > > > I have just cloned our production DB to a test machine (ie copy all
> > > > datafiles, init files, netwrok files etc) after doing recovery on the
> > DB
> > > > I can connect through server manager and see all the data..
> > > >
> > > > However I can't connect via sqlplus (from a pc) using sqlnet.. it
> > keeps
> > > > telling me that Oracle is not available.. when the database is started
> > and
> > > > the tnslistener is also started.
> > > >
> > > > TIA
> > > >
> > > > Saj Iqbal
> > > > --
> > > > U-NET Ltd a VIA NET.WORKS Inc company
> > > > Sajid Iqbal | Mail : sajid_at_u-net.net
> > > > Database DBA/Developer | Ext : 4485
> > > > U-NET Ltd | ICQ : 43903417
> > > > Warrington, Cheshire, UK |
> > > >
> > > >
> > > >
> > > > --------
> > > > If you're bored, then visit the list's website: http://www.lazydba.com
> > > > (updated daily)
> > > > to unsubscribe, send a blank email to
> > oracledba-unsubscribe_at_quickdoc.co.uk
> > > > to subscribe send a blank email to oracledba-subscribe_at_quickdoc.co.uk
> > >
> >
> > --
> > Author: Sajid Iqbal
> > INET: sajid_at_u-net.net
> >
> > 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).
> --
> Author: Miguel Urosa
> INET: murosa_at_smseuropa.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
Received on Wed May 31 2000 - 04:13:09 CDT