Could not connect to host 127.0.0.1 (port 8080).

[Derek Broughton]

Phil Pinkerton wrote:

> Derek Broughton wrote:

>> Try executing the SQLPLUS line - 
>> without the /NOLOG
>>
>> In fact, I _do_ expect a lot more than that.  If I run the script from my
>> own terminal, I get:
>>
>> $
>> /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/config/scripts/startdb.sh
>>   ERROR:
>>   ORA-09925: Unable to create audit trail file
>>   Linux Error: 13: Permission denied
>>   
> squplus output:

Phil, "$sqlplus" is hardly the line in the script.  I'm trying to get you to
execute the startup script one step at a time.  Running sqlplus - with a
bogus username - won't help.

The script executes:

$SQLPLUS -s /nolog @$ORACLE_HOME/config/scripts/startdb.sql

I suggested removing /nolog, but it's really the "-s" (silent) you want to
take out (/nolog is actually "no login", because the connect statement is
part of the sql file).
> 
> $sqlplus
> 
> SQL*Plus: Release 10.2.0.1.0 - Production on Sat Jun 16 07:22:14 2007
> 
> Copyright (c) 1982, 2005, Oracle.  All rights reserved.
> 
> Enter user-name: admin
> Enter password:
> oracleXE: error while loading shared libraries: libaio.so.1: cannot open
> shared object file: No such file or directory
> ERROR:
> ORA-12547: TNS:lost contact

However, all that said - how did you install oracle-xe?  libaio is NOT part
of Ubuntu.  Ubuntu is using libaio1.  libaio needs to be installed from the
same source as oracle-xe.  In my case, I had /etc/apt/sources.list pointing
to the oracle download site, so when I did "aptitude install oracle-xe", I
got the libaio package with it.  Somehow, I seem to have lost that line,
but I'm sure you can find it with google.
-- 
derek