So at one time or another most of us have run into an issue where no matter what we install or try we just can’t get a unix system to throw an x window for anything. Well I personally have run into this issue often enough that I thought I would throw together a quick blog about how I usually get around this problem by using the -silent install switch for creating a database. I use a similar process for installing the Oracle software as well.
Now there are a few ways that you can go about doing this.
The first option is you can make a copy of the dbca.rsp file that is found under the directory that you unzipped the install files “../database/response/dbca.rsp”. Then you can take on the task of editing this massive file to get the database setup exactly how you want. Sometimes this is the only option you have and you have to suffer through it. Then you use the command: dbca -silent -responseFile dbca.rsp
The next option is to do a quick install of a database template by using the below dbca command with your settings in the proper places.
dbca -silent -createDatabase -templateName General_Purpose.dbc -gdbname ora12c -responseFile NO_VALUE -characterSet AL32UTF8 -memoryPercentage 40 -emConfiguration LOCAL
After you issue the above command it will ask you for a password. Once you enter the password it will start the database creation. Now this command will use the General_purpose.dbc template to create the files in their respective locations according to the templates settings. Now that’s great for a quick database that you can play with, but it’s by no means good enough for a production database. There are several reasons why; for instance the redo log members aren’t multiplexed by default.
The quicker/easiest option in my opinion; is to actually start dbca on a similar OS that can throw an x window and run through the screens and at the end save the configuration as a template file. You can then use that template file in the example above in place of the General_Purpose.dbc and even get rid of a few more of the options/switches.
Well that’s all for now. I hope this helps someone who has been in a similar situation. If you would like to see a more detailed write up please let me know and I will make it happen.