Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Share tablespace between OLTP and OLAP

873797Aug 11 2015 — edited Aug 12 2015

Hello experts,

Do you see any down side of putting OLAP and OLTP objects in one single tablespace? performance, maintainability or otherwise?

Thanks!

Comments

678145
ORA-28056: Writing audit records to Windows Event Log failed
Cause: Unable to write an audit entry to the Windows event log used as the audit trail.
Action: Check the error number for a possible operating system error. If there is no error, contact Oracle Support Services.
Satish Kandi
Guessing here. Can you try making a backup of the event viewer in Windows and truncating the same after backup and then repeat this operation?
685051
Hello,

Clear the Event Logs. This solved the problem for me after updating from 11.1.0.6 to 11.1.0.7.

Control Panel --> Administrative Tools --> Event Viewer --> Clear All Events

Increase the log size.
shamg
Clearing event logs helped. thanks for the solution
EdStevens
So how about marking answers as "helpful" or "correct" and flagging the thread as "answered" ....
FusionUser
Do like our friend said. Control Panel --> Administrative Tools --> Event Viewer --> Clear All Events. After open the CMD, write "sqplus /nolog" and press enter. now, write "connect as sysdba", enter the user name, for example, "sys" and the password. After connect, write "startup". Tell if works.

tip: Grown the space of the Event viewer. you only need to right click th type of event, for example, "application" --> "properties" and grown the size. You should mark "change when necessary" too. You shouldn't have more problems like this now.

Edited by: lucas rehem on 09/09/2010 11:04
775294
Hi All,
I got the same error while creating new db using dbca for Oracle11gR2.
So cleared all events log as suggested above which helped database creation to completed successfully.

Cheers
Haider

Edited by: haider.ali on 31-Oct-2010 14:05
818057
I would ask Tom Kyte. Although he dismisses ORA errors as ambiguous, he told me so at Oracle World 2010. Better off re-installing Windows Server 2008
818057
I would also consider migrating OS to Red Had LINUX 5.x or higher. Very much gooder than Windows Server 2008
818057
Did Oracle Server upgrade migrate sucessfully? I am getting a red X. I will check out the log when I am done assuming Sun Spots do not occur first.
812975
clearing event log solves the problem.. even I faced this problem using DBCA in 11g R2.
This thread should be marked as answered.

Edited by: Saad on Jan 2, 2011 6:43 AM
sb92075
This thread should be marked as answered.
OP last posted to forum about 1 year ago.
I doubt your requested will be seen and honored.

Why do you resurrect zombie posts?
865824
The solution is simple go to Control Panel->Administrative Tools->Event Viewer->Clear All Events and then run the configuration wizard again













Regards
Amit Mishra
788487
Thanks ,
It helped me to solve the error
EdStevens
862821 wrote:
The solution is simple go to Control Panel->Administrative Tools->Event Viewer->Clear All Events and then run the configuration wizard again













Regards
Amit Mishra
I wonder how many times we can resurrect an old thread (now over two years since the OP) to restate, yet again, that the solution is to clear the Windows event log?
1 - 15
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Sep 9 2015
Added on Aug 11 2015
10 comments
620 views