RE: Database Cloning

have you added the service name for the test-database to the listener.ora? Check with "lsnrctl80 status"

Stephan

-----Original Message-----
From: Sajid Iqbal [mailto:sajid_at_u-net.net] Sent: Tuesday, May 30, 2000 3:17 PM
To: Multiple recipients of list ORACLE-L 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       |  

-- 
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).