Archive for category Technical

Some basic tips of Spagobi installation

Create a Variable : CATALINA_HOME
Set the value of this variable to the folder where SpagoBI server resides, for eg:
CATALINA_HOME=D:\SpagoBI

Create another variable JAVA_HOME
Set the value of this variable to the folder where Java resides, for eg:
JAVA_HOME=C:\Program Files\Java\jdk1.8.0_25

The default port of SpagoBI is 8080, if oracle xe is installed, it also uses the same port.
Below is the steps to Change Oracle port from 8080 to 3010

C:\>sqlplus /nolog
SQL*Plus: Release 10.2.0.1.0 – Production on Tue Aug 26 10:40:44 2008
Copyright (c) 1982, 2005, Oracle. All rights reserved.

SQL> connect
Enter user-name: system
Enter password: <enter password if will not be visible>
Connected.

SQL> Exec DBMS_XDB.SETHTTPPORT(3010); [Assuming you want to have HTTP going to this port]
PL/SQL procedure successfully completed.

SQL>quit

,

Leave a comment