Posted 03.01.2021 by admin

Oracle Express For Mac Download

Oracle Database 10g Release 2, Oracle SQL Developer, and Oracle JDeveloper are fully certified on Mac OS X. Turn your Mac into a full-fledged development environment and deploy Xserve-based grids. Sep 26, 2013. May 10, 2020. Oracle Application Express (APEX) is a low-code development platform that enables you to build scalable, secure enterprise apps, with world-class features, that can be deployed anywhere. Using APEX, developers can quickly develop and deploy compelling apps that solve real problems and provide immediate value. Oracle Express Free Download For Mac Nancy Drew Royal Tower full. free download For Mac Gsr202 Iogear Download For Mac Internet Explorer Download For Mac Yosemite Ib Game Download For Mac Is Mapple Math software, free download For Mac Sims Pets Free Download For Mac Pdf Writer Free Download For Mac.

Oracle Database Express Edition (XE) is a community supported edition of the Oracle Database family. Please go to the Oracle Database XE Community Support Forum for help, feedback, and enhancement requests. Note: Oracle Support Services only provides support for Oracle Database Enterprise Edition (EE) and Oracle Database Standard Edition 2 (SE2) in conjunction with a valid Oracle.

A few semester back I finished database design course at university. While the theory part was all about database design the lab part focused more on database manipulation. Or in simpler words it was all about SQL. Now if you want an RDBMS software what choices do you get? A lot! Oracle, Microsoft SQL Server, MySQL etc etc. The list will just rage on these days. Our lab instructor however insisted on using Oracle, and that bugged me out because I carry a macbook to the lab for lab works and – there’s no MacOS version by Oracle for the Oracle Database Express. But, we’re in the age of VM’s and who cares what OS you’re using? Use a VM, job done! Now should you install an entire OS on VM for that? Well, it’s overkill. That’s why Docker comes in, it creates a Linux VM where you can deploy install test and do whatever you want with your applications. The overhead is really negligible as if you’re natively running Oracle Server on your machine. Let’s see how to install Oracle Database Express 11g on your shiny Mac via Docker.

What you need

Your Mac(iMac, Mac Mini, Mac Pro, Macbook Pro, Macbook Air or whatever Mac Apple is going to release after I publish this post)
Make sure your machine has enough RAM to power a VM. Anything above 4GB is fine.
Make sure again you’re running the Latest Version of MacOS
Docker Toolbox + Kitematic
And yes you need some time. Grab some coffee or Doritos if you want to.

First : Download Docker Toolbox and install it

Download Docker Toolbox + Kitematic dmg form this LINK . You know how to install from dmg images on your mac so I’m just skipping this part.

A note : MacOS may block the installer from running saying it’s unidentified. Just allow it from “Security and Privacy” in System Prefs.

Open Kitematic

Docker is a command line based tool and we don’t want to get pinned down with large commands, Kitematic, with it’s GUI makes life easier for us and helps completely forget that Docker needs cli. At least for our purpose!

If Docker shows some error like it’s unable to create the VM, install Oracle Virtual Box. A quick google will give you the link. First time installation will take a while so have patience. You’ve coffee and Doritos right?

When it’s ready you’ll get this Window. You can create an account if you want, or skip for now. I’d suggest opening an account. Has some benefits.

Next Part : Download and install Oracle Database Express 11g Image

You don’t need to look further! Just type in the name and Kitematic will find out the image for you(if it’s available).

Well well, a lot of choices , I mean images. So which one to choose? I’ll go with the marked one (because I’ve used it, tested, works.) – created by “wnameless”. Click on create and let the wait flow through you. Kitematic will download and install the image for you. Easy. You just need to wait.

Aaaaaaaaand we’re ready!

Kitematic has done the hardwork for us, now it’s time to get to work.

Now we need to start the server. Just click on start. Wait Until you see Unauthorized in Web Preview. The server needs some time to set in. Once you see it, click on the button beside right to web preview.

