August 2005
Intermediate to advanced
154 pages
4h 48m
English
Content preview from Oracle DBA Pocket Guide
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.
28
|
Oracle DBA Pocket Guide
instance. The SID is a unique name that is used to identify a
particular instance across your entire environment. Typi-
cally, the INIT.ORA file is located in the $ORACLE_HOME/
dbs directory.
NOTE
Refer to the Oracle documentation for the default loca-
tion of this file for your particular operating system.
You must be sure to store the INIT.ORA file in a location
where it is accessible to the client that’s starting the database.
Because the INIT.ORA file is a simple text file, it can be
modified using any ASCII editor. However, be careful not to
use a word-processing program like Microsoft Word to edit
the INIT.ORA file; doing so can easily make the file unread-
able by Oracle. If you must use Word to create or modify the
file, be sure to save it as a plain ASCII text file.
Parameters are typically entered into the file with one param-
eter and value per line, as shown in the previous example.
Comments may be added after a parameter or on their own
line (preceded by the # symbol):
# The following line contains a comment
DB_FILE_MULTIBLOCK_READ_COUNT = 8 # Do not change
SPFILE: The Server Parameter File
The server parameter file, known as the SPFILE, differs from
the standard INIT.ORA file in a number of ways:
• It is a binary file, rather than a text-based file.
• It is stored on the server, rather than on a client machine.
• It can maintain changes to parameter values over
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.