Skip to Main Content

E-Business Suite

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Where Do You Define Database Links For FSG's? (Doc ID 1057188.6)

Beauty_and_dBestMay 13 2020 — edited Feb 9 2021

EBS 12.2

12c

OL7

Hi ALL,

Can you help create a database link in EBS please?

I tried to follow docs above but it so confusing.

At database level, I create a dblink as below:

create database link FSG2TARGET connect to apps identified by "apps" using 'FSG_TARGET';

How do I translate it to the entries in the forms below?

pastedImage_3.png

Please help what entry do I put above, or can you share document that clearly show how to setup entries above?

Kind Regards,

Jc

This post has been answered by Nabot Dash on May 13 2020
Jump to Answer

Comments

Nabot Dash
Answer

Domain name is an important parameter you need to have that handy before proceeding here:

1. Verify the domain name:

show parameters db_domain;

OR

SELECT value FROM v$parameter WHERE UPPER(name) = 'DB_DOMAIN';

2. Change if applicable (Take DBA help)

If the domain name has any characters other than A-Z (letters), 0-9 (numerals), _ (underscore), # (hash), $ (dollar),. (period), or @ (at the rate), for example, a '-' (hyphen), then change the domain name.

alter system set db_domain='<domain_name_with_illegal_char_replaced_with_legal_char>' scope=spfile sid='*';

3. Have the connection string in following format.

    SERVER=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=MyHost)(PORT=MyPort))(CONNECT_DATA=(SERVICE_NAME=MyOracleSID)))

4. Provide the target database name:

    SELECT value FROM v$parameter WHERE UPPER(name) = 'DB_NAME';

Then you can have all these to check your connection.

Please mark Helpful or Correct if this information helped you in any way.

Cheers !

Marked as Answer by Beauty_and_dBest · Sep 27 2020
Beauty_and_dBest

Thaks Noname

I will check that...brb

yoonas

Please see if it helps, i did it longer back when i had to work on FSG transfer

https://yoonusp.blogspot.com/2015/01/transferring-fsg-from-one-instance-to.html

Regards,

Yoonas

1 - 3

Post Details

Added on May 13 2020
3 comments
75 views