ORACLE專題之安裝，oracle專題

ORACLE專題之安裝，oracle專題

聲明：原創作品，出自 “深藍的blog” 部落格，歡迎轉載，轉載時請務必註明出處，否則追究著作權法律責任。

深藍的blog：http://blog.csdn.net/huangyanlong/article/details/43935049

 

    枯燥的知識點介紹是漫天飛舞，我們不妨從中篩選出部分細節，帶著問題來學習Oracle體系知識，這樣也許印象會更深刻吧。接下來的一段日子裡，本人為了通過ocp考試，將會通過這種形式，開始oracle體系、備份、調優等一系列的學習梳理與練習，以下即是一個自我的總結，也作為網路上的簡單分享。

    基礎知識，如果也能協助到初學者，欣慰不已。 

【不恥下問】1、手工建庫如何實施？

參考我的文章：

ORACLE10G 建庫參考：http://blog.csdn.net/huangyanlong/article/details/43926321

ORACLE11G 建庫參考：http://blog.csdn.net/huangyanlong/article/details/43926437

 

2、如何圖形化安裝資料庫？

思路為：

1、主機名稱、網域名稱解析及網路設定；

2、安裝需要的包；

3、建立使用者、組、目錄；

4、配置核心參數、修改環境變數；

5、設定shell限制；

6、解壓安裝包；

7、圖形化安裝oracle軟體、dbca建庫、netca配置監聽；

8、配置開機啟動。

 

具體細節可以參考我的相關文章：

CentOS 5上安裝Oracle10g

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

CentOS 5上安裝Oracle11g

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

CentOS 6上安裝Oracle10g

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

CentOS 6上安裝Oracle11g

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

安裝相關參考文章

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

3、什麼是OFA？

OFA最優靈活體繫結構，是Optimal Flexible Architecture的簡稱。這是一種oracle的規範，在於提出一種統一的檔案及目錄的規則。

 

【小試牛刀】

題目來自ocp認證考試大綱：

題庫來源：052、053。

106、install

106.

You plan to configure the new Oracle Database 11g installation by performing 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 would you use for this installation?

A.2

B.3

C.1 and 2

D.3 and 4

E.1, 2, and 4

Answer: E 

個人愚見：3項中的，DBUA為升級使用，無關於安裝。其它選項，oui為卸載程式，dbca為建庫程式，第4項是net manager配置（用netca命令調用）

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 performed by the root user.

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

D.The installation is being performed 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 

個人愚見：安裝必須保證inventory歸屬於oinstall組，oracle使用者有許可權訪問。

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 performed?

A.Oracle Managed Files

B.Oracle Grid Architecture

C.Optimal Flexible Architecture

D.Oracle database architecture

E.Automatic Storage Management

Answer: C 

個人愚見：OFA最優靈活體繫結構，一種安裝規則。

110、install

110.

Which task would 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  

個人愚見：oraInst.loc檔案通常位於/etc目錄中。在其他Unix系統（如Solaris）中，該檔案位於/var/opt/oracle目錄中。圖形化安裝時會自動建立。

 

該檔案內容，從網上找了下資料，如下：

該檔案含有下列資訊：

Oracle清單目錄路徑；

擁有安裝和升級Oracle軟體操作許可權的OS組的名稱。

Oracle清單目錄中含有管理Oracle安裝和升級的檔案。通常，每台主機都有一個Oracle清單目錄。該目錄結構中含有inventory.xml檔案，該檔案含有伺服器上已安裝的各種Oracle版本的記錄。

Oracle清單OS組擁有安裝和升級Oracle軟體的許可權。Oracle公司建議將該組命名為oinstall。有時候DBA會將清單組設定為dba組。如果您的環境不需要其他獨立的組（如oinstall），那麼使用dba組就沒有問題。

可以使用公用程式（如vi）建立oraInst.loc檔案。 

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: 1512MB

Actual Result: 1018MB

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: A 

個人愚見：oracle對swap分區有最低要求是幾百兆，即使設定不是太高也不會影響安裝。swap作為虛擬記憶體使用，會影響一定效率但並不致於使oracle無法安裝。

112、install

112.

View the Exhibit.

What would 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: A 

個人愚見：當Oracle Home檔案為空白時，會繼續安裝。

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 task 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 

個人愚見：“第3小項”是為客戶配置遠端連線，這個不在dbca設定的範疇之內。netca是圖形化配置遠程監聽及網路設定屬性的。

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 of?

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: A 

個人愚見：網路設定oracle，設定全域資料庫名要包含“資料庫名”和“網路網域名稱”。

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 could 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

個人愚見：使用通用模板建立資料庫，塊尺寸為指定尺寸不能修改。

 

題庫：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 would 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 would not be an OFA-compliant database.

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

Answer: D

個人愚見：沒有設定根目錄不影響安裝進行，會選擇預設oracle目錄，但此資訊會出現在警示日誌中提示你對其進行設定。

 

聲明：原創作品，出自 “深藍的blog” 部落格，歡迎轉載，轉載時請務必註明出處，否則追究著作權法律責任。

深藍的blog：http://blog.csdn.net/huangyanlong/article/details/43935049