Solved

Error while configuring ERwin Mart server

Posted on 2013-06-28
2
603 Views
Last Modified: 2013-07-03
Hi,
I am configuring ERwin Mart server and got this error:
system.data.oracleclient requires oracle client software version 8.1.7 or greater

So, I installed Oracle 10.x client and tried to configure the mart server again, resulted in the same error.

I also went to Oracle_home and in the security tab - added "Authenticated User" with Read and Execute permissions and rebooted my system. But still the same error.

I am using windows 2008 64 bit system.

Could someone please suggest?

-Thanks
0
Comment
Question by:MRPT
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 12

Accepted Solution

by:
Praveen Kumar Chandrashekatr earned 500 total points
ID: 39287822
To create a Mart Server with oracle database then first you have to install the oracle client and configure the tnsnames.ora file for connecting to the oracle database.

Go through the installation and configuration doc of Mart server as shown below.

https://support.ca.com/cadocs/0/CA%20ERwin%20Data%20Modeler%20r9%201-ENU/Bookshelf_Files/HTML/Install%20Mart/index.htm?toc.htm?installing_configuring_mart.html

For steps to setting up and Administering the Oracle Database and Client as shown in below doc.
http://docs.oracle.com/cd/E13212_01/wles/docs42/installadmin/database.html#1061413
0
 

Author Closing Comment

by:MRPT
ID: 39296690
Thank You
0

Featured Post

Get 15 Days FREE Full-Featured Trial

Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
For anyone that has accidentally used newSID with Server 2008 R2 (like I did) and hasn't been able to get the server running again because you were unlucky (as I was) and had no backups - I was able to get things working by doing a Registry Hive rec…
This tutorial will walk an individual through locating and launching the BEUtility application to properly change the service account username and\or password in situation where it may be necessary or where the password has been inadvertently change…
This is Part 3 in a 3-part series on Experts Exchange to discuss error handling in VBA code written for Excel. Part 1 of this series discussed basic error handling code using VBA. http://www.experts-exchange.com/videos/1478/Excel-Error-Handlin…
Suggested Courses

627 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question