Skip to Main Content
Forums

SQL Developer Data Modeler

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Logical Diagram Notation - Information Engineering Notation

899773Nov 11 2011 — edited Oct 18 2012
I'm a little confused about the Logical Diagram Relational Properties diagram. In a parent/child relationship where parent is required and children are optional, the Source to Target Cardinality must be set to * and Target to Source Cardinality to 1. Source Optional pertains to the Source and is unchecked and Target Optional is checked. A bit inconsistent and untuitive to me to have one Source setting describe the source and the other Source setting describe the Target, but fine. Those settings display correctly in Barker and Bachman notation.

If, however, you switch the notation to Information Engineering Notation, the optional settings are revered and display incorrectly. Checking Source Optional controls the optionality of the Target and visa versa.

Comments

There's been a few common issues we are seeing, lets make sure you are not hitting them. In particulat pay close attention to #4, #5 and #7 below.

  1. Is ORACLE_HOME or TNS_ADMIN set in the environment? Go to a command prompt, type "set". You will need to temporarily unset any such environment variables.

  2. Are you using Windows 10 Home Edition? It is not supported and the installer is not properly checking for it in the Prerequisite check.

  3. Are you using Server 2019? Same issue.

  4. On your network adapter that you are using, check (enable) "Client for Microsoft Networks" and "File and Printer Sharing for Microsoft Networks".

  5. Check to see if Netbios is enabled on your network connection:
    See this link for more info:
    http://ecross.mvps.org/howto/enable-netbios-over-tcp-ip-with-windows.htm

  6. In some cases, antivirus has interfered with an installation. Try disabling anti-virus and then installing.

  7. Try creating a local user and adding to local administrator group and then log in and install as that user.

If any of these work for you, please report back and let me know.

Leo2807

Hello,
I saw the same answers and notes in another task and in the past I did all of them - but without a solution of my problem.
The Link you sent me is faulty and I cannot see the content there.

It looks like that link is down right now.
You can read the instructions in the internet archive:
Enable NetBIOS over TCP/IP with Windows (0 Bytes)One of the main issues with the 18.4 windows installer is that it uses named pipes. This tends to be locked down by anti-virus and by administrators. In future releases of XE on windows, named pipes will not be used.

Leo2807

Thanks you for your help.
I enabled the NetBIOS with the help in the documentation and start the installation again as Administrator (without any AntivirusTools).
But it was of no use - I have still the same problem.

User_EAI7R

I am also having the same problem, trying a failing to install on 18.4 on 3 PCs. I have successfully installed it on my laptop with no problem but always getting this roll back issue after installation process gets so far on these 3 PCs. I have tried every suggestion I have found with no luck. Is it related somehow to whether or not the PC is connected to a network?
By deleting all traces of previous attempts to install it, including registry keys, I have now got it to install on 2 of the PCs. I can connect through SQL*Plus but not through the proprietary software I am trying to use there is no Listener service on either PC.

1 - 5
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Nov 15 2012
Added on Nov 11 2011
#data-modeler
3 comments
431 views