CODEWITHSUNDEEP
databaseoracle-database
Rakibul Islam
Rakibul Islam

Reputation: 333

Oracle Installation for client server connection in lab

i don't know anything about oracle. Our faculty members assign us for setup lab(class lab) in client server connection. can anyone please say what the process and what component i should install and how to configure it. Lab PC has linux based OS. N.B. i didn't find any easy guide by googling it.

Upvotes: 0

Views: 269

Answers (3)

Can
Can

Reputation: 39

you can check my article from here; step by step installation

http://www.cansayin.com/2019/11/16/oracle12c-installation/

You have to install packages for oracle and set some parameter on your operating system before installation.

Upvotes: 1

Christopher Jones
Christopher Jones

Reputation: 10496

For the DB, download Oracle Database XE edition from https://www.oracle.com/database/technologies/xe-downloads.html The installation guide is https://docs.oracle.com/en/database/oracle/oracle-database/18/xeinl/installation-guide.html. You can google for various blog posts etc that will help.

If the "client" computer is on a different machine, then install Oracle Instant Client from http://www.oracle.com/technetwork/topics/linuxx86-64soft-092277.html. The instructions are at the bottom of the page.

If you only have one computer then don't install Instant Client. The Oracle Database libraries can also be used by applications to connect to the database.

Upvotes: 1

Littlefoot
Littlefoot

Reputation: 142710

If I understood you correctly, there's the database server in your lab which has an Oracle database. Your assignment is to establish connection to it from your PC.

If that's so, you'll need to install Oracle Client software. It can be downloaded from the Oracle Technology Network < a href="https://www.oracle.com/downloads/#category-database">Download section.

The simplest option is to download & install the Instant Client. Navigate to your operating system version, download it and run the setup.

If you visit this page, you'll find installation instructions at the bottom of the page.

I don't use Linux so I can't guide you based on my own experience, sorry.

Once you're done, you'll have to edit the TNSNAMES.ORA file in order to include database's alias (DBA should tell you that information if you don't know it). Basically, that should be enough to establish the connection.

Upvotes: 0

Related Questions