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?
> -----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
Received on Tue May 30 2000 - 07:57:09 CDT
