Problem description: When we try to connect to the OWB repository on production through the design center, it does not open up. It opens up very rarely.
Initial analysis done: It is not a problem with client. The same client is being used to connect to DEV and QA repositories.
There are lot of stale OWBSYS objects in the production database. And there are no stale objects present in DEV or QA. Although the stats were gathered on Prod, the objects still appear stale.
For the time being: team is using the node2 of Oracle instead of scan listener.
It works fine. There is some problem with node1 .When connected with Node 1, it keeps on running and there is no end to it.
Kindly help us in resolving this issue.
one of the possible cause could be you use up the space in the tablespace, check which tablespace your owbsys use, by default it is using user tablespace if you don't change it when you installed.