Oracle Database Express will now open in your system default web browser. You can copy paste the address to another browser if you want to!

Now you need a username and password. As the Docker image doc goes, you need to use these credentials.

username : system
password : oracle

!!!!ISSUES!!!!!

Now this should be working pretty nice but it doesn’t. From my experience I’ve found that you can’t login this way. What you need to this , enter the credentials and when it asks again for credentials , cancel it, then refresh the page. It works this way. If you find a workaround, feel free to leave a comment. May help others (and me too!)

Hail the Oracle Database

So we’re in and this is what Oracle Database system looks.
Now what happens if you accidentally close the window? No problem, just open it from Docker again. Funny thing is , this time it won’t bother you with that login issue.

Let’s create an user and configure system admin for database

Oracle express for mac download windows 10

You now need an user account to work with the database and also need admin privilege to create user and workspaces for them. Now who’s the admin? You’re, and you’ve the login credentials we mentioned above.

Click on Application Express to begin with. Login with username : system and password : oracle.

For first time use, create a new user, a database and give the user a password. Now what if you’ve worked for some time then logged out and want to get back where you left off. Follow the instruction the the image, click on that button, enter the username and password you used when creating the user and you should be right back where you left off. Cool!

Wrapping up

So let’s just wrap it. It was a long procedure, I hope you didn’t run out of coffee and Doritos.

This section covers the following topics:

5.1 Running the Installer

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.

Note:

Before attempting to install Oracle Database XE 18c, uninstall any existing Oracle Database XE or database with the SID XE from the target system.
Installer will use SID XE for database creation. Any SID other than SID XE will not be allowed.
See Migrating Data and Applications if you need to move data from Oracle Database Express Edition to Oracle Database Enterprise Edition 18c.
See Exporting and Importing Data between Oracle Database XE 11.2 and 18c if you need to move data from XE 11.2 to XE 18c.

To install Oracle Database XE:

Oracle Express Application

Log on to Windows with Administrator privileges.
You must be part of the Administrators group on Windows to install Oracle Database XE. If you are logged in as a domain user, ensure that you are connected to the network. Otherwise, you may receive a prerequisite check failure for Administrator privileges during the install.
If the ORACLE_HOME environment variable has been set, then delete it.
Download the Microsoft Windows version of Oracle Database XE.
Extract the downloaded zip file to a temporary location. Locate setup.exe and double click it.
In the Welcome to the InstallShield Wizard for Oracle Database 18c Express Edition window, click Next.
In the License Agreement window, read the text of the agreement and if you agree to its terms, select I accept the terms in the license agreement and then click Next. If you do not accept the terms, cancel the installation and delete the Oracle Database 18c Express Edition software from the computer.
The installer now performs a prerequisite check to ensure that the version of Windows is supported, that the installation user has administrative privileges, and that there is no Oracle Database XE service already created. If any of these checks fail a Prerequisite Checks window will open notifying the user. In that case, cancel the installation, fix the problem, and retry the installation.
In the Choose Destination Location window, either accept the default or click Change to select a different installation directory. (Do not select a directory that has spaces in its name.) Then click Next.
In the Specify Database Passwords window, enter and confirm the single database password to use for the SYS, SYSTEM, and PDBADMIN database accounts. Then click Next.
Note:
The same password will be used for these accounts.
Oracle recommends that the password entered should be at least 12 characters in length, contain at least 1 uppercase character, 1 lower case character and 1 digit [0-9]. The password should conform to the Oracle recommended standards. See Oracle Database Security Guide for more information about guidelines for securing passwords.
In the Summary window, review the installation settings, and if you are satisfied, click Install. Otherwise, click Back and modify the settings as necessary.
When the installation is complete, the Oracle Database Installed Successfully window is displayed.
Make a note of the connection strings provided for multitentant container database and the pluggable database, as well as the EM Express URL. Click Finish to close the installer.

