topic Oracle and sqmax in Operating System - HP-UX

Oracle and sqmax

John Brooks_1 — Mon, 23 Jan 2006 15:34:13 GMT

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.

Re: Oracle and sqmax

Steven E. Protter — Mon, 23 Jan 2006 16:40:44 GMT

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

Re: Oracle and sqmax

John Brooks_1 — Mon, 23 Jan 2006 16:55:59 GMT

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.

Re: Oracle and sqmax

Sameer_Nirmal — Mon, 23 Jan 2006 17:47:23 GMT

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

Re: Oracle and sqmax

Simon Wickham_6 — Tue, 24 Jan 2006 04:43:11 GMT

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