Skip to Main Content

SQL & PL/SQL

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!

Error ORA - 03127

569125Apr 30 2007 — edited Apr 30 2007
Hi,

I am facing error ora-03127 no new operations allowed untill the active operations end while selecting from table, after updating data in clob columns.

Table structure is as follows :

prj_operations_plan
---------------------------
plan_id varchar2(30)
oper_id varcahr2(30)
updt_no number(3)
text clob
sd_var sd_obj

* Here I am appending some texts to the "text" clob data.
* Proc is executed without any error.
* I got all texts appended in "text" column.

But when I have fired select query in table like ( in plsql developers's sql window)

select * from prj_operations_plan;

It gives me above mentioned error.

Kindly help.

Regards,
Rushang.

Message was edited by:
Rush

Comments

Udo
Hi Tammy,

I found out that there seems to be a bug in the listenerAdmin concerning the proper initialization for the config file. If you start the application and try to run listenerAdmin or listenerConfigure, the Listener seems to default to the tmpdir without regarding any other location.
I can now refine my previous post on what exactly has to be done with the current listener to take a config file from a location different that the default tmpdir:

1. create an apex-config.xml
2. place it into the desired directory
3. start the webapp
4. NOT run listenerAdmin, but /apex right away. Only in that part of the Listener there seems to be the proper initialization for the config file. Once you started in /apex, you'll (hopefully) see in your log that the Listener chose the right config file
5. if needed edit the config via listenerAdmin afterwards.

Note that the listenerAdmin still considers itself as unconfigured, though APEX might already be running successfully if the provided config file has the correct parameters.
As soon as you save that configuration (not necessarily changing anything), the Listener stores the "new" configuration (and probably some state information) and from that point on it will always accept that configuration file. If you call listenerAdmin again afterwards, you'll not be able to change the login credentials any more, which would have been possible in the first run.

Quite weird workaround, but it works for me.

-Udo
589721
This workaround works for me - thank you so much. One note that might save some time for others...if you change the default root from apex (or use a different name than apex.war), the URLs provided in the WLS testing page will not work. Just add "/apex" to the end of these URLs. For example: http://host:port/apex_db1/apex

I hope that the process of deploying multiple listeners will be simplified with future releases. I would like the capability to specify different configuration file names, i.e. apex-config-db1.xml, apex-config-db2.xml and to be able to specify these through the listenerAdmin instead of in the web.xml.
Udo
Hi Tammy,

I'm glad you have it working now!
I think, the ease of use for the configuration file already hits for a single instance. But configuring the applications config-file via the application itself might be a bit difficult. Since the Listener is supposed to support multiple J2EE containers: Where would you store the information for the config-file location if not in the web.xml or another (proprietary) static file in the applications context?

-Udo
Arndt Binninger
Hi Udo,

I followed your steps and were able to bring up Listener with correct config location. But when I try to change the database connection parameters via listenerAdmin the fields were greyed out so I'm not able to change them.

Any idea?

Regards,
Arndt
Igor Kortchnoï
Apparently, when one changes the default apex-config.xml location to another one, listenerAdmin's DB connection section (user, password, host, port & SID/service name) becomes protected, but not other sections.
Udo
Hi Anrdt,

it seems that this is the intended behaviour: database configuration is treated as a once-and-forever item. You can of course change the parameters in the config file itself, but the listenerAdmin is never able to edit that part at runtime. I guess this is due to the fact that once you've configured the connection parameters, you have a living connection pool you'd have to reset. This might cause more trouble as this reset might be seen as an invisible side-effect and may not even be supported without application restart on some platforms.

So, if you intentionally want to reconfigure, change the file (or even delete it) or redeploy using another config location.

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

Post Details

Locked on May 28 2007
Added on Apr 30 2007
4 comments
3,034 views