Oracle and sqmax

[John Brooks_1]

Does anyone know if these two have anything in common? My SA installed PHNE_33395 and never set the parameter SQMAX to 1000 and now I am having problems starting my concurrent managers. I am unable to find any additional in formation any where. How is it used?

This is the error message in my log file:
++++++++++++++++++++++
Starting FNDCRM Concurrent Manager : 23-JAN-2006 09:56:29

Could not start Service Manager FNDSM_AMSYS5_FINPROD. The TNS alias could not be located, the listener proces
s on AMSYS5 could not be contacted, or the listener failed to spawn the Service Manager process.
Routine AFPEIM encountered an error while starting concurrent manager FNDCRM with library /d03/oracle/prodapp
l/fnd/11.5.0/bin/FNDCRM.

Check that your system has enough resources to start a concurrent manager process. Contact your system a : 2
3-JAN-2006 09:56:29
+++++++++++++++++++

This repeats for every concurrent manager on the system.

The patch was added to the system just prior to the error. I am just trying to eliminate possible causes.

Thanks for the help.

[Steven E. Protter · Accepted solution]

I can't find any connection between that parameter and anything in the Oracle database.

Is it checked for a certain value at installation time?

SEP

[John Brooks_1]

The HP patch says to set it to 1000, which my SA is planning on doing. You need to run an additional script to set it. I am just trying to eliminate the HP patch causing my Oracle problem. There is no information on METALINK for sqmax, so maybe it is nothing. The HP patch was a security patch.

[Sameer_Nirmal]

Hi,

"sqmax" is a utility name which is used to set a internal system parameter.

Refer my reply at
http://forums1.itrc.hp.com/service/forums/questionanswer.do?threadId=989260

More details could be found at
http://www1.itrc.hp.com/service/cki/search.do?category=c0&prevQueryString=%22local+bus+adapter%22&mode=text&searchString=+HPSBUX02087&searchCrit=allwords&docType=Security&docType=Patch&docType=EngineerNotes&docType=BugReports&docType=Hardware&docType=ReferenceMaterials&docType=ThirdParty&dateRange=all

[Simon Wickham_6]

Hi,

sqmax relates to a internal system parameter. I beleive this internal system parameter is related to streams.

As for the required patch this relates to cumulative ARPA Transport patch.


Regards,
Simon