I remember this being very complex with earlier versions of Oracle,
but just seemed to work here. I'm sure that must mean that I did
something wrong, forgot something I did or that there's a massive
This is what I remember doing:
Logging into Linux as user 'oracle'
Make sure that "oraenv" has been executed (i.e., your
$ORACLE_HOME is set correctly)
On your client machine all you need to do now is point it at the right
machine and database instance.
If you want more control over the process, the "Net8 Configuration
Assistant" ('netec') should be able to help.
This used to be very difficult in many earlier version of Oracle,
involving editing many text files, most of which had an fantastically
But in 8i, if you've got your JVM working, then all you need is the
"Net8 Easy Config" program. Follow these steps to allow your machine
to connect to a database on another machine:
Start "Net8 Easy Config" by typing netec at the command
prompt while logged in as 'oracle.'
After a short delay while Java gets its act together, the
welcome screen appears. It should be asking what you want to do. Leave
the radio buttons on the left alone (the default is 'create') and
enter the name of the database in the text box. Click 'Next' when
Select one of the protocols it offers. Unless you know
differently, this should probably be 'TCP/IP' which is the
default. Press 'Next.'
Enter the hostname (or IP address) of the remote machine. The
port number probably doesn't need changing. Press 'Next.'
Select the type of database (8i or other) using the radio
buttons and enter the name in the appropriate text box. Press 'Next.'
You can now test that the information you've enter makes sense
to Oracle. I found that 'netec' has a tendency to crash if some of the
details are wrong. Press 'Next' when you're sure that it all
works. You can keep pressing the 'Back' button to go back and correct
If you're happy with all the information you've entered, you can
press the 'Finish' button and that's it!
If you want more control over the process, you may need to use the
"Net8 Assistant" -- a big window with many confusing options -- which
can be started with the netasst command.