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/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/29532781/viewspace-1420860/