RE: Database Cloning

I can tnsping to the server.. I can connect locally to oracle from the server... I I check the listener log file it shows succesful connections..

However when I try and connect from a pc via sqlnet it says - ORA-01034: ORACLE NOT AVAILABLE. When Oracle is definitely available as I can connect to server manager and select from tables etc.

So it sounds like a database name/sid problem maybe ?

Can anyone tell me the steps/files sqlnet goes through when connecting to a database from a pc.

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       | =20


On Tue, 30 May 2000, [ISO-8859-1] J=E4ck Stephan wrote:



> have you added the service name for the test-database to the listener.ora=

?


> Check with "lsnrctl80 status"

>=20


> Stephan

>=20


> -----Original Message-----

> Sent: Tuesday, May 30, 2000 3:17 PM

> To: Multiple recipients of list ORACLE-L

>=20
>=20


> Hi=20

>=20


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

>=20


> 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 an=

d


> the tnslistener is also started.

>=20


> TIA

>=20


> 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       | =20

>=20
>=20


> --=20

> Author: Sajid Iqbal

>   INET: sajid_at_u-net.net

>=20


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

> --=20

> Author: =3D?ISO-8859-1?Q?J=3DE4ck_Stephan?=3D

>   INET: Jaeck.Stephan_at_REAL.DE

>=20


> 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