AW: [opencms-dev] Installation of opencms for Oracle

[Oppermann, Joerg]

Hi Kai,

to your question regarding newsmodul and Oracle. Try to set the property 'poolname' for the news module in the module administration from the mysql poolname to jdbc:opencmspool:oracleOci and execue the newsmodule sql script in Oracle.
I have not tried it but could work.

Best regards, Joerg

-----Ursprüngliche Nachricht-----
Von: Schmidt, Kai [mailto:Kai.Schmidt at bonprix.net]
Gesendet: Dienstag, 14. Januar 2003 12:31
An: 'opencms-dev at www.opencms.org'
Betreff: AW: [opencms-dev] Installation of opencms for Oracle


Hi Deepak,

we used the classes12.jar driver to connect to oracle and placed it in the
/lib -directory of Tomcat (4.0.4).
Then we selected GENERICSQL in the setup wizard and entered a
connectionstring like
jdbc:oracle:thin:@your_oracle_db:1521:your_SID

That works quite fine here (but of course not with some modules like the
news module which is written for mysql)

By the way, is there someone out there with a news module for Oracle???

Best regards,
Kai

> -----Ursprüngliche Nachricht-----
> Von: deepaksawdekar [mailto:deepaksawdekar at infosys.com]
> Gesendet: Dienstag, 14. Januar 2003 11:56
> An: opencms-dev at opencms.com
> Betreff: [opencms-dev] Installation of opencms for Oracle.
> 
> 
> Hi ,
> 	I am trying to install OpenCms 4.6.1 using oracle 
> 8.1.7.0 as a database. Does anybody has the document for the 
> same since I could not found it on the site www.opencms.org .
> 
> 
> I got this error when I tried to install opencms for oracle.
> 
> "Could no connect to database via: jdbc:oracle:oci8:@localhost
> java.sql.SQLException: ORA-12514: TNS:listener could not 
> resolve SERVICE_NAME given in connect descriptor"
> 
> 
> 
> Please help
> 
> Thanks and Regards
> Deepak 
>