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.

corrupted indexes

ski123Sep 9 2009 — edited Jun 16 2010
Oracle 9.2. We have a job running slow suddenly. Normal run time is 2 hours, now it is 6 hours. The data volume is the same. we are wondering if the indexes is corrupted. How to find corrupted indexes?
Thanks

S.

Comments

JohnGoodwin
Answer

Are you sure nothing has changed? The only time I have seen this issue is when MaxL cannot be accessed due to missing environment variables.

For example - https://john-goodwin.blogspot.com/2012/03/odi-series-problems-using-prepost-maxl.html

Cheers

John

Marked as Answer by User_BP7C5 · Sep 27 2020
User_BP7C5

They upgraded Powershell to version 5.0    That shouldn't affect it should it?   Is there a service on the server for ODI that needs to be running?

JohnGoodwin

Something has affected it, whether it was that I can't say but if changes happened on the server and then errors have started appearing then could be linked.

Did you check the three environment variables to check if they are correct like in the link I posted?

User_BP7C5

I just did that and the ARBORPATH was missing so I added it.  Rebooted Server and trying again. 

Here's my PATH:

%SystemRoot%\system32;

%SystemRoot%;

%SystemRoot%\System32\Wbem;

%SYSTEMROOT%\System32\WindowsPowerShell\v1.0;

C:\Oracle\Middleware\EPMSystem11R1\common\ODBC-64\Merant\7.0\Drivers;

C:\Oracle\Middleware\EPMSystem11R1\bin;

C:\Oracle\Middleware\EPMSystem11R1\common\SAP\bin;

C:\Oracle\Middleware\EPMSystem11R1\opmn\bin;

C:\Oracle\Middleware\EPMSystem11R1\opmn\lib;

C:\Oracle\Middleware\EPMSystem11R1\perl\bin;

C:\Oracle\Middleware\ohs\bin;

C:\Oracle\Middleware\ohs\opmn\bin;

C:\Oracle\Middleware\ohs\opmn\lib;

C:\Oracle\Middleware\ohs\perl\bin;

C:\Oracle\Middleware\jdk160_35\bin;

%PATH%;

%ESSBASEPATH%\bin;

%CSAM_SOCKADAPTER%bin;

F:\Automation\7zip;

F:\TestEssbase\bin;

C:\Oracle\EPM Automate\bin;

%systemroot%\System32\WindowsPowerShell\v1.0\;

%EPM_ORACLE_HOME%\bin;

C:\Oracle\Middleware\EPMSystem11R1\common\EssbaseRTC-64\11.1.2.0\bin

User_BP7C5

ESSBASEPATH:

%EPM_ORACLE_HOME%\products\Essbase\EssbaseServer

User_BP7C5

ARBORPATH:

F:\Essbase

However everytime I reboot server it disappears.  I'm comparing our TEST environment to our PROD.   Do we need to re-run the configurator?  That scares me to be honest.

The jobs are now executing, so that's good.   No idea how the ENV's changed.

1 - 6
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Dec 25 2009
Added on Sep 9 2009
92 comments
23,048 views