Month: October 2015

Oracle 12c Create a Pluggable Container DB From Seed & Changing Containers

Leave a Comment / Oracle / By thg

# Creating a pluggable container from the seed container pdb$seed # First create a data sub-directory under the root container cdb$root data directory as follows (your path may vary to your oradata dir): # while logged in as the oracle / Linux user that admins the 12c database cd /u01/app/oracle/product/12.1.0.2/oradata/orcl mkdir pdbmf11g cd pdbmf11g # …

Oracle 12c Create a Pluggable Container DB From Seed & Changing Containers Read More »

Oracle 12c Show Which Containers All Users Are In And Which Container You Are Currently In

Leave a Comment / Oracle, Oracle Database / By thg

When connect to the root container CDB$ROOT: select c.name container, u.username username from v$containers c, cdb_users u where c.con_id=u.con_id order by c.name; Just in case you are not certain which container you are currently connected to from sqlplus or sqldeveloper etc: show con_name CDB$ROOT

Getting a Windows 80244019 on a Windows Update after a Win 7 Pro install

Leave a Comment / Windows / By thg

I’ve been getting a Windows 80244019 error sometimes – when manually performing a Windows Update on a new Win 7 Pro install. I’ve resolved this several times by restarting the Windows Update service (Control Panel->Administrative Tools->Component Services->Services->Windows Update Stop & then Start).

On RHEL, CentOS, or OEL Oracle Enterprise Linux auto start an Oracle database – tested on 12c

Leave a Comment / Linux RHEL/CentOS/OEL, OEL (Linux) / By thg

On RHEL, CentOS, or OEL Oracle Enterprise Linux auto start an Oracle database – tested on 11gR2 and 12c As root: edit /etc/oratab and change the N to Y orcl:/u01/app/oracle/product/12.1.0.2/db_1:Y then create a file named /etc/init.d/dbora #!/bin/sh # chkconfig: 345 99 10 # description: Oracle auto start-stop script.# # Change the value of ORACLE_HOME to …

On RHEL, CentOS, or OEL Oracle Enterprise Linux auto start an Oracle database – tested on 12c Read More »

Error adding Virtual Box Additions to OEL 6 try this

Leave a Comment / VirtualBox / By thg

Maybe you left out the uek development kernel – here is how to add it in (reboot required before attempting the additions install) if using the Unbreakable kernel: yum update yum install gcc yum install kernel-uek-devel reboot then re-run the vBox additions not using UEK, substitute yum install kernel-devel

Installing Oracle yum updates for OEL 6

Leave a Comment / OEL (Linux) / By thg

You must have a terminal session open as root and yum updates requires access to the internet from your Linux OS then: cd /etc/yum.repos.d wget http://public-yum.oracle.com/public-yum-ol6.repo yum update thx Mike

Oracle 12c Database Auto Start on RHEL 6 and others

Leave a Comment / OEL (Linux) / By thg

# To auto start Oracle 12c Database on RHEL 6 and others I did this (there are other methods): # as root # update the “N” in /etc/oratab to “Y” for the instance you want to auto-start # add the following file to /etc/init.d as root dbora #! /bin/sh # chkconfig: 345 99 10 # description: …

Oracle 12c Database Auto Start on RHEL 6 and others Read More »

Lost the Oracle VirtualBox Menu Bar on your VM? Here's how to get it back

Leave a Comment / VirtualBox / By thg

If you accidentally removed the menu bar on your VM – there is no straight forward way to get it back. Here is how I did it. What removed it for me, is I selected View->MenuBar from the Menu Bar – and it turned it off as there was no check box indicating it was …

Lost the Oracle VirtualBox Menu Bar on your VM? Here's how to get it back Read More »

SQL Developer on Mac OS Creates large log file on startup – maybe fixed in 4.0

Leave a Comment / Mac OS / By thg

This bug was identified in SQLDeveloper 4.x – I have not tested it on MAC OS. I’m just porting my older posts over from the wordpress site. After installing SQL Developer 3.2 on Mac OS 10.8.2 my disk space started running out. And kept running out. SQL Developer was constantly appending to a log file …

SQL Developer on Mac OS Creates large log file on startup – maybe fixed in 4.0 Read More »

.netrc and a here document to automate and script FTP

Leave a Comment / OEL (Linux) / By thg

Using a .netrc file combined with a “Here Document” for ftp scripting can simplify ftp scripting by automating the login and setting up macros – that can be run from a scripted ftp session Here is an example .netrc file from something I did recently. Note do a “chmod 600 .netrc” after you have created …

.netrc and a here document to automate and script FTP Read More »