Hi,

Your's is a solution to the problem but not to the root cause. I want to
know why Oracle is refusing to create the DB link whereas the script is
absolutely OK as it works fine in the other testing environments.


Thanks & Regards,

Manash Partim Baruah

Collaboration Platform LCS-E-commerce| DBA Team| Tech Mahindra Ltd.|
Sharda Center, 6th Floor Annex Building, Pune-4, India
www.techmahindra.com


-----Original Message-----
From: Kedar Barde
[mailto:oracledba-ezmlmshield-x40925645.[Email address protected]
Sent: Thursday, January 31, 2008 8:26 PM
To: LazyDBA Discussion
Subject: RE: creating DB Link

CREATE DATABASE LINK SYNCH_ENVIR_DBLINK

CONNECT TO chealth1

IDENTIFIED BY siobhan

USING '(DESCRIPTION =

ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP)(HOST = moe )(PORT = 1521)))
(CONNECT_DATA=(SID = r6144113)(SERVER = DEDICATED)) )'

/

Works fine

YOU CAN create a public synonym for the link SYNCH_ENVIR_DBL

Create public synonym SYNCH_ENVIR_DBLINK for SYNCH_ENVIR_DBL;

Kedar Barde

Oracle 9i DBA

Oracle Certified Associate(OCA)



-----Original Message-----
From: Manash Baruah
[mailto:oracledba-ezmlmshield-x73886374.[Email address protected]
Sent: 31 January 2008 14:36
To: LazyDBA Discussion
Subject: RE: creating DB Link



Hi,

It does not work even if I replace the connect string with the one in
the tns entry.

Please note that it works when I make the name of the db link short by 3
letters i.e. if I use SYNCH_ENVIR_DBL instead of SYNCH_ENVIR_DBLINK, it
works fine.

Thanks & Regards,

Manash Partim Baruah

Collaboration Platform LCS-E-commerce| DBA Team| Tech Mahindra Ltd.|

Sharda Center, 6th Floor Annex Building, Pune-4, India

www.techmahindra.com


"Any of the statements or comments made above should be regarded as
personal and not necessarily those of Velindre NHS Trust, any
constituent part or connected body

Dylai'r datganiadau neu'r sylwadau uchod gael eu trin fel rhai personol
ac nid o reidrwydd fel datganiadau neu sylwadau gan Ymddiriedolaeth GIG
Felindre, unrhyw ran ohono neu unrhyw gorff sy'n gysylltiedig a'r
Ymddiriedolaeth".



---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a
dba job: http://jobs.lazydba.com To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



============================================================================================================================


Disclaimer:

This message and the information contained herein is proprietary and confidential and subject to the Tech Mahindra policy statement, you may review the policy at <a href="http://www.techmahindra.com/Disclaimer.html">http://www.techmahindra.com/Disclaimer.html</a> externally and <a href="http://tim.techmahindra.com/Disclaimer.html">http://tim.techmahindra.com/Disclaimer.html</a> internally within Tech Mahindra.

============================================================================================================================

Oracle LazyDBA home page