Oracle 12c RAC On linux Using VMwate Workstation（安裝筆記-圖解）三

十二、安裝oracle軟體

[oracle@12crac1 database]$ pwd

/oracle/app/oracle/database

[oracle@12crac1 database]$ ls

install response rpm runInstaller sshsetup stage welcome.html

[oracle@12crac1 database]$ ./runInstaller

Starting Oracle Universal Installer...

Checking Temp space: must be greater than 500 MB. Actual 15357 MB Passed

Checking swap space: must be greater than 150 MB. Actual 3089 MB Passed

Checking monitor: must be configured to display at least 256 colors. Actual 16777216 Passed

Preparing to launch Oracle Universal Installer from /tmp/OraInstall2015-01-21_07-52-01PM. Please wait ...

時間同步已配置，其餘可忽略

執行指令碼：

[root@12crac1 ~]# /oracle/app/oracle/product/12.1.0/root.sh

Performing root user operation.

The following environment variables are set as:

ORACLE_OWNER= oracle

ORACLE_HOME= /oracle/app/oracle/product/12.1.0

Enter the full pathname of the local bin directory: [/usr/local/bin]:

The contents of "dbhome" have not changed. No need to overwrite.

The contents of "oraenv" have not changed. No need to overwrite.

The contents of "coraenv" have not changed. No need to overwrite.

Entries will be added to the /etc/oratab file as needed by

Database Configuration Assistant when a database is created

Finished running generic part of root script.

Now product-specific root actions will be performed.

[root@12crac1 ~]#

[root@12crac2 ~]# /oracle/app/oracle/product/12.1.0/root.sh

Performing root user operation.

The following environment variables are set as:

ORACLE_OWNER= oracle

ORACLE_HOME= /oracle/app/oracle/product/12.1.0

Enter the full pathname of the local bin directory: [/usr/local/bin]:

The contents of "dbhome" have not changed. No need to overwrite.

The contents of "oraenv" have not changed. No need to overwrite.

The contents of "coraenv" have not changed. No need to overwrite.

Entries will be added to the /etc/oratab file as needed by

Database Configuration Assistant when a database is created

Finished running generic part of root script.

Now product-specific root actions will be performed.

[root@12crac2 ~]#

十三、建立資料庫

[oracle@12crac1 ~]$ dbca

十四、檢查配置

[grid@12crac1 ~]$ crsctl status res -t

--------------------------------------------------------------------------------

Name Target State Server State details

--------------------------------------------------------------------------------

Local Resources

--------------------------------------------------------------------------------

ora.DATA.dg

ONLINE ONLINE 12crac1 STABLE

ONLINE ONLINE 12crac2 STABLE

ora.LISTENER.lsnr

ONLINE ONLINE 12crac1 STABLE

ONLINE ONLINE 12crac2 STABLE

ora.asm

ONLINE ONLINE 12crac1 Started,STABLE

ONLINE ONLINE 12crac2 Started,STABLE

ora.net1.network

ONLINE ONLINE 12crac1 STABLE

ONLINE ONLINE 12crac2 STABLE

ora.ons

ONLINE ONLINE 12crac1 STABLE

ONLINE ONLINE 12crac2 STABLE

--------------------------------------------------------------------------------

Cluster Resources

--------------------------------------------------------------------------------

ora.12crac1.vip

1 ONLINE ONLINE 12crac1 STABLE

ora.12crac2.vip

1 ONLINE ONLINE 12crac2 STABLE

ora.LISTENER_SCAN1.lsnr

1 ONLINE ONLINE 12crac1 STABLE

ora.MGMTLSNR

1 ONLINE ONLINE 12crac1 169.254.222.168,STAB

LE

ora.cvu

1 ONLINE ONLINE 12crac1 STABLE

ora.mgmtdb

1 ONLINE ONLINE 12crac1 Open,STABLE

ora.oc4j

1 ONLINE ONLINE 12crac2 STABLE

ora.qiudb.db

1 ONLINE ONLINE 12crac1 Open,STABLE

2 ONLINE ONLINE 12crac2 Open,STABLE

ora.scan1.vip

1 ONLINE ONLINE 12crac1 STABLE

--------------------------------------------------------------------------------

--RAC資料庫的配置資訊

[grid@12crac1 ~]$ srvctl config database -d qiudb

Database unique name: qiudb

Database name: qiudb

Oracle home: /oracle/app/oracle/product/12.1.0

Oracle user: oracle

Spfile: +DATA/QIUDB/PARAMETERFILE/spfile.311.869696193

Password file: +DATA/QIUDB/PASSWORD/pwdqiudb.291.869693131

Domain:

Start options: open

Stop options: immediate

Database role: PRIMARY

Management policy: AUTOMATIC

Server pools:

Disk Groups: DATA

Mount point paths:

Services:

Type: RAC

Start concurrency:

Stop concurrency:

OSDBA group: dba

OSOPER group: oper

Database instances: qiudb1,qiudb2

Configured nodes: 12crac1,12crac2

Database is administrator managed

[grid@12crac1 ~]$

[grid@12crac1 ~]$ srvctl status database -d qiudb

Instance qiudb1 is running on node 12crac1

Instance qiudb2 is running on node 12crac2

[grid@12crac1 ~]$ srvctl status listener

Listener LISTENER is enabled

Listener LISTENER is running on node(s): 12crac1,12crac2

SQL> select instance_name, status from gv$instance;

INSTANCE_NAME STATUS

---------------- ------------

qiudb1 OPEN

qiudb2 OPEN

SQL> set lines 1000

SQL> set pages 999

SQL> select CON_ID, NAME, OPEN_MODE, OPEN_TIME, CREATE_SCN, TOTAL_SIZE from v$pdbs;

CON_ID NAME OPEN_MODE OPEN_TIME CREATE_SCN TOTAL_SIZE

---------- ------------------------------ ---------- ---------------------------------------------------------------------------

2 PDB$SEED READONLY 22-JAN-15 10.27.37.855 PM -08:00 1594450 870318080

3 PDB READWRITE 22-JAN-15 10.48.26.309 PM -08:00 1761742 891289600

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/29532781/viewspace-1420860/，如需轉載，請註明出處，否則將追究法律責任。

Oracle 12c RAC On linux Using VMwate Workstation（安裝筆記-圖解）三

十二、安裝oracle軟體

十三、建立資料庫

十四、檢查配置

相關文章