Translate

Friday, 30 October 2015

OBIEE 12 Commands and File Locations etc

OBIEE 12 Commands / Locations - Will keep Adding them



Uploading and Downloading an RPD for Offline Editing


Before Uploading and Download an RPD .

First of all get your service key ( You need to open the wlst Weblogic Scripting Tool)

weblogic offline

/ORACLE_HOME/oracle_common/common/bin/wlst.sh

Once Logged in run the following

List Service Instances

listBIServiceInstances('/u01/Middlewarehomebi12/user_projects/domains/bi12')

Once you have the service Key (" my key was "ssi" ... must be default)

Run the following to upload and download RPD (Call RPD what you Like)

Location of BITOOLS : Most RPD Commands 

[ORACLE_HOME]/user_projects/domains/bi12/bitools/bin

Download Command : 
sh data-model-cmd.sh downloadrpd -O myrpd.rpd -W Admin123 -SI ssi -U weblogic -P weblogic123

Upload Command :
sh data-model-cmd.sh uploadrpd -I myrpd_new.rpd -W Admin123 -SI ssi -U weblogic -P weblogic123


You will get completion messages after uploading and downloding such as Success !!



OBIEE 12 TNS Location for Oracle DB


ORACLE_HOME/user_projects/domains/bi12/config/fmwconfig/bienv/core/

Place your tnsnames.ora in the location above and run the ./stop.sh  from bitools directory then ./start.sh to bounce all services.

File Locations (SSI can vary dependent upon Serviceinstance)


NQS Config.INI

/ORACLE_HOME/user_projects/domains/bi12/config/fmwconfig/biconfig/OBIS

Webcatlog

[ORACLE_HOME]/user_projects/domains/bi12/bidata/service_instances/ssi/metadata/content

RPD - Datamodel

[ORACLE_HOME]/user_projects/domains/bi12/bidata/service_instances/ssi/metadata/datamodel


Log Files

[ORACLE_HOME]/user_projects/domains/bi/servers/obis1/logs/



High-level Directory Structure


  • Oracle BI Domain Home: /.../Oracle_Home/user_projects/domains/bi
  • Single Data Directory (SDD): /.../Oracle_Home/user_projects/domains/bi/bidata
  • Lifecycle Management / Process Control Scripts: /.../Oracle_Home/user_projects/domains/bi/bitools/bin

File Location  References:

Where are the start / stop / status  and lifecyle management scripts located?

  • ORACLE_HOME/user_projects/domains/bi/bitools/bin - stop.sh / start.cmd | start.sh / start.cmd | 

  • sh start.sh (Will Start weblogic , managed servers , OBIEE and all Components)
  • sh.stop.sh (Will Stop weblogic , managed servers , OBIEE and all Components)
  • Individual Components same commands as above ie . stop.sh -i obis1,obips1
  •  
  • status.sh / status.cmd  [use -h for syntax help]
  • ORACLE_HOME/bi/migration-tool/jlib/bi-migration-tool.jar (11g to 12c migration tool)
  • ORACLE_HOME/bi/lib/bi-bar.jar (CreateBIArchive java executable)

You may also continue to use Enterprise Manager Fusion Middleware Control and Weblogic Console.
  • Using Commands to Stop, Start, and View Status of Oracle Business Intelligence Processes
  • Using Fusion Middleware Control to Start and Stop System and Java Components
  • Using Fusion Middleware Control to Start and Stop Java Components
  • Using Oracle WebLogic Server Administration Console to Start and Stop Java Components
  • Viewing the Status of Oracle Business Intelligence Components in a Domain

Where are the common configuration and script files located?

Configuration files are no longer duplicated. Separate configuration files still exist for example, for Oracle BI Presentation Services and BI Server, but they are not duplicated in the case of a cluster.
  • Weblogic configuration
    • /.../ORACLE_HOME/user_projects/domains/bi/config/config.xml
    • /.../ORACLE_HOME/user_projects/domains/bi/bin/setDomainEnv.sh/cmd
  • JDBC Data Sources
    • /.../ORACLE_HOME/user_projects/domains/bi/config/jdbc/..
  • Weblogic Scripting Tool (WLST)
    • /.../ORACLE_HOME/oracle_common/common/bin/wlst.sh
  • RCU
    • /.../ORACLE_HOME/oracle_common/bin/rcu
  • Table and Schema DDL/SQL
    • /.../ORACLE_HOME/oracle_common/common/sql/biplatform

  • Sample Application XML data files
    • /.../Oracle_Home/bi/bifoundation/server/samples/SampleAppLite/sample/SampleAppFiles/Data
  • Core BI Domain
    • /.../Oracle_Home/user_projects/domains/bi/config/fmwconfig/biconfig/core/ bi-config.xml | bienv-components.xml | tnsnames.ora | odbc.ini
  • OBI Server (nqsserver)
    • /.../ORACLE_HOME/user_projects/domains/bi/config/fmwconfig/biconfig/OBIS/NQSConfig.INI
  • Presentation Server (sawserver)
    • /.../ORACLE_HOME/user_projects/domains/bi/config/fmwconfig/biconfig/OBIPS/instanceconfig.xml
    • /.../ORACLE_HOME/bi/bifoundation/web/schemas/*.xsd
    • /.../ORACLE_HOME/bi/bifoundation/web/display/authenticationschemas.xml
    • /.../ORACLE_HOME/user_projects/domains/bi/bidata/components/OBIPS/customMessages (for custom xml messaging)
  • ClusterController
    • /.../ORACLE_HOME/user_projects/domains/bi/config/fmwconfig/biconfig/OBICC/bi-cluster-config.xml
    • /.../Oracle_Home/user_projects/domains/bi/config/fmwconfig/biconfig/core/ClusterConfig.xml
  • Scheduler
    • /.../ORACLE_HOME/user_projects/domains/bi/config/fmwconfig/biconfig/OBISCH/schedulerconfig.xml
  • JavaHost
    • /.../ORACLE_HOME/bi/modules/oracle.bi.cam.obijh/env/obijh.properties  -- 17.2.1 Increasing Heap Size to Assist in Exports to Excel
    • /.../ORACLE_HOME/bi/modules/oracle.bi.cam.obijh/env/startOBIJH.sh (sourced, not executed -- see obijh.properties
    • /.../ORACLE_HOME/user_projects/domains/bi/config/fmwconfig/biconfig/OBIJH/config.xml

Where are the BI Executables?

  • OBI Server | Scheduler | ClusterController: /.../ORACLE_HOME/bi/bifoundation/server/bin/ nqsserver | nqscheduler | nqsclustercontroller 
  • PS: /.../ORACLE_HOME/bi/bifoundation/web/bin/ sawserver | catalogmanager | sawrepaj -deprecated
  • JavaHost: /.../ORACLE_HOME/bi/modules/oracle.bi.cam.obijh/startOBIJH.sh/cmd
  • Catalog Manager CLI: /.../Oracle_Home/user_projects/domains/bi/bitools/bin/runcat.sh
  • RDA: /../oracle_common/rda

Where are the JEE apps?

  •  /.../Oracle_Home/bi/bifoundation/jee/ analytics.ear | xmlpserver.ear | bimad.ear | bisearch.ear | jbips.ear | bicustom.ear | ...

Where are the RPD and catalog located?

  • /.../ORACLE_HOME/user_projects/domains/bi/bidata/service_instances/ssi/metadata (ssi is the default service instance and only one supported in 12.2.1)

Where are the common diagnostic logs located?

  • /.../ORACLE_HOME/user_projects/domains/bi/servers/obis1/logs/FineGrainedLogDir (on-line RPD udxml logs)
  • Weblogic
    • Administration Server: /.../ORACLE_HOME/user_projects/domains/bi/servers
    • Managed Server: /.../ORACLE_HOME/user_projects/domains/bi/servers
  • System Components
    • OBI Server: /.../ORACLE_HOME/user_projects/domains/bi/servers/obis1/logs - obis1.out | obis1-diagnostic.log | obis1-query.log | oracle_BiServerXmlGen.log | oracle_nQSecUDMLGen.log
    • Presentation Server: /.../ORACLE_HOME/user_projects/domains/bi/servers/obips1/logs - sawlog0.log | obips1.out | webcateupgrade0.log | upgrade-[date stamp].log
      • Catalog Manager: /.../ORACLE_HOME/user_projects/domains/bi/servers/obips1/logs/catalogmanager - catalogmanager.0.0.log
    • Scheduler: /.../ORACLE_HOME/user_projects/domains/bi/servers/obisch1/logs - nqscheduler.log | obisch1.out
    • JavaHost: /.../ORACLE_HOME/user_projects/domains/bi/servers/obijh1/logs - jh.log | obijh1.out
    • ClusterController: /.../ORACLE_HOME/user_projects/domains/bi/servers/obiccs1/logs - nqcluster.log | obiccs1.out

Where are the common temporary | temp | tmp directories and cache located?


  • System Components
    • OBI Server:
      • /.../ORACLE_HOME/user_projects/domains/bi/servers/obis1/tmp
      • /.../ORACLE_HOME/user_projects/domains/bi/servers/obis1/tmp/obis_temp
      • /.../ORACLE_HOME/user_projects/domains/bi/servers/obis1/cache
      • /.../ORACLE_HOME/user_projects/domains/bi/servers/obis1/MDXCache
      • Global Cache - no default, user defined
    • Presentation Server: /.../ORACLE_HOME/user_projects/domains/bi/servers/obips1/tmp
    • Scheduler: /.../ORACLE_HOME/user_projects/domains/bi/servers/obisch1/tmp
    • JavaHost:
      • /.../ORACLE_HOME/user_projects/domains/bi/servers/obijh1/tmp
      • /.../ORACLE_HOME/user_projects/domains/bi/system_components/OBIJH/obijh1/tmp
      • other as defined in JavaHost configuratoin file (e.g. ramdisk)


Over and Out 

Shahed M and Krishna M







1 comment:

  1. BlueHost is definitely one of the best web-hosting provider for any hosting services you need.

    ReplyDelete

Google Big Query Clone / Copy DataSets / Tables - PROD --> TEST --> DEV Projects

Google Big Query Cloning of Datasets & Tables across GCS Projects. We searched the internet and could not find a simple cloning / ...