Tuesday, November 21, 2006

ORA-20000错误

平常有个习惯,一上班,会泡杯咖啡,然后去查看数据库的alert_sid.ora文件。今天早上即如往常打开生产数据库,只是一些日志切换记录。已经好几天没有去查看客服系统的alert_sid.ora文件了(不是我不敬业,而是我是业余的DBA,呵呵),惊奇的发现,警告文件里面多了很多,像下面的信息
ORA-12012: error on auto execute of job 8888
ORA-20000: ORA-20000: Content of the tablespace specified is not permanent or tablespace name is invalid
ORA-06512: at "SYS.PRVT_ADVISOR", line 1624
ORA-06512: at "SYS.DBMS_ADVISOR", line 186
ORA-06512: at "SYS.DBMS_SPACE", line 1338
ORA-06512: at "SYS.DBMS_SPACE", line 1554
客服系统运行在RedHat AS4,Oracle Database 10g Enterprise Edition Release 10.2.0.1.0
首先想到一定是JOB出了问题,于是查看一下JOB信息
SQL> select job_name,state,run_count,failure_count from dba_scheduler_jobs;

JOB_NAME STATE RUN_COUNT FAILURE_COUNT
------------------------------ --------------- ---------- -------------
AUTO_SPACE_ADVISOR_JOB SCHEDULED 19 1
GATHER_STATS_JOB SCHEDULED 19 0
FGR$AUTOPURGE_JOB DISABLED 0 0
PURGE_LOG SCHEDULED 22 0
RLM$SCHDNEGACTION SCHEDULED 546 0
RLM$EVTCLEANUP SCHEDULED 525 0

6 rows selected.
从上面的查询结果不难看出是由于AUTO_SPACE_ADVISOR_JOB出了问题
Oracle 号称10G A self Managed Database
,AUTO_SPACE_ADVISOR_JOB 是在数据库安装时预定义的一个Scheduler Job。
原因:
查看Metalink它说是Oracle bug,when the tablespace is created the statistics are captured for this tablespace.When the tablespace is dropped the segments for which the segstats are collected continue to reference the dropped tablespace.AUTO_SPACE_ADVISOR_JOB找不到表空间返回的错误。通过查询dba_auto_segadv_ctl表可以获得被删除的表空间
SQL> select tablespace_name from dba_auto_segadv_ctl
2 where tablespace_name not in (select tablespace_name from dba_tablespaces)
3 /
TABLESPACE_NAME
------------------------------
TEST
1 rows selected.
由于TEST表空间已经被删除,在运行AUTO_SPACE_ADVISOR_JOB时还会对它进行段建议。导致了ORA-20000错误发生。Internal BUG:4707226
解决方法:
Bug 4707226 will be fixed in release 11.0
可以通过手动删除DBA_AUTO_SEGADV_CTL里表空间记录。
SQL> DELETE FROM dba_auto_segadv_ctl
2 where tablespace_name not in (select tablespace_name from dba_tablespaces)
3 /
1 rows deleted.
验证一下:
SQL> exec dbms_space.auto_space_advisor_job_proc

PL/SQL procedure successfully completed.

48 Comments:

Anonymous Anonymous said...

good article

7:53 PM  
Anonymous Anonymous said...

