A walk through some of the hard won lessons of using Oracle Business Intelligence, the experience of upgrading to 11G and how it works.
Showing posts with label windows server 2008. Show all posts
Showing posts with label windows server 2008. Show all posts
Tuesday, 7 January 2014
OBIEE - Javascript and CSS locations
In OBIEE 11g, the path for Javascript and Custom Style Sheet is located at-
OBIEE\user_projects\domains\bifoundation_domain\servers\bi_server1\tmp\_WL_user\analytics_11.1.1\7dezjl\war\res\
And for using them-
<script type="text/javascript" src="res/test.js"></script>
<link href="res/test.css" type="text/css" rel="stylesheet">
Refererence- https://forums.oracle.com/forums/thread.jspa?threadID=2453825&tstart=0
Thursday, 18 October 2012
Creating a windows service for a managed server in OBIEE 11.1.1.6
Create a text file with the contents as below, the assumption here is that you have a middleware home of D:\OBIEE11G - set yours appropriately and fill in the servername in <myserver>.
SETLOCAL
set DOMAIN_NAME=bi_server1
set USERDOMAIN_HOME=D:\OBIEE11G\user_projects\domains\bifoundation_domain
set SERVER_NAME=bi_server1
set PRODUCTION_MODE=true
set ADMIN_URL=http://<myserver>:7001
cd %USERDOMAIN_HOME%
call %USERDOMAIN_HOME%\bin\setDomainEnv.cmd
call "D:\OBIEE11G\wlserver_10.3\server\bin\installSvc.cmd"
ENDLOCAL
and name the file something like "installManServer.cmd"
Assuming that you have created an AdminServer service and set the Java Memory configuration then you are nearly home and dry.
Refer to http://docs.oracle.com/cd/E14571_01/web.1111/e13708/winservice.htm#i1188099
especially the part on delay (-delay:delay_milliseconds) and depend (-depend:"beasvc Adminserver_Adminserver")
for example -delay:300000 will delay for 5 minutes
And in your WL_HOME\server\bin\installSvc.cmd script edit in the delay and/or depend parameters.
Also remember to change your logfile destination, you don't want Adminserver and managed service in the same logfile, trust me, it gets very confusing.
This should give you a final line in the I=installSvc.cmd that looks something like
"%WL_HOME%\server\bin\beasvc" -install
-svcname:"%DOMAIN_NAME%_%SERVER_NAME%"
-delay:300000
-depend:"beasvc Adminserver_Adminserver"
-javahome:"%JAVA_HOME%" -execdir:"%USERDOMAIN_HOME%"
-extrapath:"%WL_HOME%\server\bin" -password:"%WLS_PW%"
-log:"D:\OBIEE11G\user_projects\domains\bifoundation_domain\servers\bi_server1\bi_server1-stdout.txt"
-cmdline:%CMDLINE%
Update (27 Feb 2014)
This also works for 11.1.1.7
Thursday, 14 June 2012
bicontentserver(11.1.1) down - an update and fix
Following on from a previous post here.
It turns out that all you have to do is create a new environment variable
BI_ORACLE_HOME and give the value of your middleware install ..\Oracle_BI1 directory.
You then need to restart the service and ..... yay.
It turns out that all you have to do is create a new environment variable
BI_ORACLE_HOME and give the value of your middleware install ..\Oracle_BI1 directory.
You then need to restart the service and ..... yay.
Wednesday, 4 April 2012
Configuring and Installing the Network Loopback Adapter on Windows Server 2008
OBIEE requires a looback adapter if the server uses a dynamically assigned IP Address.
Installing the loopback is fairly straightforward.
Start -> Computer -> Right-click, Properties -> Device Manager -> Computer Name, Right-click, Add Legacy Hardware ->
The Wizard appears ... click Next >.
On the selection screen "What do you want the wizard to do?" Select Install the hardware that I manually select from a list (Advanced) then click Next >
From the list, scroll down to and select the Network Adapters then click Next >
Scroll down the Manufacturer list (left) and select Microsoft then on the network adapter list, select Microsoft Loopback Adapter (right) and click Next >
The wizard will now confirm to install the virtual hardware. Clicking Next > will start the installation process.
Finally click the Finish button.
While the control panel is open. its a good time to configure the new (virtual) network adapter. We can configure the new Network just like a physical network. Go to Network and Sharing Center on the control panel
On the Network and Sharing Center, click Manage network connections.
Find the Network connection with labels as Microsoft Loopback Adapter, right click, then choose properties.
On my virtual network, I will be using IPv4 only for now. Choose Internet Protocol Version 4 (TCP/IPv4), then click properties.
I’m using a static network, and I will use the 10.10.10.10/ 24 block. Using this series, I dont want to conflict the existing physical network. My subnet mask is 255.255.255.0 and the DNS server (127.0.0.1). Click Ok. Then close the wizard.
Installing the loopback is fairly straightforward.
Start -> Computer -> Right-click, Properties -> Device Manager -> Computer Name, Right-click, Add Legacy Hardware ->
The Wizard appears ... click Next >.
On the selection screen "What do you want the wizard to do?" Select Install the hardware that I manually select from a list (Advanced) then click Next >
From the list, scroll down to and select the Network Adapters then click Next >
Scroll down the Manufacturer list (left) and select Microsoft then on the network adapter list, select Microsoft Loopback Adapter (right) and click Next >
The wizard will now confirm to install the virtual hardware. Clicking Next > will start the installation process.
Finally click the Finish button.
While the control panel is open. its a good time to configure the new (virtual) network adapter. We can configure the new Network just like a physical network. Go to Network and Sharing Center on the control panel
On the Network and Sharing Center, click Manage network connections.
Find the Network connection with labels as Microsoft Loopback Adapter, right click, then choose properties.
On my virtual network, I will be using IPv4 only for now. Choose Internet Protocol Version 4 (TCP/IPv4), then click properties.
I’m using a static network, and I will use the 10.10.10.10/ 24 block. Using this series, I dont want to conflict the existing physical network. My subnet mask is 255.255.255.0 and the DNS server (127.0.0.1). Click Ok. Then close the wizard.
Subscribe to:
Posts (Atom)