One more doubt :-show parameter spfile--- see the location
Is my spfile address going to be $ORACLE_HOME/dbs/spfileorcl2.ora or since it is an ASM installation , it is
something "+DATA/orcl2/spfileorcl2.ora" ?
But after all this , now my tns listener gives error too when i try to connect with db .hope the thread helps you..
Enter user-name: sys@orcl2 as sysdba
ORA-12518: TNS:listener could not hand off client connection
How can i remove this now ?