Re: Duplicate database

Howard,

I replied to the first of his double postings before noticing the second, with your reply. I know that all three of those files are necessary to complete the connection picture, but specific to an ORA-12514, how do the LISTENER and INIT files fit in? I though a -12514 meant "hey, user, I can't find that connect string in my TNSNAMES file.

Uh, OK, even as I typed the first paragraph, I remembered the DEFAULT_DOMAIN parm in SQLNET.ORA. But what about INIT.ORA? Is there something there that also fits into the connect mechanism? And what in LISTENER could relate to an ORA-12514? Sign me -- "Seeking enlightenment"

• Ed Stevens

On Wed, 26 Jun 2002 20:24:25 +1000, "Howard J. Rogers" <dba_at_hjrdba.com> wrote:

>Not without seeing your listener.ora, your init.ora, and your sqlnet.ora.
>
>HJR
>
>
>"mike Desouza" <mike_at_archoak.fsworld.co.uk> wrote in message
>news:afc3vu$fgc$1_at_news8.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
>>
>> Cheers
>> mike
>>
>>
>>
>>
>>
>
>

--
Ed Stevens
(Opinions expressed do not necessarily represent those of my employer.)