[BNM] Accessing Oracle Db on AIX

[Jason Bailey]

--- On Fri, 19/9/08, Hazlitt Eastman <heastman at i-zimbra.com> wrote:

> We are trying to extract a load of data from an Oracle
> database running
> on an AIX box using SQLPlus.
> 
>  
> 
> When we try and execute SQLPlus from a shell without
> options or using
> the option dbadmin/ignored, using a fully qualified path we
> get the
> following error: -

Hello,

Have you set the oracle_home path?
http://sabdarsyed.blogspot.com/2007/09/how-to-find-oraclehome-path-in-oracle.html

Also might be worth using something like Toad (win only and not free) or sqldeveloper (free -java based) on your desktop computer to access the database. You'll still need to install oracle tools on the computer (i.e. sqlplus and set oracle_home).

I've not set-up oracle DBs but do use the developer tools on my PC and connect to one a lot.

Jas