RE: creating DB Link

RE: creating DB Link

 

  


Hi,

The version being used is:Oracle9i Enterprise Edition Release 9.2.0.4.0
- 64bit Production

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: Rod Reynolds [mailto:rod.[Email address protected]
Sent: Thursday, January 31, 2008 8:22 PM
To: Manash Baruah
Subject: Re: creating DB Link

**A LazyDBA.com subscriber has responded to your lazydba.com post**
**LazyDBA.com mail shield has forwarded you this email, **and removed
any attachments, and kept your email address secret **from this person,
and any viruses/trojans.
**If you reply to this email, the person will see your email address as
normal **Anything below this line is the original email text


What version of Oracle are you using?

Manash Baruah wrote:
> 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
>
>
> -----Original Message-----
> From: Kathy Wright
> [mailto:oracledba-ezmlmshield-x83832411.[Email address protected]
> Sent: Thursday, January 31, 2008 7:53 PM
> To: LazyDBA Discussion
> Subject: creating DB Link
>
> Use the connect string in the tnsnames.ora file on the db server.
>
> i.e,,
> CREATE DATABASE LINK SYNCH_ENVIR_DBLINK CONNECT TO <USER_NAME>
> IDENTIFIED BY <PASSWORD> USING connect_string;
>
> Kathy
>
>
>>>> "William R Douglas " <oracledba-ezmlmshield-x27633313.[Email
>>>> address
>>>>
>
>
>>>> protected] 1/31/2008 6:05:51 AM >>>
>>>>
> you missed a ' ('
>
>
> try this:
>
> CREATE DATABASE LINK SYNCH_ENVIR_DBLINK CONNECT TO <USER_NAME>
> IDENTIFIED BY <PASSWORD> USING '(DESCRIPTION = (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = HOST_NAME)(PORT = 1521)))
> (CONNECT_DATA =(SID = SID_NAME)(SERVER = DEDICATED)) )';
>
>
>
>
>
>
>
>
> "Manash Baruah " <oracledba-ezmlmshield-x55064903.[Email address
> protected]
>
> 01/31/2008 06:35 AM
>
> To
> "LazyDBA Discussion" <[Email address protected] cc
>
> Subject
> Strange error while creating DB Link
>
>
>
>
>
>
>
>
> Hi All,
>
> While creating a db link with the following script:
>
> CREATE DATABASE LINK SYNCH_ENVIR_DBLINK CONNECT TO <USER_NAME>
> IDENTIFIED BY <PASSWORD> USING '(DESCRIPTION = ADDRESS_LIST = (ADDRESS

> = (PROTOCOL = TCP)(HOST = HOST_NAME)(PORT = 1521))) (CONNECT_DATA
> =(SID = SID_NAME)(SERVER = DEDICATED)) )';
>
> I get the following errors:
>
> ORA-00604: error occurred at recursive SQL level 1
> ORA-01401: inserted value too large for column
> ORA-06512: at line 6
>
> If I reduce the length of the db link name, then it is created. But I
> cannot do this as that will result in changes in a huge number of
> scripts referring this link name.
>
> If anyone has an explanation for this and the remedy please provide...
>
>
> 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
>
>
> ======================================================================
> == ====================================================
>
>
> 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.
>
> ======================================================================
> == ====================================================
>
>
> ---------------------------------------------------------------------
> 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
>
>
>
>
>
> ---------------------------------------------------------------------
> 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
>
>
>
>
>
> ---------------------------------------------------------------------
> 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.techmahind
ra.com/Disclaimer.html</a> externally and <a
href="http://tim.techmahindra.com/Disclaimer.html">http://tim.techmahind
ra.com/Disclaimer.html</a> internally within Tech Mahindra.
>
> ======================================================================
> ======================================================
>
>
> ---------------------------------------------------------------------
> 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