Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

ORACLE 9.0.2 DBLINK between two linux  servers.

Posted on 2006-10-19
4
Medium Priority
?
698 Views
Last Modified: 2013-12-11
Once I am connected to an Oracle 9 DB I  need - probably thru DBLINK - to access to some tables on another ORACLE DB located into another Oracle server.

I have done some changes in the tnsnames.ora of each server but I am probably missing something?

Can anybody help me?
0
Comment
Question by:egomeze
  • 2
  • 2
4 Comments
 
LVL 8

Expert Comment

by:Pierrick LOUBIER
ID: 17766326
No changes are required on the target (DB to connect to). Here are the steps on the source :
1/ Add the target service name to TNSNAMES.ORA
2/ Check connectivity with TNSPING
3/ Create a DB link (syntax at http://www.ss64.com/ora/link_c.html)
4/ Target tables are : <owner>.<table_name>@<db_link>
0
 

Author Comment

by:egomeze
ID: 17766847
Thanks, I have checked it and it works fine.
By the way, jst before closing the issue. Shouldn't be better to add a new listener for the target server to get a better performace and security?
0
 

Author Comment

by:egomeze
ID: 17766868
By the way, jst before closing the issue. Shouldn't be better to add a new listener for the target server to get a better performace and security?
0
 
LVL 8

Accepted Solution

by:
Pierrick LOUBIER earned 1040 total points
ID: 17769882
Nope.
You'll have to secure and monitor 2 listeners, and the second listener will waste a little bit of RAM.
The only benefit I can imagine is related to firewalls (ie if you must use specific ports between the 2 hosts)...
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This post first appeared at Oracleinaction  (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Suggested Courses
Course of the Month13 days, 16 hours left to enroll

580 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question