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 11.2.0.1 to 11.2.0.4 [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.
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
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
Symptoms |
Changes |
Cause |
Solution |