Turing's Man Blog

Part 6. Oracle Database 11gR2. Creating database with Database Configuration Assistant

Bookmark and Share

We will now run DBCA – Database Configuration Assistant – for our freshly installed Oracle 11gR2. This tool will help us to create a database for our further explorations. Therefore, we will not go into the details of DBCA too much. Our plan is to create the general purpose database. Also, we have to run this tool separately, because we skipped DBCA step during Oracle Universal Installer installation process (see part 5). This was due to the lack of "Seed_Database.dbf" – which in fact can be found on the Oracle Database 11gR2 installation disks and was lost during copying operation (on OTN forum some people claim that "Seed_Database.dbf" file can be lost during unzipping operation – unfortunately, no other details are provided). So, let's start.

 

First of all, we have to be sure, that our environment is properly configured – especially, when it comes to the paths etc. Check with the "env" command:

$ env
HZ=
SHELL=/bin/bash
TERM=xterm
LD_LIBRARY_PATH=/u01/app/oracle/product/11.2.0/dbhome_1/lib
ORACLE_SID=TURINGSMAN
ORACLE_BASE=/u01/app/oracle
MAIL=/var/mail/oracle
PATH=/usr/bin::/usr/local/bin:/u01/app/oracle/product/11.2.0/dbhome_1/bin
PWD=/export/home/oracle
LANG=en_US.UTF-8
SHLVL=1
HOME=/export/home/oracle
LOGNAME=oracle
ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1
_=/usr/bin/env

 

Export DISPLAY variable:

$ export DISPLAY=turingsman:0.0

 

Then we can execute DBCA with the following command – of course, as an oracle user:

$ dbca

 

On the Welcome screen we click "Next".

 

DBCA, Welcome screen

 

DBCA consists of 12 steps. In the first step we have to select: "Create a Database" option (other options are unavailable, except "Manage Templates", because there is no database yet in our system).

 

DBCA, step 1

 

Then we have to select type of our database in the second step: "General Purpose or Transaction Processing".

 

DBCA, step 2



Please click "Show Details…" button to see what database components are required for such type of database.

 

DBCA, step 2

 

Step 3. We have to provide Global Database Name and SID (System Identifier) of our database.

 

DBCA, step 3

 

Step 4. Leave the default values for "Enterprise Manager settings" and "Automatic Maintenance Tasks".

 

DBCA, step 4

 

Step 5. However, this is not recommended – especially in production environment (in fact, not allowed for security reasons!) – we can make things easier and set the same passwords for all administrative accounts (SYS, SYSTEM, DBSNMP, SYSMAN). All in all, we're working in test environment and this is only a kind of reconnaissance. Also, please note, that all passwords can be changed in the future. For now, we can go with less secure option – let's set the same password for all mentioned accounts.

 

DBCA, step 7

 

Step 6. As it was mentioned before – we've skipped DBCA step during OUI installation process because "Seed_Database.dbf" file (database template file) was not found. This issue was reported several times by some people here and there, including OTN forum. There were many suggestions on what to do, including – manual database creation (in my opinion – a good challenge for experienced DBAs) or downloading Oracle Database 11gR2 installation disks once again from OTN. Well, maybe re-downloading is a good idea, if we're sure that our installation disks became corrupted. The question is then – how it was possible to install Oracle database from such installation media to this moment? In my case, the most reasonable explanation is that – after several copying operations between volumes (including the issue with required disk resize operation etc.) I – somehow – lost this file. Therefore, I decided to look into the Oracle installation disk for "Seed_Database.dbf". I found this file under the following location (check inside disk 2):

D:\Pawel\OraSol\solaris.x64_11gR2_database_2of2.zip\database\stage\Components\oracle.rdbms.install.seeddb\11.2.0.1.0\1\DataFiles\Expanded\filegroup1

 

Seed_Database.ctl file location

 

So, I copied this file to the previously mounted /mnt/sf_OraSol directory on my Solaris virtual machine and told DBCA (via "Browse…" button) where it is. This was a good idea. No additional software downloading from DBCA, no hand made database creation etc.

 

DBCA, step 6a

 

DBCA, step 6b

 

Step 7. Remember to select a proper database files location – in our case: /u01/oradata.

 

DBCA, step 7

 

Step 8. We can leave default values for our purposes.

 

DBCA, step 8

 

Step 9. Yes, we should add sample schemas – this will be very usable in our future exercises (especially, famous Human Resources schema).

 

DBCA, step 9

 

Step 10. Default values – only remember to set Unicode for national characters encoding.

 

DBCA, step 10a

 

DBCA, step 10a

 

DBCA, step 10b


Step 11. Database Storage. Default values – we will not change anything or add any file. Please only refer to the files locations to be sure, that everything will be installed in the desired place (control files, data files and redo logs).

 

DBCA, step 11

 

DBCA, step 11a

 

DBCA, step 11b

 

DBCA, step 11c

 

DBCA, step 11d

 

Step 12. Select "Crate Database" and click "Finish". "Confirmation" window will be opened – just refer to all presented database details to once again confirm all our decisions and click "OK". The database creation process will be launched.

 

DBCA, step 12

 

DBCA, step 16a

 

DBCA, step 12b

 

DBCA, step 12c

 

DBCA, step 12d

 

And then – it's done.

 

DBCA, finished

 

We have now created our first database, which includes exemplary schemas. In the next part we will verify that all basic configuration files are defined correctly and we can easily operate our database with provided tools.

 

 

Bookmark and Share

Comments   

 
0 #4 Garima 2013-12-07 14:35
lukeluke,

Have you set the DISPLAY value for GUI tool,

display value need to be set for your windows server where you are using the GUI tool (exceed or any other). Also please check the server you are acessing can be accessed through the remote /local machine. i have faced the similar kind of issue where one of my onsite server i was trying to create from my local windows PC. I have accessed the same through onsite windows server and get this done. It might help you also.
export DISPLAY=
and then run the dbca.
Quote
 
 
0 #3 alyssa 2013-11-16 17:34
thanks for the information ~ it helps for my assignments :) :P
Quote
 
 
0 #2 Turingsman 2013-06-29 10:55
This can be almost everything, but for sure it is related to Oracle prerequisites or system configuration. You have to meet Oracle requirements before actual installation, so prepare your system correctly – check all the prerequisites in this tutorial and Oracle documentation, especially for required OS patch level, RAM and swap availability, file permissions etc. Are you sure your display is set correctly? Check what is written in the logs, too. We have to be very careful when dealing with the Oracle stuff.
Quote
 
 
0 #1 lukeluke 2013-06-16 18:41
It's very strange when I'm running dbca. Nothing happened before it returns to the prompt. :sad:
Quote
 

Add comment


Security code
Refresh