Java Mailing List Archive

http://www.dba.5341.com/

Home » Home (12/2007) » suse oracle »

Re: [suse-oracle] SL 10.1 + 10g R2 + HTMLDB

Rolf Masfelder

2006-06-13

Replies:

Hello Ansgar,

Am Montag 12 Juni 2006 13:58 schrieb Ansgar Schlueter:
> Hello
>
> I am struggling with SuSE Linux 10.1, Oracle 10g R2 DB and HTMLDB
> from the companion CD.
>
> Installation of 10g R2 went without any problem. I used the available
> Information for 10g R2 and SL 10.0.

nice to know ... because
>
> Installation of HTTP server and HTMLDB from companion CD failed,
> because apache couldn't start because of missing libdb.so.2. This
> problem can be resolved by installing the gnome-libs.

I will install a similar environment the next days ..

>
> Now the installation of apache and HTMLDB showed no problems. The
> HTTP server is working on port 7780 but when trying to use htmldb I
> get the following error message in my browser:
>
> Service Temporarily Unavailable
> The server is temporarily unable to service your request due to
> maintenance downtime or capacity problems. Please try again later.
> Oracle-Application-Server-10g/10.1.2.0.0 Oracle-HTTP-Server Server at
> tux02.tm.iabg.de Port 7780

did you configure the file
$ORACLE_HOME/Apache/modplsql/conf/marvel.conf ?
PlsqlDatabaseUsername -Password and -ConnectString ???

This is from an Installation of HTMLDB 1.6 on a SuSE 9.2 but I'm shure
it is still the same file to configure.
>
> I enabled PLSQL debugging and found the following error message:
>
> <265829316 ms>[ReqStartTime: 12/Jun/2006:15:50:42]
> <265829316 ms>Request ID ReqID:24775_1150120242
> <265829316 ms>Connecting to database with connect string :
> "(DESCRIPTION=(ADDRES
> S_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=tux02.tm.iabg.de)(PORT=1521)))(CO
>NNECT_D ATA=
> (SERVICE_NAME=TIMR2)))"
> <265829366 ms>ORA-604 LogOn ORA-00604: error occurred at recursive
> SQL level 1
> ORA-00911: invalid character
> <265829366 ms>Stale Connection due to Oracle error 604
> <265829366 ms>Logoff: Closing connection due to stale connection
> <265829366 ms>[ReqEndtime: 12/Jun/2006:15:50:42]
> <265829366 ms>[ReqExecTime: 50 ms]
>
> So there seems to be a problem with the Logon to the
> HTMLDB_PUBLIC_USER schema. I'm puzzled with the "ORA-00911: invalid
> character", since the password does not have any special characters.
> Using sqlplus to login to the HTMLDB_PUBLIC_USER is possible without
> any problem.

Don't worry about the 00911! This is caused by the error-Message and if
you are using GERMAN_GERMANY ... ....

>
> So I am lost at this point and would be glad to get any hints to
> solve this problem.
>
> Regards
> Ansgar
> --
> Ansgar Schlueter                phone: +49 5933 62-119
> IABG mbH Aussenstelle Lathen        fax:  +49 5933 6220
> Hermann Kemper Str. 23            email:
> Ansgar.Schlueter@(protected)                  
> web:
> http://www.iabg-transrapid.de/
> Germany
Viel Glück
--
MfG
Rolf Masfelder
EMail:  rolf.masfelder@(protected)

--
To unsubscribe, email: suse-oracle-unsubscribe@(protected)
For additional commands, email: suse-oracle-help@(protected)
Please see http://www.suse.com/oracle/ before posting

©2008 dba.5341.com - Jax Systems, LLC, U.S.A.