Unix Technical Forum

Oracle client for DOS

This is a discussion on Oracle client for DOS within the Oracle Database forums, part of the Database Server Software category; --> Hi! Where can I download Oracle Client for DOS to connect to Oracle Server version 7, 8 or 9? ...


Go Back   Unix Technical Forum > Database Server Software > Oracle Database

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 02-23-2008, 09:57 AM
Igor Shulgin
 
Posts: n/a
Default Oracle client for DOS

Hi!

Where can I download Oracle Client for DOS to connect to Oracle Server
version 7, 8 or 9?

Thank you for any advice.

--
Igor Shulgin
Chelyabinsk, JSC Uralsvyazinform


Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old 02-23-2008, 09:57 AM
Daniel Morgan
 
Posts: n/a
Default Re: Oracle client for DOS

Igor Shulgin wrote:
> Hi!
>
> Where can I download Oracle Client for DOS to connect to Oracle Server
> version 7, 8 or 9?
>
> Thank you for any advice.
>
> --
> Igor Shulgin
> Chelyabinsk, JSC Uralsvyazinform


No where on this planet.

But you will find sqlplus.exe on every Windows server and client
machine that has an Oracle home. And that is the DOS client assuming,
by DOS, you don't really mean DOS but rather the Windows command line.
Well it really is DOS but the folks at Microsoft hate it when that is
pointed out.

Look in $ORACLE_HOME/bin.

--
Daniel Morgan
http://www.outreach.washington.edu/e...ad/oad_crs.asp
http://www.outreach.washington.edu/e...oa/aoa_crs.asp
damorgan@x.washington.edu
(replace 'x' with a 'u' to reply)

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #3 (permalink)  
Old 02-23-2008, 09:57 AM
Igor Shulgin
 
Posts: n/a
Default Re: Oracle client for DOS

Hi, Daniel!

No, I *really* mean "Microsoft DOS version 6.20". Unfortunately, we must use
MS DOS in our distant departments' computers.
I doubt that sqlplus.exe from $ORACLE_HOME/bin in Windows version would work
in clear MS DOS environment.

--
Igor Shulgin
Chelyabinsk, JSC Uralsvyazinform

"Daniel Morgan" <damorgan@x.washington.edu> ???????/???????? ? ????????
?????????: news:1082358270.737922@yasure...
> Igor Shulgin wrote:
> > Hi!
> >
> > Where can I download Oracle Client for DOS to connect to Oracle Server
> > version 7, 8 or 9?
> >
> > Thank you for any advice.
> >
> > --
> > Igor Shulgin
> > Chelyabinsk, JSC Uralsvyazinform

>
> No where on this planet.
>
> But you will find sqlplus.exe on every Windows server and client
> machine that has an Oracle home. And that is the DOS client assuming,
> by DOS, you don't really mean DOS but rather the Windows command line.
> Well it really is DOS but the folks at Microsoft hate it when that is
> pointed out.
>
> Look in $ORACLE_HOME/bin.
>
> --
> Daniel Morgan
> http://www.outreach.washington.edu/e...ad/oad_crs.asp
> http://www.outreach.washington.edu/e...oa/aoa_crs.asp
> damorgan@x.washington.edu
> (replace 'x' with a 'u' to reply)
>



Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #4 (permalink)  
Old 02-23-2008, 09:57 AM
Howard J. Rogers
 
Posts: n/a
Default Re: Oracle client for DOS

Igor Shulgin wrote:
> Hi, Daniel!
>
> No, I *really* mean "Microsoft DOS version 6.20". Unfortunately, we must use
> MS DOS in our distant departments' computers.
> I doubt that sqlplus.exe from $ORACLE_HOME/bin in Windows version would work
> in clear MS DOS environment.
>


Just out of interest, why is it that these clients must use a 10-year
old operating system? I'm intrigued!

To answer your question, although I'm really just repeating what
Daniel's said: you're not going to find a true DOS client any time soon.
Your best bet, I think, would be to approach Oracle directly and ask
them if they've got anything in the archives. But I don't rate your
chances even so.

