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"