ORACLE Installation and oracle Installation

ORACLE Installation and oracle Installation

Statement:Original Works are from the blog of "Deep Blue blog". You are welcome to repost them. Please indicate the source when you repost them. Otherwise, the copyright will be held legally responsible.

Deep Blue blog:Http://blog.csdn.net/huangyanlong/article/details/43935049

 

The introduction of boring knowledge points is just like a breeze. We may wish to find some details from them and learn about the Oracle System with questions, so we may be more impressed. In the next few days, in order to pass the ocp examination, I will start a series of learning and exercises such as oracle system, backup, tuning, and so on. The following is a summary of myself, it also serves as a simple share on the network.

I am very grateful for the basic knowledge that can help beginners.

[Shame] 1. How to Implement manual database creation?

Refer to my article:

ORACLE10G Database reference: http://blog.csdn.net/huangyanlong/article/details/43926321

ORACLE11G database reference: http://blog.csdn.net/huangyanlong/article/details/43926437

 

2. How do I install databases in a graphical manner?

The idea is:

1. Host Name, domain name resolution, and network configuration;

2. Install the required package;

3. Create users, groups, and directories;

4. Configure Kernel Parameters and modify environment variables;

5. Set shell restrictions;

6. Unzip the installation package;

7. graphical installation of oracle software, dbca database creation, and netca configuration listening;

8. Configure boot.

 

For details, refer to my related articles:

Install Oracle10g on CentOS 5

Http://blog.csdn.net/huangyanlong/article/details/40180579

Install Oracle11g on CentOS 5

Http://blog.csdn.net/huangyanlong/article/details/40180867

Install Oracle10g on CentOS 6

Http://blog.csdn.net/huangyanlong/article/details/40181003

Install Oracle11g on CentOS 6

Http://blog.csdn.net/huangyanlong/article/details/40181661

Installation references

Http://blog.csdn.net/huangyanlong/article/category/2637015

3. What is OFA?

OFA's Optimal and Flexible Architecture is short for Optimal Flexible Architecture. This is an oracle specification. It proposes a unified file and directory rule.

 

[Small Test]

Questions from the ocp Certification Examination Syllabus:

Source: 052 and 053.

106 install

106.

You plan to configure the new Oracle Database 11g installation by using Ming these tasks:

-Use Automatic Storage Management (ASM) as the storage option.

-Use Oracle Enterprise Manager Database Control to manage the database.

-Provide the same password for SYS, SYSTEM, SYSMAN, and DBSNMP accounts during theinstallation.

-Configure the database to send email notifications.

Some tools available to you for installation are:

1: Oracle Universal Installer (OUI)

2: Database Configuration Assistant (DBCA)

3: Database Upgrade Assistant (DBUA)

4: Oracle Net Configuration Assistant

Which tools wocould you use for this installation?

A.2

B .3

C.1 and 2

D.3 and 4

E.1, 2, and 4

Answer: E

For example, DBUA is used for upgrade and has no installation instructions. For other options, oui is the uninstall program, dbca is the database creation program, and 4th items are the net manager configuration (called using the netca command)

108 install

108.

You are installing Oracle Database 11g on your server. during the installation Oracle Universal Installer (OUI) prompts you to enter the path of the inventorydirectory and also prompts you to specify an operating system group name. which statement is true in this case?

A. The ORACLE_BASE parameter is not set.

B. The installation is being already med by the root user.

C. The operating system group that will be specified shocould have root user as its member.

D. The installation is being your med without the "Create Starter Database" option selected.

E. The operating system group that will be specified must have permission to write to the inventory directory.

Answer: E

Note: The installation must ensure that the inventory belongs to the oinstall group, and the oracle user has the permission to access the group.

109 install

109.

In a new installation of Oracle Database 11g, you perform these activities:

1: Organize software and data on different subdirectories to avoid poor performance.

2: Use consistent naming conventions for database files.

3: Separate administrative information pertaining to the database in different directories.

Which option corresponds to the type of activities you ordered med?

A. Oracle Managed Files

B. Oracle Grid Architecture

C. Optimal Flexible Architecture

D. Oracle database architecture

E. Automatic Storage Management

Answer: C

In my opinion, OFA's optimal and flexible architecture is an installation rule.

110 install

110.

Which task wocould you perform before you run Oracle Universal Installer (OUI) in silent or suppressed mode for an installation?

A. Run the root. sh script.

B. Create the oraInst. loc file.

C. Create the tnsnames. ora file.

D. Run the oraintRoot. sh script.

Answer: B

In my opinion, the oraInst. loc file is usually located in the/etc directory. In other Unix systems (such as Solaris), the file is located in the/var/opt/oracle directory. It is automatically created during graphical installation.

 

The content of this file is found from the Internet, as follows:

This file contains the following information:

Path of the Oracle List Directory;

