- Oracle Database Express Edition 11g Release 2 For Macos
- Download Oracle Database Free
- Oracle 12c Express Edition Download
- Oracle Database Express Edition 11g Release 2 For Macbook Pro
Installing 11G Database. Next, unzip both the zip files in the same folders. If you unzip in different folder then copy stage folder from win6411gR2database2of2database to win6411gR2database1of2database folder. Now click on setup.exe file to start the installation. Oracle quickly does the pre-requisite check and launches the. 2 Oracle 11g R2 Database Release 2 only support Windows, Linux, and Solaris. So if you want to using Oracle 11g R2 on a Mac OS you will need to using something like Virtual Box or VMware Fusion. You can read more about installing Oracle 11g R2 on these operating system here.
This article explains how to install Oracle 11G release 2 Database on Windows 10. These instructions should also work on Windows 7, Windows 8.
Download 11G Database
Click to Download Oracle 11G database. You need an Oracle account to download any software. Click on Accept License Agreement. Enter the username and password.
Below are the step by stape installation steps.
Installing 11G Database
Next, unzip both the zip files in the same folders. If you unzip in different folder then copy stage folder from win64_11gR2_database_2of2database to win64_11gR2_database_1of2database folder.
Now click on setup.exe file to start the installation. Oracle quickly does the pre-requisite check and launches the Universal Installer.
Configure Security Updates
Provide your email address to receive security issue information. It is optional. Unselect I wish to receive security updates via My Oracle Support.
If you have this information you can enter it.
Installation option
Now select the database installation option.
- Create and configure database – This option creates and configures a database.
- Install database software only – This installs only database software. Post-installation you need to manually create and configure database.
- Upgrade existing database – This upgrades the existing database.
Select the default and click the Next button.
System Class
Select either Desktop Class or Server Class and click Next button.
Database configuration
Installed defaults all basis configuration like Oracle base, Software location, Database file location. Click browse and select a different location to change it.
The installer creates a global database with the name orcl. Enter Administrative password and enter the same password in Confirm Password field and click Next
Summary
This screen shows a summary of the installation. Review it. If it is fine click on the Finish button or click on the Back button to change.
Install Product
The installer starts and copies all necessary files.
Click Allow Access.
Database Configuration Assistant
The installer creates and configures the database.
Below popups shows database information. Click Ok to finish the installation.
Summary
In this guide, we explained how to install Oracle Database 11G Release 2 on Windows.
1. Install Oracle 11g Express
1.1 Download and install Oracle 11g Express
Baidu searchoracleClick on the official website:
Click “Database Download”:
clickDatabase 11g Express Edition：
clickAccept License AgreementThen DownloadOracle Database Express Edition 11g Release 2 for Windows x64：
Double-click after decompressionsetup.exeInstallation:
Installation process is simple, you can specify the installation directory. In addition, you need to specify the default systemsysorsystemUser’s password, the password I set isroot。
1.2 Test the success of installing Oracle 11g Express
Check if there are icons in the start menu:
Desktop will also have an additional nameOracle Database 11g Express Edition IntroductionIcon:
Click on the Start MenuRun the SQL command lineIn fact, it’s the command line tool that comes with it.SqlPlus。 Enter login commandsconnectAnd then the account numbersystemPasswordroot。 The following picture:
2. Connecting Oracle database with PL/SQL Developer
PL/SQLIt is also a programming language, called Procedural Language / SQL. PL/SQL is an extension of Oracle database to SQL statements. PL/SQL is a programming language that organizes data operations and query statements into the procedural units of PL/SQL code and realizes complex functions or computations through logical judgement and loops.Oracle 11g ExpressIt’s just the server side of Oracle database, not the client side.PL/SQL DeveloperIt’s an Oracle integrated development environment. It’s a fee-based one, so order me or spend my time on my own.PL/SQL DeveloperYou need to install Oracle Client, the client of Oracle database, which can be downloaded from the official website.Instant Client
2.1 Download Instant Client
Baidu searchoracleClick on the official website:
Click “Database Download”:
clickInstant Client：
ChoiceBasicJust download:
2.2 Instant Client Installation
hypothesisOracle 11g ExpressThe installation directory is:F:oracle_database
holdInstant ClientCompressed package decompressed toapporacleproductUnder the catalogue (you can also press it elsewhere)
The directory path after decompression is:F:oracle_databaseapporacleproductinstantclient_12_2
Document:
F:oracle_databaseapporacleproduct11.2.0servernetworkADMINtnsnames.ora
Copy to:
F:oracle_databaseapporacleproductinstantclient_12_2
2.3 Installation of PL/SQL Developer
Installation process is very simple, are clicked on the “next step”, after installation, click on the Chinese Baohua can be.
After installation, double-click openPLSQL DeveloperIt will display the login window and click Cancel. The unlisted interface is then displayed.
click'Configuration'–'Preferences'：
inputInstant ClientDirectory andoci.dllPath
Oracle Database Express Edition 11g Release 2 For Macos
Oracle home directory name:
F:oracle_databaseapporacleproductinstantclient_12_2
OCI Library:
F:oracle_databaseapporacleproductinstantclient_12_2oci.dll
Download Oracle Database Free
Exit after completionPL/SQL Developer。
2.4 Add system environment variables:
Variable name: NLS_LAN variable value:SIMPLIFIED CHINESE_CHINA.ZHS16GBK
Variable name: TNS_ADMIN variable value:F:oracle_databaseapporacleproductinstantclient_12_2(that is)Path of Instant Client）
takeF:oracle_databaseapporacleproductinstantclient_12_2(that is)Path of Instant ClientAdd toPathVariable
2.5 Connecting Oracle Server with PL/SQL
Oracle 12c Express Edition Download
Oracle Database Express Edition 11g Release 2 For Macbook Pro
Open PL/SQL, enter the password of the account (system/root), and select XE for the database. Wish you a successful connection!