If you are running Oracle database on your environment, and having some performance issues because of memory, you may have to look at the swap space configured on your system.
For Oracle 11g database, the following is the recommendation from Oracle in terms of how much space space you should add.
Even if you are not an Oracle DBA, you’ll still encounter a situation where you may have to take a backup of an Oracle database.
Using Oracle RMAN, you can take a hot backup for your database, which will take a consistent backup even when your DB is up and running.
This tutorial gives you an introduction on how to perform Oracle DB backup using RMAN.
If you are using Oracle database, at some point you might have to deal with uploading data to the tables from a text file.
This article provides 10 practical examples on how to upload data from a flat file to Oracle tables.
Oracle VM VirtualBox is an open source virtualization software that you can install on various x86 systems. You can install Oracle VM Virtualbox on top of Windows, Linux, Mac, or Solaris. Once you install the virtualbox, you can create virtual machines that can be used to run guest operating systems like Windows, Linux, Solaris, etc.
On a high-level Oracle VM VirtualBox is similar to VMware. Oracle got this VirtualBox technology from Sun.
This article cover the basic installation of virtualbox and how to install a guest OS on it.
Question: I have purchased Linux support for RHEL and OEL from Oracle corporation. How do I register my Linux system to Oracle support network to download and update packages? Can you explain me with step-by-step instruction?
Answer: After purchasing Linux support from Oracle, you should register your Linux system with Oracle’s Unbreakable Linux Network using up2date utility as explained in this article.
Question: Can you provide me a shell script that will accept oracle credentials, sql query to be executed and displays the output?
Answer: The shell script given below prompts some basic information and displays the output of the SQL.
You can use the same concept and hard-code some of these values in the shell-script itself and even run this script in the background to generate the output of an oracle sql query automatically (or use the oracle shell script from cron job).
This script accepts following values from the user:
- Oracle username
- Oracle password
- Oracle SQL Query to be executed.
Script validates the $ORACLE_HOME and $ORACLE_SID set in environment.
Starting up and shutting down the oracle listener is a routine task for a database administrator. However a Linux system administrator or programmer may end-up doing some basic DBA operations on development database. It is critical for non-DBAs to understand the basic database admin activities.
In this article, let us review how to start, stop, check status of an oracle listener using Oracle listener control utility LSNRCTL.
For a DBA, starting up and shutting down of oracle database is a routine and basic operation. Sometimes Linux administrator or programmer may end-up doing some basic DBA operations on development database. So, it is important for non-DBAs to understand some basic database administration activities.
In this article, let us review how to start and stop an oracle database.