Oracle

Acronyms

• MATS Minimal Acceptance Test Suite

Git Tips

Git Tips

Installing OBIEE Suite

• Set JAVA_HOME variable to an appropriate JDK directory

• Install Microsoft Loopback Adapter, go to its IPv4 setting, and give a static IP 192.168.1.41 and subnet mask 255.255.255.0. Leave other fields blank.

• Add the following lines to C:\Windows\System32\drivers\etc\hosts: ("orcl" will be the name of the database service)

127.0.0.1 localhost
192.168.1.41 orcl orcl.oradev.oraclecorp.com

• Go to Oracle Technology Network (otn.oracle.com) and install Oracle Database 12c ("winx64_12c_database_1of2.zip") using the same name "orcl"

• Install RCU ("ofm_rcu_win_11.1.1.7.0_64_disk1_1of1.zip") to create schema

• Install Oracle WebLogic Server 11gR1 (10.3.6) + Coherence - Package Installer Generic 64-bit ("wls1036_generic.jar") to a new folder (e.g. C:\app\BI)

• Install OBIEE 11.1.1.7.0 to the same folder with the "software only install" option

• Run Oracle_BI1/bin/config.bat to start configuration

Installing OBIEE Suite (Alternative Method that worked on Windows 7)

• Set JAVA_HOME variable to an appropriate JDK directory
• Install Oracle Database 11g manually (i.e. software only install + set up orcl database manually)
• Install RCU ("ofm_rcu_win_11.1.1.7.0_64_disk1_1of1.zip") to create schema
• Install OBIEE 11.1.1.7.0 with the "simple install" option

Using OBIEE Suite

• Before starting BI server check everything is "alive":

C:\app\obi\instances\instance1\bin\opmnctl status

• If not alive start all:

opmnctl startall

• Start the BI server

• Use Firefox to open the page http://localhost:7001/analytics/saw.dll?bieehome and log in using weblogic/yourpassword. DO NOT USE CHROME.

Setting Up Hosted Windows Dev Environment

Use "Microsoft Windows 2008 Enterprise R2 (Intel x64, Developer)" image for your hosted machine. (Need MSDN license.)

Make sure you have ORADEV account. If you do not have ORADEV account password,

• sign in to Oracle Identity Manager
• My Access - Accounts - Windows Unified Domain - Reset Password. (or create account - Windows Unified Domain)

Log-on using remote desktop (run "mstsc").

username: ORADEV\YOURGLOBALID

Run Visual Studio 2010 X64 Command Prompt (Administrator).

get Kerberos ticket

ade okinit

create ADE view

ade createview YOURVIEWNAME -series BIFNDN_MAIN_WINDOWS.X64 -populated

use ADE view

ade useview YOURVIEWNAME

Start IDE - inside your view

cd C:\ADE\YOURVIEWNAME\bifndn\analytics_web\main
startide.bat

Using Command Line (sawbuild.bat) to build - inside your view

cd C:\ADE\YOURVIEWNAME\bifndn\analytics_web\main
sawbuild bipsmatsbuildlite (for debug version. For release version: "sawbuild r bipsmatsbuildlite")

Then run.

sawbuild preparemats
setenv
sawserverD -updateGuidAndStart 

To update your view to the latest version,

ade refreshview -latest

To remove your view,

ade destroyview YOURVIEWNAME

Running BI in your browser

Install tomcat 7.0 (everything default, username/pass: admin/admin)

Go to tomcat directory C:\Program Files\Apache Software Foundation\Tomcat 7.0\conf\Catalina\localhost\ and create a file tyun.xml.

// tyun.xml
<Context docBase="C:/ADE/tyun_view/bifndn/analytics_web/main/app-link" />

Open browser and go to http://localhost:8080/tyun

log in Administrator / Admin123

Visual Studio Set-ups and Tips

Setting up and Using Visual Studio (8/13/2013)

• Indentation

