Turing's Man Blog
- Last Updated on Saturday, 26 January 2013 17:44
- Published on Tuesday, 01 January 2013 22:10
- Written by Pawel Wawrzyniak
- Hits: 20189
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:
Export DISPLAY variable:
$ export DISPLAY=turingsman:0.0
Then we can execute DBCA with the following command – of course, as an oracle user:
On the Welcome screen we click "Next".
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).
Then we have to select type of our database in the second step: "General Purpose or Transaction Processing".
Please click "Show Details…" button to see what database components are required for such type of database.
Step 3. We have to provide Global Database Name and SID (System Identifier) of our database.
Step 4. Leave the default values for "Enterprise Manager settings" and "Automatic Maintenance Tasks".
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.
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):
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.
Step 7. Remember to select a proper database files location – in our case: /u01/oradata.
Step 8. We can leave default values for our purposes.
Step 9. Yes, we should add sample schemas – this will be very usable in our future exercises (especially, famous Human Resources schema).
Step 10. Default values – only remember to set Unicode for national characters encoding.
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).
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.
And then – it's done.
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.