[opencms-dev] installation on Oracle 10g - cannot drop user

[Michael Moossen]

Hi Mathias!

check the connection string, by default the setup wizard proposes a connection
string for Oracle9, for Oracle10 you have to remove the at-char (@) in-front of
the server name.

HTH 

Kind Regards,
Michael
 
-------------------
Michael Moossen
 
Alkacon Software GmbH  - The OpenCms Experts
http://www.alkacon.com - http://www.opencms.org




Quoting Mathias Diehl <md at evoconcept.de>:

> Hi List,
> 
> I tried to install OpenCms on Oracle 10g (as we will use Oracle also for some
> other tasks...). Unfotunatly I'm far away from beeing a dba - but however...
> 
> My problem is that the installation fails as the install wizard tells me:
> 
> Error executing SQL statement: DROP USER opencms CASCADE
> -------------------------------------------
> java.sql.SQLException: ORA-01940: cannot drop a user that is currently
> connected at...
> 
> 
> 
> As I'm quite sure that there are people out there running opencms with oracle
> I wonder what causes my problem. 
> 
> I run opencms on tomcat 5.5 and (even though not authorized) oracle on debian
> sarge.
> 
> Any idea what's wrong? I tried to reboot my database and start the wizard
> again - no effect. I tried to reboot the tomcat server - no effect.
> 
> Any help would be highly appreciated.
> 
> cheers,
> 
> Mathias
> 
> _______________________________________________
> This mail is sent to you from the opencms-dev mailing list
> To change your list options, or to unsubscribe from the list, please visit
> http://lists.opencms.org/mailman/listinfo/opencms-dev
> 


----------------------------------------------------------------
This message was sent using IMP, the Internet Messaging Program.