| |
 |
|
Oracle Tips by Burleson |
Database Identification,
Options and Configurations screen
On the Database Identification screen you
fill in one value, the SID domain name for your database. If you are
unsure of the domain to use, type "sid.world" or simply the SID
name. In my system, the domain is my server name, so I used the
sid.tuscgalinux or specifically galinux2.tuscgalinux where the
database name (SID) is "galinux1". The screen automatically strips
off the domain name (anything after the first period) to create the
SID name, and places the SID in the appropriate box for you. Once
you have defined the SID and domain and selected the Next button,
the Database Options screen (Figure 2.5) is displayed.
Database Options
The Database Options screen lists all
available database options. By default, you will see that the Oracle
Spatial, Oracle Ultra Search, and Example Schemas have been
selected. I suggest unselecting the Example Schemas unless this is
to be a learning database, as they are not needed for a production
environment. This screen also allows you to add either
custom-designed scripts or choose, via browse capabilities, scripts
such as catblock.sql, catparr.sql, or other Oracle-provided scripts
not run by catproc.sql. Once you have selected the options to be
loaded and have specified any custom scripts that you want run,
select the Additional database configurations button; the screen
that allows you to select, or deselect, the Oracle JVM and
Intermedia options is displayed. This additional option screen is
shown in Figure 2.6.
Additional Configurations screen.
Oracle suggests (and I agree) that you add
the JVM and Intermedia to your selection of options; they both
provide additional power and functionality that are easy to add now,
but may be more difficult in a fully functional production
environment. Once you have chosen (or not chosen, as the case may
be) the JVM and Intermedia options, select the OK button and then
the Next button on the Options screen to display the Database
Connection Options screen (Figure 2.7).
Database Connection Options screen.
In the
Connection Options screen, you choose between using dedicated
connections and configuring a multithreaded server (MTS). Generally,
if your system isn't serving about 100 connections per CPU to the
database, you won't need MTS, however if you will be using large,
complex SQL commands you may need to turn on a minimal MTS
configuration to ensure that the large pool is utilized. I have seen
cases where not using the large pool will generate ORA-04031 and
ORA-1037 errors with large, complex SQL. MTS is used when you either
have many connections or when you have a very small amount of memory
and many connections. If you have sufficient memory resources to
serve the connected users, you will want to use dedicated
connections. Make your selection, and then either select Next, if
you choose dedicated connections, or configure the MTS (called
shared connection) parameters; then select OK and Next. The next
screen displayed will be the Initialization Parameters screen.
See Code Depot
www.oracle-script.com |