Tool - Options - All Languages - Tab
Tab size: 3
Indent size: 3
and check "Insert spaces".

• Overwriting autoexp.dat file

Copy C:\ADE\tyun_view\bifndn\analytics_web\main\support\visualstudio\AUTOEXP.DAT
and paste to the
C:\Program Files (x86)\Microsoft Visual Studio 10.0\Common7\Packages\Debugger\autoexp.dat
(make a backup before you overwrite the file)

• Shortcuts

Ctrl + F7: compile only this file

• Adding breakpoints

right click on the desired position - breakpoint - Insert breakpoint

• Adding a subSystem (called hello)

Inside C:\ADE\tyun_view\bifndn\analytics_web\main\project\websubsystems\sssearch.cpp,

define function:

// hello world
void SearchSubsystem::hello(NQHttpStream & httpStream,
                                 const saw::Handle<ClientSession>& hClientSession, const HttpArgs & rArgs)
{
   NQWString hello = L"hello world";
   httpStream << hello;
}

and add the following in an appropriate location

// hello world
   SAW_ADD_HTTPCOMMAND(rRegistrar,hello,                 SearchSubsystem, kNormalCall);

Now define the function inside a header file sssearch.h in the same directory:

//hello world
   void hello(NQHttpStream & rStream, const saw::Handle<ClientSession>& hClientSession, const saw::HttpArgs & rArgs);

JDeveloper Tips

1. When JDeveloper shows low-memory warning message

Edit C:\Oracle\Middleware\jdeveloper\ide\bin\ide.conf
Increase the memory value to 1024, e.g. "AddVMOption -Xmx1024M".

If "Perm Memory" is running low, edit the following file
C:\Oracle\Middleware\jdeveloper\jdev\bin\jdev.conf, e.g. "AddVMOption -XX:MaxPermSize=512M"

Oracle Database

Changing the hostname from "localhost" to "adcxxxxxxx"

1. Go to Enterprise Manager
2. Click the Listener and click Edit
3. Login as ORADEV\TYUN window account
4. change the hostname

and according to https://forums.oracle.com/thread/2367554,

