Download Oracle 8

I have downloaded Oracle 9i Lite and evena after following all the tips from this site still cannot get a Listener properly set up and so have been unable to use it.

Does anyone know where I can get a download for Oracle 8 please ?
jonatecAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Guy Hengel [angelIII / a3]Billing EngineerCommented:
If you don't get it right with 9i, I doubt that you will get it working with 8 as it's the same thing.

can you post the listener.ora, tnsnames.ora and the sqlnet.ora (if present)
what is the SERVICE_NAME and/or SERVICE_ID of the database?
how you do try to connect?
what OS?
0
jonatecAuthor Commented:
Thanks, I will peice together the information you ask for and get back....
0
schwertnerCommented:
Turn off all firewalls and antiviruses on the computer.

If they were running you have to einstall Oracle
and isnstall it from scratch.

I guess you are using Windows XP.
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

jonatecAuthor Commented:
Hi, I list below the file contents you requested. I am using Window XP Pro with no firewall or antivirus at the moment, thanks..
----------------------------------------------------------------------------------------------------------------------------------
# TNSNAMES.ORA Network Configuration File: D:\oracle\ora90\NETWORK\ADMIN\tnsnames.ora
# Generated by Oracle configuration tools.

JONATEC =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = jonatec)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = jonatec)
    )
  )
----------------------------------------------------------------------------------------------------------------------------------
# LISTENER.ORA Network Configuration File: D:\oracle\ora90\NETWORK\ADMIN\listener.ora
# Generated by Oracle configuration tools.

LISTENER =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = JONATEC)(PORT = 1521))
  )
----------------------------------------------------------------------------------------------------------------------------------






0
Guy Hengel [angelIII / a3]Billing EngineerCommented:
is the service oraclelistener started?

what does this command line tool calls return:

lsnrctl status
tnsping JONATEC


0
jonatecAuthor Commented:
From a dos window after the command line lsnrctl status I get:

'lsnrctl' is not recognized as an internal or external command
operable program or batch file.

---------------------------------------------------------------------------------------------------------------------
After:  tnsping JONATEC   i get....


TNS Ping Utility for 32-bit Windows: Version 9.0.1.1.1 - Production on 11-APR-20
06 17:15:29

Copyright (c) 1997 Oracle Corporation.  All rights reserved.

Used parameter files:
D:\oracle\ora90\network\admin\tnsnames.ora

Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)
(HOST = jonatec)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = jonatec)))
TNS-12541: TNS:no listener


0
schwertnerCommented:
c:>lsnrctl status
c:lsnrctl start
0
schwertnerCommented:
c:>lsnrctl start
0
Guy Hengel [angelIII / a3]Billing EngineerCommented:
>'lsnrctl' is not recognized as an internal or external command

then you have to check the exact name, possibly in version 8 of oracle the tool has a slighly other name.
check in the bin folder for files with a similar name...
0
schwertnerCommented:
in Oracle 8i 'lsnrctl' exists.
But it is visible only iv the Oracle 'bin' directory is in the PATH
environment variable.
So you have the check if the user you connect has the correct entry in PATH (in Linux/Unix)
or the installation is successfull un Windows.
Also try simply to find this commend ($ORACLE_HOME\bin)
and to start it usin full directory description.
How many Oracle homes have you on your box?
0
virtual_voidCommented:
You mentioned that you downloaded Oracle 9i Lite, are you using it for mobile applications?

For lite you need a database server, a mobile webtogo server (e.g. 9i lite) and a mobile client.

If you just want a database server download the 9i database, Oracle used to have a personal database but lite is different from a personal database.
0
jonatecAuthor Commented:
Ok, I can't find a lsnrctl file in the ora90/bin directory.

Yes, I downloaded Oracle 9i Lite from the Oracle web site and installed the defaults. Are you suggesting the Lite edition is for mobile web development only? Do I need to de-install the whole lot and get the full Oracle 9i? I only want to create tables and test out some PL/SQL on my home machine, which is running Win Xp.

0
schwertnerCommented:
Yes,
Lite is a special Oracle edition for Mobile devices.
You can install Enterprise Edition or Personal Edition of Oracle instead.
0
virtual_voidCommented:
You can download 9i server for windows at:
http://www.oracle.com/technology/software/products/oracle9i/htdocs/winsoft.html

Why are you downloading 9i when 10.2 is available, it has many more features and easier to use than 9i (however it does require more resources, about 15% more CPU/RAM than 9i)

0
jonatecAuthor Commented:
Ok, so to summarise, should I get the full version of Oracle 9i and this will work ok ?
Second point is Oracle 9i is used at work, hence the reason I want it on my machine at home.
0
virtual_voidCommented:
Yes. 9i full version (9i database server) will work fine.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.