Please check the following.
If this fails to solve the problem, please answer the questions
in ">>> QUESTIONS >>>" and send your responses to [EMAIL PROTECTED]
The following assumes you are using Rose 2001 or 2001a
(there are other issue with 2000e not addressed below).
>>>>> PLEASE CONFIRM THE FOLLOWING >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
1. You can connect with other Oracle8 tools such as SQL Plus.
2. Please check and confirm that Oracle is in your FIRST in your
path.
\ORANT\BIN (NT default path)
\ORAWIN95\BIN
\ORAWIN98\BIN
(by placing this first in your path, this should rule out some
possible pathing problems)
3. You have minimum rights.
For the Data Modeler CONNECT and RESOURCE role should be all
you need but if having problem test with DBA to completly rule
out any kind of rights issue.
4. Are you working with more than one version of Oracle?
Are you using Oracle 8i multiple HOME feature?
Start:Program Files:Oracle For Windows NT:Oracle Home Selector
(if you do not have multiple oracle homes, a dialog box will
pop up telling you so).
If so check to make sure DEFAULT_HOME points to correct location.
Open Regedit and check the following
Depending upon version of Oracle being used:
[HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\ALL_HOMES]
LAST_HOME points to your current (or last) home
directory,
LAST_HOME = "0"
Then check this key, HOME0
[HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOME0]
ORACLE_HOME = "C:\orant"
ORACLE_HOME_NAME = "DEFAULT_HOME"
SHARED_ORACLE_HOME = "C:\orant"
-or -
[HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\ORACLE_HOMES]
>>>>> TESTING CONFIGURATION ISSUES >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
5. In some situations information may be lost (or you may have a
connection problem) if you login in the Data Modeler in lower
case. Try loggin in, in all upper case,
i.e. SCOTT\TIGER not scott\tiger.
6. You get the same problem trying to reverse engineer any
Oracle schema. i.e. sample table SCOTT/TIGER, or that
isn't available, create a simple test schema, add one
simple table to it, i.e.
CREATE TABLE test_table (
col_1 SMALLINT NOT NULL,
col_2 SMALLINT NOT NULL,
CONSTRAINT PK_test0 PRIMARY KEY (col_1)
);
Attempt to reverse engineer this as user TEST (to rule out any
problems with ownership of the schema). i.e. When you create
user TEST a default schema with the name of TEST is created.
Login into SQL Plus as TEST, create the above schema, then
start Rose, Data Modeler, and login as TEST, reverse engineer
TEST schema.
If this schema fails then we are most probably dealing with a
configuration issue.
If this test works, then we are probably dealing with a problem
with something related to the particular schema itself, see
TESTING SCHEMA PROBLEMS below.
7. Can you connect using the o8 addin instead of the Data Modeler
addin? If you cannot connect to your schema using the Oracle8
addin, please see the following technical note.
http://www.rational.com/technotes/rose_html/Rose_Oracle_html/
technote_6451.html
TITLE: Oracle8 Analyze Schema troubleshooting
Oracle8 addin will give more errors and has a longer history,
so if we can get this working, it may also solve the Data
Modeler connection problems or give us a clue as to the cause of
the problem.
Example,
Tools:Oracl8:Analyze Schema
SCHEMA: demo
DATABASE SERVER: <blank if local, or server name if remote>
USERNAME: scott
PASSWORD: tiger
8. If you have tested and confirmed the above then we would like to
try the following test:
Data Modeler uses MDAC OLEDB driver for Oracle that sits on
the top of Oracle client software. To validate whether this
is a Rose issue or a configuration issue outside of Rose
could you please try the following test.
There is a MicroSoft program
that ships with MDAC 2.5 SDK, called RowsetViewer.
This utility can be obtain from MS and is included in
MDAC 2.5 SDK - OLE DB Samples
http://msdn.microsoft.com/downloads/sdks/platform/database.asp
or you can download the SDK from
http://www.microsoft.com/msdownload/platformsdk/setuplauncher.asp
Microsoft Platform SDK
There are quite a few files include with Rowsetviewer, but
the only one needed for the test is rowsetviewer.exe
Start this program.
Go to File:Data Links
On the Provider tab select, Microsoft OLE DB Provider for
Oracle Next button will then take you to Connection tab.
Enter Service name, user name and Password
example:
SERVER NAME: tcp-loopback.world
USERNAME: scott
PASSWORD: tiger
Then [Test Connection]
What was the result of this test?
If this test fails, so will Rose.
Possible solution would be to download latest version of MDAC.
http://www.microsoft.com/data/download.htm
(Component Checker is another utility found in the MDAC SDK
which can tell us your MDAC version, if we suspect this may
be part of the problem.)
>>>>> TESTING SCHEMA ISSUES >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
9. In order to troubleshoot a problem with the schema itself,
We would like to know if you can reverse engineer your table
if it's in the form of a DDL script rather than directly
connecting to the database?
If reverse engineering the DDL file fails please forward.
If reverse engineering of the DDL file works, but
a. It fails when you attempt to reverse engineer it directly
from the database
-AND-
b. Other schemas such as the demo or test schema work,
could you also please forward the DDL so we can create a test
schema with this DDL and test it here?
In order to troubleshoot problems with the schema, we need to
get the DDL in order to duplicate the problem. If the demo or
test schema from above tests also fails, then at this point
getting the DDL is probably not going to help.
10. Are you using object oriented features in this Oracle 8
table or strickly relation constructs? Note that the
data modeler only works with relational. If you wish to reverse
engineer objects, use the Oracle8 addin. See,
http://www.rational.com/technotes/rose_html/Rose_Oracle_html/
technote_11964.html
TITLE: Which addin should I use, Oracle 8 Addin or Data Modeler?
>>>>> QUESTIONS >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
1. What version of Rose is being used?
(help:about, Rose version: 7.0.????, 7.1.????, 7.5.????)
2. What operating system are you on?
3. What exact version of Oracle is being used?
(8.0.6, 8.1.7, etc.)
4. Do you have the Oracle Client software installed?
5. Where is the database, local or remote? If remote what
operating system? Do you have the same Oracle client version
installed on the your machine?
6. You checked issues 1,2,3,4 above?
7. What was the results from the tests in 6,7,8?
Patrick Kennedy
Rational Support
On May 30, 15:10, Mara Lascu wrote:
> Subject: (ROSE) Reverse engineering problem
>
> I am trying to do reverse engineering for an Oracle 8.1.7 database.I go to
> Tools->Data Modeler->Reverse engineering and insert username/password and
> service name the way I defined it in Oracle Net8 Easy Config. It keep saying
> that it cannot connect to the database even though I am able to connect with
> any of Oracle utilities.
> If I go to Tools->Oracle8->Analyze schema I am able to connect but what I
> get is an objecy model not a data model.
> Could somebody help me please?!
> Thanx
> Mara Lascu
>
> ************************************************************************
> * Rose Forum is a public venue for ideas and discussions.
> * For technical support, visit http://www.rational.com/support
> *
> * Admin.Subscription Requests: [EMAIL PROTECTED]
> * Archive of messages:
http://www.rational.com/products/rose/usergroups/rose_forum.jtmpl
> * Other Requests: [EMAIL PROTECTED]
> *
> * To unsubscribe from the list, please send email
> *
> * To: [EMAIL PROTECTED]
> * Subject:<BLANK>
> * Body: unsubscribe rose_forum
> *
> *************************************************************************
>-- End of excerpt from Mara Lascu
************************************************************************
* Rose Forum is a public venue for ideas and discussions.
* For technical support, visit http://www.rational.com/support
*
* Admin.Subscription Requests: [EMAIL PROTECTED]
* Archive of messages:
http://www.rational.com/products/rose/usergroups/rose_forum.jtmpl
* Other Requests: [EMAIL PROTECTED]
*
* To unsubscribe from the list, please send email
*
* To: [EMAIL PROTECTED]
* Subject:<BLANK>
* Body: unsubscribe rose_forum
*
*************************************************************************