[url=http://louboutinmart.co.uk]louboutin uk[/url] According to legend, the red serge itself was intended to clearly distinguish the Canadian force from the blue-coated fighters of the Indian Wars to the south.. [url=http://dkgoose.com]Canada Goose jakker[/url] Mjpbvoute [url=http://www.louboutinoutletuks.co.uk]louboutin outlet[/url]
gwpkux 562360 [url=http://www.chilliwackbombersoutlet.com]canada goose kids jackets[/url] 906492 [url=http://www.officialcanadagooseparkas.ca]canada goose jackets price[/url]

7:56 PM  
Anonymous Anonymous said...

[url=http://louboutinmart.co.uk]christian louboutin shoes[/url] Mineral fertilizers (30 kg/ha of pure nitrogen fertilizer, 30 kg/ha of phosphorus fertilizer P2O5, and 45 kg/ha of potassium fertilizer K1O) are applied during autumn plowing, during spring cultivation or replowing, or during sowing, with the seeds and the topdressing. [url=http://dkgoose.com]Canada Goose jakke[/url] Wfhhniwfc [url=http://csrhelix.com]canada goose sverige[/url]
mxmgeb 952953 [url=http://www.chilliwackbombersoutlet.com]canada goose decoys for sale[/url] 429042 [url=http://www.beatsbydreaonsales.com]beats by dre christmas sale[/url]

3:01 AM  
Anonymous Anonymous said...

[url=http://www.mulberryinoutlet.co.uk]Mulberry Alexa[/url] Wool, leather and fur were used most often. [url=http://dkgoose.com]canada goose[/url] Kcrqgxdfl [url=http://www.louboutinoutletuks.co.uk]christian louboutin outlet uk[/url]
qsknhr 729008 [url=http://www.chilliwackbombersoutlet.com]canadian geese eggs[/url] 218628 [url=http://www.beatsbydreaonsales.com]beats by dre christmas sales[/url]

8:51 AM  
Anonymous Anonymous said...

http://bestlouboutinshop.co.uk He's had enough of his parents lavishing more attention to their crops and sheltering him so as to skirt the law. [url=http://dkgoose.com]canada goose[/url] Jtoqtoyui [url=http://www.louboutinoutletuks.co.uk]christian louboutin uk[/url]
oqwmfh 899093 504318 [url=http://www.beatsbydreaonsales.com]dr dre[/url]

12:44 AM  
Anonymous Anonymous said...

http://www.sheisunique.com/content/chariot-payday-loans-online-no-credit-check

12:06 AM  
Anonymous Anonymous said...

Cheap Payday Loans Online http://legitpaydayloansonline2.com/ Fundpopog Payday loans online Stype [url=http://legitpaydayloansonline3.com/]payday loans online[/url] Payday Loans Online Direct Lenders In this economy, payday loans and cash your private rejection without having to visit the lender's office.Their senses did not betray the truth that they cannot stay becoming you have income and/or employment!Should you choose chapter 7, your homepage employed prime repay are information and assistance you can find.

3:46 AM  
Anonymous Anonymous said...

Your means of telling the whole thing in this piece of writing is actually good, all can
effortlessly be aware of it, Thanks a lot.


Here is my page: www.2013rolexfreeshippig.com

12:00 PM  
Anonymous Anonymous said...

I’m not that much of a online reader to be honest but your sites really
nice, keep it up! I'll go ahead and bookmark your website to come back down the road. All the best

Also visit my web site ... ロレックスレプリカ

1:29 PM  
Anonymous Anonymous said...

Great blog here! Also your web site loads up very
fast! What web host are you using? Can I get your affiliate link to your host?
I wish my site loaded up as fast as yours lol

Feel free to visit my web page; rolexコピー

12:03 AM  
Anonymous Anonymous said...

I am sure this article has touched all the internet users, its really really fastidious post on building up new webpage.



Also visit my web blog :: ロレックスコピー

1:38 AM  
Anonymous Anonymous said...

Thanks , I've just been looking for information approximately this topic for ages and yours is the greatest I have found out till now. But, what concerning the bottom line? Are you sure concerning the source?

My web-site - rolexスーパーコピー

1:36 PM  
Anonymous Anonymous said...

Hola! I've been reading your site for a while now and finally got the courage to go ahead and give you a shout out from Kingwood Tx! Just wanted to mention keep up the fantastic job!

Stop by my web page: コーチバッグ

2:35 PM  
Anonymous Anonymous said...

It's an remarkable piece of writing designed for all the web users; they will take benefit from it I am sure.

Visit my web page ... サングラス オークリー

1:39 AM  
Anonymous Anonymous said...

I blog frequently and I seriously thank you for
your content. Your article has really peaked my interest.
I am going to book mark your site and keep checking for new information about once per week.

I subscribed to your RSS feed as well.

Feel free to surf to my blog post chloe 財布

6:09 PM  
Anonymous Anonymous said...

What a stuff of un-ambiguity and preserveness
of valuable familiarity on the topic of unpredicted emotions.


Also visit my blog post - www.bringnewshoes.com

4:08 PM  
Anonymous Anonymous said...

all the time i used to read smaller articles or reviews that
as well clear their motive, and that is also
happening with this article which I am reading now.


Visit my homepage レイバンサングラス

3:17 AM  
Anonymous Anonymous said...

I am really grateful to the holder of this web site who has shared this impressive piece of
writing at here.

Also visit my blog post; クロエバッグ新作

8:20 AM  
Anonymous Anonymous said...

It's awesome in favor of me to have a web site, which is valuable for my knowledge. thanks admin

Look into my web site :: ロレックスコピー

7:19 PM  
Anonymous Anonymous said...

It is the best time to make some plans for the long run and
it's time to be happy. I've read this submit and if I may
I desire to suggest you some interesting issues or suggestions.
Perhaps you can write next articles relating
to this article. I desire to read more things about it!

Visit my blog post エアジョーダン

4:16 AM  
Anonymous Anonymous said...

Greetings from Los angeles! I'm bored to tears at work so I decided to check out your site on my iphone during lunch break. I love the info you present here and can't wait to take a look when I get home.
I'm surprised at how quick your blog loaded on my mobile .. I'm not even
using WIFI, just 3G .. Anyways, wonderful site!

Feel free to visit my web-site monster beats

6:20 AM  
Anonymous Anonymous said...

Hey, I think your site might be having browser compatibility issues.
When I look at your website in Safari, it looks fine but when opening in Internet Explorer, it has some overlapping.
I just wanted to give you a quick heads up! Other then
that, superb blog!

Visit my webpage - サングラス オークリー

3:32 PM  
Anonymous Anonymous said...

Oh my goodness! Awesome article dude! Many thanks,
However I am experiencing troubles with your RSS. I don't understand why I am unable to subscribe to it. Is there anyone else having similar RSS issues? Anyone that knows the answer can you kindly respond? Thanx!!

My web-site: http://www.pradahandbagsoutletssale.com

7:16 PM  
Anonymous Anonymous said...

I'm really enjoying the theme/design of your web site. Do you ever run into any web browser compatibility issues? A small number of my blog audience have complained about my blog not operating correctly in Explorer but looks great in Firefox. Do you have any solutions to help fix this issue?

My web site - ロレックスレプリカ

9:18 PM  
Anonymous Anonymous said...

I am regular reader, how are you everybody?

This paragraph posted at this web page is in fact fastidious.


Feel free to visit my website; monster beats

2:14 AM  
Anonymous Anonymous said...

Great blog! Do you have any tips for aspiring writers?
I'm hoping to start my own blog soon but I'm a little lost on everything.
Would you recommend starting with a free platform like Wordpress or go for a paid option?
There are so many options out there that I'm completely confused .. Any tips? Thanks!

Also visit my weblog ... オークリーメガネ

3:15 AM  
Anonymous Anonymous said...

Good site you've got here.. It's difficult to find high quality writing like yours nowadays.
I honestly appreciate individuals like you! Take care!
!

Have a look at my page :: オークリー

11:21 AM  
Anonymous Anonymous said...

I write a comment each time I especially enjoy a post on a site or I have something to valuable to contribute to the conversation.
Usually it is triggered by the sincerness communicated in the post I
read. And on this post "ORA-20000错误".
I was excited enough to leave a comment :-) I do have 2 questions for you if it's allright. Could it be only me or do a few of the responses look like they are left by brain dead people? :-P And, if you are posting at other places, I'd like
to follow you. Would you list every one of your
communal pages like your linkedin profile, Facebook page or twitter feed?


Here is my web page - アバクロンビー

1:25 PM  
Anonymous Anonymous said...

I think this is one of the most vital info for me.
And i am happy reading your article. However wanna observation
on some common things, The website style is ideal, the articles
is in point of fact excellent : D. Good process, cheers

My page: シャネルバッグ

2:36 PM  
Anonymous Anonymous said...

This piece of writing will help the internet viewers for creating new website or
even a blog from start to end.

Feel free to surf to my page アバクロンビーフィッチパーカー

3:20 PM  
Anonymous Anonymous said...

I read this post completely about the comparison of latest and previous
technologies, it's remarkable article.

My blog; 眼鏡レイバン

3:22 PM  
Anonymous Anonymous said...

Its like you read my mind! You seem to know a lot about this, like you wrote the book in it or something.
I think that you could do with some pics to drive the message home a
little bit, but instead of that, this is wonderful blog.
An excellent read. I will certainly be back.

Visit my page ルイヴィトンコピー

3:47 PM  
Anonymous Anonymous said...

Wow! After all I got a blog from where I be capable of genuinely obtain valuable data concerning my
study and knowledge.

Stop by my homepage ... ルイヴィトン

7:56 AM  
Anonymous Anonymous said...

Hi colleagues, its wonderful article concerning
cultureand completely explained, keep it up all the time.

Here is my site ロレックスレプリカ

11:56 AM  
Anonymous Anonymous said...

Greetings from Idaho! I'm bored at work so I decided to browse your website on my iphone during lunch break. I love the information you present here and can't wait to
take a look when I get home. I'm surprised at how quick your blog loaded on my phone .. I'm not
even using WIFI, just 3G .. Anyways, excellent site!



Also visit my page; www.airshoeshanbai.com

5:55 PM  
Anonymous Anonymous said...

If you are going for best contents like me, simply visit this web page daily because it provides quality contents, thanks

Feel free to visit my weblog - シャネル財布

2:01 PM  
Anonymous Anonymous said...

Excellent, what a webpage it is! This webpage presents valuable information to us, keep
it up.

my weblog ... エアジョーダン

6:55 AM  
Anonymous Anonymous said...

Helpful information. Fortunate me I discovered
your site accidentally, and I'm stunned why this twist of fate didn't
came about earlier! I bookmarked it.

My page: シャネルバッグ

7:40 AM  
Anonymous Anonymous said...

Everyone loves what you guys are usually up too. Such clever work and reporting!
Keep up the superb works guys I've included you guys to our blogroll.

My web-site; アバクロ

7:41 AM  
Anonymous Anonymous said...

Hey there just wanted to give you a quick heads up.
The text in your post seem to be running off the screen in Opera.
I'm not sure if this is a format issue or something to do with web browser compatibility but I figured I'd post
to let you know. The layout look great though! Hope you get the issue resolved soon.
Cheers

my blog ... monster beats

7:44 AM  
Anonymous Anonymous said...

My brother suggested I may like this website. He was once entirely right.
This publish actually made my day. You cann't imagine just how a lot time I had spent for this info! Thank you!

Take a look at my website モンスター イヤホン

7:44 AM  
Anonymous Anonymous said...

I simply could not go away your site before suggesting
that I actually loved the standard information an individual supply on your visitors?
Is gonna be again regularly to investigate cross-check new posts

Also visit my homepage :: http://www.vuittonpursefreeshippingjp.com/

7:46 AM  
Anonymous Anonymous said...

I have learn a few good stuff here. Certainly price bookmarking for revisiting.
I surprise how so much attempt you put to make such a excellent
informative site.

Feel free to visit my web-site: モンスターヘッドホン

7:54 AM  
Anonymous Anonymous said...

Having read this I believed it was rather enlightening. I appreciate you taking the time and effort to
put this short article together. I once again find myself spending way too much time both reading and leaving comments.
But so what, it was still worth it!

Here is my homepage ... prada 財布

9:39 PM  
Anonymous Anonymous said...

Pretty section of content. I just stumbled upon your blog and in accession capital to assert that I acquire in fact enjoyed account your blog posts.
Anyway I'll be subscribing to your augment and even I achievement you access consistently quickly.

Also visit my blog post monster ヘッドホン

1:37 AM  
Anonymous Anonymous said...

Quality content is the important to invite the visitors to visit the site, that's what this web page is providing.

Have a look at my website - ヴィトン

2:29 AM  
Anonymous Anonymous said...

Hey there! I've been reading your website for a long time now and finally got the courage to go ahead and give you a shout out from Huffman Texas! Just wanted to tell you keep up the fantastic job!

My web site ... グッチ

11:55 AM  
Anonymous Anonymous said...

Great blog you have got here.. It's difficult to find quality writing like yours nowadays. I seriously appreciate individuals like you! Take care!!

Check out my weblog: http://www.numipedia.pl/index.php?title=Dyskusja_u%C5%BCytkownika:KlaudiaYJ

7:35 PM  

Post a Comment

<< Home