[nick.polites]

Besides changing the IP address, the only changes you need to make to the server.xml for Tomcat is
Context path="/analytics" docBase="/opt/oraclebi/web/app" privileged="true">

You also have to add the JAVA_HOME directory to your startup and shutdown scripts for Tomcat.

Honestly you should already have a ticket opened with Oracle support. The 4-5 page document is missing a lot of information that is needed to get this installed. After I documented the entire process, I ended up with a 21 page document.

[suresh_gym]

Hi Nick,

Yes, I have raised the SR with Oracle, but still it's waiting with the development for more than a week. Thanks for all your inputs, so that I can reduce my error level.

I verified the server.xml and it seems fine. I have a big doubt. What are the services associated with OBIEE? For me the following services are running.

1. oc4j
2. BI server(run-sa.sh)
3.Oracle BI Java Host(run-saw.sh)
4.Oracle BI Scheduler(run-sch.sh)

Apart from this should I start the apache(using apachectl) and tomcat(startup.sh)? As per my configuration, I believe this should be the problematic one.

[nick.polites]

Yep that should be all that is needed. Check all of your obi startup scripts and ensure you don't get any errors in any of these startups.

[suresh_gym]

Hi Nick,

I started the services and found no errors in the logfiles. But still I can't see the dashboards from OTM.

What should be Listen port values in <obiee>/apache/conf/httpd.conf file? It should be same like the value in <otm>/apache/conf/httpd.conf file?

Here are the values at my environment.
/otm55/apache/conf/httpd.conf
Listen 10.239.5.126:80
Listen 10.239.5.126:443

/oraclebi/apache/conf/httpd.conf
Listen 10.239.5.126:8081
Listen 10.239.5.126:8443

/otm55/glog/config/glog.properties
aa_webserver=ctsinnvlvmotx.cts.com:8443

Do you find any issue over these values?

[nick.polites]

On the OBIEE http, I'm running on port 8081.

Make sure you glog.properties file on your web server looks like this for AA.

# Advanced Analytics
aa_webserver=xxx.mavenwire.com:8081
#aa_domain=.[AA_DOMAIN]
ALLOW_ADVANCED_ANALYTICS=true

Nick

[suresh_gym]

Nick,

I restarted all the services. But this I got a exception while accessing OBIEE from OTM.

type Exception report

message

description The server encountered an internal error () that prevented it from fulfilling this request.

exception

java.net.ConnectException: Connection refused
java.net.PlainSocketImpl.socketConnect(Native Method)
java.net.PlainSocketImpl.doConnect(PlainSocketImpl .java:333)
java.net.PlainSocketImpl.connectToAddress(PlainSoc ketImpl.java:195)
java.net.PlainSocketImpl.connect(PlainSocketImpl.j ava:182)
java.net.SocksSocketImpl.connect(SocksSocketImpl.j ava:366)
java.net.Socket.connect(Socket.java:520)
java.net.Socket.connect(Socket.java:470)
java.net.Socket.<init>(Socket.java:367)
java.net.Socket.<init>(Socket.java:180)
com.siebel.analytics.web.sawconnect.ConnectionPool SocketFactoryImpl.createSocket(ConnectionPoolSocke tFactoryImpl.java:63)
sun.reflect.NativeMethodAccessorImpl.invoke0(Nativ e Method)
sun.reflect.NativeMethodAccessorImpl.invoke(Native MethodAccessorImpl.java:39)
sun.reflect.DelegatingMethodAccessorImpl.invoke(De legatingMethodAccessorImpl.java:25)
java.lang.reflect.Method.invoke(Method.java:585)
com.siebel.analytics.web.sawconnect.ConnectionPool SocketFactoryImpl.createSocket(ConnectionPoolSocke tFactoryImpl.java:70)
com.siebel.analytics.web.sawconnect.ConnectionPool .createNewConnection(ConnectionPool.java:314)
com.siebel.analytics.web.sawconnect.ConnectionPool .getConnection(ConnectionPool.java:133)
com.siebel.analytics.web.SAWBridge.processRequest( SAWBridge.java:284)
com.siebel.analytics.web.SAWBridge.doPost(SAWBridg e.java:320)
javax.servlet.http.HttpServlet.service(HttpServlet .java:647)
javax.servlet.http.HttpServlet.service(HttpServlet .java:729)

I can able to see the same error in tomcat logfiles. Any suggestion?

[nick.polites]

Unfortunately I would have to take a look at your environment to troubleshoot where the error is coming from. PM me if you are interested in Mavenwire providing you support or you could wait for Oracle support to get back to you.

Nick

[suresh_gym]

No problem Nick. Thanks for all your support. I would update with the resolution method followed.

[suresh_gym]

Hi Nick,

Finally I have solved the issue. No other trouble shooting is required other than the stuffs specified in this thread. I removed the entire installation directory and re-installed the OBIEE software again. I took the help of the oracle installation document, this thread and my past experience. Now I can access OBIEE from OTM.

Thanks for all your support Nick! I have asked oracle to close the SR which is still with the development.

[seo1394]

Originally Posted by nick.polites

Did you rerun the [FONT='Arial','sans-serif']OBI EE]/Oracle BI\server\Bin\[/FONT]schconfig script again so that it uses the 9i client?

I am also assuming you have installed this on a Redhat 4 server?


[FONT='Arial','sans-serif']As far as modifying the odbc.ini, I can tell you that I didn't have to modify it to get this working. I had to add the RPTAPP as a tnsnames.ora entry into the Oracle 9i client.[/FONT]
[FONT='Arial','sans-serif'][/FONT]

The TNSNAMES.ORA is a configuration file and the entry inside this file is used to connect to a oracle database server.
This file exist in oracle client pc and from the client computer this file entry is used to resolve
oracle service to establish connection to oracle server. It is nothing but contains net service names
mapped to connect descriptors for the local naming method, or net service names mapped to listener
protocol addresses. Note that we can easily connect to oracle database server without the help of
TNSNAMES.ORA.