文章存档
相关博文
- ·
- ·
- ·
- ·
- ·
- ·
- ·
- ·
- ·
- ·
分类： oracle
2011-11-17 10:20:50
[oracle@asm1 gan]$ su - grid
password:
[grid@asm1 ~]$ ls -l
total 4
drwxr-xr-x 3 grid oinstall 4096 jun 20 14:19 oradiag_grid
[grid@asm1 ~]$ env |grep oracle
oracle_sid= asm
oracle_base=/u01/app
oracle_home=/u01/app/grid
[grid@asm1 ~]$ sqlplus "/as sysasm"
sql*plus: release 11.2.0.1.0 production on wed nov 2 14:44:28 2011
凯发app官方网站 copyright (c) 1982, 2009, oracle. all rights reserved.
connected to:
oracle database 11g enterprise edition release 11.2.0.1.0 - production
with the automatic storage management option
sql> shutdown immediate;
asm diskgroups dismounted
asm instance shutdown
sql> startup;
asm instance started
total system global area 284565504 bytes
fixed size 1336036 bytes
variable size 258063644 bytes
asm cache 25165824 bytes
asm diskgroups mounted
sql> exit
disconnected from oracle database 11g enterprise edition release 11.2.0.1.0 - production
with the automatic storage management option
[grid@asm1 ~]$ exit
logout
[oracle@asm1 gan]$ env |grep oracle
oracle_sid= asm
oracle_base=/u02/app
oracle_home=/u01/app/grid
[oracle@asm1 gan]$ sqlplus "/as sysasm"
sql*plus: release 11.2.0.1.0 production on wed nov 2 14:45:16 2011
凯发app官方网站 copyright (c) 1982, 2009, oracle. all rights reserved.
error:
ora-01031: insufficient privileges
enter user-name:
11g r2的oracle asm instance有变化了。以前直接sqlplus "/as sysdba" shutdown不可以用了。
需要切换到grid用户后sqlplus "/as sysasm"才可以。
password:
[grid@asm1 ~]$ ls -l
total 4
drwxr-xr-x 3 grid oinstall 4096 jun 20 14:19 oradiag_grid
[grid@asm1 ~]$ env |grep oracle
oracle_sid= asm
oracle_base=/u01/app
oracle_home=/u01/app/grid
[grid@asm1 ~]$ sqlplus "/as sysasm"
sql*plus: release 11.2.0.1.0 production on wed nov 2 14:44:28 2011
凯发app官方网站 copyright (c) 1982, 2009, oracle. all rights reserved.
connected to:
oracle database 11g enterprise edition release 11.2.0.1.0 - production
with the automatic storage management option
sql> shutdown immediate;
asm diskgroups dismounted
asm instance shutdown
sql> startup;
asm instance started
total system global area 284565504 bytes
fixed size 1336036 bytes
variable size 258063644 bytes
asm cache 25165824 bytes
asm diskgroups mounted
sql> exit
disconnected from oracle database 11g enterprise edition release 11.2.0.1.0 - production
with the automatic storage management option
[grid@asm1 ~]$ exit
logout
[oracle@asm1 gan]$ env |grep oracle
oracle_sid= asm
oracle_base=/u02/app
oracle_home=/u01/app/grid
[oracle@asm1 gan]$ sqlplus "/as sysasm"
sql*plus: release 11.2.0.1.0 production on wed nov 2 14:45:16 2011
凯发app官方网站 copyright (c) 1982, 2009, oracle. all rights reserved.
error:
ora-01031: insufficient privileges
enter user-name:
11g r2的oracle asm instance有变化了。以前直接sqlplus "/as sysdba" shutdown不可以用了。
需要切换到grid用户后sqlplus "/as sysasm"才可以。
给主人留下些什么吧！~~