Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Erwin Configuration Problem

Posted on 2009-05-05
4
Medium Priority
?
6,499 Views
Last Modified: 2013-12-18
Hi,

I have ERWIN installed but I cannot connect to Oracle databases. Specifically, I've tried to connect to an Oracle DB 10g DB on Linux and an Oracle Express 10g DB on Windows XP
I get same error every time:
   
     "ORA-01041: internal error, hostdef extension doesn't exist"

Any help would be greatly appreciated. See attachment for screen I'm trying to use in ERWIN and the error message dialog.

I've tried every ERWIN permutation possible to connect to DB including:
Service Name (DBATST)
Server Name
Server Name + Port
Fully Qualified Server Name (i.e. server.domain.com)
Fully Qualified Server Name + Port (server.domain.com:port)
Schema + Server Name (schema@server)
Schema + Server Name + Port (schema@server:port)
Schema + Fully Qualified Server Name + Port (schema@server.domain.com:port)
Nothing Works!  Same error every time:

MY SYSTEM
-----------
AllFusion ERWIN Data Modeler Release: 7.2.0.1644
Windows XP Professional SP3
Toad for Oracle
Oracle Client: 10.2
Document4.doc
0
Comment
Question by:deckard666
[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
  • 2
4 Comments
 
LVL 40

Expert Comment

by:mrjoltcola
ID: 24310789
Can you connect via Toad with that user?
Can you connect via SQLPLUS with that user?
Are you connecting through a firewall?
Can you check the alert log?

ORA-0600 and ORA-01041 (internal errors) are often Oracle bugs and/or environment configuration problems and should be reported to Oracle.

You can try restarting the database to see if it clears up.
0
 

Author Comment

by:deckard666
ID: 24310967
We can connect via Toad, but only direct... not TNS. We can't get TNS to work with Toad.
No firewall.
0
 
LVL 40

Accepted Solution

by:
mrjoltcola earned 2000 total points
ID: 24311415
From my experience using ERwin I always and only connected with TNS, I don't believe it can connect direct like recent versions of Toad can, however, I might be wrong as I switched to ER/Studio 2 yrs ago and didn't use 7.1-7.2 very long.

You should configure your tnsnames.ora with netca, or setup tnsnames.ora properly, so that tnsping and sqlplus will work with the TNS alias before trying ERwin.

Running without tnsnames.ora is atypical.

Try this below, copy into your {ORACLE_HOME}/network/admin

Then try tnsping dbatst
If that works, try ERwin again
# tnsnames.ora
#
DBATST =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = server.domain.com)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = DBATST)
    )
  )

Open in new window

0
 

Author Closing Comment

by:deckard666
ID: 31578306
The solution helped us to fix the TNS problem
0

Featured Post

Moving data to the cloud? Find out if you’re ready

Before moving to the cloud, it is important to carefully define your db needs, plan for the migration & understand prod. environment. This wp explains how to define what you need from a cloud provider, plan for the migration & what putting a cloud solution into practice entails.

Question has a verified solution.

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

This article shows the steps required to install WordPress on Azure. Web Apps, Mobile Apps, API Apps, or Functions, in Azure all these run in an App Service plan. WordPress is no exception and requires an App Service Plan and Database to install
Recently, Microsoft released a best-practice guide for securing Active Directory. It's a whopping 300+ pages long. Those of us tasked with securing our company’s databases and systems would, ideally, have time to devote to learning the ins and outs…
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.

722 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