Oracle XE

Check if JVM is Installed in Oracle

How to Check if JVM is Installed in Oracle

I recently thought of using Java’s built-in BigInteger.gcd() method inside a PL/SQL function wrapper to calculate GCD in SQLs. And so I wrote the Java code and ran it on Oracle XE. Things didn’t go as planned.

Read the Full Article →
Thumbnail image for Access Control List (ACL) in Oracle 11G

Access Control List (ACL) in Oracle 11G

I recently upgraded Oracle XE from 10G to 11G, and found that none of the PL/SQL code using UTL_HTTP was working after upgrade. The code failed with the error: Oracle 10G used to be happy as long as the user running network packages like UTL_HTTP had execute permission on the package. Oracle 11G and above […]

Read the Full Article →
Thumbnail image for ORA-12560: TNS:protocol adapter error

ORA-12560: TNS:protocol adapter error

Sometimes you try to login to your Oracle XE on your home computer, and get this curt blocking response: Here’s the top reason why it might happen and how to fix it.

Read the Full Article →
Thumbnail image for I want to learn Oracle. Where should I begin?

I want to learn Oracle. Where should I begin?

Here is a simple guide to learning Oracle as a developer from scratch, on your own. For an absolute beginner to Oracle, it helps you navigate your way around the sea of information available at your disposal.

Read the Full Article →
Unlock Database User in Oracle Express Edition

Unlock User Account in Oracle Express Edition

The default user HR in Oracle 10G Express Edition is locked when you first try to login after database installation. This is apparently due to security reasons, and needs to be unlocked by the administrator. To unlock HR – or any other database user account in Oracle Database XE – follow the simple steps below:

Read the Full Article →
Oracle Database Express Edition

Oracle 10G Express Edition

Oracle Database 10g Express Edition (Oracle Database XE) is a free, lightweight version of Oracle. If you’re a small enterprise with modest database needs, or an individual looking to learn Oracle on your home computer, Oracle XE is just the answer for you. This starter version of Oracle is free to download, distribute and deploy. […]

Read the Full Article →