Configuration, Database Files, and Logs Location

The following table lists important locations such as Oracle Base, Oracle Home, Database files, and logs. <INSTALL_DIR> is the installation directory chosen by you during the time of install. The default installation directory is C:app<username>product18.0.0, where <username> is the name of the Windows user performing the installation.

Table 5-1 Configuration, Database Files and Logs Location

File Name and Location	Purpose
`<INSTALL_DIR>`	Oracle Base This is the root of the Oracle Database XE directory tree.
`<INSTALL_DIR>dbhomeXE`	Oracle Home This home is where the Oracle Database XE is installed. It contains the directories of the Oracle Database XE executables and network files.
`<INSTALL_DIR>oradataXE`	Database files
`<INSTALL_DIR>diagrdbmsXEXEtrace`	Diagnostic logs The database alert log is `<INSTALL_DIR>diagrdbmsXEXEtracealert_XE.log`
`<INSTALL_DIR>cfgtoollogs`	Database installation, creation, and configuration logs. The `<INSTALL_DIR>cfgtoollogsdbcaXEXE.log` file contains the results of the database creation script execution.
`%Program Files%OracleInventorylogs`	Software installation logs.

5.2 Performing a Silent Installation

If you plan to install Oracle Database XE on multiple computers or bundle it with a third-party application, then you may want to perform a silent installation, in which you download the installation executable and run it at a command line using the provided response files.

If you have an existing version of Oracle Database XE, you can save your data by exporting it to data files. After you install the new version of Oracle Database XE, you can import this data into the new database.

To perform a silent installation of Oracle Database XE:

Log on to Windows with Administrator privileges.
You must be part of the Administrators group on Windows to install Oracle Database XE. If you are logged in as a domain user, ensure that you are connected to the network.
Download Oracle Database XE for Microsoft Windows. Extract the files to a temporary directory.
Open the XEInstall.rsp response file and modify the settings if necessary.
Note:
For information on response file parameters, see Table 5-2.
If the ORACLE_HOME environment variable has been set, then delete it.
Run the installation executable with the XEInstall.rsp response file.
For example, if you extracted the setup.exe executable and the XEInstall.rsp file to a directory called xe_temp, you would enter the following command:
After the installation is complete, Oracle Database XE starts.

Response File Parameters

The following table describes the important response file parameters. The parameter value cannot be empty. You must specify a valid value for the parameters.

Table 5-2 Response File Parameters

Download Oracle 10g Express Edition

Parameter	Purpose	Default Value
`INSTALLDIR`	The install directory location. Replace `[USERNAME]` with current user. Mac won't download anything.	`INSTALLDIR=C:app[USERNAME]product18.0.0`
`PASSWORD`	The XE Database password. All users are set with this password. Reset the password immediately after the installation is complete.	`PASSWORD=passwordvalue`
`LISTENER_PORT`	The listener port.	`LISTENER_PORT=0` If listener port is set to `0`, available ports will be automatically allocated starting from `1521`.
`EMEXPRESS_PORT`	The EM express port.	`EMEXPRESS_PORT=0`. If EM express port is set to `0`, available port will be automatically allocated starting from `5550`.
`CHAR_SET`	The character set of the database.	`CHAR_SET=AL32UTF8`

Note:

After the installation is successfully completed, the following message is available in the log file that you have specified as the parameter to setup.exe. For example, c:xe_tempsetup.log:

MSI (c) (28:B8) [Timestamp]: Windows Installer installed the product. Product Name: Oracle Database 18c Express Edition. Product Version: 18.4.0.0.0. Product Language: [Current Language ID]. Manufacturer: Oracle Corporation. Installation success or error status: 0.

Oracle Mac Download

Since silent install runs asynchronously, you can check the log file for the completion status.

Oracle Mac Os

If the installation fails, see the following installation log files:

general logs: located at %Program Files%OracleInventorylogs
database creation logs: located at <Oracle_base>cfgtoollogs