Oracle

Git Tips

Cheatsheet git status -- state of commits of your local branch vs repository

You are working on a new feature - newfeat 1) create a new branch, newfeat

> git checkout -b newfeat master

2) make changes, etc in your branch

3) push feature branch into repository

> git push -u origin newfeat

4) merge back into master

> git checkout master > git merge --no-ff newfeat > git branch -d newfeat > git push origin master

If master changes and you want to incorporate master changes into your branch: git rebase master or git merge master

Delete branch local: git branch -d old_branch remote: git push origin :old_branch

Undo last commit, 1) reset files to before you committed

    git reset --hard HEAD~1

2) just undo the "commit" action but leave everything else as is

    git reset --hard HEAD~1

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

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"

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
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 freezed".