| How to make a DOS-based ORACLE database running [message #656347] |
Mon, 03 October 2016 13:26  |
 |
larshgf
Messages: 8
Registered: September 2016
|
Junior Member |
|
|
Hello ORACLE-people,
I have a friend who about 15 years ago wrote a dictionary for Greek-Danish using a DOS-program called CXMaster (from Compulexis). He know needs the data again and because he had some problems to get the old DOS program running I have tried to help him.
Until now I have copiede the CXMASTER folder (program) and the CXDATA folder (data) from his old computer to my laptop. I am trying to run the CXMASTER from my laptop using a DOS emulator called DOSBOX. When trying to do this the only thing that happens is that I get the main (wellcome) window of CXMaster but without the "log in" possibility (there is only a black rectangular area at the bottom of the screen. So I cant go further because I get a DOS prompt message: "access denied".
However, by looking at an Autoexec.bat file afterwards, I realized that a map called ORACLE6 is needed too. I have yet not tried to copy this map to my laptop because of practical reasons but my hope is that a connection to the ORACLE6 map will make a proper "log in" possible.
In connextion to these problems my dream scenario would be answers to a few questions:
1) Do you think it will be possible to run CXMaster in DOS in a) DOSBOX (or Virtual Box) or b) on my friends original PC (in that case it has to be fixed)? Of course the main program (CXMASTER), the CXDATA folder and the ORACLE6 folder must be on the same harddisk.
2) [in case it is not possible to access data in a DOS based system] Would it be possible (using some kind of Database tool) to get access to the dictionary data from these files in the CXDATA map without using the CXMaster.......?
[The files in the CXDATA folder (in brackets I have written what I think these files do)
CXAUX001.ORA - Configuration tables
CXDTGA10.ORA (data-files) - Configuration tables
CXDTGB10.ORA (data-files) - Configuration tables
CXHIST10.ORA (historic - log)
CXHIST11.ORA (historic - log)
CXHIST12.ORA (historic - log)
CXROLL01.ORA (?) - Oracle transaction rollback data file
CXSMLL10.ORA (?) - CX primary data table CXSMLL11.ORA (?) - ditto (Oracle expansion file)
CXSMLL12.ORA (?) - ditto (Oracle expansion file)
CXSYS001.ORA (different systemdata, for instance felt-definitions, texts in CXMaster etc)
CXWORK01.ORA (?) - temporary working area
DBS1.ORA (as far as I can see text that could be SQL-code)
DBS2.ORA (as far as I can see text that could be SQL-code)
MOVEDATA.SQL
3) Do you have any advice for me concerning this problem?
4) If I am not able to solve this do you know where I can find profesional help and how much this will cost me?
I hope very much to hear from somebody here on this forum. I have no professionel connection to (or financial interest in) this situation. I am facinated by the greek language. For many years I have been a happy amateur making small programs in the Delphi language mainly for personal use. Unfortunately my experience with databases is insuficient, and I have not worked with Oracle at all. I hope very much somebody out there can help me with som advice / answers so I can be able to restore the hard work (a complete dictionary!) made by my friend for about 15 years ago.
Kind Regards
Lars Frederiksen
DENMARK
|
|
|
|
|
|
|
|
| Re: How to make a DOS-based ORACLE database running [message #656355 is a reply to message #656349] |
Mon, 03 October 2016 15:45  |
 |
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
|
Senior Member
Account Moderator |
|
|
Oracle6? Whoa, that's old.
The first Oracle I ever saw was version 5; I had an opportunity to "work" with Oracle 6 for 2 months (or so), but the first "real" version I worked on was Oracle 7. I think I have the "Personal Oracle" CD somewhere, but I can't remember which version it really was. Why am I saying that? Because I believe that you'd have to install Oracle database, version 6, on your computer. I don't know whether you can acquire that version at all. Perhaps you could ask Oracle corp. (if I were them, I'd be happy to give it to you. Knowing how old it is, I'd consider it abandonware (not really, but close to it)).
However, even if you manage to get it, I'm not sure it'll work in DOSBOX (regarding required memory etc.). VirtualBox? Perhaps, if you put pure DOS onto it. I think I have DOS 5.0 somewhere on floppy disks but I don't have a floppy disk drive any more; Google says it can be downloaded (is it legal? No idea).
Imagine you install DOS and put Oracle onto it. What then? As data is stored into tables, you could - as the simplest option - spool data into TXT files and load it somewhere else; Oracle Application Express could even create an "application" based on those files (true, there wouldn't be any relations between tables, but I suppose that the dictionary you talk about can't be that complex ...). Why spool? Because I guess that export/import wouldn't work; I don't feel like investigating compatibility matrix for Oracle databases, but I don't think that you could import Oracle 6 export into any modern Oracle database just like that.
Anyway, looks like an interesting task to do, with uncertain outcome. Best of luck!
|
|
|
|
|
|
| Re: How to make a DOS-based ORACLE database running [message #656367 is a reply to message #656359] |
Tue, 04 October 2016 02:01 |
John Watson
Messages: 8961
Registered: January 2010
Location: Global Village
|
Senior Member |
|
|
|
I would think that you have to get the current release 6 system running. I remember that O6 for DOS came on about 50 3.5" diskettes, even if you have them the chance of them all reading correctly is minimal. Just copying the software may not work. What is the state of the current system?
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Re: How to make a DOS-based ORACLE database running [message #656912 is a reply to message #656911] |
Sun, 23 October 2016 04:01 |
John Watson
Messages: 8961
Registered: January 2010
Location: Global Village
|
Senior Member |
|
|
|
Are you sure it is the original machine? You say the application was written fifteen years ago, and that you are using Windows XP. XP was released on 25 October 2001. Well, of course fifteen years is only an estimate, but you also said that it was a DOS program. Certainly the only PC installs I saw of O6 were on on DOS PCs, never Windows XP, or even Windows 95.
|
|
|
|
| Re: How to make a DOS-based ORACLE database running [message #656913 is a reply to message #656912] |
Sun, 23 October 2016 04:38 |
|
larshgf
Messages: 8
Registered: September 2016
|
Junior Member |
|
|
The old pc is from about 1997 I guess. It has two harddisks. An old one (10 Gb) with Windows 98,and a newer one (80 gb) with Windows XP. If I start with F8 I can choose DOS in fail secured condition. So I have the Black DOS screen and can act with the usual old DOS commands. My friend (it is his pc and program) has been able to run the cx-master with Oracle on this very pc for sure. But I guess it is about 8 years ago he used it last time.
[Updated on: Sun, 23 October 2016 04:40] Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
