Database Software

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!

The Database Link is not active

716679Apr 26 2011 — edited Apr 26 2011

try to be more clear, i'm in lack of ideas in this problem.
I am following guide Oracle Database 2 Day + Data Replication and Integration Guide.
I defined global_names parameter of remote database as true.In the step of "creation database link" i am getting error.(oracle enterprise manager 11g-->schema-->database links-->create)
When i query on remote database(select * from global_name), I got orcl.
So,In "Name" and "Net service name" field i specified orcl.Check radio button "Fixed user." and Username and password of remote database, and i got message "Database Link STRMADMIN.ORCL has been created successfully."

But when i clicked on database link Name i got error, saying that
"The Database Link is not active.ORA-02084: database name is missing a component "

(Both dbs are oracle 11g.)
Please reply.

Locked Post

New comments cannot be posted to this locked post.

Locked on May 24 2011

Added on Apr 26 2011

#database-key-features, #replication

2 comments

434 views