Re: Duplicate databases

"mike Desouza" <mike_at_archoak.fsworld.co.uk> wrote in message news:afc16c$52$1_at_news7.svr.pol.co.uk...
> Hi
>
> Need some help on the following
> I have got two databases called training on two different servers, But I
am
> having problems connecting to one of the databases from one of the
servers.
>
> Here is my samples of the tnsnames.ora file
>
> CLONE =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = DC_D1)(PORT = 1521))
> )
> (CONNECT_DATA =
> (SERVICE_NAME = training)
> )
> )
> TRAINING =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = DC_T0)(PORT = 1521))
> )
> (CONNECT_DATA =
> (SERVER = DEDICATED)
> (SERVICE_NAME = training)
> )
> )
>
> But when i connect to the training database on the DC_D1 box from the
dc_t0
> box i get the following error
>
> connect sys/training_at_clone as sysdba
> ERROR:
> ORA-12514: TNS:listener could not resolve SERVICE_NAME given in connect
> descriptor
>
> Any ideas

Does the clone database really have a service name of training - i.e. you have two service names the same.

If it does you need to make sure that the listener on the clone box is correctly configured for the clone database.

--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer

******************************************