*** ForumCoin is Proudly Hosted by Hawk Host ***
ForumCoin is an online community where you earn ForumCoin for making posts and for referring other members. You can use the ForumCoin virtual currency to buy and sell goods and services and to exchange for traditional currencies. Find out more!
BMF Banner Ad
Get paid up to 150 ForumCoin to submit your article.

Installing Oracle 18C(12.2.0.2)DB Client on a Windows System

Postby ptrikha21 » 26 May 2019, 16:08

Oracle Database Server and Client

When we need to work on Oracle Database, we need to install a Oracle Database Server. This is the only Oracle Database system on a single standalone system, or in an environment where multiple End User or Programmers/Administrators access the Central Database through accessing systems, which are called as Clients.
These clients can be a laptop, desktop, dumb terminals, or even mobile devices in some latest systems(though DB clients especially for Oracle can be heavy even on a top notch mobile device).

So here I would discuss as to how to install the Database Client for accessing the Database server.

Downloading the Oracle 18C database client

For download, one needs Oracle support : https://support.oracle.com access. Either one can create a personal username and password, or use a company approved access.
A vital point: I had two such access and Oracle asks one to be removed. So I no longer use my personal access.
Once downloaded, we get a zip file which we can save to a local folder. Say a folder named Oracle_Software in D drive.
We then untar the zip file to another local folder. I recommend using 7-zip, but you can opt other programs too.

Starting the installation
Oracle_Client_18C_setup_2.png
Choose the Administrator Option- very important in Oracle 18C client setup
Oracle_Client_18C_setup_2.png (62.28 KiB) Viewed 107 times


After unzipping the compressed file above, look for setup.exe in ..\client folder. Execute this file, using Run as Administrator (obtained by right clicking).
You will get Installation Type screen :
Follow these steps:
1)Choose Administrator
2)Next, Use Windows Built In Account if you have less space. Else if you are not lacking space, go for the Virtual account option.
3)Choose an appropriate path for Oracle 18C Client Installable(s)
Click on Next.
4)click on Install

Oracle_Client_18C_setup.png
Executing the Oracle 18C client executable
Oracle_Client_18C_setup.png (41.13 KiB) Viewed 107 times

I have shared the screen that we get once the installation completes.

Once the installation is complete, check if the Oracle client executable path has been added to the Path variable.
Also, add the entry in the tnsnames.ora.

Next, make a tnsnames.ora entry for the Oracle 12C Database Server

[color=#400080]Location :
<Ora18c_client_home>\network\admin
e.g-
D:\ora18c_client\client\user1\product\18.0.0\client_1\network\admin

(Disclaimer: The IP used below is an imaginary one)
#18C Database on invdb.europedomain.com (122.198.23.45)
orcl18_invdb =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 122.198.23.45)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl18)
)
)
[/color]
When we try to connect to this Db :
C:\Windows\System32>sqlplus <USERNAME>/<PASSWORD>@orcl18_invdb

SQL*Plus: Release 18.0.0.0.0 - Production on Tue May 14 12:32:55 2019
Version 18.3.0.0.0

Copyright (c) 1982, 2018, Oracle. All rights reserved.

Last Successful login time: Thu May 02 2019 17:43:47 +05:30

Connected to:
Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production
Version 18.3.0.0.0

SQL> SELECT * FROM ...... ;

Source: Own Knowledge and Practice. Images attached are by myself.
  • 0

User avatar
ptrikha21
 
Posts: 4,939
Location: India
Referrals: 5
Reputation: 960
ForumCoin: 897


Banner Ad

Re: Installing Oracle 18C(12.2.0.2)DB Client on a Windows System

Postby mrki444 » 26 May 2019, 16:11

On what OS did you install it with this tutorial? Looks like Windows 7 from screenshots.
  • 0

mrki444
 
Posts: 26,800
Location: Croatia
Referrals: 1
Reputation: 1132
ForumCoin: 533

Re: Installing Oracle 18C(12.2.0.2)DB Client on a Windows System

Postby ptrikha21 » 26 May 2019, 18:35

mrki444 wrote:On what OS did you install it with this tutorial? Looks like Windows 7 from screenshots.


It was on an Enterprise system- Windows Server 2008 R2 (release 2) which is (yes) equivalent to Windows 7.
  • 0

User avatar
ptrikha21
 
Posts: 4,939
Location: India
Referrals: 5
Reputation: 960
ForumCoin: 897



Your Ad Here.

Return to Articles & Tutorials



Who is online

Users browsing this forum: No registered users and 2 guests

Reputation System ©'