INSTALLATION DOCUMENTS BY RAVI

Showing posts with label CLOUD. Show all posts
Showing posts with label CLOUD. Show all posts

Sunday, April 26, 2020

Installing Oracle Data Gateway on Windows

Download data gateway software from the below location.

https://www.oracle.com/middleware/technologies/oac-downloads.html



















Extract the downloaded file as below



















Open the extracted folder and double click on the datagateway.exe file



















It will open the analytics gateway configuration wizard



































Friday, January 17, 2020

Wednesday, December 4, 2019

How to Connect to the Oracle Analytics Cloud (OAC) RPD using Client Admintool with SSL port


Connect to OAC via the "In the Cloud" option:
Launch the Oracle BI Administration Tool
Choose File > Open > In the Cloud





















Define the parameters for your OAC instance:
Username: admin
Password: ***********
Cloud: bootstrap
Host Name: test.oraclecloud.com
Port Number: 443
SSL: Check ON
Trust Store: <OAC Client Home>\oracle_common\jdk\jre\lib\Security\cacerts
Password: changeit (This is the default password for cacerts)


























Click on open




















Saturday, July 27, 2019

Installing and Configuring Oracle Analytics Cloud Data Sync


Installing Data Sync
Data Sync stores sensitive information, including connection information to our on-premises databases. It is recommended that we only install Data Sync in protected environments where the operating system and file system privileges are tightly controlled.
Prerequisite:
Install Java Development Kit (JDK) 1.7 or later
Note:
Data Sync doesn’t work with Java Runtime Environment (JRE). We must install JDK.
Steps for installing and configuring Data Sync:
Download Data Sync from Oracle Technology Network:
Unzip BICSDataSync_Vx_x.Zip to a directory with no spaces in its name.




















Setting JAVA_HOME:
Open config.bat (Windows) or config.sh (Linux or Unix).
Replace @JAVA_HOME with the directory where JDK is installed.





















Copy any database-specific JDBC drivers that we need to Data Sync’s \lib directory.
Data Sync installs Oracle JDBC driver 11.2.x. If we want to connect to a different database (for example, Microsoft SQL Server or DB2) or if you want to use a different Oracle driver from the default version, obtain and manually copy the required files to the \lib directory



















Starting Data Sync for the First Time:
The first time we start Data Sync, you’ll be asked to give your Data Sync repository a name and provide a password.
To Start Data Sync. Run datasync.bat (on Windows) or datasync.sh (on Linux/UNIX) from the directory where you installed Data Sync.




















Open the command prompt and run the datasync.bat file as below
















Click on Next



















Select Configure a new environment and click on Next



















Provide repository name and click on Next



















Provide the password and click on Next



















After configuration got completed click on Finish



















To start Data Sync server run startserver.bat as below





























To open Data Sync Tool run datasyncClient.bat




















Provide login password which we were given while configuration and click on Login



















Select Create a New Project
Provide a name for the project and click on ok



















Click on Ok
















To stop Data Sync Server run stopserver.bat file as below





























Saturday, August 25, 2018

Steps for opening Oracle Analytics Cloud RPD online using Oracle BI Administration Tool

Open Administration Tool

















Navigate to File -> Open -> In the Cloud

















Provide the details below and click on open

















User: Admin username (like WebLogic)
Cloud: Service Instance Name
Port Number: Analytics port number
Hostname: hostname or IP address of the instance


Altering user password in oracle analytics cloud database

ERROR at line 1:
ORA-65048: error encountered when processing the current DDL statement in
pluggable database OACDEVPDB1

ORA-01918: user 'USER1' does not exist








Enable oracle script as below
Sql> alter session set “_ORACLE_SCRIPT”=true;









Disable oracle script:
Sql> alter session set “_ORACLE_SCRIPT”=false;






Sunday, August 12, 2018

STEPS FOR INSTALLING AND CONFIGURING PSM (PAAS SERVICE MANAGER COMMAND LINE UTILITY)

Installing Python:

Download and install the python as below
















Click on Install Now
































Wait until the setup progress got finished
















Click on disable path length limit
















Checking for the python:















For some reason downloading the PSM is hidden away and not easy to find 
we need to login to your Oracle Cloud service, 
go to the service console screen, 
then click on the drop down arrow against your user name in the top right of the screen , 
select ‘Help’  and then ‘Download Center’

















Click on download

































Installing psm:
Open the command prompt and install psm as below



















Configuring psm:




Provide username, password, identity domain, region, 
output format and use oauth details and 
click enter



















It displays the list of available services as above.

Psm commands for Oracle analytics cloud
services:
List all Oracle Analytics Cloud instances
Syntax:
psm analytics services








Service:
Psm command to see the details of service
Syntax:
psm analytics service -s OACDEV










  Opatch reports 'Cyclic Dependency Detected' error when patching ODI   Issue: When applying a Patch Set Update (PSU) to WebLogic Se...