Siebel System Admin, Install and Upgrade (MOSC)

MOSC Banner

Upgrep process Hung - It was running for more than 24 hrs

edited Nov 21, 2014 10:03AM in Siebel System Admin, Install and Upgrade (MOSC) 2 commentsAnswered

Hello Experts -

We are Upgrading from 8.1.1.6 SEA (sql 2005, windows 2003) to 8.1.1.11 SIA (SQL 2012, windows 2012)

I have started upgrade in windows 2012 env

Upgrep process did not complete, on further analysis found that following SQL doesn't give any result, keeps running though.


Can you please let me know what does this do ? And how to fix it ?


This SQL is in  repos_upgrade.sql

insert into TMP_DUP_UKA(REPOS_NAME,TBL_NAME,UK_NAME,UKA_NAME,UKA_ROW_ID) 

select R.NAME                                  

,      T.NAME                                  

,      UK.NAME                                 

,        C1.NAME                               

,      UKA.ROW_ID                              

from S_REPOSITORY    R

,    S_TABLE         T

,    S_USER_KEY      UK

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center