[opencms-dev] installation on Oracle 10g - cannot dr.

[Mathias Diehl]

Hi Michael,

thanx for your prompt response. I found a hack to solve my problem - but will also test your advise sometime.

The hack: run wizad to the error message, check via sqlplus for connections, kill them, go back with the wizard and try import again.

Also I noticed that two collums (I think PROJECT_NAME) are too short.

cheers,

Mat


-----Original Message-----
Sent: Freitag 21.04.06 11:51:52
Subject: Re: [opencms-dev] installation on Oracle 10g - cannot dro...

>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.
>
>
>_______________________________________________
>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