|Oracle® Real Application Clusters Installation Guide
12c Release 1 (12.1) for Linux and UNIX
|PDF · Mobi · ePub|
This chapter describes how to complete the postinstallation tasks after you have installed the Oracle Database 12c Release 1 (12.1) with Oracle Real Application Clusters (Oracle RAC) software. This chapter contains the following topics:
Note:This chapter describes only basic configurations. Refer to Oracle Database Administrator's Guide, and the product administration and tuning guides for more detailed configuration and tuning information. Refer also to Oracle Database Installation Guide for your platform for additional postinstallation configuration information.
Perform the following tasks after completing your installation:
On HP-UX platforms only, complete the following procedure to set external jobs ownership to the low-privilege user
Log on as
Change directory to the Oracle Database Oracle home:
# cd $ORACLE_HOME/rdbms/admin/
externaljob.ora with a text editor, and find the parameters
run_user to the external jobs user (
extjob), and set
run_group to a low-privileged group, such as
other. For example:
Save the file.
Many Oracle products and options must be configured before you use them for the first time. Before using individual Oracle Database 12c Release 1 (12.1) database products or options, refer to the manual in the product documentation library, which is available on the Oracle Technology Network (OTN) at:
Refer to these sections for information about configuring various products and features after installation:
OUI installs Oracle Database Vault by default when you install the Oracle RAC software, but you must register Oracle Database Vault with the Oracle RAC database and create database user accounts before you can use it. You must create the Database Vault Owner user and, optionally, the Database Vault Account Manager administrative user accounts.
To enable or disable the database security configuration after installation, you must use command-line Oracle Database Configuration Assistant (DBCA) options. By design, the DBCA graphical user interface (GUI) does not have the option to enable or disable secure configuration. For example, to enable the security settings after installation, you would use a command of the following form, where
myRACdb1.example.com is the either the name of the local database instance or the
dbca –configureDatabase –sourceDB myRACdb1.example.com -SID –enableSecurityConfiguration true
After installation, you must configure Oracle Label Security in a database before you use it. You can configure Oracle Label Security in two ways: with Oracle Internet Directory integration and without Oracle Internet Directory integration.
|With Oracle Internet Directory integration||To configure Oracle Label Security with Oracle Internet Directory integration, Oracle Internet Directory must be installed in your environment and the Oracle database must be registered in the directory.|
|Without Oracle Internet Directory integration||If you configure Oracle Label Security (OLS) without Oracle Internet Directory integration, then you cannot configure it to use Oracle Internet Directory at a later stage. To configure Oracle Label Security with Oracle Internet Directory on your database at a later time, you must remove the OLS option on the database and configure the OLS with Oracle Internet Directory integration option.|
See Also:Oracle Label Security Administrator's Guide for information about configuring Oracle Label Security
Oracle XML DB is a required component of the Oracle Database installation. However, you must manually configure the FTP and HTTP ports for Oracle XML DB.
See Also:Oracle XML DB Developer's Guide for information on configuring the FTP and HTTP protocols for Oracle XML DB
If your Oracle RAC database uses files that are external to the database, then the external files should be located on shared storage that is accessible to all nodes. Each node should use the same mount point to access the file. Acceptable shared file systems include Database File System (DBFS), Oracle ASM Cluster File System (Oracle ACFS), or a supported network file system (NFS) using the Direct NFS Client.
The database directory object used to write and read files external to the database must point to a shared storage location, and each node must use the same mount point for the same shared storage location.
Note:There is no checking of the contents of the external files or directory object specified as part of the external table to ensure that the directory contents are consistent on each node. To avoid unpredictable results, you must ensure that the same file is accessed from all nodes, or that the same file is used on all nodes.
See Also:Oracle Grid Infrastructure Installation Guide for more information about configuring storage
Oracle recommends that you complete the following tasks after installing Oracle RAC:
On each node, in the installation owner user profile file (in this example,
oracle), set the environment variables
ORACLE_SID; also add
ORACLE_HOME/bin to the path environment variable.
export ORACLE_BASE=/u01/app/oracle export ORACLE_HOME=/u01/app/oracle/12.1.0/dbhome_1 export PATH=$PATH:$ORACLE_HOME/bin export ORACLE_SID=sales1
If the environment variables
ORACLE_SID are not set, and you try to use SQL*Plus or other tools, then you receive an error message requesting that you set these variables.
Oracle recommends that you run the
utlrp.sql script after creating or upgrading a database. This script recompiles all PL/SQL modules that might be in an invalid state, including packages, procedures, and types. This is an optional step but Oracle recommends that you do it immediately following installation, not at a later date.
Complete setting up the Oracle software owner user account environment (for example,
oracle), as described in "Set the Oracle User Environment Variables" in the preceding section.
Start SQL*Plus, as follows:
$ sqlplus "/ AS SYSDBA"
utlrp.sql script, where
Oracle_home is the Oracle home path:
You can set up additional user accounts to manage your database. For information about setting up additional optional user accounts, see Oracle Database Security Guide.
Oracle recommends that you run the RACcheck audit tool to check your Oracle RAC installation. RACcheck is an Oracle RAC auditing tool that checks various important configuration settings within Oracle Real Application Clusters, Oracle Clusterware, Oracle Automatic Storage Management and the Oracle Grid Infrastructure environment.
For information about downloading, configuring, and running RACcheck configuration audit tool, refer to My Oracle Support note 1268927.1, which is available at the following URL:
If you have installed Oracle Configuration Manager, then you must run a script to create a database account to collect database configuration collections. You must create this account in both Connected and Disconnected modes. The database account stores the PL/SQL procedures that collect the configuration information, and the account owns the database management system (DBMS) job that performs the collection. After the account has been set up, the account is locked because login privileges are no longer required.
To configure the database for configuration collection, run the following script:
$ORACLE_HOME/ccr/admin/scripts/installCCRSQL.sh collectconfig -s SID -r\ SYSDBA-USER -p SYSDBA-PASSWORD
installCCRSQL.sh creates an Oracle Configuration Manager user and loads the PL/SQL procedure into the database defined by the
ORACLE_SID. You can also specify the database SID by using the
-s option in the command line, as in the following example, where the SID is
$ORACLE_HOME/ccr/admin/scripts/installCCRSQL.sh collectconfig -s orcl
For Oracle RAC, you must run the database script against only one instance, such as the local instance on which you performed the installation. However, Oracle Configuration Manager must be installed in all instance homes.
See Also:Oracle Configuration Manager Installation and Administration Guide for more information about Oracle Configuration Manager installation
When you install Oracle Database, some options are enabled and others are disabled. To enable or disable a particular database feature for an Oracle home, shut down the database and use the
chopt tool is a command-line utility that is located in the directory
ORACLE_HOME/bin. It uses the following syntax, where db_option is the option whose status you want to modify:
chopt [enable | disable] db_option
Table 4-1 shows the possible options for
Oracle Data Mining Database Files
Oracle Real Application Testing