• What is dbt_artifacts?

    dbt_artifacts is a package for modeling a dbt project and its run metadata. It includes the following models to help you understand the current state of a dbt project and its performance over time. It...

  • Data migration from the Salesforce to snowflake Data warehouse by using Matillion

    Purpose of the Article: This blog explains how to load the data from Salesforce to Snowflake Intended Audience: This article will help our Organizational level kind of developers working on data migra...

  • WiMAX-A Study of Mobility

    1. Introduction The wireless market is growing rapidly; being pushed through wireless connectivity demand various wireless connectivity means are emerging (WLAN/802.11, WMAN/802.16a, WWAN/802.16d) [IE...

  • Weblogic Upgrade

    Patch Name wls1036_upgrade_generic.jar Reference https://www.youtube.com/watch?v=Be6hrYTANQE Just Click Next and Next MAKE SURE ALL OBIEE SERVICES ARE DOWN AND CLOSED IN PROCESS Open CMD prompt C:Mid...

Tags

bics installation OBIEE obiee 11g installation guide Oracle

Categories

Unifier 16.0.2 /Unifier 16R2 Installation

Unifier 16.0.2 /Unifier 16R2 Installation

Create Unifier Domain

Click Start > Oracle >Configuration Wizard

2016-11-21_0945

Replace “base_domain” with “unifier” and click next

screen-shot-2016-11-20-at-22-34-18

screen-shot-2016-11-20-at-22-35-03

Enter name and password > Next

screen-shot-2016-11-20-at-22-35-56

 

Select Production > Next

screen-shot-2016-11-20-at-22-36-10

Select Administration Server > Next

screen-shot-2016-11-20-at-22-39-58

Leave Server Name as “AdminServer” Change Listen Port if it need to be changed.

 

screen-shot-2016-11-20-at-22-40-17

Once 100% then click Next

screen-shot-2016-11-20-at-22-40-40

 

 

screen-shot-2016-11-20-at-22-40-53This will start Weblogic admin server and can be accessed using url http://192.168.2.7:4201/console from local browser.

2016-11-21_1011

You need to download Unifier application from https://edelivery.oracle.com

Sign-in into portal and search for Unifier, select your system platform. Software details will appear in Download Queue window, click on Continue.

Accept the license and download all zip files.

Extract the V77738-01.zip file. Extracted zip file will contain unifier_16.2.0.0.zip and BASIC_V16.2.0.0.zip, now extract unifier_16.2.0.0.zip file. This is your Unifier application file. You will find these files inside extracted unifier_16.2.0.0 folder.

Connect with SQL DEVELOPER or Toad for Oracle and run following:

create user unifier identified by Password;

grant connect, resource, create table, create view to unifier ;

commit;

grant unlimited tablespace to unifier;

commit;

screen-shot-2016-11-21-at-00-01-00

Open Weblogic folder. Right click and edit setenv.bat file. Following parameter needs to be set in setenv.bat file

DOMAIN_HOME

screen-shot-2016-11-20-at-22-50-13

DOMAIN_HOME is the Weblogic’ s domain on which you are deploying Unifier application.

2016-11-21_0857

Save the file

Perform Following steps before kickstarting installation

  • Create temp folder in c:\
  • Rename unifier_16.0.0.2 to unfier
  • Create folder named “projectdata” in unifier folder

2016-11-21_0921

2016-11-21_0921a

Now run configure.bat file present in same folder. At General tab, select Server Type as Staging if you are installing application for Dev and QA environment, else select Production. Server Internal URL should contain IP address of server where Unifier will be deployed (Weblogic server ip address). Port number is your Admin/managed server port in our case its 4201 as we are deploying on admin server only. Rest of the settings are self-explanatory.

screen-shot-2016-11-20-at-22-51-15

screen-shot-2016-11-20-at-22-51-37

Now click on Repository Tab. Settings at this tab tells Unifier where to store Business Process’s attachment, published/unpublished documents uploaded at Document Manager, Report files etc. You should create folder like below and map these to each directory using browse button.

screen-shot-2016-11-20-at-22-56-39

At Database tab, provide details of Unifier database user (refer first post where we have created Unifier database user)

screen-shot-2016-11-20-at-22-56-31

Click on test connection to validate details.

At Email tab provide details of email exchange server which you will get from your email support team, Unifier will use these details for sending email notification to user for task approval, record submission etc. Also it will send email notification to a particular email id about database connectivity error (email which is defined for system error notification). It is good to use single email group id for System Notification E-mail Address, System Error Notification E-Mail Address and License Notification E-mail Address.

Email login URL should be same as server internal URL provided earlier at General tab, just remove ‘bluedoor’ from URL.

For Inbound email account use a generic email id, normal application user will get task related notification from this email account.

Click on Test Inbound E-mail Account to validate the details.

screen-shot-2016-11-20-at-23-19-32

 

Report Tab

screen-shot-2016-11-20-at-23-19-15

screen-shot-2016-11-20-at-23-19-20

At Markup Server tab provide details for Autovue server’s host name and port.

screen-shot-2016-11-20-at-23-19-27

 

At Geo Map provide following details for integrating unifier with Oracle map server

Map Server URL: https://elocation.oracle.com

Map Tile:elocation.oracle.com

Map Geocoder URL: https://elocation.oracle.com

screen-shot-2016-11-21-at-09-36-25

At Authentication tab provide details for authentication provider, in our case we are keeping it as native.

screen-shot-2016-11-20-at-23-19-00

After filling all the details go to File > Save. This will save all settings.

Then click on File > Create EAR. It will take approximately 5-10 minutes for EAR file to be created.

You can see the EAR file in same folder as of configure.bat

2016-11-21_1916

Now run the deploy.bat file. This will deploy our EAR file in Weblogic. This operation calls setenv.bat for getting Weblogic details, so if there is any error with file path this operation will fail, also make sure that Weblogic’s admin console is up and running.

2016-11-20_2329a

Provide Weblogic user name and password.

2016-11-21_1023

Open Unifier

http://192.168.2.7:4201/unifier

screen-shot-2016-11-21-at-10-30-35

Login as Administrator/Administrator

screen-shot-2016-11-21-at-15-32-26

 

screen-shot-2016-11-21-at-15-32-26

Installing Application

2016-11-21_0036

 

screen-shot-2016-11-21-at-15-45-28

Debugging:

ORA-01000: maximum open cursors exceeded

SELECT MAX(A.VALUE) AS HIGHEST_OPEN_CUR, P.VALUE AS MAX_OPEN_CUR FROM V$SES

STAT A, V$STATNAME B, V$PARAMETER P WHERE A.STATISTIC# = B.STATISTIC# AND B.NAME

 = ‘OPENED CURSORS CURRENT’ AND P.NAME= ‘OPEN_CURSORS’ GROUP BY P.VALUE;

Output of this query will show the current Cursor limit, if it is less increase it by running following query

ALTER SYSTEM SET OPEN_CURSORS=1337 SID=’*’ SCOPE=BOTH;

Stop Weblogic by running stopWeblogic.cmd file present at

<weblogic installation directory>\user_projects\domains\<domain name>\bin

Drop unifier database user by running below query

DROP USER unifier CASCADE;

Commit the changes.

Create user again and grant necessary privileges.

Start Weblogic server by running startWeblogic.cmd file and continue installation of Unifier.

Warning: Array to string conversion in /volume1/web/wordpress/wp-includes/link-template.php on line 2361 Call Stack: 0.2521 6404088 1. {main}() /volume1/web/wordpress/index.php:0 0.2521 6404400 2. require('/volume1/web/wordpress/wp-blog-header.php') /volume1/web/wordpress/index.php:17 3.4668 22977784 3. require_once('/volume1/web/wordpress/wp-includes/template-loader.php') /volume1/web/wordpress/wp-blog-header.php:19 3.4801 22986104 4. include('/volume1/web/wordpress/wp-content/themes/ayro/single.php') /volume1/web/wordpress/wp-includes/template-loader.php:106 4.0372 25024880 5. ayro_qodef_get_blog_single() /volume1/web/wordpress/wp-content/themes/ayro/single.php:9 4.0375 25025256 6. ayro_qodef_get_module_template_part($template = 'templates/single/holder', $module = 'blog', $slug = '', $params = ['sidebar' => 'default']) /volume1/web/wordpress/wp-content/themes/ayro/framework/modules/blog/blog-functions.php:459 4.0375 25025384 7. ayro_qodef_get_template_part($template = 'framework/modules/blog/templates/single/holder', $slug = '', $params = ['sidebar' => 'default']) /volume1/web/wordpress/wp-content/themes/ayro/framework/lib/qode.functions.php:907 4.0378 25026288 8. include('/volume1/web/wordpress/wp-content/themes/ayro/framework/modules/blog/templates/single/holder.php') /volume1/web/wordpress/wp-content/themes/ayro/framework/lib/qode.functions.php:888 4.0378 25026288 9. ayro_qodef_get_single_html() /volume1/web/wordpress/wp-content/themes/ayro/framework/modules/blog/templates/single/holder.php:3 4.1829 25236368 10. ayro_qodef_get_module_template_part($template = 'templates/single/parts/single-navigation', $module = 'blog', $slug = ???, $params = ???) /volume1/web/wordpress/wp-content/themes/ayro/framework/modules/blog/blog-functions.php:523 4.1829 25236512 11. ayro_qodef_get_template_part($template = 'framework/modules/blog/templates/single/parts/single-navigation', $slug = '', $params = []) /volume1/web/wordpress/wp-content/themes/ayro/framework/lib/qode.functions.php:907 4.1831 25237848 12. include('/volume1/web/wordpress/wp-content/themes/ayro/framework/modules/blog/templates/single/parts/single-navigation.php') /volume1/web/wordpress/wp-content/themes/ayro/framework/lib/qode.functions.php:888 4.1989 25287160 13. previous_post_link($format = '%link', $link = [0 => 'https://miaz-tech.com/wp-content/uploads/2016/05/shop-product-image-4.jpg', 1 => 600, 2 => 651, 3 => FALSE], $in_same_term = TRUE, $excluded_terms = '', $taxonomy = 'category') /volume1/web/wordpress/wp-content/themes/ayro/framework/modules/blog/templates/single/parts/single-navigation.php:27 4.1989 25287160 14. get_previous_post_link($format = '%link', $link = [0 => 'https://miaz-tech.com/wp-content/uploads/2016/05/shop-product-image-4.jpg', 1 => 600, 2 => 651, 3 => FALSE], $in_same_term = TRUE, $excluded_terms = '', $taxonomy = 'category') /volume1/web/wordpress/wp-includes/link-template.php:2278 4.1989 25287160 15. get_adjacent_post_link($format = '%link', $link = [0 => 'https://miaz-tech.com/wp-content/uploads/2016/05/shop-product-image-4.jpg', 1 => 600, 2 => 651, 3 => FALSE], $in_same_term = TRUE, $excluded_terms = '', $previous = TRUE, $taxonomy = 'category') /volume1/web/wordpress/wp-includes/link-template.php:2259
No Comments
Post a Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.