April 1999
Intermediate to advanced
552 pages
15h 39m
English
Content preview from Oracle Distributed SystemsBecome an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
Database Links
Distributed Oracle databases are built on database links. In a nutshell, a database link is a connection from one database to another that is available to users having proper privileges any time both databases are available. The purpose of database links is to make remote data available for queries and, in some cases, updates. Because a database link is essentially a stored login to a remote database, the DBA must take care to ensure that it does not compromise the security of either the local or the remote database. This section discusses database link naming conventions, the different types of database links, different methods of creating them, restrictions, security concerns, and how to report on them.
Global Names and Database Links
If the GLOBAL_NAMES INIT.ORA parameter is set to its default value of FALSE, you can use any name you want for a database link. I worked at one site where one developer was partial to the name “Fred” for the links he created. Informality may be acceptable in a small organization, but not where more than three or four databases are in use.
The most intuitive approach is to use the naming convention DB_NAME .DB_DOMAIN for all database links, for example, D7CA.BIGWHEEL.COM. Setting GLOBAL_NAMES to TRUE enforces this convention of database links having the same name as the database to which they connect. If you are using advanced replication, you must set this parameter to TRUE.
Note that you can change the global name of any database instance ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.