Wednesday, January 11, 2017

Kill Datapump job that running inside Database

even if you interrupt data bump job on shell therefore you have to do the following :-

as / as sysdba run the below query :

select * from dba_datapump_jobs


After checking the status of each one,

run the following :-

DECLARE
h1 NUMBER;
BEGIN
h1:=DBMS_DATAPUMP.ATTACH('JOB_NAME','OWNER_NAME');
DBMS_DATAPUMP.STOP_JOB (h1,1,0);
END;
/

Thanks 

Sunday, January 8, 2017

Oracle Data Integrator repository is not accessible.

When trying to access to the http://hostname:9704/biacm

the following warning appeared on the Dashboard :-

Oracle Data Integrator repository is not accessible.

Possible causes:

  1. Bad user credentials and/or type of Authentication.
  2.  Incorrect Database connection configuration from WLS to ODI DB Repositories.
OBIA 11g: BIACM - Unable To Access Oracle Data Integrator Repository. You Will Not Be Able Generate Or Execute (Doc ID 2115096.1)



Solution :-


Login to ODI Studio with a Supervisor user and in the ODI Security, open the user used to login to BIACM and the one with the problem with accessing ODI. Select the Retrieve GUID button and select the Supervisor check box, if not already done.

If this 'Retrieve GUID' button is not present, then the ODI Repository Authentication has been changed to "internal", meaning that it is not anymore as the OBIA out of the box installation configures it, where the users are managed by the WLS LDAP. This is not to be confused with external authentication with OID. Every OBIA installation has what ODI calls "External Authentication", as the users are not managed internally by ODI. If this is the case, disconnect from the Repository and switch back to External Authentication from ODI Studio menu ODI > Change Authentication Mode.

therefore you have to chance the authentication in ODI studio.

Thanks
Osama

Thursday, January 5, 2017

OBIEE Oracle Support Notes - Useful One.

A list of Information Centers:


  • Note 1378677.2 - Information Center: Enterprise Performance Management and BI Index (EPM/BI)
  • Note 1349989.2 - Information Center: Installing and Configuring Oracle Business Intelligence Enterprise Edition Release 10g and Later
  • Note 1349996.2 - Information Center: Optimizing Performance for Oracle Business Intelligence Enterprise Edition Release 10g and Later
  • Note 1349983.2 - Information Center: Oracle Business Intelligence Enterprise Edition (OBIEE) Release 10g and Later
  • Note 1350005.2 - Information Center: Security Information for Oracle Business Intelligence Enterprise Edition Release 10g and Later


List of Notes that may be useful :-


Note 1210310.1 - Master Note for Answers and Dashboards Issues in OBIEE
Note 1292894.1 - Master Note for BI Publisher Issues in OBIEE
Note 1292859.1 - Master Note for Briefing Book Issues in OBIEE
Note 1292904.1 - Master Note for Cache Issues in OBIEE
Note 1292936.1 - Master Note for Clustering Issues in OBIEE
Note 1293348.1 - Master Note for Crash/Hang Issues in OBIEE
Note 1293505.1 - Master Note for Data Warehouse Issues in OBIEE
Note 1293334.1 - Master Note for Disconnected Analytics Issues in OBIEE
Note 1265441.1 - Master Note for OBIEE 10g and 11g Essbase Integration issues (Doc ID )
Note 1293329.1 - Master Note for Integrated Security Issues in OBI Applications
Note 1248939.1 - Master Note for OBIEE 10g Integration with EBS, Siebel, SSO, Portal Server, Peoplesoft
Note 1301946.1 - Master Note for Internationalization and Globalization Issues in OBIEE
Note 1293391.1 - Master Note for iPhone BI Apps Issues in OBIEE
Note 1293337.1 - Master Note for Mapviewer Issues in OBIEE
Note 1293391.1 - Master Note For Oracle Business Intelligence Mobile Applications (iPhone/iPad) Issues in OBIEE
Note 1293344.1 - Master Note for Multi-user Development Issues in OBIEE
Note 1293301.1 - Master Note for Office Integration Issues in OBIEE
Note 1364889.1 - Master Note For OBIEE use with OPatch
Note 1293374.1 - Master Note for Performance Issues in OBIEE
Note 1293435.1 - Master Note for Presentation Server Administration Issues in OBIEE
Note 1293384.1 - Master Note for Repository Design Issues in OBIEE
Note 1293351.1 - Master Note for Scorecard & KPI Issues in OBIEE
Note 1293407.1 - Master Note for Security/Access Control Issues in OBIEE
Note 1293411.1 - Master Note for Server Execution Issues in OBIEE
Note 1293394.1 - Master Note for SOAP API Issues in OBIEE
Note 1293424.1 - Master Note for System Configuration EM/JMX Issues in OBIEE
Note 1293415.1 - Master Note for Usage Tracking Issues in OBIEE
Note 1293477.1 - Master Note for Webcat Replication Issues in OBIEE
Note 1293490.1 - Master Note for Write Back Issues in OBIEE
Note 1307975.1 - Summary Note About OBIEE 10.1.3.4.1 Patch 9492821: Information Applicable Prior To, Or After, Install
Note 1391648.1 - OBIEE11g: Installation, Migration and Upgrade Hints and Tips
Note 1589028.1 - Master Note For Oracle Hyperion Smart View For Office Issues in OBIEE


