I'm a developer working on an application team that supports a system with one production database and 4 test databases (2 Dev, a SIT and UAT environment).
The prod database exists on it's own Unix server and the 4 test databases all live on a different Unix server. For various reasons, over the years these 6 databases have become quite out sync with regards to their Initialization Parameters. A quick comparison of the V$Parameter table reveals a number of key setting differences that have been causing our application team problems and need to be corrected.
I'm working with our DBA team now to try and correct them but it is a large Enterprise and the process is painful. I'd love to find a way to keep these parameters better in line for those databases that share the same server.
Is there a way to have multiple databases share a parameter file? I reviewed some documentation and saw some references to doing this for a RAC setup but these databases aren't clustered but rather just copies of one another. I know certain parameters like
db_name would need to be unique but I was wondering if common settings like
resource_limit could be centralized somehow?
Note I'm currently using 11G but we plan to upgrade to 12 within a month.