ASM available on the server? listener doesn't show ASM instance registered with it.
1* select open_mode from v$database
SQL> shutdown immediate
ORACLE instance shut down.
SQL> startup mount
ORACLE instance started.
Total System Global Area 456146944 bytes
Fixed Size 1344840 bytes
Variable Size 348129976 bytes
Database Buffers 100663296 bytes
Redo Buffers 6008832 bytes
SQL> select open_mode from v$database;
what is current OPEN_MODE for ASM instance?
Please kindly read the earlier post the one i have posted for PAVAN. I am not been able to install dabatabase from dbca. I have mentioned that i my previous post.
[oracle@storage Desktop]$ sqlplus / as sysdba
SQL*Plus: Release 18.104.22.168.0 Production on Fri Jul 17 07:27:27 2015
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to an idle instance.
SQL> select * from V$INSTANCE;
select * from V$INSTANCE
ERROR at line 1:
ORA-01034: ORACLE not available
Process ID: 0
Session ID: 0 Serial number: 0
ASM requires a mounted instance which is separate & distinct from any database created by DBCA.
ASM is NOT required to have an operational Oracle database.
Why are adding the complication of ASM to having a standalone Oracle database?
Thats the same thing i wanted to ask ? why ASM is so much complicated. i simply created listener from netmgr and checked srvctl status ASM which SHOWS ASM status is running despite of simply doing that it always become complicated. Besides if it is not complicated then why does entering password for ASMSNMP gives an complication.