Srvctl cannot start Database, I get the following error ,PRCR-1079,ORA-00119, ORA-00132,CRS-5017 however sqlplus can start it on both nodes

              I have upgraded 10.2.0.5 to 11.2.0.3  Database by using DBUA by setting after cluster_database=false . After upgraded Trying to start database after added  instance's it's not able start because of Invalid specification of LOCAL_LISTENER's on instances.  But I can start from SQLPLUS session . When I am trying to start through srvctl not able .   Finally found because Didnt setup TNS_ADMIN for for database


srvctl start database -d QA1MOD

OUTPUT:-
~~~~~~~~

PRCR-1079 : Failed to start resource ora.qa1mod.db
CRS-5017: The resource action "ora.qa1mod.db start" encountered the following error:
ORA-00119: invalid specification for system parameter LOCAL_LISTENER
ORA-00132: syntax error or unresolved network name 'LISTENER_XXXXXX1'
. For details refer to "(:CLSN00107:)" in "/u01/app/grid/11gR2_2/log//agent/crsd/oraagent_oracle/oraagent_oracle.log".

CRS-2674: Start of 'ora.qa1mod.db' on 'qa2db1' failed
CRS-5017: The resource action "ora.qa1mod.db start" encountered the following error:
ORA-00119: invalid specification for system parameter LOCAL_LISTENER
ORA-00132: syntax error or unresolved network name 'LISTENER_XXXXXX'
. For details refer to "(:CLSN00107:)" in "/u01/app/grid/11gR2_2/log//agent/crsd/oraagent_oracle/oraagent_oracle.log".

CRS-2674: Start of 'ora.qa1mod.db' on 'qa2db2' failed
CRS-2632: There are no more servers to try to place resource 'ora.qa1mod.db' on that would satisfy its placement policy



Check the TNS_ADMIN has been setup or not


srvctl getenv database -d XXXXXXXX
OUTPUT:-
~~~~~~~
XXXXXX:


Nothing has been setup environment variables for above database

So, I set ENV on CLUSTER with Database (that make me this idea) and then start again:

srvctl setenv database -d XXXXXX -T TNS_ADMIN=/u01/app/oracle/common/network/admin


Check one more time is setup or not:-

srvctl getenv database -d XXXXXXXX

OUTPUT:-
~~~~~~~

XXXXX:
TNS_ADMIN=/u01/app/oracle/common/network/admin


In above TNS_ADMIN has been setup Now start the database

Start Database:-

srvctl start database -d QA1MOD

Check Status of database :-

srvctl status database -d XXXXXX

OUTPUT:-
~~~~~~~

Instance XXXXX1 is running on node abc1
Instance XXXXX2 is running on node abc2



Finally Database and instances has been started . Intially server control looking for Local_Listener  different location due to that reason its not able to started this database.



There is Another situation where we cant start database which is explain by Surachart Opun's Blog :-

http://surachartopun.com/2008/07/srvctl-cannot-start-instance-i-get.html