Oracle

From TedYunWiki
Revision as of 13:15, 13 August 2014 by Tedyun (talk | contribs) (→‎Git Tips)
Jump to navigation Jump to search

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

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"

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
Retrieved from "https://wiki.tedyun.com/index.php?title=Oracle&oldid=225"