Name of the OS group that has the permission to install and upgrade the Oracle software.

The Oracle List Directory contains files for managing Oracle Installation and upgrade. Generally, each host has an Oracle List Directory. The directory structure contains the inventory. xml file, which contains records of various Oracle versions installed on the server.

The Oracle list OS group has the permission to install and upgrade the Oracle software. Oracle recommends that you name this group oinstall. Sometimes DBA sets the Configuration Group as a dba group. If your environment does not require other independent groups (such as oinstall), you can use the dba group.

You can use a utility (such as vi) to create an oraInst. loc file.

111 install

111.

You are installing Oracle Database 11g on a machine. When you run the installer, the Oracle Universal Installer (OUI) shows the message that says one of the product-specific prerequisite checks has failed:

Checking available swap space requirements...

Expected result: 1512 MB

Actual Result: 1018 MB

Check complete. The overall result of this check is: Failed <

Problem: The system does not have the required swap space.

What happens to the installation in this situation?

A. It can be continued.

B. It resizes the swap space automatically when you proceed further.

C. It can be continued, but the instance cannot be started without increasing the swap space.

D. It shows a message saying one or more prerequisite checks have failed and the installation cannot proceed.

Answer:

In my opinion: oracle has a minimum requirement of several hundred megabytes for swap partitions. installation is not affected even if the setting is not too high. Using swap as the virtual memory will affect certain efficiency, but it does not mean that oracle cannot be installed.

112 install

112.

View the Exhibit.

What wowould happen if Oracle Home is not empty?

A. The installation will not be continued until the location is empty.

B. The installation will proceed without overwriting the existing files.

C. The installation can be continued, but the existing files will be overwritten.

D. The installation terminates automatically after showing an error message.

Answer:

For example, if the Oracle Home file is empty, the installation will continue.

113 install

113.

You are working on a new Oracle Database 11g server, where only the software is installed and no database is created. you plan to create a database on this server using the Database Configuration Assistant (DBCA ).

Some of the requirements set for your database creation tasks are:

1: Configure the database to operate in shared server mode.

2: Disable automatic maintenance tasks such as optimizer statistics collection.

3: Configure a naming method to help the remote user connect to the database instance.

4: Use Automatic Storage Management (ASM) for storing the database files.

5: Configure daily database backup to flash recovery area.

6: Configure Enterprise Manager Database Control to manage the database.

Which of these requirements can be met while creating the database?

A.4 and 6

B .2, 3, 4, and 6

C.1, 2, 4, 5, and 6

D.1, 2, 3, 4, 5, and 6

Answer: C

In my opinion, "3rd sub-item" is used to configure remote connection for the customer, which is not within the scope set by dbca. Netca allows you to configure remote monitoring and network configuration properties in a graphical manner.

114 install

114.

You plan to implement the distributed database system in your company. you invoke Database Configuration Assistant (DBCA) to create a database on the server. during the installation, DBCA prompts you to specify the Global Database Name.

What must this name be made up?

A. It must be made up of a database name and a domain name.

B. It must be made up of the value in ORACLE_SID and HOSTNAME.

C. It must be made up of the value that you plan to assign for INSTANACE_NAME and HOSTNAME.

D. It must be made up of the value that you plan to assign for ORACLE_SID and SERVICE_NAMES.

Answer:

For personal remarks, configure oracle on the network and set the global database name to include "Database Name" and "network domain name ".

115 install

115.

View the Exhibit.

You are creating an additional database by using the Database Configuration Assistant (DBCA ). you opted to create a General Purpose database and during the database creation realize that the Block Size field is not enabled. what cocould be the reason for this?

A. You have chosen the File System option as the storage option.

B. You have chosen the Automatic Storage Management (ASM) as the storage option.

C. The data block size can be increased only when DBCA is invoked from Oracle Universal Installer (OUI ).

D. You are using General Purpose template and not the Custom Database template to create the database.

Answer: D

For example, you can use a general template to create a database. The block size cannot be changed if it is the specified size.

 

Question Bank: 053

37. install

37. during the installation of Oracle Database 11g, you do not set ORACLE_BASE explicitly. you selected the option to create a database as part of the installation. how wocould this environment variable setting affect the installation?

A. The installation terminates with an error.

B. The installation proceeds with the default value without warnings and errors.

C. The installation proceeds with the default value but it wocould not be an OFA-compliant database.

D. The installation proceeds with the default value but a message wocould be generated in the alert log file.

Answer: D

Note: If the root directory is not set, the installation will not be affected. The default oracle directory will be selected, but this information will appear in the alarm log, prompting you to set it.

 

Statement:Original Works are from the blog of "Deep Blue blog". You are welcome to repost them. Please indicate the source when you repost them. Otherwise, the copyright will be held legally responsible.

Deep Blue blog:Http://blog.csdn.net/huangyanlong/article/details/43935049