Database Software

Hi!

I have installed oracle Clusterware 11.2.2 and I'm trying to set up cold failover for a single instance database. To do this I configured as cluster resource a virtual ip (vip_exp), a listener (listener_exp) and a database (BBDD).

Initillay, everything worked fine, but sundDely fail BBDD resource, but the database followed started. I stopped database.

Now, the virtual ip and the listener is working properly but when I try start resource BBDD whith crsctl, despite starts
the database cluster returns me this error:

crsctl start res BBDD
CRS-2672: Attempting to start 'BBDD' on 'sdbtte02'
CRS-2674: Start of 'BBDD' on 'sdbtte02' failed
CRS-2527: Unable to start 'BBDD' because it has a 'hard' dependency on 'listener_exp'
CRS-2525: All instances of the resource 'listener_exp' are already running; relocate is not allowed because the force option was not specifiedCRS-4000: Command Start failed, or completed with errors.

When I check status for cluster resource:

sdbtte01:/home/oracle$> crs_stat -t
Name Type Target State Host
------------------------------------------------------------
BBDD clus...esource ONLINE OFFLINE
listener_exp clus...esource ONLINE ONLINE sdbtte02
ora.DATOS.dg ora....up.type ONLINE ONLINE sdbtte01
ora.FRA.dg ora....up.type ONLINE ONLINE sdbtte01
ora....ER.lsnr ora....er.type ONLINE ONLINE sdbtte01
ora....N1.lsnr ora....er.type OFFLINE OFFLINE
ora.VOTING.dg ora....up.type ONLINE ONLINE sdbtte01
ora.asm ora.asm.type ONLINE ONLINE sdbtte01
ora.cvu ora.cvu.type OFFLINE OFFLINE
ora.gsd ora.gsd.type OFFLINE OFFLINE
ora....network ora....rk.type ONLINE ONLINE sdbtte01
ora.oc4j ora.oc4j.type OFFLINE OFFLINE
ora.ons ora.ons.type ONLINE ONLINE sdbtte01
ora.scan1.vip ora....ip.type OFFLINE OFFLINE
ora....SM1.asm application ONLINE ONLINE sdbtte01
ora....01.lsnr application ONLINE ONLINE sdbtte01
ora....e01.gsd application OFFLINE OFFLINE
ora....e01.ons application ONLINE ONLINE sdbtte01
ora....e01.vip ora....t1.type ONLINE ONLINE sdbtte01
ora....SM2.asm application ONLINE ONLINE sdbtte02
ora....02.lsnr application ONLINE ONLINE sdbtte02
ora....e02.gsd application OFFLINE OFFLINE
ora....e02.ons application ONLINE ONLINE sdbtte02
ora....e02.vip ora....t1.type ONLINE ONLINE sdbtte02
vip_exp app....t1.type ONLINE ONLINE sdbtte02


In the crsd.log I found this error: CRS-2613: Could not find resource 'ora.exp.db' (see below line 72306)

Thanks.


Anyone know where the problem can be??

Thanks




................................................crsd.log..................................................................