NOTE:1293490.1 - Master Note for Write Back Issues in OBIEE
NOTE:1293505.1 - Master Note for Data Warehouse Issues in OBIEE
NOTE:1301946.1 - Master Note for Internationalization and Globalization Issues in OBIEE
NOTE:1349983.2 - Information Center: Oracle Business Intelligence Enterprise Edition (OBIEE) Release 10g and Later
NOTE:1349989.2 - Information Center: Installing and Configuring Oracle Business Intelligence Enterprise Edition Release 10g and Later
NOTE:1349996.2 - Information Center: Optimizing Performance for Oracle Business Intelligence Enterprise Edition Release 10g and Later
NOTE:1350005.2 - Information Center: Security Information for Oracle Business Intelligence Enterprise Edition Release 10g and Later
NOTE:1364889.1 - Master Note For OBIEE use with OPatch
NOTE:1378677.2 - Information Center: Business Analytics Index (EPM/BI)
NOTE:1293391.1 - Master Note For Oracle Business Intelligence Mobile Applications (iPhone/iPad) Issues in OBIEE
NOTE:1293394.1 - Master Note for SOAP API Issues in OBIEE
NOTE:1293407.1 - OBIEE 11g: Master Note for Security/Access Control Issues
NOTE:1293411.1 - Master Note for Server Execution Issues in OBIEE
NOTE:1293415.1 - Master Note for Usage Tracking Issues in OBIEE
NOTE:1293424.1 - Master Note for System Configuration EM/JMX Issues in OBIEE
NOTE:1293435.1 - Master Note for Presentation Server Administration Issues in OBIEE
NOTE:1293477.1 - Master Note for Webcat Replication Issues in OBIEE
NOTE:1210310.1 - Master Note for Answers and Dashboards Issues in OBIEE
NOTE:1248939.1 - Master Note for OBIEE 10g Integration with EBS, Siebel, SSO, Portal Server, Peoplesoft
NOTE:1265441.1 - Master Note for OBIEE 10g and 11g Essbase Integration issues
NOTE:1267009.1 - Oracle Business Intelligence Enterprise Edition (OBIEE) Product Information Center (PIC)
NOTE:1292859.1 - Master Note for Briefing Book Issues in OBIEE
NOTE:1292894.1 - Master Note for BI Publisher Issues in OBIEE
NOTE:1292904.1 - Master Note for Cache Issues in OBIEE 10g and 11g
NOTE:1292936.1 - Master Note for Clustering Issues in OBIEE 10g and 11g
NOTE:1293301.1 - Master Note for Office Integration Issues in OBIEE
NOTE:1293329.1 - Master Note for Integrated Security Issues in OBI Applications
NOTE:1293334.1 - Master Note for Disconnected Analytics Issues in OBIEE
NOTE:1293337.1 - OBIEE: Master Note for Mapviewer Issues
NOTE:1293344.1 - Master Note for Multi-user Development Issues in OBIEE
NOTE:1293348.1 - Master Note for Crash/Hang Issues in OBIEE 10g and 11g
NOTE:1293351.1 - Master Note for Scorecard & KPI Issues in OBIEE
NOTE:1293374.1 - Master Note for Performance Issues in OBIEE
NOTE:1293384.1 - Master Note for Repository Design Issues in OBIEE
NOTE:1589028.1 - Master Note For Oracle Hyperion SmartView (Smart View) For Office Issues in OBIEE


Cheers
And Enjoy Reading 

Osama mustafa

Wednesday, December 21, 2016

When the last time the password has been changed ?

Do you want to know what is the last time the DBA or developers change the password ?

Using the below table :-

Name
Null
Type
USER#       
NOT NULL
NUMBER
NAME        
NOT NULL
NUMBER        
TYPE#       
NOT NULL
VARCHAR2(30)  
PASSWORD    
        
NUMBER        
DATATS#     
NOT NULL
NUMBER        
TEMPTS#     
NOT NULL
DATE          
CTIME       
NOT NULL
DATE          
PTIME       
        
DATE          
EXPTIME     
        
DATE          
LTIME       
        
NUMBER        
RESOURCE$   
NOT NULL
VARCHAR2(38)  
AUDIT$      
        
NUMBER        
DEFROLE     
NOT NULL
NUMBER        
DEFGRP#     
        
NUMBER        
DEFGRP_SEQ# 
        
NUMBER        
ASTATUS     
NOT NULL
NUMBER        
LCOUNT      
NOT NULL
VARCHAR2(30)  
DEFSCHCLASS 
        
