Michael McLaughlin
Rexburg, ID

Hear the Author!
Press to play


DB_LINK w/o tnsnames.ora
Wed, 27 Jul 2016 00:15:46 +0000
A question popped up, which I thought was interesting. How can you create a DB_LINK in Oracle without the DBA changing the tnsnames.ora file? It’s actually quite easy, especially if the DBA sets the TNS address name the same as the instance’s service name or in older databases SID value. Do the following with the […]

Can’t Display 256 Colors
Wed, 01 Jun 2016 08:12:00 +0000
If you’re reading this post, you most likely are trying to run the Oracle Database 11g or 12c runInstaller program, and it’s failing a critical dependency check and displaying an error like the one below. If so, choose n because if you choose y it won’t launch the Oracle Installer. Starting Oracle Universal Installer...   […]

Oracle 12c Pre-requisites
Tue, 31 May 2016 08:44:59 +0000
Installing any Oracle database is tedious, but the installing the prerequisites can be especially tedious. This post tries to simplify the process by creating a single prereq.sh file for all the prerequisite libraries, except for the oracle-rdbms-server-12cR1-preinstall, which you should run after the prerequisite file. The prerequisite file should contain the following: yum install -y […]

Linux User-Group Console
Sun, 29 May 2016 22:32:38 +0000
This post shows you how to add the menu option and GUI to set users and groups. It’s quite a bit easier than mastering all the command-line syntax. It makes setting up the required user and group accounts for an Oracle Enterprise or MySQL database solution much easier. You add the utility by calling the […]

Fix VMware Networking
Thu, 26 May 2016 06:58:01 +0000
Occasionally, my students loose their network connection when copying their virtual machines. This article shows you how to rebuild your Internet connection. The first step requires you to identify the port number on your host operating system, which is typically Windows OS or Mac OS X. You can find that by running the following search […]

Debug PL/SQL Web Pages
Mon, 16 May 2016 23:18:25 +0000
What happens when you can’t get a PL/SQL Web Toolkit to work because it only prints to a web page? That’s more tedious because any dbms_output.put_line command you embed only prints to a SQL*Plus session. The answer is quite simple, you create a test case and test it inside a SQL*Plus environment. Here’s a sample […]

Author Profile
Name: Michael McLaughlin
Location: Rexburg, ID
Subjects: Applications; Databases; Middleware; Servers;

Website: Oracle Press Books

Copyright © 2013 McGraw-Hill Global Education Holdings, LLC Any use is subject to the Terms of Use and Privacy Notice