How to install Oracle easily?
Installing the Oracle DBMS.
1.
Installation recommendations:
RAM size of at least 1 Gb (for Windows systems).
Free HDD space of about 10 Gb.
2. To start the installation, go to the Disk1 directory and
run the setup.exe file.
3. Choose the installation mode.
4. Specify the directories where the software
will be installed:
5.
For installing the Oracle DBMS at the next step you need to select
the installation of Oracle Database 9.2.0.1.0
6. At step 6, you need to choose the DBMS installation type. If you plan to
store and process large volumes of data, you need to choose the
Enterprise Edition installation type, otherwise choose Standart Edition
7. You need to select the products that will be installed during setup.
(the default installation is General Purpose).
8. At step 8, you need to set the database identifier – this is a lower-
case parameter of up to 8 characters.
Global Database Name – the global identifier, for example :
my-city.com.ua
SID – the local identifier, for example: my-city
9. You need to specify the directory where the database files
containing the data will be located.
10. Specify the data storage encoding for the DBMS. It is recommended to leave the
default Cyrillic CL8MSWIN1251.
11. Set passwords for the 2 reserved users:
System and sys.
How to easily configure Oracle?
System configuration.
Configuring the Oracle DBMS is a fairly long and labor-intensive process.
This guide only lists the points that are necessary for the sys-
tem to work:
1.You need to launch the Enterprise Manager Console service application.
2. Select the default option.
3. Expand the Databases item and select the installed database:
12. In the connection window, you need to select the administrative privileges:
Connect as: SYSDBA
13. Then select the Instance and Configuration items in sequence and click
the All Initialization Parameters… button. In the configuration parameters section you need to set the save type to SPFile and set the following values
for the following parameters:
max_enabled_roles - 148
open_cursors - 1000
14. On the Memory tab, you need to set the value of the following parameters:
- Shared Pool
- Buffer Cache
- Large Pool
- Java Pool
- Total SGA
- SGA Max Size
8. On the Recovery tab you need to set the value of the following parameters
- Archive Log Mode
- Automatic Archival
- Log Archive Filename Format (for this parameter it is best to set the value: Redo%T.Log)
- The directory to which the archive files will be saved – Archive Log Destination(s)
After the DBMS restarts it will start up in Archivelog mode.
You will again need to select in sequence the Instance and
Configuration items and click the All Initialization Parameters… button. In the configuration
parameters section you need to set the save type to SPFile and set the following
value for this parameter:
log_archive_start = TRUE
9. In the Databases directory tree you need to select the following items Storage->Tablespaces
For the Temp and Undotbs1 tablespaces, on the Storage tab you need to disable the Automatically extend datafile when full (Autoextended) parameter, to rule out
cases where these spaces could grow uncontrollably, and then, where possible, set them to the required values.
In this same section you can create the two tablespaces needed for the system to work, DATA_SEGMENT and IND_SEGMENT.
Comments