Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

What is guidance on the CREATE DATABASE statement for a new Oracle 12 database for use with Jira 8.5

Fadl Abideen
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
July 21, 2020

I have seen the documentation online with respect to database user creation, permissions, and connection, but nothing with regards to actually creating the new database. Therefore, I have some questions in regards to a new Oracle 12 database creation. They are the following:

1. What are the memory requirements for the database? (PGA/SGA allocation?)
2. Are there any sizing requirements for oracle SYS/SYSAUX/USERS tablespaces?
3. I'm assuming when I create the 'jiradbuser' I will be assigning them to the USERS tablespace, correct?
4. What are the recommended number/sizing of redo log files, if needed, for the new database?

If I can get some clarification on the above, that will help me get started. Thanks

0 answers

Suggest an answer

Log in or Sign up to answer