[Solved] Installation problem with Oracle 9i

[TEVA_COGNOS]

Hi all,

I'm currently trying to install ReportNet on a server with Oracle 9i.Ã,  All the components will be on the same computer.

I have already install reportnet but it was on Oracle 8i and unix environment.

Environment: windows (XP), IIS, JRE 1.4.1.2, Oracle 9i

I have created the environment variables HOME_JAVA, TNS_ADMIN, ORACLE_HOME and NLS_LANG.

I have created the oracle database for the content store with the character set UL32UTF8, I have copied and renamed the file classes12.zip to classes12.jar for JDBC in the crn directory.

I have created the virtual directories crn, crn/cgi-bin and crn/help...

But I got a error message HTTP 500.Ã,  My problem comes from the content manager which can't connect or create the database...Ã,  I tried various solutions in the configuration tool using either Database Oracle or Database Oracle (advanced options)...

Have you got an idea of what I could try ???

Thank you very much for your help

[BIsrik]

R u configuring directly on the oracle server or connecting the oracle server through client.

I had once faced a problem while configuring through client. For my case the SID of the client was renamed to a user friendly name.

I found that this type of renaming will not work for configuring the CS. the SID of the client and the server should be same...

Srik

[TEVA_COGNOS]

R u configuring directly on the oracle server or connecting the oracle server through client.

The oracle server is on the same computer that ReportNet, I have tried to connect to the database using Toad and this is OK, do someone knows where I can find the strings connection used by the content manager to connect via JDBC to the oracle database ???

Thanks for your help

[cognosfreelancer]

Enter the following command in your DOS window

tnsping 'name of your database'.

This would be your SID.

Confirm the port number and host.

Make sure you enter the same port and host in your congos configuration. Also are you entering the same user id and password.

Finally the account under which you log into the content store should have full privileges to the database objects.

NKT

[TEVA_COGNOS]

thank you,

I will tried this and wil let you know...

have a good day

[TEVA_COGNOS]

I have tried it after checking the connection string with tnsping dos command but it doesn't work...

Is anyone to suggest something ???

Thanks in advance

[sir_jeroen]

Doesn't tnsping work.. Than you have to find the correct tns. Because if tnsping can't find it......

[TEVA_COGNOS]

tnsping is OK
here's the error message

Etat HTTP 500 -

type Rapport d''exception

message

description Le serveur a recontrer une erreur interne () qui l'a empèché de satisfaire la requête.

exception

javax.servlet.ServletException: "Servlet.init()" pour la servlet dispatch a généré une exception
   at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:963)
   at org.apache.catalina.core.StandardWrapper.allocate(StandardWrapper.java:668)
   at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:210)
   at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
   at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
   at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
   at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
   at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
   at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
   at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
   at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2416)
   at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)
   at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
   at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:171)
   at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
   at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172)
   at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
   at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:577)
   at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
   at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
   at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
   at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174)
   at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
   at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
   at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
   at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:223)
   at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:601)
   at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:392)
   at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:565)
   at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:619)
   at java.lang.Thread.run(Unknown Source)

cause mère

java.lang.NoClassDefFoundError
   at javax.crypto.Cipher.a(DashoA6275)
   at javax.crypto.Cipher.getInstance(DashoA6275)
   at com.cognos.accman.jcam.crypto.SystemProtectionSession.(SystemProtectionSession.java:65)
   at com.cognos.accman.jcam.crypto.misc.Configuration.(Configuration.java:46)
   at com.cognos.accman.jcam.crypto.misc.Configuration.getInstanceWithDefaultConfig(Configuration.java:93)
   at com.cognos.accman.jcam.crypto.CAMFactory.initialize(CAMFactory.java:110)
   at com.cognos.caf.S.A(Unknown Source)
   at com.cognos.caf.S.configure(Unknown Source)
   at com.cognos.caf.CAFFirewall.configure(Unknown Source)
   at com.cognos.pogo.transport.PogoServlet.init(PogoServlet.java:117)
   at com.cognos.pogo.isolation.ServletWrapper.initServlet(ServletWrapper.java:112)
   at com.cognos.pogo.isolation.ServletWrapper.init(ServletWrapper.java:98)
   at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:935)
   at org.apache.catalina.core.StandardWrapper.allocate(StandardWrapper.java:668)
   at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:210)
   at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
   at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
   at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
   at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
   at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
   at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
   at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
   at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2416)
   at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)
   at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
   at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:171)
   at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
   at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172)
   at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
   at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:577)
   at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
   at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
   at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
   at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174)
   at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
   at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
   at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
   at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:223)
   at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:601)
   at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:392)
   at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:565)
   at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:619)
   at java.lang.Thread.run(Unknown Source)

Apache Tomcat/4.1.27

??? ??? ??? ??? ??? ??? ??? ???

[BIsrik]

is that problem solved. if not...do one thing..go to the logs directory and rename the crnserver log file to some other name. again try to connect to the cognos connection. the error appears again and a new crnserver log file [with the old file name] is created in the log directory. check in that...what it is indicating...

Srik

[Darek]

I think I was getting same error when my JCE expired.

http://support.cognos.com/supported/en/support/advisories/advcrn04_0405.html

[TEVA_COGNOS]

The problem is solved.

After checking the knowledge base, I read the antivirus could be responsible of the non creation of the content store.Ã,  As soon I disabled it, ReportNet was OK....

Thank you for your help, your advice was helpful

Teva

[TEVA_COGNOS]

Hi all,

To close this subject, I have to add to be exhaustive that Oracle installation was too responsible of this problem of installation:  the HTTP server installed with Oracle killed IISS services when computer was starting....

Teva