VARCHAR2(4000)
EXT_USERNAME
        
NUMBER        
SPARE1      
        
NUMBER        
SPARE2      
        
NUMBER        
SPARE3      
        
VARCHAR2(1000)
SPARE4      
        
VARCHAR2(1000)
SPARE5      
        
DATE
SPARE6      
        
NUMBER        
USER#       
NOT NULL
VARCHAR2(30)  
NAME        
NOT NULL
NUMBER        
TYPE#       
NOT NULL
NUMBER        
PASSWORD    
        
DATE          
DATATS#     
NOT NULL
DATE          
TEMPTS#     
NOT NULL
DATE          
CTIME       
NOT NULL
DATE          
PTIME       
        
NUMBER        
EXPTIME     
        
VARCHAR2(38)  
LTIME       
        
NUMBER        
RESOURCE$   
NOT NULL
NUMBER        
AUDIT$      
        
NUMBER        
DEFROLE     
NOT NULL
NUMBER        
DEFGRP#     
        
NUMBER        
DEFGRP_SEQ# 
        
VARCHAR2(30)  
ASTATUS     
NOT NULL
VARCHAR2(4000)

Referring to Oracle Documentation :-

     
NAME – name for user or role
TYPE# – 0 for role or 1 for user
CTIME – the date of creation
PTIME – the date the password was last changed
EXPTIME – the date the password has last expired
LTIME – the date the resource was last locked
LCOUNT – number of failed logon

You Can use this query :-

SELECT name, ctime, ptime FROM sys.user$ WHERE name = 'USER-NAME';

Thank you
Osama 

Friday, December 9, 2016

OCP Upgrade 1Z0-060 Exam guide

This guide will get Oracle admins up to date with the latest developments in Oracle 12c. It includes all the necessary information that you need to implement in your existing systems.

All of the information in this book has been handpicked to help you study for the Oracle 12c upgrade exam. Each chapter has been written with the objective of helping you pass this exam with ease. Content in this book is aligned with the objectives of the exam, making it really easy to follow the course content. Every example mentioned in this book has been tried and tested in actual environment. Real-world examples will help you learn about new features such as multitenant containers database architecture, managing containers, pluggable databases, database administration enhancements, database auditing, tuning, backup, and flashback enhancements.

You will also learn about storage enhancements, security updates, tuning, troubleshooting, and backup enhancements. This book also covers section 2 of the exam course making this book a complete guide for passing OCP 12c upgrade exam 1Z0-060.

What you will learn

All of the new features of the Oracle 12c database that you are required to know for the OCP Upgrade Exam 1Z0-060
New multitenant architecture introduced in Oracle 12c and how it works
Monitor complex database operations and use the new enhanced SQL tuning features to tune bad SQLs
Manage data over time using information life cycle management
Make your data more secure by implementing new enhanced auditing
Learn new security features and how to implement encryption to secure your data
Explore how backup and flashback works with new multitenant architecture
Performance management techniques that will analyze and tune your database


The book link from here

Cheers
Osama

Friday, December 2, 2016

2016 Another Year In this world

I don't know if it is early to write something now, most of people will share this during the end of December but i choose to write mine earlier, i will not share anything technical this time but i will share what i did during this year maybe it will be useful for someone :) so enjoy reading.

I did a lot of things during 2016 and most of them related to my work and what i love which is Oracle and contribution in Oracle community there was differenct conference during this year which took a lot of time and travel i don't how much time i spent in the air but i am sure it's more than 10 days since i am living in the other side of the world which is Jordan - Amman or Sometimes Dubai.

I start the year with one of the best conference and the well known one which is Rocky mountains and this is was my first time in this amazing conference during the conference i celebrate my birthday in Denver with my friends, alot of the conference and traveling so i will mention them as point ( i don't want the reader to get bored  ).


  • RMOUG 
  • OUGN
  • IOUG
  • TROUG
  • OUGF
  • OTN TOUR - LA 
  • OOW 
  • DOAG
For the Other contribution i did the following :- 

  • Organize Local event for Jordan Amman Oracle User Group.
  • Technical Reviewer for two books.
  • Technical Reviewer for Videos about Oracle database series. 
  • working on my new book.
  • write different oracle articles.
  • Sure ... Post blogs about Oracle.

I feel like i forgot something to mention but if i remember anything i will publish it for sure and update the blog post here. 

I would like to take this opportunity to thanks Oracle ACE Program to allow us & support us do what we are doing for the community. which is one of the best community in the world.

I am always thankful for meeting new friends around the world and for my family for their continues support.

Thank you Oracle

Wish Happy new year everyone and all of the best next year.
Merry Christmas everyone enjoy the holiday. 

My friends see you next year Inchallah :) Finally Inchallh next year will be better for all of us.

Cheers
Osama 

Like Usual comments are always welcome.