Please see my other blog for Oracle EBusiness Suite Posts - EBMentors

Search This Blog

Note: All the posts are based on practical approach avoiding lengthy theory. All have been tested on some development servers. Please don’t test any post on production servers until you are sure.

Wednesday, April 27, 2011

TNS-12531: TNS:cannot allocate memory

Symptoms
On windows platform, new client connections to the database through listener fails, "TNS-12531: TNS:cannot allocate memory" error found in listener.log.

Tuesday, April 26, 2011

How to Install Oracle 10.2.0.5 on MS Windows 7 / Windows 2008R2

Goal

Instructions to Install Oracle 10.2.0.5 on MS Windows 7 and MS Windows 2008R2.
These instructions can be used for either the Oracle Database software, or the Oracle Client software.

Sunday, April 24, 2011

TG4MSQL and slow response

If you see the "HS Message to agent" wait event for a long time while querying the SQL Server, first of all check that tracing is enabled and if it is enabled , disable it and rerun the statement again as tracing may cause the poor response.
I met this situation with one of the environment today where a query was taking the 4 minutes and SQL Server team confirmed that query does not take the 2 seconds to execute on the SQL Server itself. I investigated and found that tracing was On with debug option , just I remarked the related line in the TG init file (eg; E:\oracle\product\10.2.0\tg_1\tg4msql\admin\inittg4msql.ora) as below
#HS_FDS_TRACE_LEVEL=debug
and query returned the results in few seconds rather than 4 minutes.

Monday, April 18, 2011

Notify Report success/failure by mail

You can change the report configuration to notify the report failure or success by mail as below. Set Notification tag and pluginparam in report server's configuration file . Failnote.txt and succnote.txt files are found under
MT_OH\reports\templates