1. you may need to change your listener.ora file , if you have hardcoded ip address.
2. if hostname has been used in listener.ora file, the change you operating system host file (/etc/hosts in linux or [drivers\etc\hosts] in windows.
3. change your tnsnames.ora, if you have hardcoded any ipaddress.
4. if for any application interface, if they [application team] hardcoded ipaddress in any application tables, then it has to be changed.

Expression Editor

• Series : BIADFCOMPS_MAIN_GENERIC
• ADF project path: biadfcomps/modules/bi-raas-apps/bi-raas-admin/bi-raas-admin
• TaskFlow : public-html/pages/SimpleModelEditor/FullExprEditor.jsff
• backing bean : oracle/bi/modeling/ui/simplemodeleditor/backingbeans/FullExpressionEditor.java
• Parser project :biadfcomps/modules/bi-metadata-uel

From Abdur

There is a wiki page

https://stbeehive.oracle.com/teamcollab/wiki/RaaS+and+SaaS+-+Thin+Client+Admin+Tool:Setting+up+RaaS+project+for+build+and+test It may not be uptodate.

Here are the steps:

Run the following command first: biadfcomps> make SINKALL=bi-raas-apps rebuild

More over,

1. you need a oracle database and optionally a BIServer (OBIEE installation)
2. Start the embedded Weblogic server
3. Manually deploy bi-modeler-sharedlib
4. Manually define datasource for locking service.

for steps 3 and 4 pl. take a look into the wiki page, section: "Before you can deploy RaaS webapp to the embedded WebLogic"

Then in your bi-raas-admin.jws app/project, right click Home.jspx and run that. That will launch the application.

You can access it from the http://<host>:7101/bi-raas-admin/faces/pages/SimpleModelEditor/Home.jspx

From Abdur 131217

1. ade createview
2. ade useview
3. make altpullsan (once after you create a view)
4. make SINKALL=bi-raas-apps rebuild (every time you create or refresh a view)
5. Open another terminal and useview
6. On second terminal, open jdev: ../oracle/jdeveloper/jdev/bin/jdev
7. Open Application
   • Open scratch/tyun/view_storage/tyun_biadfcomps/biadfcomps/modules/bi-raas-apps/bi-raas-admin/bi-raas-admin.jws
8. Run - Start Server Instance (IntegratedWebLogicServer)
9. Access weblogic console: machinename.us.oracle.com:7101/console
10. Follow Deplying BI-Modeler-... doc file
11. Follow Adding WL JDBC data source doc file
    • Use database and DEV_BIPLATFORM Schema
12. Run webcontent->pages->SimpleModelEditor->Home.jspx
13. Click link to go to browser machinename:7101/bi-raas-admin/faces/pages/SimpleModelEditor/Home.jspx
14. Settings button -> DEV Tenant Info -> Take a look and change if you want.
15. Lock the data model to edit.
16. Drag SALES to "Fact Tables" (might have to unlock)
17. Click dragged SALES
18. Click Add Column
19. Click Full Editor

Note: expression editor is currently "feature frozen".

Design

Tokens

1. Variable (e.g. "SALES")
2. Dot (.) between two Variables
3. Operator
4. Functions
   1. Aggregate, Running Aggregate, and Time Series Functions
   2. String Functions
   3. Math Functions
   4. Calendar Date/Time Functions
   5. Conversion Functions
   6. Database Functions
   7. Hierarchy Navigation Functions
   8. System Functions

http://docs.oracle.com/cd/E25054_01/fusionapps.1111/e20836/sqlref.htm#i1005560

SenseComplete

• Dependencies in obips.sencomplete module.

1) obips.ColorPicker
obips.ColorPicker.RGBColor class

2) obips.Observable
obips.Observable class
obips.Observable.EventListener class
obips.Observable.Event class

3) obips.ResourceManager
obips.ResourceManager.getSingleton()
obips.ResourceManager.getSingleton().getURL(...)

4) obips.UberBar
obips.UberBar.IconSet class
obips.UberBar.IconButtonModel class
obips.UberBar.Model class
obips.UberBar.Viewer class

5) obips.Callback
obips.Callback class

6) obips.FloatingWindow
obips.FloatingWindow.Manager.getSingleton().destroy()

7) obips.HTMLDOM namespace

obips.HTMLDOM.removeChildNodes(...)
obips.HTMLDOM.calculateAbsoluteOffsetLeft(...)
obips.HTMLDOM.calculateAbsoluteOffsetTop(...)

8) obips.BrowserEventFramework

obips.BrowserEventFramework.EventRouter class
obips.BrowserEventFramework.EventRouter.getEventRouter(...)
new obips.BrowserEventFramework.EventRouter.getEventRouter(...)
obips.BrowserEventFramework.getViewerFromElement(...)
obips.BrowserEventFramework.cancelBubble(...)

9) obips.FloatingWindow
obips.FloatingWindow.Model class
obips.FloatingWindow.Viewer class
obips.FloatingWindow.Manager.getSingleton()

10) Global Variables / Constants
obips.masterResourceBundlePath

Selenium

1. Install eclipse
2. Run

   gradlew eclipse

3. Open eclipse
4. Import bi-tech project directory and import all projects in it
5. Right click on "functional-tests" and click "close unrelated projects"
6. Click on your source file (e.g. ValidatorTests.java) and open "run configuration" dialog (Run -> Run Configurations in the top menu)
7. Click on Arguments and type in the following in the "VM arguments" box (the last argument is only for phantom)

   -Dselenium.browserType=phantom -DwindowHeight=800 -DwindowWidth=1000 -Duser.context.root=bali -Dphantomjs.binary.path=D:/Workspace/bi-tech/plugins/build/phantomjs/phantomjs.exe

