Shulou(Shulou.com)06/01 Report--

The oracle version is 11.2.0.3 and the system version is Centos Linux 6.6x86room64. After installing the grid software, everything is fine and there is no error, but after using sqlplus / as sysasm, you are prompted to connect to the idle process.

[grid@oracle dbs] $sqlplus / as sysasm;SQL*Plus: Release 11.2.0.3.0 Production on Mon Apr 25 15:08:06 2016Copyright (c) 1982, 2011, Oracle. All rights reserved.Connected to an idle instance.SQL > startup mount;ORA-15149: another ASM instance found running on the host

Check css status

[grid@oracle] $crs_stat-tName Type Target State Host-ora.DATA.dg ora....up.type ONLINE ONLINE oracle ora....ER .lsnr ora....er.type ONLINE ONLINE oracle ora.asm ora.asm.type ONLINE ONLINE oracle ora.cssd ora.cssd.type ONLINE ONLINE oracle ora.diskmon ora....on.type OFFLINE OFFLINE ora.evmd ora.evm.type ONLINE ONLINE oracle ora.ons ora.ons.type OFFLINE OFFLINE ora.orcl .db ora....se.type ONLINE ONLINE oracle

It is found that ora.diskmon is in offline state. After consulting the data, it is found that since version 11.2.0.3, the default diskmon is disabled on non-exadata.

11.2.0.3 Grid Infrastructure diskmon Will be Offline by Default in Non-Exadata Environment [ID 1346881.1]

Do everything possible to see if there is a way to enable ora.diskmon. Setting auto_start to 1 has no effect. Check the asm process.

[grid@oracle grid] $ps-ef | grep asm_grid 25991 1 0 14:56? 00:00:00 asm_pmon_+ASMgrid 25993 10 14:56? 00:00:00 asm_psp0_+ASMgrid 26019 1 2 14:56? 00:00:18 asm_vktm_+ASMgrid 26023 1 0 14:56? 00:00:00 asm_gen0_+ASMgrid 26025 1 0 14:56? 00:00:00 asm_diag_+ASMgrid 26027 1 0 14:56? 00:00:00 asm_dia0_+ASMgrid 26029 1 0 14:56? 00:00:00 asm_mman_+ASMgrid 26031 1 0 14:56? 00:00:00 asm_dbw0_+ASMgrid 26033 1 0 14:56? 00:00:00 asm_lgwr_+ASMgrid 26035 1 0 14:56? 00:00:00 asm_ckpt_+ASMgrid 26037 1 0 14:56? 00:00:00 asm_smon_+ASMgrid 26039 1 0 14:56? 00:00:00 asm_rbal_+ASMgrid 26041 1 0 14:56? 00:00:00 asm_gmon_+ASMgrid 26043 1 0 14:56? 00:00:00 asm_ Mmon_+ASMgrid 26045 10 14:56? 00:00:00 asm_mmnl_+ASMgrid 29065 25763 0 15:10 pts/4 00:00:00 grep asm_

Check the monitoring status

[grid@oracle] $lsnrctl statusLSNRCTL for Linux: Version 11.2.0.3.0-Production on 25-APR-2016 14:56:58Copyright (c) 1991, 2011, Oracle. All rights reserved.Connecting to (DESCRIPTION= (ADDRESS= (PROTOCOL=IPC) (KEY=EXTPROC1521)) STATUS of the LISTENER----Alias LISTENERVersion TNSLSNR for Linux: Version 11.2.0.3.0-ProductionStart Date 25-APR-2016 14:55:38Uptime 0 days 0 hr. 1 min. 20 secTrace Level offSecurity ON: Local OS AuthenticationSNMP OFFListener Parameter File / u01/app/grid/network/admin/listener.oraListener Log File / u01/app/diag/tnslsnr/oracle/listener/alert/log.xmlListening Endpoints Summary... (DESCRIPTION= (ADDRESS= (PROTOCOL=ipc) (KEY=EXTPROC1521)) (DESCRIPTION= (ADDRESS= (PROTOCOL=tcp) (HOST=oracle.study) (PORT=1521)) Services Summary...Service "+ ASM" has 1 instance (s). Instance "+ ASM", status READY, has 1 handler (s) for this service...Service "orcl" has 1 instance (s). Instance "orcl", status READY, has 1 handler (s) for this service...Service "orclXDB" has 1 instance (s). Instance "orcl", status READY, has 1 handler (s) for this service...The command completed successfully

The monitoring status is normal.

Check the parameter file init+asm.ora and found no problem.

[grid@oracle dbs] $cat init+asm.ora * .asm_power_limit=1*.instance_type='asm'*.large_pool_size=12M*.remote_login_passwordfile='EXCLUSIVE'*.asm_diskstring='/dev/asm-disk*'

Finally check the .bash _ profile file configuration

[grid@oracle dbs] $cat ~ / .bash_profile# .bash _ profile# Get the aliases and functionsif [- f ~ / .bashrc]; then. ~ / .bashrcfi # User specific environment and startup programsORACLE_BASE=/u01/app; export ORACLE_BASEORACLE_HOME=/u01/app/grid; export ORACLE_HOMEORACLE_SID=+asm; export ORACLE_SID export LD_LIBRARY_PATH=$ORACLE_HOME/libPATH=$PATH:$HOME/bin:$ORACLE_HOME/binexport PATH

ORACLE_SID is lowercase + asm, while in the actual process, uppercase + ASM,oracle is case-sensitive. It will be normal after being changed to uppercase and then connected.

[grid@oracle grid] $export ORACLE_SID=+ ASM [grid @ oracle grid] $sqlplus / as sysasm;SQL*Plus: Release 11.2.0.3.0 Production on Mon Apr 25 15:11:28 2016Copyright (c) 1982, 2011, Oracle. All rights reserved.Connected to:Oracle Database 11g Enterprise Edition Release 11.2.0.3.0-64bit ProductionWith the Automatic Storage Management optionSQL > show parameter diskgroupNAME TYPE VALUE -asm_diskgroups string

OK after connection

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.