INSTALLATION DOCUMENTS BY RAVI

Saturday, August 25, 2018

Exporting and importing dmp file in oracle database 12c

Exporting dmp file
Exporting dmp file of a schema using system user:
Syntax:
expdp system/Admin123@pdborcl schemas=HR directory=DPUMP_DIR dumpfile=hr.dmp logfile=expdpHR.log
Creating a directory object for oracle dump:
Syntax:

SQL> CREATE or REPLACE DIRECTORY dpump_dir as ' C:\app\BIASADMIN\oradata\orcl\pdborcl’;













To enable user hr to have access to these directory objects, you would assign the necessary privileges, for example:
SQL> GRANT READ, WRITE ON DIRECTORY dpump_dir TO hr;













Use the following Data Pump Export command





















Exporting dmp file of a schema using itself:
Syntax:
expdp hr/hr@pdborcl directory=DPUMP_DIR dumpfile=HR1.dmp logfile=HR1.log full=yes





















Importing dmp file
Importing dmp file of a schema using system user:
Syntax:
impdp system/Admin123@pdborcl schemas=HR directory=DPUMP_DIR dumpfile=HR.dmp logfile=impdpHR.log



















Importing dmp file of a schema using itself:
Syntax:
impdp hr/hr@pdborcl directory=DPUMP_DIR dumpfile=HR2.dmp logfile=HR2.log























Error: Cannot delete Process Group because it contains 1 Templates Apache Nifi HDF

Node sandbox-hdf.hortonworks.com:9090 is unable to fulfill this request due to: Cannot delete Process Group because it contains 1 Templates. The Templates must be deleted first.

















Templates, when created, are not inherently made available to all users.
They are tightly coupled to the authorization policies of the process group they are created in.
Since these templates are coupled in this way to a particular process group, that process group cannot be deleted until those associated templates are removed.

Removing the template:
Go to templates as shown in the below screen.

















Before removing the template, backup the template by downloading it

















































Now click on remove template to remove

















Click on yes to delete the template





























Like this remove all the templates with same “Process Group Id”

Close the Nifi templates page and try to delete the processor group now



































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










Steps for uploading rpd in Oracle Analytics Cloud























Go to console





















Click on Snapshot






















Click on replace the data model





















Browse the rpd and provide the password and click ok





















After getting successful upload message,
Login to the analytics page.
Under Administration tab click on reload files and metadata.


















Steps for migration obiee 11117 to Oracle Analytics cloud (bundle migration)

Generate migration-too-.jar file in OAC environment

./migration-tool.sh package bi-migration-tool.jar













Copy the generated jar file to obiee 11.1.1.7.0 environment.






Export the bundle in obiee 11.1.1.7.0 environment as below:


















After the migration got to succeed, 
Copy the exported bundle file to OAC environment





Import the bundle file as below:



























Restart the OAC suit as below:
Stopping:





















Starting:






































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