Home » RDBMS Server » Server Administration » ORA-27062 in alert log
ORA-27062 in alert log [message #56374] Tue, 25 March 2003 14:02 Go to next message
Meg
Messages: 16
Registered: November 2002
Junior Member
Hi All,

We have oracle 81700 on solaris 8 here. Recently I have noticed the error
ORA-27062: skgfospo: could not find pending async I/Os
in alert log and the instance is crashing. Can someone shed some light into this??

Thanks
Meg

Report message to a moderator

Re: ORA-27062 in alert log [message #56380 is a reply to message #56374] Tue, 25 March 2003 17:51 Go to previous messageGo to next message
Chakravarthi Ayyalasomaya
Messages: 1
Registered: March 2003
Junior Member
Hi Meg,

Has error generated any trace files? If you scan through alert log file, with this error see if it recorded a .trc file. If so, please send the .trc file to my email id and we will go from there.

Chakravarthi

Report message to a moderator

Re: ORA-27062 in alert log [message #56398 is a reply to message #56374] Wed, 26 March 2003 13:03 Go to previous messageGo to next message
sai sreenivas jeedigunta
Messages: 370
Registered: November 2001
Senior Member
Yeah! do as what chakravarthi said.. also make sure that u r running the latest kernel of solaris..
u can get Furthur info on this from Metalink / OTN

sai

Report message to a moderator

Re: ORA-27062 in alert log [message #56401 is a reply to message #56398] Wed, 26 March 2003 13:27 Go to previous messageGo to next message
Meg
Messages: 16
Registered: November 2002
Junior Member
Thank you to both of you. I appreciate you both taking time to respond to my query.

Chakravarti,
I am in the process of collecting the trace and alert logs. I will email them to you soon.. I would really appreciate it if you can find a little time to go through them and let me know if you see any problem..

Sai,
I will check the solaris patch level with our Unix team..
I will followup soon on this..

Thanks again guys..

Report message to a moderator

Re: ORA-27062 in alert log [message #56456 is a reply to message #56398] Tue, 01 April 2003 08:00 Go to previous message
Meg
Messages: 16
Registered: November 2002
Junior Member
Helo Guys,

I think I found a patch that fixed this problem for us. We did several hours of testing after applying this solaris patch and looks like it is working. The solaris patch no. is 112254-01. We did have this patch already applied to Solaris 2.8 on this box but we did not set the system parameter that this patch requires. ie., set TS:ts_sleep_promote=1. Setting this parameter in /etc/system did the trick..

Thanks to both Sai and Chakravarthi for your help.

Meg

Report message to a moderator

Previous Topic: Any problem with Application accounts under the Group DBA?
Next Topic: Additional privileges for a DBA user
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 06:38:56 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.