My Oracle Support Banner

Issue While Starting Third Party Application Resource - PostgreSQL Via CRS (Doc ID 2215728.1)

Last updated on SEPTEMBER 16, 2021

Applies to:

Oracle Database - Enterprise Edition - Version to [Release 11.2]
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.


1.  Third party application PostgreSQL is added as a resource in CRS.

2.   Encountered below issue  while starting the third party application resource using "crsctl" :-

Whenever the customer trys to start the resource via CRS it failed with below error but it worked directly from the user. Output from scriptagent log file

2016-09-20 01:21:57.090: [pgdb][4045674240]{1:24576:9806} [start] waiting for server to start....LOG: invalid value for parameter "max_stack_depth": 2048
2016-09-20 01:21:57.090: [pgdb][4045674240]{1:24576:9806} [start] DETAIL: "max_stack_depth" must not exceed 1536kB.
2016-09-20 01:21:57.090: [pgdb][4045674240]{1:24576:9806} [start] HINT: Increase the platform's stack depth limit via "ulimit -s" or local equivalent.               <<<<<<<<< Here
2016-09-20 01:21:57.241: [pgdb][4045674240]{1:24576:9806} [start] 2016-09-20 08:21:57 UTC FATAL: configuration file "/xxxx/postgresql/data/postgresql.conf" contains errors



Intention is to register the PostgreSQL resource in Oracle Grid infrastructure as a third party application and manage it.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.