Any client that you get truly for DOS is also going to have a hell of a
time connecting to an Oracle 9i database. Oracle 9i clients don't
connect to Oracle 7 databases because of changes in the SQL Net
layers... so I assume Oracle 7 clients don't readily connect to Oracle
9i databases either. Anything that is truly a DOS client is itself going
to be from at least the Oracle 7 or earlier vintage, and is therefore
most unlikely to be able to talk to 9i databases. I suppose, on the
other hand, that miracles do happen.

Which brings me back to wondering why you are so constrained in your
choice of client.

If it's because the machines are so ancient, I'd be looking at
crowbar-ing some sort of Linux onto them and running a more modern
client in an X GUI. Actually, I'd be looking at making a donation to the
local museum and buying something a bit more realistic, but the linux
approach might at least be feasible.

Regards
HJR
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #5 (permalink)  
Old 02-23-2008, 09:57 AM
Holger Baer
 
Posts: n/a
Default Re: Oracle client for DOS

Howard J. Rogers wrote:
>
> Any client that you get truly for DOS is also going to have a hell of a
> time connecting to an Oracle 9i database. Oracle 9i clients don't
> connect to Oracle 7 databases because of changes in the SQL Net
> layers... so I assume Oracle 7 clients don't readily connect to Oracle
> 9i databases either. Anything that is truly a DOS client is itself going
> to be from at least the Oracle 7 or earlier vintage, and is therefore
> most unlikely to be able to talk to 9i databases. I suppose, on the
> other hand, that miracles do happen.


Just for the record: According to the client/server certification matrix,
7.3.4 client to 9iR2 Server connections are classified as 'WAS' i.e.
when 7.3.4 was still supported or in the first two years of EMS, it *was*
expected to work with 9iR2 Servers, and from my experience it does.

However, since 7.3.4 is desupported, it's pretty unlikely that someone
at Oracle will put much effort in helping the OP, considering the quality
of support that was discussed on this group recently....

Regards,

Holger
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #6 (permalink)  
Old 02-23-2008, 09:57 AM
Daniel Morgan
 
Posts: n/a
Default Re: Oracle client for DOS

Igor Shulgin wrote:
> Hi, Daniel!
>
> No, I *really* mean "Microsoft DOS version 6.20". Unfortunately, we must use
> MS DOS in our distant departments' computers.
> I doubt that sqlplus.exe from $ORACLE_HOME/bin in Windows version would work
> in clear MS DOS environment.
>
> --
> Igor Shulgin
> Chelyabinsk, JSC Uralsvyazinform


Try it before rejecting it. I still run a 1995 copy of XTreePro under
Windows XP and it works just fine.

But if it doesn't contact: alison.holloway@oracle.com

--
Daniel Morgan
http://www.outreach.washington.edu/e...ad/oad_crs.asp
http://www.outreach.washington.edu/e...oa/aoa_crs.asp
damorgan@x.washington.edu
(replace 'x' with a 'u' to reply)

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #7 (permalink)  
Old 02-23-2008, 09:57 AM
Jim Kennedy
 
Posts: n/a
Default Re: Oracle client for DOS


"Igor Shulgin" <igor.shulgin@chel.usi.ru> wrote in message
news:c5vpb5$pq9$1@image.surnet.ru...
> Hi!
>
> Where can I download Oracle Client for DOS to connect to Oracle Server
> version 7, 8 or 9?
>
> Thank you for any advice.
>
> --
> Igor Shulgin
> Chelyabinsk, JSC Uralsvyazinform
>
>


You can't; it is not a supported platform anymore. (neither is Oracle 7)
Jim


Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #8 (permalink)  
Old 02-23-2008, 09:58 AM
Ed prochak
 
Posts: n/a
Default Re: Oracle client for DOS

"Howard J. Rogers" <hjr@dizwell.com> wrote in message news:<408388fb$0$16964$afc38c87@news.optusnet.com. au>...
> Igor Shulgin wrote:
> > Hi, Daniel!
> >
> > No, I *really* mean "Microsoft DOS version 6.20". Unfortunately, we must use
> > MS DOS in our distant departments' computers.
> > I doubt that sqlplus.exe from $ORACLE_HOME/bin in Windows version would work
> > in clear MS DOS environment.
> >