72198 2011-01-17 12:06:30.530: [UiServer][49] {1:32916:156} Container [ Name: UI_START
72199 CLIENT:
72200 TextMessage[]
72201 CLIENT_PRIMARY_GROUP:
72202 TextMessage[orainstall]
72203 LOCALE:
72204 TextMessage[AMERICAN_AMERICA.US7ASCII]
72205 QUEUE_TAG:
72206 TextMessage[1]
72207 RESOURCE:
72208 TextMessage[BBDD]
72209 ]
72210 2011-01-17 12:06:30.530: [UiServer][49] {1:32916:156} Sending message to PE. ctx= 60000000018e0ac0
72211 2011-01-17 12:06:30.531: [ CRSPE][48] {1:32916:156} Cmd : 6000000001977c30 : flags: QUEUE_TAG
72212 2011-01-17 12:06:30.531: [ CRSPE][48] {1:32916:156} Processing PE command id=228. Description: [Start Resource : 6000000001977c30]
72213 2011-01-17 12:06:30.538: [ CRSPE][48] {1:32916:156} RI [BBDD 1 1] new internal state: [STARTING] old value: [STABLE]
72214 2011-01-17 12:06:30.538: [ CRSPE][48] {1:32916:156} Sending message to agfw: id = 831
72215 2011-01-17 12:06:30.539: [ AGFW][43] {1:32916:156} Agfw Proxy Server received the message: RESOURCE_START[BBDD 1 1] ID 4098:831
72216 2011-01-17 12:06:30.539: [ CRSPE][48] {1:32916:156} CRS-2672: Attempting to start 'BBDD' on 'sdbtte01'
72217
72218 2011-01-17 12:06:30.539: [ AGFW][43] {1:32916:156} Agfw Proxy Server forwarding the message: RESOURCE_START[BBDD 1 1] ID 4098:831 to the agent /u0
1/app/11.2.0/grid/bin/scriptagent_oracle
72219 2011-01-17 12:06:30.541: [UiServer][49] {1:32916:156} Container [ Name: ORDER
72220 MESSAGE:
72221 TextMessage[CRS-2672: Attempting to start 'BBDD' on 'sdbtte01']
72222 MSGTYPE:
72223 TextMessage[3]
72224 OBJID:
72225 TextMessage[BBDD]
72226 WAIT:
72227 TextMessage[0]
72228 ]
72229 2011-01-17 12:06:31.464: [UiServer][50] CS(6000000003265350)set Properties ( oracle,60000000032dae60)
72230 2011-01-17 12:06:31.480: [UiServer][49] {1:32916:157} Sending message to PE. ctx= 60000000018e0a20
72231 2011-01-17 12:06:31.481: [ CRSPE][48] {1:32916:157} Processing PE command id=229. Description: [Stat Resource : 6000000002132440]
72232 2011-01-17 12:06:31.483: [UiServer][49] {1:32916:157} Done for ctx=60000000018e0a20
72233 2011-01-17 12:06:31.500: [UiServer][50] CS(60000000032655b0)set Properties ( oracle,60000000032db460)
72234 2011-01-17 12:06:31.521: [UiServer][49] {1:32916:158} Sending message to PE. ctx= 60000000018e0700
72235 2011-01-17 12:06:31.521: [ CRSPE][48] {1:32916:158} Processing PE command id=230. Description: [Stat Resource : 6000000002132440]
72236 2011-01-17 12:06:31.523: [UiServer][49] {1:32916:158} Done for ctx=60000000018e0700
72237 2011-01-17 12:06:31.568: [UiServer][50] CS(60000000032655b0)set Properties ( oracle,60000000032db460)
72238 2011-01-17 12:06:31.580: [UiServer][49] {1:32916:159} Container [ Name: UI_START
72239 CLIENT:
72240 TextMessage[]
72241 CLIENT_PRIMARY_GROUP:
72242 TextMessage[orainstall]
72243 FORCE_TAG:
72244 TextMessage[1]
72245 HOST:
72246 TextMessage[sdbtte01]
72247 HOST_TAG:
72248 TextMessage[1]
72249 LOCALE:
72250 TextMessage[AMERICAN_AMERICA.WE8ISO8859P1]
72251 QUEUE_TAG:
72252 TextMessage[1]
72253 RESOURCE:
72254 TextMessage[ora.asm]
72255 ]
72256 2011-01-17 12:06:31.580: [UiServer][49] {1:32916:159} Sending message to PE. ctx= 60000000018e0750
72257 2011-01-17 12:06:31.581: [ CRSPE][48] {1:32916:159} Cmd : 6000000002132440 : flags: FORCE_TAG | HOST_TAG | QUEUE_TAG
72258 2011-01-17 12:06:31.581: [ CRSPE][48] {1:32916:159} Processing PE command id=231. Description: [Start Resource : 6000000002132440]
72259 2011-01-17 12:06:31.583: [ CRSPE][48] {1:32916:159} PE Command [ Start Resource : 6000000002132440 ] has completed
72260 2011-01-17 12:06:31.584: [ CRSPE][48] {1:32916:159} UI Command [Start Resource : 6000000002132440] is replying to sender.
72261 2011-01-17 12:06:31.584: [UiServer][49] {1:32916:159} Container [ Name: ORDER
72262 MESSAGE:
72263 TextMessage[CRS-5702: Resource 'ora.asm' is already running on 'sdbtte01']
72264 MSGTYPE:
72265 TextMessage[1]
72266 OBJID:
72267 TextMessage[ora.asm]
72268 WAIT:
72269 TextMessage[0]
72270 ]
72271 2011-01-17 12:06:31.584: [UiServer][49] {1:32916:159} Container [ Name: UI_DATA
72272 ora.asm:
72273 TextMessage[223]
72274 ]
72275 2011-01-17 12:06:31.584: [UiServer][49] {1:32916:159} Done for ctx=60000000018e0750
72276 2011-01-17 12:06:37.385: [UiServer][50] CS(60000000032655b0)set Properties ( oracle,60000000032db460)
72277 2011-01-17 12:06:37.400: [UiServer][49] {1:32916:160} Container [ Name: UI_START
72278 ASYNC_TAG:
72279 TextMessage[1]
72280 CLIENT:
72281 TextMessage[]
72282 CLIENT_PRIMARY_GROUP:
72283 TextMessage[orainstall]
72284 EVENT_TAG:
72285 TextMessage[1]
72286 HOST:
72287 TextMessage[sdbtte01]
72288 HOST_TAG:
72289 TextMessage[1]
72290 LOCALE:
72291 TextMessage[AMERICAN_AMERICA.WE8ISO8859P1]
72292 NO_WAIT_TAG:
72293 TextMessage[1]
72294 RESOURCE:
72295 TextMessage[ora.exp.db^AUSR_ORA_OPI=true^AUSR_ORA_INST_NAME=EXP]
72296 ]
72297 2011-01-17 12:06:37.401: [UiServer][49] {1:32916:160} Sending message to PE. ctx= 60000000018e0a20
72298 2011-01-17 12:06:37.401: [ CRSPE][48] {1:32916:160} Cmd : 6000000002132440 : flags: EVENT_TAG | HOST_TAG
72299 2011-01-17 12:06:37.402: [ CRSPE][48] {1:32916:160} Processing PE command id=232. Description: [Start Resource : 6000000002132440]
72300 2011-01-17 12:06:37.402: [ CRSPE][48] {1:32916:160} Attribute overrides for the command: USR_ORA_INST_NAME = EXP;USR_ORA_OPI = true;
72301 2011-01-17 12:06:37.402: [ CRSPE][48] {1:32916:160} Bad resource ID:ora.exp.db Skipping it
72302 2011-01-17 12:06:37.404: [ CRSPE][48] {1:32916:160} PE Command [ Start Resource : 6000000002132440 ] has completed
72303 2011-01-17 12:06:37.404: [ CRSPE][48] {1:32916:160} UI Command [Start Resource : 6000000002132440] is replying to sender.
72304 2011-01-17 12:06:37.404: [UiServer][49] {1:32916:160} Container [ Name: ORDER
72305 MESSAGE:
72306 TextMessage[CRS-2613: Could not find resource 'ora.exp.db'.]
72307 MSGTYPE:
72308 TextMessage[1]
72309 OBJID:
72310 TextMessage[ora.exp.db]
72311 WAIT:
72312 TextMessage[0]
72313 ]
72314 2011-01-17 12:06:37.404: [ COMMCRS][49]clscsendx: (60000000032db460) Connection not active
72315
72316 2011-01-17 12:06:37.404: [UiServer][49] {1:32916:160} CS(60000000032655b0)Error sending msg over socket.6
72317 2011-01-17 12:06:37.405: [UiServer][49] {1:32916:160} Communication exception sending reply back to client.FatalCommsException : Failed to send respo
nse to client.
72318 (File: clsMessageStream.cpp, line: 275
72319
72320 2011-01-17 12:06:37.405: [UiServer][49] {1:32916:160} Container [ Name: UI_DATA
72321 ora.exp.db:
72322 TextMessage[210]
72323 ]
72324 2011-01-17 12:06:37.405: [UiServer][49] {1:32916:160} CS(60000000032655b0)No connection to client.6
72325 2011-01-17 12:06:37.405: [UiServer][49] {1:32916:160} Communication exception sending reply back to client.FatalCommsException : Failed to send respo
nse to client.
72326 (File: clsMessageStream.cpp, line: 275
72327
72328 2011-01-17 12:06:37.405: [UiServer][49] {1:32916:160} Done for ctx=60000000018e0a20
72329 2011-01-17 12:06:40.134: [UiServer][50] CS(60000000032655b0)set Properties ( oracle,60000000032db2e0)
72330 2011-01-17 12:06:40.154: [UiServer][49] {1:32916:161} Sending message to PE. ctx= 60000000018e0700
72331 2011-01-17 12:06:40.155: [ CRSPE][48] {1:32916:161} Processing PE command id=233. Description: [Stat Resource : 6000000002132440]
72332 2011-01-17 12:06:40.160: [UiServer][49] {1:32916:161} Done for ctx=60000000018e0700
72333 2011-01-17 12:06:40.173: [UiServer][50] CS(6000000003265350)set Properties ( oracle,60000000032dae60)
72334 2011-01-17 12:06:40.194: [UiServer][49] {1:32916:162} Sending message to PE. ctx= 60000000018e0750
72335 2011-01-17 12:06:40.194: [ CRSPE][48] {1:32916:162} Processing PE command id=234. Description: [Stat Resource : 6000000002132440]
72336 2011-01-17 12:06:40.196: [UiServer][49] {1:32916:162} Done for ctx=60000000018e0750
72337 2011-01-17 12:06:40.214: [UiServer][50] CS(60000000032655b0)set Properties ( oracle,60000000032db2e0)
72338 2011-01-17 12:06:40.233: [UiServer][49] {1:32916:163} Sending message to PE. ctx= 60000000018e0a20
72339 2011-01-17 12:06:40.234: [ CRSPE][48] {1:32916:163} Processing PE command id=235. Description: [Stat Resource : 6000000002132440]
72340 2011-01-17 12:06:40.239: [UiServer][49] {1:32916:163} Done for ctx=60000000018e0a20
72341 2011-01-17 12:06:40.253: [UiServer][50] CS(6000000003265350)set Properties ( oracle,60000000032dae60)
72342 2011-01-17 12:06:40.273: [UiServer][49] {1:32916:164} Sending message to PE. ctx= 60000000018e0700
72343 2011-01-17 12:06:40.274: [ CRSPE][48] {1:32916:164} Processing PE command id=236. Description: [Stat Resource : 6000000002132440]
72344 2011-01-17 12:06:40.275: [UiServer][49] {1:32916:164} Done for ctx=60000000018e0700
72345 2011-01-17 12:06:45.833: [ AGFW][43] {1:32916:156} Received the reply to the message: RESOURCE_START[BBDD 1 1] ID 4098:832 from the agent /u01/app
/11.2.0/grid/bin/scriptagent_oracle
72346 2011-01-17 12:06:45.834: [ AGFW][43] {1:32916:156} Agfw Proxy Server sending the reply to PE for message:RESOURCE_START[BBDD 1 1] ID 4098:831
72347 2011-01-17 12:06:45.835: [ CRSPE][48] {1:32916:156} Received reply to action [Start] message ID: 831
72348 2011-01-17 12:06:53.220: [ AGFW][43] {1:32916:156} Received the reply to the message: RESOURCE_START[BBDD 1 1] ID 4098:832 from the agent /u01/app
/11.2.0/grid/bin/scriptagent_oracle
72349 2011-01-17 12:06:53.221: [ AGFW][43] {1:32916:156} Agfw Proxy Server sending the last reply to PE for message:RESOURCE_START[BBDD 1 1] ID 4098:831
72350 2011-01-17 12:06:53.221: [ CRSPE][48] {1:32916:156} Received reply to action [Start] message ID: 831
72351 2011-01-17 12:06:53.221: [ CRSPE][48] {1:32916:156} RI [BBDD 1 1] new internal state: [STABLE] old value: [STARTING]
72352 2011-01-17 12:06:53.222: [ CRSPE][48] {1:32916:156} CRS-2674: Start of 'BBDD' on 'sdbtte01' failed
72353
72354 2011-01-17 12:06:53.223: [UiServer][49] {1:32916:156} Container [ Name: ORDER
72355 MESSAGE:
72356 TextMessage[CRS-2674: Start of 'BBDD' on 'sdbtte01' failed]
72357 MSGTYPE:
72358 TextMessage[1]
72359 OBJID:
72360 TextMessage[BBDD]
72361 WAIT:
72362 TextMessage[0]
72363 ]
72364 2011-01-17 12:06:53.223: [ CRSPE][48] {1:32916:156} Sequencer for [BBDD 1 1] has completed with error: CRS-0215: Could not start resource 'BBDD'.
72365
72366 2011-01-17 12:06:53.230: [ CRSPE][48] {1:32916:156} PE Command [ Start Resource : 6000000001977c30 ] has completed
72367 2011-01-17 12:06:53.231: [ CRSPE][48] {1:32916:156} UI Command [Start Resource : 6000000001977c30] is replying to sender.
72368 2011-01-17 12:06:53.231: [UiServer][49] {1:32916:156} Container [ Name: ORDER
72369 MESSAGE:
72370 TextMessage[CRS-2527: Unable to start 'BBDD' because it has a 'hard' dependency on 'listener_exp']
72371 MSGTYPE:
72372 TextMessage[1]
72373 OBJID:
72374 TextMessage[BBDD]
72375 WAIT:
72376 TextMessage[0]
72377 ]
72378 2011-01-17 12:06:53.231: [ AGFW][43] {1:32916:156} Agfw Proxy Server received the message: CMD_COMPLETED[Proxy] ID 20482:855
72379 2011-01-17 12:06:53.232: [ AGFW][43] {1:32916:156} Agfw Proxy Server replying to the message: CMD_COMPLETED[Proxy] ID 20482:855
72380 2011-01-17 12:06:53.232: [UiServer][49] {1:32916:156} Container [ Name: ORDER
72381 MESSAGE:
72382 TextMessage[CRS-2525: All instances of the resource 'listener_exp' are already running; relocate is not allowed because the force option was
not specified]
72383 MSGTYPE:
72384 TextMessage[1]
72385 OBJID:
72386 TextMessage[BBDD]
72387 WAIT:
72388 TextMessage[0]
72389 ]
72390 2011-01-17 12:06:53.232: [UiServer][49] {1:32916:156} Container [ Name: UI_DATA
72391 BBDD:
72392 TextMessage[222]
72393 ]
72394 2011-01-17 12:06:53.233: [UiServer][49] {1:32916:156} Done for ctx=60000000018e0ac0