on 08-24-2014 7:55 AM
Hi ,
I am trying to connect oracle database using workbench. Connection test succeeded but I am getting the error like Cannot retrieve children nodes - browse remote error: Oracle <orcl> error message for operation <OCIStmtFetch>: <ORA-24338: statement handle not executed.
I have tried with designer, I can import table by table but I cannot browse all the metadata.
Please find the screenshots for reference
Please help me how to resolve this issues.
Thanks & Regards,
Ramana.
Hi Ramana,
Same Issue i faced in BODS 4.1, Please do the below activity.
I have seen these Oracle messages when the database runs out of sessions or processes. Ask your DBA to execute the following commands:
And then restart the database to take effect. If your DBA does not know what that is, forget it, it is just another optimization with its own pros and cons.
Regards,
Daya Jha
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Daya,
Thanks for your response. I have tried already with above options but I am facing the same issue. I changed the parameters values and I restarted the oracle services.
I am not only facing the issue for workbench. If I click on the oracle data store also I am getting the below error.
Thanks & Regards,
Ramana.
User | Count |
---|---|
84 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.