Oracle参数：instance_type
Oracle的参数“instance_type”可以表明Oracle实例的类型，它有三个可能值：
INSTANCE_TYPE = { RDBMS | ASM | ASMPROXY }
官方对于该参数的说明：
http://docs.oracle.com/database/121/REFRN/GUID-CE80FEFA-70D4-44C5-906D-D7ECA8CD10D7.htm#REFRN10244
例：
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 |
[root@smmis1 ~]# su - oracle [oracle@smmis1 ~]$ [oracle@smmis1 ~]$ ps -ef | grep pmon oracle 475 368 0 11:16 pts/1 00:00:00 grep pmon oracle 8676 1 0 Sep16 ? 00:00:01 asm_pmon_+ASM1 oracle 8862 1 0 Sep16 ? 00:00:42 ora_pmon_smmisdb1 [oracle@smmis1 ~]$ [oracle@smmis1 ~]$ env | grep SID ORACLE_SID=smmisdb1 [oracle@smmis1 ~]$ [oracle@smmis1 ~]$ sqlplus / as sysdba SQL*Plus: Release 10.2.0.5.0 - Production on Wed Oct 28 11:16:37 2015 Copyright (c) 1982, 2010, Oracle. All Rights Reserved. Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production With the Partitioning, Real Application Clusters, OLAP, Data Mining and Real Application Testing options SQL> show parameter instance_type; NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ instance_type string RDBMS SQL> exit Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production With the Partitioning, Real Application Clusters, OLAP, Data Mining and Real Application Testing options [oracle@smmis1 ~]$ [oracle@smmis1 ~]$ export ORACLE_SID=+ASM1 [oracle@smmis1 ~]$ sqlplus / as sysdba SQL*Plus: Release 10.2.0.5.0 - Production on Wed Oct 28 11:16:59 2015 Copyright (c) 1982, 2010, Oracle. All Rights Reserved. Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production With the Partitioning, Real Application Clusters, OLAP, Data Mining and Real Application Testing options SQL> show parameter instance_type; NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ instance_type string asm SQL> exit Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production With the Partitioning, Real Application Clusters, OLAP, Data Mining and Real Application Testing options [oracle@smmis1 ~]$ |
————————————————————
Done。
