Oracle 12c Initialization parameters and permissions for jira

[Mojtaba]

We want to use oracle 12c for installing jira version 8.1.  can someone please share sample configuration for initialization parameters for database and the exact permissions which should be granted for user except what's are mentioned on below link?


https://confluence.atlassian.com/adminjiraserver071/connecting-jira-applications-to-oracle-802592181.html

grant connect to <user>;
grant create table to <user>;
grant create sequence to <user>;
grant create trigger to <user>;

[Nic Brough -Adaptavist-]

The parameters given in the doc you've found are the ones you need.

[Mojtaba]

Thanks Nik, but there were no parameters for oracle database in the document,  should we go with oracle default initialization parameters? 

[Nic Brough -Adaptavist-]

Yes.  The docs have some stuff about collation and regions, but for Oracle, there's almost nothing to do.  Where the doc gives you a specific setting, you will need to look at it.  Anything it does not explicitly have advice about, don't bother, set it to your DBs recommended standard.