When learning to develop Oracle Fusion applications, one of your first steps, if not already completed, should be to install a database for your applications to connect to. Oracle ADF applications are capable of connecting with several different database technologies, but perhaps the most conducive is Oracle’s own database suite. Oracle offers several different database solutions with varying levels of functionality. Oracle’s free, entry-level database offering, Oracle Database Express Edition (XE), is a very capable platform which should provide ample power for development purposes. Oracle Database XE does have some performance limitations which are described in Oracle XE Limitations (CPU, RAM, Data Limits). Fortunately, you can often start with the entry-level XE edition and upgrade your existing database when it becomes necessary.
Installing Oracle Database 11g XE
Oracle Database XE also includes Oracle Application Express release 2.1, a declarative, graphical development environment for creating database-centric Web a pplications. In addition to Oracle Application Express release 2.1, you can use all the popular Oracle and third-party languages and tools to develop your Oracle Database XE applications. Most users will install Oracle Database XE by downloading the installation package, extracting the files, double-clicking setup.exe, and answering graphical user interface prompts as needed.
The first step in installing Oracle Database XE is to download the latest version from Oracle’s website. This can be found in Downloads tab on any their pages.
Once the download is complete, extract the archive and run the setup.exe file under the DISK1 directory. Once the installer loads, step through the installation.
If you want to install the software in a non-standard location, you can do so on the Choose Destination Location screen.
Make sure to choose a safe password that you can remember. You will need this password to make any changes to your database.
Once the installer finishes, your installation will be complete. The system will automatically start the database running in the background. You can find tools for administering the database in your start menu under Oracle Database 11g Express Edition in your application menu. These tools can be use to start, stop, backup, or restore the database.
Unlocking the HR Schema
Once the database is installed, you can create users and schemas with most any SQL scripting tool or command line. Two of the most common tools used to interface with Oracle databases are SQL*Plus, a command line-based interface, and Oracle SQL Developer, an graphical database utility.
Many of the tutorials that you will encounter while learning to develop ADF applications make use of the HR example schema which comes pre-installed with Oracle databases. Before you can make use of this, the hr user must first be unlocked. This can be accomplished by issuing the following SQL command:
This command can be issued from any SQL utility capable of interfacing with Oracle databases. To execute this command in SQL*Plus, first start the console application by typing sqlplus in a command prompt. Next, log in as the system user using the password you specified earlier during installation of the database. Finally execute the above code.
An alternative way of accomplishing this is via the Oracle SQL Developer application. The application does not come bundled with Oracle Database XE and must be downloaded from Oracle’s website. The first time the application is executed, you must create a connection to your database as the system user. To do this, click the green plus icon in the Connections panel.
This will bring up a dialog for creating the new connection. Enter a connection name, the username system, and your password. Once you’ve entered these details, test your connection with the Test button. You should see a status of Successif everything went correctly. Click Connect to save and confirm.
Once you are connected as system, expand the tree in the connection panel as Connections-SYSTEM-Other Usersand right-click on HR to access the Edit User dialog.
Within the dialog, simply uncheck the box entitled Account is Locked and click Apply.
After completing this tutorial, you should now have a fully functional Oracle XE database with the example HR schema unlocked.
[message_box title=”We’re Oracle Experts!” color=”blue”]If you need Oracle help, you’re in the right place. We want to partner with you to get your projects done, and make things better.[/message_box]Contact UsVirtualBox for Mac OS X12
VirtualBox for Mac OS X is an extremely popular virtualization application with an amazingly rich functionality. The tool is absolutely cross-platform and is available for Windows, Linux, Solaris and Mac OS systems. It can run everywhere from small embedded systems or desktop class machines to Cloud solutions. The tool has been popular for more than ten years and currently contains dozens of useful functions for the most efficient work. You can download Oracle VM VirtualBox for MacBook right here and get the most important virtualization tool in a couple of seconds.
VirtualBox has a user-friendly interface and contains all the needed functions in its main menu. Both web developers and users with no additional knowledge can easily start using the app without any difficulties. The program runs smoothly on almost all machines with Mac OS X system, including your favorite MacBook. Moreover, the application is currently free to use and still does not contain any paid tools or trial period.
VirtualBox for Mac OS X has a range of benefits:
- completely free to download and use
- no trial period
- no annoying ads or pop-up windows
- a handy manual to help your on any stage of installation and running the app
- top quality software with no bugs or malware
- enormous possibilities for virtualization
- designed for professionals, offering an advanced number of handy utilities
- shared clipboard, as well as drag and drop technology: easy data sharing between the host and the virtual operating systems
- snapshots: once you configured your VirtualBox, you can easily save the machine's state by creating a special snapshot
- powerful functionality for developers and IT gurus
You can start using VirtualBox for Mac OS X for free and get a full package of the needed option for effective virtualization!
VirtualBox for Mac OS X
Full Setup Size:
Mac OS X
Oracle Express For Mac Download
Setup File Name:
![Oracle Xe For Mac Download Oracle Xe For Mac Download](/uploads/1/2/6/5/126596454/948237737.gif)
32-bit (x86), 64-bit (x64)
License:
5.1.22
For devices:
Oracle
Oracle Xe Download Mac Os
Download VirtualBox
*VirtualBox for Mac OS X is available for free downloading without registration.
Oracle Xe Mac
Downloads VirtualBox for Mac OS X?
Share the page on your site:
Share the page on your site: