Tuesday, October 9, 2007

Trobleshooting

We applied the CPU Patch in 2 node RAC cluster (10.2.0.2, Linux As3.0). DBA used sqlplus to bring up the instances. We started the monitoring and found out that the monitoring is alerting the below messages:

ORA-01034: ORACLE not available
ORA-27123: unable to attach to shared memory segment
Linux Error: 22: Invalid argument
Additional information: 1
Additional information: 1081344

All the instances were up. After 30-40 minutes analysis we found the workaround to resolve this issue.

I believe that there is an unknown bug with sqlplus vs. svrctl -. I am sharing the workaround we used to resolve the issue.


Here is what happened when we used sqlplus:

SQL> startup
ORACLE instance started.

Total System Global Area 599785472 bytes
Fixed Size 1262200 bytes
Variable Size 205524360 bytes
Database Buffers 385875968 bytes
Redo Buffers 7122944 bytes
Database mounted.
Database opened.
[oracle@bev2 oracle]$ sqlplus system/xxxx@nep1

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jun 2 16:05:36 2007

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

ERROR:
ORA-01034: ORACLE not available
ORA-27123: unable to attach to shared memory segment
Linux Error: 22: Invalid argument
Additional information: 1
Additional information: 1081344


Our workaround:

I used srvctl to bring up the instances and found that everything is fine. We checked the tns connections and it went successful.

oracle@bev1 oracle]$ srvctl start instance -d nep -i nep1 -o open

[oracle@bev2 oracle]$ sqlplus system/xxx@nep1

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jun 2 16:10:47 2007

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


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options

SQL>

2 comments:

Xia Zhang said...

http://www.shopbestgoods.com/
http://www.bestcustomsonline.com/
http://www.nike-jordanshoes.com/
http://www.polo-tshirts.com/
http://www.burberry-factory.com/
http://www.kate-spades.com/
http://www.barbour-factory.com/
http://www.coachlosangeles.com/
http://www.official-coachoutlet.com/
http://www.louisvuittonas.com/
http://www.burberryoutlet2014.com/
http://www.official-mkoutlet.com/
http://www.official-pradaoutlet.com/
http://www.beatsbydreoutlet.net/
http://www.michaelkorsonlineusa.com/
http://www.northsclearance.com/
http://www.ralph-laurensale.com/
http://www.gucci-shoesuk2014.com/
http://www.michael-korsusa.com/
http://www.polo-outlets.com/
http://www.hermes-outletonline.com/
http://www.ralphslauren.co.uk/
http://www.marcjacobsonsale.com/
http://www.mcmworldwides.com/
http://www.warmbootssale.com/
http://www.salongchamppairs.com/
http://www.canada-gooser.com/
http://www.michaelkors.so/
http://www.oakley-sunglassoutlet.com/
http://www.north-faceoutlets.net/
http://www.moncler-clearance.com/
http://www.woolrich-clearance.com/
http://www.barbour-jacketsoutlet.com/
http://www.moncler-jacketsoutletonline.com/
http://www.monsterbeatsbydres.net/
http://www.lv-guccishoesfactory.com/
http://www.cheapdiscountoutlet.com/
http://www.coachsfactoryoutlet.com/
http://www.coach-blackfriday2014.com/
http://www.coach-storeoutletonline.com/
http://www.coach-factorysoutletonline.com/
http://www.coachccoachoutlet.com/
http://www.coach-factories.net/
http://www.coach-pursesoutletonline.com/
http://www.coach-outletsusa.com/
http://www.zxcoachoutlet.com/
http://www.mischristmas.com/
http://www.misblackfriday.com/
http://www.newoutletonlinemall.com/
http://www.ralphlaurenepolo.com/
http://michaelkorsoutlet.mischristmas.com/
http://mcmbackpack.mischristmas.com/
http://monsterbeats.mischristmas.com/
http://northfaceoutlet.mischristmas.com/
http://mk.misblackfriday.com/
http://coachoutlet.misblackfriday.com/
http://coachfactory.misblackfriday.com/
http://uggaustralia.misblackfriday.com/
http://coachpurses.misblackfriday.com/
http://coachusa.misblackfriday.com/
http://coach.misblackfriday.com/
http://michaelkorss.misblackfriday.com/
http://michaelkors.misblackfriday.com/
http://airmax.misblackfriday.com/
http://michael-kors.misblackfriday.com/
https://twitter.com/CoachOutlet2014
https://www.facebook.com/coachoutletstoreonline
https://www.facebook.com/ralphlaurenoutletonline

dong dong23 said...

retro jordans
cheap jordans
polo ralph lauren
longchamp outlet
gucci handbags
oakley sunglasses
ralph lauren
louis vuitton bags
louis vuitton handbags
toms outlet
cheap jerseys
adidas stan smith
supra shoes
louis vuitton outlet
tods outlet
hollister uk
michael kors outlet
louis vuitton outlet
oakley sunglasses
replica watches
tory burch sale
kate spade handbags
michael kors outlet online
nike uk
louis vuitton
giuseppe zanotti
fitflop sandals
michael kors outlet online
gucci handbags
kate spade handbags
hollister clothing
ray bans
coach factory outlet
nike roshe run
celine
jordans for sale
celine
hollister clothing
marc jacobs
christian louboutin shoes
20166.4wengdongdong