>
> Just out of interest, why is it that these clients must use a 10-year
> old operating system? I'm intrigued!
>
> To answer your question, although I'm really just repeating what
> Daniel's said: you're not going to find a true DOS client any time soon.
> Your best bet, I think, would be to approach Oracle directly and ask
> them if they've got anything in the archives. But I don't rate your
> chances even so.
>
> Any client that you get truly for DOS is also going to have a hell of a
> time connecting to an Oracle 9i database. Oracle 9i clients don't
> connect to Oracle 7 databases because of changes in the SQL Net
> layers... so I assume Oracle 7 clients don't readily connect to Oracle
> 9i databases either. Anything that is truly a DOS client is itself going
> to be from at least the Oracle 7 or earlier vintage, and is therefore
> most unlikely to be able to talk to 9i databases. I suppose, on the
> other hand, that miracles do happen.
>
> Which brings me back to wondering why you are so constrained in your
> choice of client.
>
> If it's because the machines are so ancient, I'd be looking at
> crowbar-ing some sort of Linux onto them and running a more modern
> client in an X GUI. Actually, I'd be looking at making a donation to the
> local museum and buying something a bit more realistic, but the linux
> approach might at least be feasible.
>
> Regards
> HJR


While I agree that upgrading the machines should be seriously
considered, Linux might not be a possible solution. LINUX assumes at
least a 32bit processor and that might not be available on machines
that are not even running MS Windows.

But he might be able to use the machines as terminals, using telnet.
Then sqlplus would be running on the server.

Advantages
Keep old hardware OS at departments.
run latest OS and Oracle on the server.

Disadvantages
local functionality is missing, like printing. (e.g., the SPOOL
command would save files on the server which would have to be moved to
the client machine for storing/editting/printing)

About even
communication issues would seem to be similar whether running thin
clients (telnet to server running Oracle) or fat clients (sqlplus on
the department machine)

hth,
Ed
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #9 (permalink)  
Old 02-23-2008, 09:59 AM
Volker Hetzer
 
Posts: n/a
Default Re: Oracle client for DOS


"Ed prochak" <ed.prochak@magicinterface.com> schrieb im Newsbeitrag news:4b5394b2.0404190951.3f6cf42a@posting.google.c om...
> "Howard J. Rogers" <hjr@dizwell.com> wrote in message news:<408388fb$0$16964$afc38c87@news.optusnet.com. au>...
> > Igor Shulgin wrote:
> > > Hi, Daniel!
> > >
> > > No, I *really* mean "Microsoft DOS version 6.20". Unfortunately, we must use
> > > MS DOS in our distant departments' computers.
> > > I doubt that sqlplus.exe from $ORACLE_HOME/bin in Windows version would work
> > > in clear MS DOS environment.
> > >

> >
> > Just out of interest, why is it that these clients must use a 10-year
> > old operating system? I'm intrigued!

There can be several reasons. For instance you want to run it on something constrained,
like an embedded INTEL system. Or you need something that fits on one floppy.
It's quite surprising, how many DOSes are still running in devices.

Lots of Greetings!
Volker
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #10 (permalink)  
Old 02-23-2008, 09:59 AM
Holger Spangardt
 
Posts: n/a
Default Re: Oracle client for DOS

Igor Shulgin wrote:
Hi,
> Hi, Daniel!
>
> No, I *really* mean "Microsoft DOS version 6.20". Unfortunately, we must use
> MS DOS in our distant departments' computers.
> I doubt that sqlplus.exe from $ORACLE_HOME/bin in Windows version would work
> in clear MS DOS environment.

I can only see the way through telnet. I don't know if there exists a
ssh port for dos which would be the better choice. This telnet session
can connect to a remote linux box which offers an sqlplus-interface.
>
> --
> Igor Shulgin
> Chelyabinsk, JSC Uralsvyazinform
>

....
Hope this helps,
Holger
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 01:46 AM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com