Database DataWarehousing (MOSC)

MOSC Banner

Upgrading OWB repository from 11.2.0.2 to 11.2.0.3 and process hanging??

edited Apr 24, 2014 4:09AM in Database DataWarehousing (MOSC) 3 commentsAnswered ✓


I am trying to upgrade a OWB repository from 11.2.0.2 to 11.2.0.3. I am running the process:

./rt_mgr.sh OWBSYS password server.domain 1521 servicename

It has been running for 22 hours. It is running a java program connecting with the owbsys account to the database. I don't see any blocking locks. Status of the process is showing as "inactive", but I don't know if that is meaningful. Looking at waits on the session (via Toad), Description is "Waiting for SQL*Net message from client - waited 80654 seconds, so far". Current statement is the following:

INSERT  INTO w_r_i$_OWBREP_OWBREP

VALUES

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