Oracle Database Discussions

Hi there,

env: oracle 10gR2 (10.2.0.5)

platform: RHEL 5.8 64-bit

I installed ASM Home, then DB Home. Patched both to 10.2.0.5.

Started CSS daemon (from ASM Home) and configured listener from ASM home (listener name = LISTENER_VM1).

I have created ASM instance using DBCA - create two Diskgroups - DATA and FRA. All goo so far.

I thought to check the ASM instance before creating the Database using ASM.

$ ps -ef | grep oracle

...

oracle    6554  4960  0 09:01 pts/1    00:00:00 ps -ef

oracle    6555  4960  0 09:01 pts/1    00:00:00 grep oracle

oracle    9784  9504  0 Jul31 ?        00:00:00 /app/oracle/product/10.2.0/asm/bin/ocssd.bin

oracle   12417     1  0 Jul31 ?        00:00:00 asm_pmon_+ASM

oracle   12419     1  0 Jul31 ?        00:00:00 asm_psp0_+ASM

oracle   12421     1  0 Jul31 ?        00:00:00 asm_mman_+ASM

oracle   12423     1  0 Jul31 ?        00:00:00 asm_dbw0_+ASM

oracle   12425     1  0 Jul31 ?        00:00:00 asm_lgwr_+ASM

oracle   12427     1  0 Jul31 ?        00:00:00 asm_ckpt_+ASM

oracle   12429     1  0 Jul31 ?        00:00:00 asm_smon_+ASM

oracle   12431     1  0 Jul31 ?        00:00:00 asm_rbal_+ASM

oracle   12433     1  0 Jul31 ?        00:00:09 asm_gmon_+ASM

$ export ORACLE_SID=+ASM

$ echo $ORACLE_HOME

/app/oracle/product/10.2.0/asm

$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.5.0 - Production on Thu Aug 1 09:01:44 2013

Copyright (c) 1982, 2010, Oracle.  All Rights Reserved.

Connected to an idle instance.

SQL>

Few questions here:

1. Why am I getting "idle instance"? I can see all the required background process for +ASM instance.
2. If I choose non-default listener name (for example, LISTENER_VM1 instead of LISTENER), is there something special that I need to set in the env to tell Oracle the name of the listener?
3. Is there anything wrong is I use the default listener name (LISTENER) instead of giving it some custom name?

Please advise!

Best regards

Message was edited by: user130038