Database Configuration Assistant (DBCA) : Creating Databases 11g on Linux7.6
Create Databases 11g with DBCA
After installing Oracle Database 11g software, We have to create a database with dbca command with GUI
Actually, you can create the database together, when you install the software, but I need to manage the necessary database files to the location that I prepared.
log in to oracle user then command as below.
| # export DISPLAY=192.168.75.128:0.0 # dbca |
Template
- General Purpose or Transaction Processing for Database type is OLTP (Many concurrent users perform numerous transactions that require rapid access to data. Availability, speed, concurrency, and recoverability are key issues.)
- Custom Database (This template allows you the maximum flexibility in defining a database because you can change any of the settings for the database being created.)
- Data Warehouse for Database type is OLAP (complex queries that process large volumes of data. Response time, accuracy, and availability are key issues.)
