January 7, 2009 09:04pm pst

1. markgeer 1,200
2. dvz 300

1. schwertner 220,821
2. slightwv 64,596
3. Pradeepg... 55,488
4. Henka 45,283
5. sdstuber 44,570
6. angelIII 42,965
7. rbrooker 33,690
8. RCorfman 31,331
9. BobMc 29,143
10. bmoshier 27,233
11. pennnn 27,077
12. catchmeif... 26,789
13. ploubier 26,544
14. DrSQL 24,227
15. dvz 24,145
16. nav_kum_v 23,198
17. sujit_kumar 21,558
18. MohanKN... 21,070
19. sonicefu 20,650
20. barthdev 19,451
21. ishando 17,756
22. Pontis 17,633
23. sujith80 16,713
24. baonguyen1 16,375
25. Tolomir 15,898

04.28.2004 at 06:25AM PDT, ID: 20970598

	[x] Attachment Details

ORACLE 8I SERVER HIGH WATER MARK ERROR

[x]

The Solution Rating System

With so many solutions, how can you tell which solutions are most likely to help you and which ones are not? To provide you with a tool to use, we rate our solutions based on various elements that most accurately determine if a solution is a quality solution. To explain what factors affect the solution rating, here are the elements we take into consideration when formulating our solution rating.

The Grade of the Solution
The Zone Rank of the Expert Providing the Solution
The Number of Author and Expert Comments
The Number of Experts Contributing
The Feedback of the Community

Your Input Matters
Because of the way the system is set up, the most important variable in this equation is you. As a member of Experts Exchange, you are able to cast your vote on the quality of the solutions in regard to how complete, accurate, helpful and easy to understand each solution is. When you provide your feedback, each rating is adjusted accordingly. So, if you see a solution that has a poor rating that you think is a good solution, let us know by rating it. As you do, the rating will be adjusted and will become more accurate for other members of our site.

If you have any suggestions that you would like to make for our rating system, please ask a question in the Suggestions Zone of Community Support.

Thank you!

8.8

Zone:

Oracle Product Info

Tags:

water, high, mark, oracle

Hi all,

My database was down this morning and I had to reboot to bring it back on, here is the alert log:

starting up 1 dispatcher(s) for network protocol '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Mon Apr 26 23:10:01 2004
alter database mount exclusive
Mon Apr 26 23:10:05 2004
Successful mount of redo thread 1, with mount id 4293447245.
Mon Apr 26 23:10:05 2004
Database mounted in Exclusive Mode.
Completed: alter database mount exclusive
Mon Apr 26 23:10:05 2004
alter database open
Picked broadcast on commit scheme to generate SCNs
Mon Apr 26 23:10:06 2004
Thread 1 opened at log sequence 3782
Current log# 2 seq# 3782 mem# 0: D:\ORACLE\ORADATA\BPDB2\REDO02.LOG
Successful open of redo thread 1.
Mon Apr 26 23:10:06 2004
SMON: enabling cache recovery
SMON: enabling tx recovery
Mon Apr 26 23:10:08 2004
Completed: alter database open
Tue Apr 27 23:03:04 2004
Shutting down instance (immediate)
License high water mark = 2
Tue Apr 27 23:04:09 2004
ALTER DATABASE CLOSE NORMAL
Tue Apr 27 23:04:09 2004
SMON: disabling tx recovery
SMON: disabling cache recovery
Tue Apr 27 23:04:09 2004
Thread 1 closed at log sequence 3782
Tue Apr 27 23:04:09 2004
Completed: ALTER DATABASE CLOSE NORMAL
Tue Apr 27 23:04:09 2004
ALTER DATABASE DISMOUNT
Completed: ALTER DATABASE DISMOUNT
Dump file D:\Oracle\admin\bpdb2\bdump\bpdb2ALRT.LOG
Wed Apr 28 08:57:15 2004
ORACLE V8.1.5.0.0 - Production vsnsta=0
vsnsql=d vsnxtr=3
Windows NT V4.0, OS V5.101, CPU type 586
Starting up ORACLE RDBMS Version: 8.1.5.0.0.
System parameters with non-default values:

Anyone knows why and the best fix? Thx!

#	Title
1	Jesus Walked on the Water
2	high_water_mark
3	WHAT IS THE BEST WHOLE HOUSE W…
4	Invisible Water Mark
5	Does Oracle High Water Mark Catch UP…
6	ora-01033 oracle initialization or s…