(Les02 Installation) [1, 20180118], les0220180118

(Les02 Installation) [1, 20180118], les0220180118
Learning target database administrator (DBA) task and tool Oracle software installation Oracle Grid Infrastructure installation Oracle DB Installation

 

Design, Implementation, and maintenance of Oracle Database tasks for Oracle DB administrators: 1. evaluate the database server hardware 2. develop Oracle software installation plan 3. develop database and Security Policy Plans 4. create, port, and open a database. back up the database 6. register system users and plan other users to access the Oracle Network. database Design 8. database fault recovery 9. before monitoring database performance installation, consider the following sub-projects to understand the technical architecture required for installation confirmation (and update) Space Requirements select database software (required versions and options) make sure that the required system requirements are met. Oracle Universal Installer (OUI) is the tool used to manage Oracle databases. Oracle software and options are installed. The Database Configuration Assistant Database Assistant can be automatically started to create databases. Database Configuration Assistant (DBCA): creates a Database using the template provided by Oracle, and can copy the pre-configured seed Database (you can also create a Database template and Database yourself ). Database Upgrade Assistant (DBUA): Database Upgrade Assistant. Guide the Administrator to upgrade the existing database to the new version of Oracle. Oracle Net Manager (netmgr): configure the Network connection between Oracle databases and applications Oracle Net Configuration Assistant (NetCA): A graphical wizard tool for configuring and managing Oracle networks. Oracle Enterprise Manager (OEM): A Comprehensive Oracle System Management Platform that combines graphic consoles, proxies, public services, and tools. You can also manage Database components, such as Oracle Recovery Manager and Oracle Scheduler Enterprise Manager Database Console: used to manage a single Database Enterprise Manager Grid Control: Used to simultaneously manage multiple Database Server Control (srvctl ): the command line interface can be used to start and stop databases and instances, manage ASM instances, manage configuration information, and move and delete instances and services. SQL * Plus: Manages database Oracle Recovery Manager (RMAN) on the command line interface: backs up, restores, and recovers the entire database or specific database files. Data Pump (imp/exp impdp/expdp): used for high-speed data transmission between databases (such as exporting tables and then importing them to another database ). SQL * Loader: used to load data from external files to the Oracle database. Emctl start | status | stop dbconsole lsnrctl start | status | which Oracle software must be installed when the stop command is used to prepare the Oracle software installation plan? The Oracle Grid Infrastructure cluster software must be installed for the ASM storage. Does the hardware involved meet the requirements of the installation specifications? Ensure that the hardware meets the requirements of Oracle software specifications. How do I install multiple products? We recommend that you first install Oracle Grid Infrastructure and then Oracle DB software. If you install Oracle DB before installing Oracle Grid Infrastructure, you must manually register the database. If you want to use the ASM storage, You need to perform the porting step. Must non-DBA operators check the prerequisites? The storage administrator may need to configure disk partitions. Oracle Grid Infrastructure and Oracle DB installation system environment requirements memory requirements: Database instances using Oracle Enterprise Manager Database Control require 1 GB of ASM instances and Oracle Restart requires 1.5 GB of disk space requirements: 3 GB swap space (2 GB memory) Retain 1 GB disk space in/tmp directory Oracle DB software installation requires 3.8 GB Oracle Grid Infrastructure software requires 4.5 GB pre-configured database requires 1.7 GB (optional) the quick recovery zone requires 3.4 GB (optional) operating system initialization (Linux) User Group oinstall dba optional group (if you want to divide responsibilities among multiple users); asmdba asmoper asmadmin user software owner, generally, oracle can be used to install multiple products and create multiple users to set the environment variable ORACLE_BA. SE: The base Directory of the Oracle directory structure. For example,/u01/app/oracle ORACLE_HOME: Oracle product running environment. For example,/u01/app/oracle/product/11.2.0/dbhome_1 ORACLE_SID: Set the oracle Instance name to simplify interaction with specific instances in the future. NLS_LANG: an optional environment variable for controlling language, region, and client Character Set settings. For example, the NLS_LANG = AMERICAN_AMERICA.AL32UTF8 system checks that the system requires sufficient temporary space and swap space for 64-bit and 32-bit errors, dependency package system and Kernel Parameter X Server permission ORACLE_HOME environment variable status Oracle Universal Installer (OUI) tool Oracle Universal Installer is a java application that provides the following functions: automatic parsing of dependencies and complex logic processing from WEB installation components and kit installation by implicit uninstallation support for multiple Oracle Home Directories NLS or globalization support for Distributed installation by using the Silent Installation of configuration files