by 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
- 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
- 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.
[b][u]Oracle Database Server and Client
[/u][/b]
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.
[b][u]Downloading the Oracle 18C database client [/u][/b]
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.
[b][u]Starting the installation[/u][/b]
[attachment=0]Oracle_Client_18C_setup.png[/attachment]
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
[attachment=1]Oracle_Client_18C_setup_2.png[/attachment]
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=#8000FF][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][/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.