Oracle VM Server appears in red with Status "Server of VM(s) in Errored Status", "Offline Server 1/1" under Oracle VM Manager Console

Oracle VM Server appears in red with Status "Server of VM(s) in Errored Status", "Offline Server 1/1" under Oracle VM Manager Console
b2ap3_thumbnail_1_20150416-081626_1.jpg

IssueOracle VM Server appears in red with Status "Server of VM(s) in Errored Status", "Offline Server 1/1" under Oracle VM Manager Console. On the contrary, the Oracle VM Server is up and running.

Investigation DoneThis is probably due to a failed event that has happened in the recent past.

Continue reading
Rate this blog entry:
0 Comments

Index on Database Tables- Performance Benefits and Costs

Index on Database Tables- Performance Benefits and Costs

Why Indexes?

Basic use of index is to find data in a table more quickly by speeding up the query searches. Consider an employees table with 1 million records. If I query the table to extract data for 1 employee based on emp_id, all the records are compared for the emp_id. This approach will be very time taking in real time when many queries are searching for records. Thus we should use indexes to speed up the searching process.

Continue reading
Rate this blog entry:
0 Comments

FREE Course: SQL Fundamentals for Oracle Functional Consultants. Worth US $49.

FREE Course: SQL Fundamentals for Oracle Functional Consultants. Worth US $49.
b2ap3_thumbnail_SQLFREECourse.png

FREE Course: SQL Fundamentals for Oracle Functional Consultants. Worth US $49.

Use Coupon Code BIGFRIDAY415 on checkout to get 100% free.

Continue reading
Rate this blog entry:
0 Comments

CASE statement and expressions: usage in PL/SQL

CASE statement and expressions: usage in PL/SQL

CASE statement is used to select one out of many set of statements to execute.

Types of CASE statements:

Continue reading
Rate this blog entry:
0 Comments

How to use Linux Install media as depot to install software

How to use Linux Install media as depot to install software
DVD repo01
DVD repo02
DVD repo03

On this document I will go through a series of steps to add a local DVD to a RPM based Linux server and then use it as a Yum repository to install software.

Step 1 - Insert the Linux DVD containing the required software and then issue the command scsi-rescan NOTE: For help on how to add a Linux DVD to a Virtual Box VM check this other blog.

Continue reading
Rate this blog entry:
0 Comments