Menu
Go Up to Database Connectivity (FireDAC)
This topic describes how to connect to Oracle Server.
Jul 26, 2018 If your application uses Oracle database, you will need to install the appropriate version of Oracle Client in your local machine. As this software keeps being updated, you may find yourself trying to uninstall old versions from your system after a while. 2.how to find the oraclehomename for the exisiting installation of oracle client/server. I am trying to upgrade client from one version to another, we have some issue on server end to get the GUI working. In the response file, its asking for oraclehomename. 3.Can patch sets be installed in non-interactive mode Thanks for your considerations. May 14, 2017 A trigger is like a stored procedure that Oracle Database invokes automatically whenever a specified event occurs. I have Oracle 64-bit client installed to run with my weblogic application. I learnt that pl-sql developer doesn't work with oracle 64-bit client so now i have both 32. ORA-24280 to ORA-28674.
- 2Client Software
- 2.1Windows Client Software
Supported Versions
The FireDAC native driver supports Oracle Enterprise, Standard (ex Workgroup), and Express (ex Personal) server editions version 8.0.3 and later. For detailed discussion on Oracle usage in FireDAC for the Delphi application, read the 'Using Oracle with FireDAC' chapter.
Client Software
Windows Client Software
Pl Sql Developer Oracle Client Not Properly Installed Oracle Home Key Crack
FireDAC requires one of the following Oracle x86 or x64 client software types to be installed on the workstation:
- 'Fat' Oracle Client (details) -- It requires the standard install procedure. The driver uses the client that is installed in the primary Oracle Home, if not specified explicitly.
- 'Thin' Oracle Instant Client (details) -- The driver uses the client, which is either copied into a folder in the PATH or into the application EXE folder, if not specified explicitly. See 'Using Instant Client' below.
If the Oracle client software has not been installed properly, an exception is raised when trying to connect:
[FireDAC][Phys][Ora]-1309. OCI is not properly installed on this machine (NOE1/INIT)
Using Instant Client
To install Instant Client, download the Oracle Instant x86 or x64 client archive, unpack it and copy the files:
- oci.dll
- oraocci11.dll
- oraociei11.dll
- orasql11.dll
in your application EXE folder or in a folder in the PATH.
When you are using TNS names, put the tnsnames.ora file in the same folder or set the TFDPhysOracleDriverLink.TNSAdmin property value to a folder path with tnsnames.ora or use the TNSAdmin driver configuration parameter.
Set TFDPhysOracleDriverLink.NLSLang to the required value or use the NLSLang driver configuration parameter.
macOS Client Software
FireDAC requires:
- the libclntsh.dylib x86 client library.
You can download it as Instant Client for macOS (here)
To install on Linux, read the following articles:
- Instant Client Installation - for basic Oracle Instant Client installation steps;
- SQL*Plus Instant Client - for advanced Oracle Instant Client configuration, including configuring language and TNS parameters.
Linux Client Software
To install the Linux client library:
- Install the libaio library:
- On Ubuntu Server 16.04 LTS, run:
sudo apt-get install libaio1
- On Red Hat Enterprise Linux 7, run:
sudo yum install libaio
- On Ubuntu Server 16.04 LTS, run:
- Install the Instant Client for Linux as described in any of the following articles:
- Instant Client Installation - for basic Oracle Instant Client installation steps.
- SQL*Plus Instant Client - for advanced Oracle Instant Client configuration, including configuring language and TNS parameters.
Driver Linkage
To link the driver:
- Drop a TFDPhysOracleDriverLink component from the 'FireDAC Links' palette page.
- Or include the FireDAC.Phys.Oracle unit in an uses clause.
Connection Definition Parameters
To connect to an Oracle DBMS, most applications require that you specify DriverID, Database, User_Name, and Password (see Defining Connection (FireDAC) for details).
DriverID=Ora
Parameter | Description | Example value |
---|---|---|
Database | The value can be one of the following:
|
|
OSAuthent | Specify Yes to use OS authentification, and No to use the DBMS authentification. | No |
User_Name | The Oracle user name, if OSAuthent=No | Scott |
Password | The Oracle user password, if OSAuthent=No | tiger |
AuthMode | The Oracle authentification mode:
| Normal |
ReadTimeout | Specifies the timeout value in milliseconds for the receive or read operations. Specifying zero means no timeout.
| |
WriteTimeout | Specifies the timeout value in milliseconds for the database server to complete a send operation to clients. Specifying zero means no timeout.
| |
CharacterSet | The character set for the connection. If not specified, the NLS_LANG variable value is used. |
|
BooleanFormat | Defines how to represent Boolean values:
| Choose |
ApplicationName | Name of the application. If specified, this value is stored in the V$SESSION column MODULE. | AllBooks |
OracleAdvanced | Additional Oracle session options. For details, see the ALTER SESSION SET chapter, the 'Initialization Parameters and ALTER SESSION' paragraph. A value format is - <option>=<value>[;..]. | |
NewPassword | Specifies the new Oracle user password. FireDAC connects to the DB using the old password and immediately changes it to the new one. | tiger2 |
MetaDefSchema | Specifies the default schema for the application. The design time code omits the schema name in object names if it is equal to MetaDefSchema. | SCOTT |
Use Cases
- Connect to a database using the predefined TNS name (stored in tnsnames.ora):
- Connect to a database using host, port, and instance name info:
- Connect to a local database as sysdba:
Pl Sql Developer Oracle Client Not Properly Installed Oracle Home Key Fob
- Connect to a database using the TNS name and change the password:
- Connect to a database using the easy connect string:
See Also
Retrieved from 'http://docwiki.embarcadero.com/RADStudio/Sydney/e/index.php?title=Connect_to_Oracle_Server_(FireDAC)&oldid=270591'
Summary: this tutorial shows you step by step how to install Oracle Database 12c in Windows 10.
Installing Oracle Database
To install Oracle database on your computer, you need to download the installer from the download page of Oracle website.
After having the installation files which are in ZIP format, you need to extract them into a specific folder on your computer.
The following picture shows the structure of the folder of the Oracle installation files after extraction.
Now you need to double-click the setup.exe file to start the installation process. There will be 9 steps which mostly automatically execute.
Step 1. The installer asks you to provide your email address to get the latest security issues and updates. You can ignore it by clicking the Next button
Because I didn’t provide the email address, the Oracle database installer confirm it, you just need to click the No button to continue.
Step 2. In step 2, Oracle installer ask you to whether you want to create and configure a database, install database software only or just upgrade an existing database. Because you install the Oracle database at the first time, choose the option 1 and click the Next button.
Step 3. The installer allows you to choose the system class. Because you install Oracle on your computer, not a server, therefore, you choose the first option: desktop class and click the Next button.
Step 4. This step allows you to specify the Windows user account to install and configure Oracle Home for enhanced security. Choose the third option: “Use Windows Built-in Account”.
![Pl Sql Developer Oracle Client Not Properly Installed Oracle Home Key Pl Sql Developer Oracle Client Not Properly Installed Oracle Home Key](/uploads/1/1/9/5/119587458/267782800.jpg)
Step 5. in this step you can (1) choose the folder on which Oracle database will be installed, (2) Global database name and password, (3) pluggable database name.
Step 6. The installer performs the prerequisite check.
Step 7. The installer shows you the summary of the information such as global settings, database information, etc. You need to review the information and click the install button if everything is fine.
Step 8. The installer starts installing Oracle database. It will take a few minutes to complete, depending on your computer.
You will see the Database Configuration Assistant window. Click the Password management… button to enter the password for Oracle database accounts.
Enter the password for SYS and SYSTEM accounts and then click OK button.
Step 9. Once installation completes successfully, the installer will inform you as shown in the following screenshot. Click the Close button to close the window.
Pl Sql Developer Oracle Client Not Properly Installed Oracle Home Key Windows 10
Connecting to Oracle Database
First, launch the SQL developer application provided by the Oracle Database.
Second, right-click the connections node and choose New Connection … menu item to create a new connection.
Third, enter the information that you provided during the installation process as shown in the following screenshot. Click the Connect button to connect to the Oracle Database.
SQL developer will display all objects as shown below.
Congratulation! you have installed Oracle Database 12c successfully. Let’s start exploring Oracle.
Adding an entry to the tnsnames.ora file
![Developer Developer](/uploads/1/1/9/5/119587458/790780354.png)
The
tnsnames.ora
file is typically located in the following directory:If you follow the above installation steps, then the file is located at the following directory:
You first open the
tnsnames.ora
file using any text editor such as Notepad or Notepad++. Then, you need to add the following lines at the end of the file:After that, you can save the file and close it. It is time to download and load a sample database into the Oracle Database server.