Solved

Erwin Configuration Problem

Posted on 2009-05-05
4
6,337 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
  • 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 500 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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

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.
Entering a date in Microsoft Access can be tricky. A typo can cause month and day to be shuffled, entering the day only causes an error, as does entering, say, day 31 in June. This article shows how an inputmask supported by code can help the user a…
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.

776 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