8. Run your source file

Check BI Server version

cat /scratch/mw_home/bi/bifoundation/version.txt

SOAP Documentation (WSDL)

Web Service Definition Language (WSDL). WSDL is an XML format for describing network services as a set of endpoints operating on messages containing either document-oriented or procedure-oriented information.

See wsdl for soap services from http://host:port/analytics/saw.dll?WSDL

Alternatively, navigate to bifndn/analytics_web/main/project/wsdlgenerator in your ADE view.

For example, this is in webcatalog.wsdlfragment.

      <xsd:element name="getItemInfo">
        <xsd:complexType>
          <xsd:sequence>
            <xsd:element name="path" type="xsd:string" />
            <xsd:element name="resolveLinks" type="xsd:boolean" />
            <xsd:element name="sessionID"  nillable="true" type="xsd:string" />
          </xsd:sequence>
        </xsd:complexType>
      </xsd:element>
      <xsd:element name="getItemInfoResult">
        <xsd:complexType>
          <xsd:sequence>
            <xsd:element name="return" type="sawsoap:ItemInfo" />
          </xsd:sequence>
        </xsd:complexType>
      </xsd:element>

JDeveloper Issue Fixes

1. JDev11g on Windows 8, JDev12c on Windows 10: http://unversioned.blogspot.com/2012/12/jdevelopers-integrated-weblogic-on.html

Error on message log is:

[Waiting for the domain to finish building...]
[11:48:02 PM] Creating Integrated Weblogic domain...
[11:48:18 PM] ERROR:  An error occurred while building the default domain.
Please see this log file for more details:
C:\Users\chris\AppData\Roaming\JDeveloper\system11.1.1.6.38.62.29\o.j2ee.adrs\CreateDefaultDomain.log
The Server Instance cannot be started because the Integrated Weblogic domain was not built successfully. 

and in CreateDefaultDomain.log there are more details:
....
wlst > Failed to get environment, environ will be empty: (0, 'Failed to execute command ([\'sh\', \'-c\', \'env\']): java.io.IOException: 
Cannot run program "sh": CreateProcess error=2, The system cannot find the file specified')
wlst > Error:  ADRS_DOMAIN_PASSWORD environment variable not set.
....

To solve this we need to patch the jython-modules.jar. For default JDeveloper installation path we need to go to C:\Oracle\Middleware\wlserver_10.3\common\wlst\modules and extract the jython-modules.jar using an utility like 7-zip. Then we need to open the javashell.py python script inside lib folder and add at line 139 a String for Windows 8 OS:

_osTypeMap = (
        ( "nt", ( 'nt', 'Windows NT', 'Windows NT 4.0', 'WindowsNT',
                  'Windows 2000', 'Windows 2003', 'Windows XP', 'Windows CE',
                  'Windows Vista', 'Windows Server 2008', 'Windows 7', 'Windows 8' )),
        ( "dos", ( 'dos', 'Windows 95', 'Windows 98', 'Windows ME' )),
        ( "mac", ( 'mac', 'MacOS', 'Darwin' )),
        ( "None", ( 'None', )),
        )

Then we need to package jar file again using jar -cvf jython-modules.jar *.* inside jython-modules extracted folder. Then after we backup (just in case) the old jython-modules.jar we override it with our new jython-modules.jar.

1. Coherence issue "Delaying formation of a new cluster; unicast networking appears to be inoperable on interface 192.168.0.101 as this process isn't receiving even its own transmissions; consider forcing IPv4 via -Djava.net.preferIPv4Stack=true": Set weblogic only listen to 127.0.0.1 instead of listening to all addresses.

1. 'findstr' bug (see #22909676 in bugDB) - Workaround: Restart JDeveloper with the following property "jdev -J-Djdev.wlst.env.vars=PATH"

Visual Studio (2010) Tips

• Find a file with a file name: Ctrl + ,