Re: Database Cloning

Have u tried entering the service in the sql net easy configuration???

-----Original Message-----
From: Miguel Urosa <murosa_at_smseuropa.com> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Date: Wednesday, May 31, 2000 10:32 PM
Subject: RE: Database Cloning

>
>
>> -----Mensaje original-----
>> De: Sajid Iqbal [SMTP:sajid_at_u-net.net]
>> Enviado el: miércoles 31 de mayo de 2000 12:26
>> Para: Multiple recipients of list ORACLE-L
>> Asunto: RE: Database Cloning
>>
>> Are you using the same connect string with SQLPLUS and Server
>> Manager. That's user/password_at_connect_string?.
>> 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
>> > also send the HELP command for other information (like subscribing).
>> >
>>
>> --
>> 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
Received on Sat Jun 03 2000 - 01:49:00 CDT