RAD Studio 10.4.1 is now available! Learn more. Looking for discounts? Visit our Special Offers page!
News

Setting up Oracle for Embarcadero ER/Studio – Part 2

Author: Anil TexasCowboy

Howdy! Welcome to the next installment of the series.

In today’s series, we will explore the options for Oracle Client Setup needed for ER/Studio. 

Install the clients needed for your environments.

Reboot after installation. 

[Verifying Environment Variables]

1) Navigate to the Environment Variables Path. 

For more information on how to do it, check this article.

http://www.computerhope.com/issues/ch000549.htm 

Navigate to the PATH variable section and make sure that the Oracle client is at the very front of the path as shown in the screenshot below.

aaeaaqaaaaaaaapaaaaajdk0ntfhzdbjltg0m2utndmwyi1im2m3lwzlytm0mtqwy2vhyq-8104954Notice: the Path points to the Oracle 64 bit client and 32 bit clients respectively.

Now time to ensure that your Oracle client is configured for TNSNames.ora

[Oracle Net Configuration Assistant]

Click on Start –> All Programs –> Oracle_home_client1 –> Application and Configuration Tools –> Oracle Network configuration Assistant

Now follow the screens as shown below

aaeaaqaaaaaaaayfaaaajdk5zmrmndg3ltq3zgqtnddiny1izmq0lwjmzgywnwi1nme2oq-7106515aaeaaqaaaaaaaattaaaajdewzjc0nzy1lwrmmwytngywoc1hnjzilta0zmiynteyzgyxoq-5262304aaeaaqaaaaaaaanoaaaajda2mzi0yzziltjhztutndc2mi05njqxltblnjiyztnmzwywmq-4055223aaeaaqaaaaaaaaxbaaaajdawzdiymtiyltu1yzytndu3mc05ndk0ltm0yjjmzwzmnzbhyg-2965882

aaeaaqaaaaaaaauvaaaajdaymmi0mzuxlwqynwytndg2oc1hm2u0ltzhnmiyngfkmwuxnw-9073705aaeaaqaaaaaaaawuaaaajdcyywvhmtkxlwe0mjytndk5ny1iodiwltg5mtg2zdzhnwqzoq-2527614

aaeaaqaaaaaaaakpaaaajgrkymm5nzkylwvlm2ytndu3oc1iyjy5lthmy2uwzmi3ytfjng-4882575Don’t worry about the error, click on the change login and enter the appropriate credentials.

aaeaaqaaaaaaaaseaaaajgy2ytq3ndrhltrmm2etndy2nc1hyjk5ltzlodkyn2zhzgjkyq-2282635Once you have entered the right credentials you should be able to connect and get a successful connection.

aaeaaqaaaaaaaaitaaaajdmxnwq3mtfiltkymjytngy5my05mjq3lwrmzgfhm2njmgzkmq-9991590Next, make sure you enter a Service Name, I have used XE as it represents my Instance.

aaeaaqaaaaaaaaraaaaajgi2mmyyyznilwuyztutndlhmy1hmjk0ltixyjk5mzg0mzm4yg-6068412Click Next to proceed.

aaeaaqaaaaaaaaz9aaaajdg1zgexywiwltq0mdctngriyi1indhhltblzmvjodexzdfkng-8609787Choose No and click Finish to save the changes.

We shall now make sure by doing a TNSPing in the Command Prompt.

Launch a Command Prompt Window and enter the following command

tnsping XE –> Replace XE with your Servicename and you should get a OK message as shown below

aaeaaqaaaaaaaaxkaaaajdhly2vjogqzltzjotgtngq5yy05ywrklwrimduwnzrhntmzma-7452746

Now let us launch ER/Studio Data Architect and Choose File –> New –> Reverse Engineer from a Database

Choose Oracle as the Native Connection

Enter your Service Name under Data Source –> XE is our case

Enter the credentials and choose the schema you need in the next screen, and you should be able successful in using ER/Studio with Oracle!

aaeaaqaaaaaaaamgaaaajda0nzbknzniltlmnjgtngvhyy04otm0ltc2mdrindhkzwe1zg-1889159aaeaaqaaaaaaaaucaaaajdbmnddhntljlwq1owmtngiwzi04ngvklty2yty0otqxzmyzma-8557950

From the Schema pick the HR schema from the Ellipse.

aaeaaqaaaaaaaaonaaaajde5mjblmji1ltcymmetndyyyy1izjexlwy4ztnkzmvizdrizg-3271710

 

aaeaaqaaaaaaaaopaaaajgyzywm2m2zkltg3zjytndi0zs05zdg5ltnkndqxnmu2mgq2ma-6424093

Congratulations!! Y’all now have Oracle Client successfully configured for ER/Studio.


Reduce development time and get to market faster with RAD Studio, Delphi, or C++Builder.
Design. Code. Compile. Deploy.
Start Free Trial   Upgrade Today

   Free Delphi Community Edition   Free C++Builder Community Edition

Related posts
Delphi

Using "reFind" tool to migrate BDE app to FireDAC with Delphi 10.1

News

Top 10 Most Important Things that Data Modelers Need to Know - By Len Silverston, Universal Data Models, LLC

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

IN THE ARTICLES