Congratulations, you have Oracle running on your Linux box. You have created a database and can connect to it using SQL*Plus.
Of course, this is not the end of it. Ideally, you'd be able to connect to it as another Unix user or from a completely different machine. That is what this section is for.
Some of the details in this section are a little sketchy as this is not a configuration that I personally use. However, performing one of the following steps should work:
. oraenvif you run a Bourne-like shell (like Bash or pdksh)
source coraenvif you prefer the C-Shell
When running "oraenv" I get an error if I use 'bash', the default Linux shell. It seems not to cause any problems so don't worry. You can always use 'pdksh' if it does worry you.
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 security hole.
This is what I remember doing:
$ORACLE_HOME
is set correctly)lsnrctl start
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 complex syntax.
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:
netec
at the command
prompt while logged in as 'oracle.'
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.
The problem is with a couple of zero-length files. Installing the patch should fix this problem.