Thursday, October 19, 2017
starting and stopping repository browser owb
To start the Warehouse Builder Browser Listener:
The
first time you invoke this listener, select and re-confirm a password for an
oc4jadmin account
Open the repository browser to check with the below url
https://localhost:8999/owbb/RABLogin.uix?
Give the login details and select design center to login to
owb design center
Select control center to login to owb control center
To stop the Warehouse Builder Browser Listener:
Configuring repository for OWB 11G in oracle database 12C
Checking for java virtual machine in database
Checking
for java objects
Checking for java roles
Running the scripts
Clean_owbsys.sql
The clean_owbsys.sql script drops the contents of any
existing OWBSYS schema installations, but leaves the schema otherwise intact.
Before proceeding you will have to default tablespace for temp:
cat_owb.sql
The cat_owb.sql script checks if an OWBSYS schema exists,
and creates it if necessary, and then installs the objects required by OWB 11.2
repository.
Unlock the users with the below scripts
reset_owbcc_home.sql
The reset_owbcc_home.sql script ensures that Oracle
Warehouse Builder uses the 11.2 version of the Control Center Service
Granting
remote server installation
Creating repository workspace
Run the repository assistant as below
Click next in the welcome screen
Give the database details and click next
Select manage warehouse builder workspace and click next
Select create new warehouse builder workspace and click next
Select create a workspace as new user a workspace owner and click next
Give database username and password and click next
Select the features we want and click next
Provide the details and click next
Provide owbsys user information and click next
Select any existing user or create new user for workspace and click next
In the repository summary screen click finish
INSTALLING ORACLE WAREHOUSE BUILDER 11G ON LINUX
Download and extract the software
Start the owb installation by running below command
On the welcome screen click Next
Give the path for inventory and specify the operating system group and click next
Specify the home details and click next
Uncheck the security updates and click next
Click on yes
In the summary screen click on install
Open the terminal as root and run the below scripts
Click on exit to finish the installation
Start the owb installation by running below command
On the welcome screen click Next
Give the path for inventory and specify the operating system group and click next
Specify the home details and click next
Uncheck the security updates and click next
Click on yes
In the summary screen click on install
Open the terminal as root and run the below scripts
Click on exit to finish the installation
Subscribe to:
Posts (Atom)
Opatch reports 'Cyclic Dependency Detected' error when patching ODI Issue: When applying a Patch Set Update (PSU) to WebLogic Se...
-
Getting the below error when installing oracle database 12c on linux machine Soft Limit: maximum stack size - This is a prerequisite con...
-
After configuring SSL with Custom Identity and Trust Keystores and when we try to start the servers getting the below error ...
-
1. Creating a directory in hdfs $ hdfs dfs -mkdir <paths> 2. List the directories in hdfs $ hdfs dfs -l...