Turing's Man Blog

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

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.

Read more...

Part 5. Oracle Database 11gR2 installation with Oracle Universal Installer on Solaris 11.1

We will now install Oracle Database 11gR2 with Oracle Universal Installer, which we have successfully run in the end of part 4 of this series. After Oracle Database 11gR2 binaries installation we will create and configure a database instance with the dedicated tool – Oracle Database Configuration Assistant (DBCA). Although, usually DBCA is run in the last stage of OUI installation process, this is not a rule. If the Oracle database environment is configured properly, we can run DBCA at any given moment to handle database instances in our system. Also, we can run DBCA separately, if OUI reported some non-critical errors which prevented successful database creation – as in our case here.

Read more...

Part 4. Oracle Database 11gR2 prerequisites. Before actual installation on Solaris 11.1

We have configured our fresh Oracle Solaris 11.1 (x86/64-bit) installation. Now we can start preparations for Oracle Database 11gR2 binaries installation. Let's check all the prerequisites – as presented in the official documentation – and then run the installation process with Oracle Universal Installer (OUI).

Read more...

Part 4A. Clone VDI helps with Oracle VirtualBox virtual disks resize operations

I created a 20 GB virtual disk drive for Solaris 11.1 and Oracle DB 11gR2. This was really too small and the most comfortable thing I could do was to use Clone VDI 2.10. This is small, simple and very useful piece of software – really recommended for all Oracle VirtualBox users. Not only we can clone our virtual hard disks, manage their UUIDs, perform compacting, but also easily resize disks.

Read more...

Part 3. Installing Gnome for Oracle Solaris 11.1 (x86/64-bit)

Now, as we have basic Oracle Solaris 11.1 installed on our virtual machine, we will need to have a graphical desktop environment installed, too. It's required by the Oracle Universal Installer (OUI) application we will use to install Oracle Database 11gR2.

Read more...