I had Oracle 10g running on a Mac. I agree with the other posts that there is no Mac version of Oracle 11g. I also used Parallels to create a Linux VM which works well, but it is not free. However I cannot get SQL Developer to open. I just got this Mac and I am trying to set it up so I also just downloaded SQL Developer. My product.config file is all commented out. I have also tried to look at the sqldeveloper.conf file and set the “SetJavaHome” there. Is there anything else you had to do to get SQL Developer running?
1. Install Oracle 11g Express
1.1 Download and install Oracle 11g Express
Baidu search
oracle
Click on the official website:Click “Database Download”:
click
Database 11g Express Edition
:click
Accept License Agreement
Then DownloadOracle Database Express Edition 11g Release 2 for Windows x64
:Double-click after decompression
setup.exe
Installation:Installation process is simple, you can specify the installation directory. In addition, you need to specify the default system
sys
orsystem
User’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 name
Oracle Database 11g Express Edition Introduction
Icon:![Developer Developer](/uploads/1/1/7/9/117948242/570080414.jpg)
Click on the Start Menu
Run the SQL command line
In fact, it’s the command line tool that comes with it.SqlPlus
。 Enter login commandsconnect
And then the account numbersystem
Passwordroot
。 The following picture:2. Connecting Oracle database with PL/SQL Developer
PL/SQL
It 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 Express
It’s just the server side of Oracle database, not the client side.PL/SQL Developer
It’s an Oracle integrated development environment. It’s a fee-based one, so order me or spend my time on my own.PL/SQL Developer
You 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 search
oracle
Click on the official website:Click “Database Download”:
click
Instant Client
:Choice
Basic
Just download:2.2 Instant Client Installation
hypothesis
Oracle 11g Express
The installation directory is:F:oracle_database
hold
The directory path after decompression is:
Instant Client
Compressed package decompressed toapporacleproduct
Under the catalogue (you can also press it elsewhere)The directory path after decompression is:
F:oracle_databaseapporacleproductinstantclient_12_2
Document:
F:oracle_databaseapporacleproduct
Copy to:
F:oracle_databaseapporacleproduct
F:oracle_databaseapporacleproduct
11.2.0servernetworkADMINtnsnames.ora
Copy to:
F:oracle_databaseapporacleproduct
instantclient_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.
Oracle 11g Tutorial
After installation, double-click open
PLSQL Developer
It will display the login window and click Cancel. The unlisted interface is then displayed.click
'Configuration'
–'Preferences'
:input
Instant Client
Directory andoci.dll
PathOracle home directory name:
F:oracle_databaseapporacleproductinstantclient_12_2
OCI Library:
F:oracle_databaseapporacleproductinstantclient_12_2oci.dll
F:oracle_databaseapporacleproductinstantclient_12_2
OCI Library:
F:oracle_databaseapporacleproductinstantclient_12_2oci.dll
Exit after completion
PL/SQL Developer
。2.4 Add system environment variables:
Variable name: NLS_LAN variable value:
Variable name: TNS_ADMIN variable value:
take
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
)take
F:oracle_databaseapporacleproductinstantclient_12_2
(that is)Path of Instant Client
Add toPath
Variable2.5 Connecting Oracle Server with PL/SQL
Download Sql Developer For Oracle 11g Free For Mac Os
Open PL/SQL, enter the password of the account (system/root), and select XE for the database. Wish you a successful connection!