December 2000
Intermediate to advanced
408 pages
12h 26m
English
Content preview from Oracle Net8 Configuration and Troubleshooting
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,
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 Initialization File Changes
MTS
is configured in your
instance parameter file
(INIT.ORA), and not in
listener.ora or any other of the Net8
configuration files. At first this may seem rather odd, but it makes
some sense. The
dispatcher and
shared server processes are tied to the
instance—they are actually considered part of the instance, so
it makes sense to configure them in the same place that you configure
the rest of the instance.
Tip
The specific initialization parameters used to configure MTS have changed significantly over the past several releases of Oracle. This chapter focuses on MTS configuration for Oracle8i.
The following initialization parameters are the ones you need to set, or modify, when configuring an instance for MTS:
| MTS_DISPATCHERS |
| MTS_SERVERS |
| MTS_MAX_SERVERS |
| MTS_MAX_DISPATCHERS |
| LOCAL_LISTENER |
| LARGE_POOL |
Implementing MTS can be as simple as adding one or more MTS_DISPATCHERS parameters to your instance parameter file, and then stopping and restarting your instance. It’s likely, however, that you’re going to want to adjust some of these other parameters as well, as described in the following sections.
MTS_DISPATCHERS
MTS_DISPATCHERS is the key
initialization parameter that you need to set in order to implement
MTS. The syntax is similar to what is used in Net8 configuration
files such as the listener.ora file—you
end up with a list of name/value pairs that are enclosed within
parentheses.
MTS_DISPATCHERS for standard connections
In a very simple case, you can enable ...
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.