Is correct TNSNAMES.ora file is in your PATH?
Have you tried connecting via SQL*Net on the db server itself? Does that
work? If yes, then the problem is related to PC setup. Can you TNSPING the
server from the PC?
> -----Original Message-----
> From: Sajid Iqbal [SMTP:sajid_at_u-net.net]
> Sent: Tuesday, May 30, 2000 8:03 AM
> To: Deshpande, Kirti
> Cc: ORACLE-L_at_fatcity.com; oracledba_at_lazydba.com
> Subject: 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
Received on Tue May 30 2000 - 08:10:53 CDT
