Subscribe to Blog via Email
Follow me on TwitterMy Tweets
I’m finally getting back to upgrading the Linux Source for a POC I’m doing with some folks and picking up from where we left off in Part I…
Now that we have our VNC Viewer working on our Amazon host, the first thing we’ll try is to run the Oracle installer, (unzipped location –> database –> runInstaller) but it’s going to fail because we’re missing the xdpinfo file. To verify this, you’ll need to open up a terminal from Application –> System Tools –> Terminal:
$ ls -l /usr/bin/xdpyinfo ls: /usr/bin/xdpyinfo: No such file or directory
We’ll need to install this with yum:
$ sudo yum -y install xorg-x11-utils
Once we’ve completed this, let’s verify our display:
$ echo $DISPLAY
:1.0 <– (0 is local, first number is the display, just as ipaddress:display for your VNC Viewer connection.)
If it’s correct, you can test it by executing xclock:
The clock should appear on the screen if the display is set correctly.
Run the installer:
The installer will come up for Oracle 12c and you can choose to enter in your information, but I chose to stay uninformed… 🙂 I chose to install AND upgrade the database to DB12c from 11g.
The warnings for swap and the few libraries I also chose to ignore by clicking ignore all and proceeded with the installation.
Once the installation of the new Oracle Home is complete, choose to run the root.sh script when prompted:
$ sudo /u01/app/oracle/product/12.1/db_1/root.sh
Overwrite all files when prompted by the script run and it’s up to you, but I chose to install the Oracle Trace File Analyzer so I can check it out at a later date. You’ll then be prompted to choose the database to upgrade. We’re going to upgrade our source database, ORCL in this example.
Choose to proceed forward with the upgrade on the database, but know that you’ll require more space for the archive logs that are generated during the upgrade. The check will tell you how much to add, but I’d add another 1Gb to ensure you are prepared with the other steps you have to run as we go through the preparation steps.
Log into SQL Plus as SYSDBA to perform this step:
ALTER SYSTEM SET DB_RECOVERY_FILE_DEST_SIZE=8100M;
Go through any warnings, but steps like stats collection and grants on triggers will have to be performed post the upgrade.
Drop the OLAP catalog:
$ sqlplus / as sysdba @$ORACLE_HOME/olap/admin/catnoamd.sql exit
Remove the OEM catalog for Enterprise Manager, first shutting down the console from the terminal:
$ emctl stop dbconsole
Copy the emremove.sql from the 12c Oracle Home/rdbms/admin and place it in the same location for 11g home. Log into SQL Plus as SYSDBA:
SET ECHO ON; SET SERVEROUTPUT ON; @$ORACLE_HOME/rdbms/admin/emremove.sql
Empty the recyclebin post these steps:
The assumption is that you have a backup prepared or you can use flashback with your resources allocated and proceed forward with upgrade.
Choose to upgrade the 11g listener and choose to install EM Express if you’d like to have that for monitoring. Make sure to keep the default checks for the following window to update everything we need and collect stats before the upgrade runs to ensure it proceeds efficiently through all objects required.
Choose to proceed with the upgrade and if you’ve followed these instructions, you should find a successful installation of DB12c and upgrade of the database. Keep in mind, we’re not going to go multi-tenant in this upgrade example, so if you were looking for those steps, my POC I’m building isn’t going to take that on in this set of blog posts.
Update your environment variables, including copying the 11g.env to a new profile called 12c.env and updating the Oracle Home. Now set your environment and log into SQL Plus as SYSDBA to the upgraded database.
Update all the necessary dictionary and fixed stats:
EXECUTE DBMS_STATS.GATHER_DICTIONARY_STATS; EXECUTE DBMS_STATS.GATHER_FIXED_OBJECTS_STATS;
Now, for our next post, we’ll need to set up the same installations on our Amazon host and VNC Viewer configuration we did for the Source and then install Oracle DB12c on our target server as we did in this post. Then we’ll discuss how to get all our Delphix VDBs, (virtual databases) upgraded to be the same as our source in no time!
For a POC that I’m working on with the DBVisit guys, I needed a quick, 12c environment to work on and have at our disposal as required. I knew I could build out an 11g one in about 10 minutes with our trust free trial, but would then need to upgrade it to 12c.
Disable snapshots to Delphix Engine
This is a simple prerequisite before you upgrade an Oracle source database and takes down the pressure on the system, as well as confusion as the database upgrades the Oracle home, etc.
Simply log into the Delphix Admin console, click on your source group that the source database belongs to and under Configuration, in the right hand side, you’ll see a slider that needs to be moved to the “disable” position to no longer take interval snapshots.
EC2 doesn’t come default with the GUI interface, so we just need to install it on the host to make life a little easier for the upgrade:
[delphix@linuxsource database]$ sudo yum update -y
xfsprogs.x86_64 0:3.1.1-20.el6 yum.noarch 0:3.2.29-81.el6.centos yum-plugin-fastestmirror.noarch 0:1.1.30-40.el6 Replaced: python2-boto.noarch 0:2.41.0-1.el6 Complete!
[delphix@linuxsource database]$ sudo yum groupinstall -y "Desktop"
xorg-x11-xkb-utils.x86_64 0:7.7-12.el6 xulrunner.x86_64 0:17.0.10-1.el6.centos zenity.x86_64 0:2.28.0-1.el6 Complete!
[delphix@linuxsource database]$ sudo yum install -y pixman pixman-devel libXfont
[delphix@linuxsource database]$ sudo yum -y install tigervnc-server
Each of the above should show completed successfully.
[delphix@linuxsource database]$ vncpasswd Password: Verify:
sudo service sshd restart
[delphix@linuxsource database]$ sudo service sshd restart Stopping sshd: [ OK ] Starting sshd: [ OK ]
[delphix@linuxsource database]$ sudo vi /etc/sysconfig/vncservers
VNCSERVERS="1:delphix" VNCSERVERARGS="-geometry 1280X1024
Save and exit the vncservers configuration file.
[delphix@linuxsource database]$ sudo service vncserver start
Log file is /home/delphix/.vnc/linuxsource.delphix.local:1.log [ OK ]
[delphix@linuxsource database]$ sudo iptables -A INPUT -m state --state NEW -m tcp -p tcp --dport 5901 -j ACCEPT
You can now use the VNC Viewer to access the GUI for the Linux Source and install/upgrade Oracle. I’m assuming you already have it, but if you don’t, download it and do a quick install. Keep in mind, to install Oracle via the GUI on the Linux Target, I’ll need to perform these steps on that target, too.
Let’s check and verify that we can get to the Linux Source desktop. Configure a new connection in the VNC Viewer and remember to use the public IP and “:1” for your user that you wish to log into. Save and log into the Linux Source.
In the next post, I’ll update the Linux Source Oracle database and we’ll proceed with upgrading Delphix source and target databases on Amazon.
I don’t want to alarm you, but there’s a new Delphix trial on AWS! It uses your own AWS account and with a simple set up, allows you to deploy a trial Delphix environment. Yes, you hear me right- just with a couple steps, you could have your own setup to work with Delphix!
There’s documentation to make it simple to deploy, simple to understand and then use cases for individuals determined by their focus, (IT Architect, Developer, Database Administrator, etc.)
This was a huge undertaking and I’m incredibly proud of Delphix to be offering this to the community!
So get out there and check this trial out! All you need is an AWS account on Amazon and if you don’t have one, it only takes a few minutes to create one and set it up, just waiting for a final verification before you can get started! If you have any questions or feedback about the trial, don’t hesitate to email me at dbakevlar at gmail.