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

Last updated on JANUARY 26, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.1 to 11.2.0.4 [Release 11.2]
Information in this document applies to any platform.

Symptoms

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

 

Changes

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

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms