Issue While Starting Third Party Application Resource - PostgreSQL Via CRS
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
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