Author: Osama Mustafa

Osama considered as one of the leaders in Cloud technology, DevOps and database in the Middle-East. I have more than ten years of experience within the industry. moreover, certfied 4x AWS , 4x Azure and 6x OCI, have also obtained database certifications for multiple providers. In addition to having experience with Oracle database and Oracle products, such as middle-ware, OID, OAM and OIM, I have gained substantial knowledge with different databases. Currently, I am architecting and implementing Cloud and DevOps. On top of that, I'm providing solutions for companies that allow them to implement the solutions and to follow the best practices.

Oracle 12.2 is Now Available on E-delivery

Posted on February 14, 2017December 23, 2018 by Osama Mustafa in News

Oracle Just Announced the availability of Oracle database 12cR2 Exadata/SuperCluster On their website, In Case you want to upgrade 🙂

You can download oracle Enterprise edition 12cR2 from Oracle Edelivery Here

Follow the steps :-

Enjoy
Osama

Oracle Database 12cR2 Documentation is here

Posted on February 12, 2017December 23, 2018 by Osama Mustafa in News

Finally Oracle 12cR2 documentation is here

also All Books for Oracle® Database Online is here

Cheers

Osama

Import One table to the new name in the same schema

Posted on February 2, 2017December 23, 2018 by Osama Mustafa in Database

The following case just want to share it in case anyone need it, development wants to import the existing table in the siebel schema into the new name to check the data integrity:-

Oracle Provide you with Attribute called REMAP_TABLE Read More about it here.

Just Run the following command and change the variable depend on your environment :-

directory : The name of existing dump
dumpfile : The name of dump file
remap_table : Allows you to rename tables during an import operation
tables : the name of the table you want to restore it.

impdp directory=DMP_BAK dumpfile=31-01-2017_PRDSBL.dmp remap_table=siebel.CX_PERMITS:CX_PERMITS_NEW tables=CX_PERMITS

Thanks
Osama

DBMS_REDEFINITION to create partition for existing table

Posted on January 20, 2017December 23, 2018 by Osama Mustafa in Database

to do this oracle provide you with package called DBMS_REDEFINITION for more information about it here

In this post i will show you how to partition existing table for SIEBEL application which is my case holding huge number of records.

Create the same structure for the original table but without any constraint just columns like the below with new name and sure choose the partition you want to use, in case any of the constraint has been created on the new table , error will be generated while the package running and you should recreate the table again without any constraint :-

CREATE TABLE SIEBEL.S_CASE_NEW
(
ROW_ID VARCHAR2(15 CHAR) ,
CREATED DATE DEFAULT sysdate ,
CREATED_BY VARCHAR2(15 CHAR) ,
LAST_UPD DATE DEFAULT sysdate ,
LAST_UPD_BY VARCHAR2(15 CHAR) ,
MODIFICATION_NUM NUMBER(10) DEFAULT 0 ,
CONFLICT_ID VARCHAR2(15 CHAR) DEFAULT ‘0’ ,
ASGN_USR_EXCLD_FLG CHAR(1 CHAR) DEFAULT ‘N’ ,
BU_ID VARCHAR2(15 CHAR) DEFAULT ‘0-R9NH’ ,
CASE_DT DATE ,
CASE_NUM VARCHAR2(100 CHAR) ,
CHGOFCCM_REQ_FLG CHAR(1 CHAR) DEFAULT ‘N’ ,
CLASS_CD VARCHAR2(30 CHAR) ,
LOCAL_SEQ_NUM NUMBER(10) DEFAULT 1 ,
NAME VARCHAR2(100 CHAR) ,
PR_REP_DNRM_FLG CHAR(1 CHAR) DEFAULT ‘N’ ,
PR_REP_MANL_FLG CHAR(1 CHAR) DEFAULT ‘N’ ,
PR_REP_SYS_FLG CHAR(1 CHAR) DEFAULT ‘N’ ,
STATUS_CD VARCHAR2(30 CHAR) ,
ASGN_DT DATE,
CLOSED_DT DATE,
CURR_APPR_SEQ_NUM NUMBER(10),
DB_LAST_UPD DATE,
REWARD_AMT NUMBER(22,7),
REWARD_EXCH_DATE DATE,
APPLICANT_ID VARCHAR2(15 CHAR),
APPR_TEMP_ID VARCHAR2(15 CHAR),
AUDIT_EMP_ID VARCHAR2(15 CHAR),
CATEGORY_TYPE_CD VARCHAR2(30 CHAR),
CITY VARCHAR2(50 CHAR),
COUNTRY VARCHAR2(30 CHAR),
CRIME_SUB_TYPE_CD VARCHAR2(30 CHAR),
CRIME_TYPE_CD VARCHAR2(30 CHAR),
DB_LAST_UPD_SRC VARCHAR2(50 CHAR),
DESC_TEXT VARCHAR2(2000 CHAR),
MSTR_CASE_ID VARCHAR2(15 CHAR),
ORG_GROUP_ID VARCHAR2(15 CHAR),
PAR_CASE_ID VARCHAR2(15 CHAR),
PRIORITY_TYPE_CD VARCHAR2(30 CHAR),
PR_AGENCY_ID VARCHAR2(15 CHAR),
PR_AGENT_ID VARCHAR2(15 CHAR),
PR_DISEASE_ID VARCHAR2(15 CHAR),
PR_POSTN_ID VARCHAR2(15 CHAR),
PR_PROD_INT_ID VARCHAR2(15 CHAR),
PR_PRTNR_ID VARCHAR2(15 CHAR),
PR_SGROUP_ID VARCHAR2(15 CHAR),
PR_SUBJECT_ID VARCHAR2(15 CHAR),
PR_SUSPCT_ID VARCHAR2(15 CHAR),
PS_APPL_ID VARCHAR2(15 CHAR),
REWARD_CURCY_CD VARCHAR2(20 CHAR),
SERIAL_NUM VARCHAR2(100 CHAR),
SOURCE_CD VARCHAR2(30 CHAR),
STAGE_CD VARCHAR2(30 CHAR),
STATE VARCHAR2(10 CHAR),
SUBJECT_NAME VARCHAR2(100 CHAR),
SUBJECT_PH_NUM VARCHAR2(40 CHAR),
SUB_STATUS_CD VARCHAR2(30 CHAR),
SUB_TYPE_CD VARCHAR2(30 CHAR),
TERRITORY_TYPE_CD VARCHAR2(30 CHAR),
THREAT_LVL_CD VARCHAR2(30 CHAR),
TYPE_CD VARCHAR2(30 CHAR),
X_APP_BIRTH_DATE DATE,
X_APP_BIRTH_DT_HIJRI VARCHAR2(10 CHAR),
X_APP_FATHER_NAME_A VARCHAR2(50 CHAR),
X_APP_FATHER_NAME_E VARCHAR2(50 CHAR),
X_APP_FAX VARCHAR2(15 CHAR),
X_APP_FIRST_NAME_A VARCHAR2(50 CHAR),
X_APP_FIRST_NAME_E VARCHAR2(50 CHAR),
X_APP_FULL_NAME VARCHAR2(100 CHAR),
X_APP_GENDER VARCHAR2(30 CHAR),
X_APP_GFATHER_NAME_A VARCHAR2(50 CHAR),
X_APP_GFATHER_NAME_E VARCHAR2(50 CHAR),
X_APP_LAST_NAME_A VARCHAR2(50 CHAR),
X_APP_LAST_NAME_E VARCHAR2(50 CHAR),
X_APP_MAIL VARCHAR2(50 CHAR),
X_APP_MOBILE VARCHAR2(15 CHAR),
X_APP_MOTHER_F_NAME_A VARCHAR2(50 CHAR),
X_APP_MOTHER_F_NAME_E VARCHAR2(50 CHAR),
X_APP_MOTHER_L_NAME_A VARCHAR2(50 CHAR),
X_APP_MOTHER_L_NAME_E VARCHAR2(50 CHAR),
X_APP_TYPE VARCHAR2(30 CHAR),
X_APPLICANT_CLASSIFICATION VARCHAR2(30 CHAR),
X_APPLICANT_NAT_ID_NO VARCHAR2(15 CHAR),
X_APPLICANT_TITLE VARCHAR2(30 CHAR),
X_APPLICANT_TYPE VARCHAR2(50 CHAR),
X_ATTACHMENT_FLG VARCHAR2(5 CHAR),
X_CANCEL_DESC VARCHAR2(300 CHAR),
X_CANCEL_REASON VARCHAR2(30 CHAR),
X_CASE_COPY_FLG VARCHAR2(30 CHAR),
X_CASE_HIJRI_DATE VARCHAR2(30 CHAR),
X_CHECK_EXISTS_FKG VARCHAR2(15 CHAR),
X_CHECK_EXISTS_FLG VARCHAR2(30 CHAR),
X_COMMERCIAL_NAME VARCHAR2(300 CHAR),
X_COMMERCIAL_REG_NO VARCHAR2(40 CHAR),
X_COPY_SERIAL_NUM VARCHAR2(100 CHAR),
X_CREATED_DATE_HEJRI VARCHAR2(30 CHAR),
X_CREATED_GRG VARCHAR2(30 CHAR),
X_CREATED_HIJRI VARCHAR2(10 CHAR),
X_CRED_EXP_DT_HIJRI VARCHAR2(10 CHAR),
X_CRED_EXPIRY_DATE DATE,
X_CRED_ISSUE_DATE DATE,
X_CRED_ISSUE_DT_HIJRI VARCHAR2(10 CHAR),
X_CRED_NO VARCHAR2(30 CHAR),
X_CRED_TYPE VARCHAR2(30 CHAR),
X_CRS_NO VARCHAR2(15 CHAR),
X_DLV_DATE DATE,
X_DLV_DATE_HIJRI VARCHAR2(10 CHAR),
X_DLV_USER_ID VARCHAR2(15 CHAR),
X_DOCUMENT_SORUCE VARCHAR2(30 CHAR),
X_EST_OWNERSHIP_TYPE VARCHAR2(30 CHAR),
X_EST_TYPE VARCHAR2(30 CHAR),
X_GIS_DATA_LOAD VARCHAR2(15 CHAR),
X_GIS_DATA_STATUS VARCHAR2(10 CHAR),
X_INV_TYPE VARCHAR2(30 CHAR),
X_IS_UPLOADED VARCHAR2(30 CHAR),
X_LAND_ORG_TYPE VARCHAR2(30 CHAR),
X_LAND_STATUS VARCHAR2(30 CHAR),
X_LAND_TYPE VARCHAR2(30 CHAR),
X_MUNICIPAL_NAME VARCHAR2(30 CHAR),
X_NATIONALITY VARCHAR2(30 CHAR),
X_ORG_END_REG_DATE DATE,
X_ORG_END_REG_HIJRI_DATE VARCHAR2(10 CHAR),
X_ORG_REGISTRATION_DATE DATE,
X_ORG_REGISTRATION_HIJRI_DATE VARCHAR2(10 CHAR),
X_ORGANIZATION_NAME VARCHAR2(200 CHAR),
X_ORIGINAL_ORG_ID VARCHAR2(15 CHAR),
X_PAPER_FLG CHAR(1 CHAR) DEFAULT ‘N’,
X_PAYMENT_DT DATE,
X_PAYMENT_FLAG VARCHAR2(30 CHAR),
X_PAYMENT_NO VARCHAR2(10 CHAR),
X_PR_EMP_ID VARCHAR2(15 CHAR),
X_PR_ENG_OFFICE_ID VARCHAR2(15 CHAR),
X_PROC_DESC VARCHAR2(100 CHAR),
X_PROC_FLG VARCHAR2(30 CHAR),
X_PROC_TYPE VARCHAR2(30 CHAR),
X_PROXY_ISSUE_AUTHORITY VARCHAR2(30 CHAR),
X_PROXY_NO VARCHAR2(10 CHAR),
X_QX_CRED_EXP_DT_HIJRI DATE,
X_REGISTRATION_DATE DATE,
X_REGISTRATION_HIJRI_DATE VARCHAR2(10 CHAR),
X_REGISTRATION_NO VARCHAR2(30 CHAR),
X_REJECT_DESC VARCHAR2(300 CHAR),
X_REJECT_REASON VARCHAR2(30 CHAR),
X_RELATION_TYPE VARCHAR2(30 CHAR),
X_RETURN_DATE DATE,
X_RETURN_DATE_HIJRI VARCHAR2(10 CHAR),
X_RETURN_NOTES VARCHAR2(100 CHAR),
X_RETURN_REASON VARCHAR2(30 CHAR),
X_SCHEMA_STATUS VARCHAR2(30 CHAR),
X_SECURITY_FLG VARCHAR2(30 CHAR),
X_SELECT_FLG CHAR(1 CHAR) DEFAULT ‘N’,
X_STRIPPED_FIRST_NAME VARCHAR2(50 CHAR),
X_STRIPPED_FULL_NAME VARCHAR2(200 CHAR),
X_STRIPPED_LAST_NAME VARCHAR2(50 CHAR),
X_STRIPPED_MOTHER_FIRST VARCHAR2(50 CHAR),
X_STRIPPED_MOTHER_FULLNAME VARCHAR2(50 CHAR),
X_STRIPPED_MOTHER_LASTNAME VARCHAR2(50 CHAR),
X_STRIPPED_SECOND_NAME VARCHAR2(50 CHAR),
X_STRIPPED_THIRD_NAME VARCHAR2(50 CHAR),
X_TO_BU_ID VARCHAR2(15 CHAR),
X_UPDATED_GRG VARCHAR2(30 CHAR),
X_UPDATED_HIJRI VARCHAR2(10 CHAR),
COR_TYPE VARCHAR2(30 CHAR),
CORR_CAS_CAT VARCHAR2(30 CHAR),
PRIMARY_EMPLOYEE VARCHAR2(30 CHAR),
SUBMIT_TO_STATUS VARCHAR2(15 CHAR),
X_DOCUMENT_TYPE VARCHAR2(30 CHAR),
X_SURVEYOR_NAME VARCHAR2(30 CHAR),
X_OLD_STATUS VARCHAR2(30 CHAR),
X_APPLICANT_ORG_ID VARCHAR2(15 CHAR),
X_APPLICANT_ROW_ID VARCHAR2(15 CHAR),
X_GIS_TOKEN VARCHAR2(100 CHAR),
X_NEW_PERMIT_FLG CHAR(1 CHAR) DEFAULT ‘Y’,
X_TRANSACTION_MOD VARCHAR2(30 CHAR),
X_TRANSACTION_STATUS VARCHAR2(30 CHAR),
X_CASE_CAT VARCHAR2(100 CHAR),
X_CASE_COPY_SERIAL NUMBER(10),
X_GIS_PARAMETER VARCHAR2(300 CHAR),
X_GIS_ROWIDS VARCHAR2(100 CHAR),
READING_FLAG CHAR(1 CHAR) DEFAULT ‘N’,
X_GIS_MUNICIPAL VARCHAR2(30 CHAR),
X_ORG_DELEGATE_NAME VARCHAR2(200 CHAR),
X_PR_POS_ORG_ID VARCHAR2(15 CHAR),
X_ORGANIZATION_STRIPPED_NAME VARCHAR2(200 CHAR),
X_CITIZEN_REVIEW CHAR(1 CHAR),
X_ALLOWED_USAGE VARCHAR2(50 CHAR),
X_AUTHORIZATION_DATE DATE,
X_AUTHORIZATION_HIJRI_DATE VARCHAR2(10 CHAR),
X_AUTHORIZATION_NO VARCHAR2(20 CHAR),
X_CIVIL_APPROVAL_DATE DATE,
X_CIVIL_APPROVAL_HIJRI_DATE VARCHAR2(10 CHAR),
X_CIVIL_APPROVAL_NO VARCHAR2(20 CHAR),
X_CIVIL_OFFICE VARCHAR2(25 CHAR),
X_NEW_MUNICIPAL_NAME VARCHAR2(30 CHAR),
X_OLD_MUNICIPAL_NAME VARCHAR2(30 CHAR),
X_OLD_STATUS_CD VARCHAR2(30 CHAR),
X_RESTRICT_NUM VARCHAR2(30 CHAR),
X_LAST_UPD_HIJRI VARCHAR2(10 CHAR),
X_APP_BIRTH_DATE_HIJRI VARCHAR2(10 CHAR),
X_FEES_EXCEPTION VARCHAR2(30 CHAR),
X_FINCL_NAME VARCHAR2(30 CHAR),
X_IS_OWNER VARCHAR2(15 CHAR),
X_MANAGER_ID VARCHAR2(15 CHAR),
X_OWNERSHIP_TYPE VARCHAR2(30 CHAR),
X_PRINT_FLG CHAR(1 CHAR) DEFAULT ‘N’,
X_PRNT_FLG VARCHAR2(5 CHAR),
X_SECRETARY_ID VARCHAR2(15 CHAR),
X_UNDER_SECRETARY_ID VARCHAR2(15 CHAR),
X_VIEW_SEQUENCE NUMBER(10) DEFAULT 0,
X_REGULATION_ACCPTNCE_FLG VARCHAR2(7 CHAR),
X_CONFIRM_FLAG VARCHAR2(7 CHAR),
X_OCCUPATION_IN_RESIDENCE VARCHAR2(30 CHAR),
X_ROWNUM NUMBER(10),
X_NUMBER_ARCHIVAL VARCHAR2(15 CHAR),
X_ATTACHMENT_PARAMETERS VARCHAR2(500 CHAR),
X_ATTACHMENT_ROW_IDS VARCHAR2(500 CHAR),
X_BP_ID VARCHAR2(15 CHAR),
X_CONTROL_SUB_TYPE VARCHAR2(30 CHAR),
X_CONTROL_TYPE VARCHAR2(30 CHAR),
X_DEPOSIT_ID VARCHAR2(15 CHAR),
X_MALL_ID VARCHAR2(15 CHAR),
X_NEW_DEPOSIT NUMBER(10),
X_SOURCE_ID VARCHAR2(15 CHAR),
X_STORE_ID VARCHAR2(15 CHAR),
APPEALED_FLG CHAR(1 CHAR) DEFAULT ‘N’ ,
CHANGED_FLG CHAR(1 CHAR) DEFAULT ‘N’ ,
EVAL_ASSESS_ID VARCHAR2(15 CHAR),
X_ARCHIEVING_TYPE VARCHAR2(30 CHAR),
X_ACTIVITY_ID VARCHAR2(15 CHAR),
X_OLD_SERIAL_NUM VARCHAR2(20 CHAR),
X_OWNER_ORG_POSTN_ID VARCHAR2(15 CHAR),
X_PR_CNTR_POSTN_ID VARCHAR2(15 CHAR),
X_REPORT_URL VARCHAR2(500 CHAR),
X_VIOLATION_ID VARCHAR2(15 CHAR),
X_APPLICANT_SOURCE VARCHAR2(50 CHAR)
)
PARTITION BY RANGE (created)(PARTITION S_CASE_2015 VALUES LESS THAN (TO_DATE(’01/01/2016′, ‘DD/MM/YYYY’)), PARTITION S_CASE_2016 VALUES LESS THAN (TO_DATE(’01/01/2017′, ‘DD/MM/YYYY’)), PARTITION S_CASE_2017 VALUES LESS THAN (MAXVALUE));

Now we should start the redefinition by running the following package

BEGIN
DBMS_REDEFINITION.start_redef_table(
uname => ‘SIEBEL’,
orig_table => ‘S_CASE’,
int_table => ‘S_CASE_NEW’);
END;
/

Sync the both tables together

BEGIN
dbms_redefinition.sync_interim_table(
uname => ‘SIEBEL’,
orig_table => ‘S_CASE’,
int_table => ‘S_CASE_NEW’);
END;
/

After Running the both package above run the below scripts but run it from the server side, because it’s takes times & to avoid any interruption

SET SERVEROUTPUT ON
DECLARE
l_errors NUMBER;
BEGIN
DBMS_REDEFINITION.copy_table_dependents(
uname => ‘SIEBEL’,
orig_table => ‘S_CASE’,
int_table => ‘S_CASE_NEW’,
copy_indexes => DBMS_REDEFINITION.cons_orig_params,
copy_triggers => TRUE,
copy_constraints => TRUE,
copy_privileges => TRUE,
ignore_errors => FALSE,
num_errors => l_errors,
copy_statistics => FALSE,
copy_mvlog => FALSE);

DBMS_OUTPUT.put_line(‘Errors=’ || l_errors);
END;
/

Finish the redefinition

BEGIN
dbms_redefinition.finish_redef_table(
uname => ‘SIEBEL’,
orig_table => ‘S_CASE’,
int_table => ‘S_CASE_NEW’);
END;
/

After finishing everything successfully, just drop the new table because now it’s became the old table

DROP TABLE S_CASE_NEW;

Run the below query to see if the partition has been successfully created

SELECT partitioned
FROM dba_tables
WHERE table_name = ‘S_CASE’;

Thanks
Osama

Kill Datapump job that running inside Database

Posted on January 11, 2017December 23, 2018 by Osama Mustafa in 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

Oracle Data Integrator repository is not accessible.

Posted on January 8, 2017December 23, 2018 by Osama Mustafa in Fusion Middleware

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:

Bad user credentials and/or type of Authentication.
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

OBIEE Oracle Support Notes – Useful One.

Posted on January 5, 2017December 23, 2018 by Osama Mustafa in Fusion Middleware

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

When the last time the password has been changed ?

Posted on December 21, 2016December 23, 2018 by Osama Mustafa in Database

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

OCP Upgrade 1Z0-060 Exam guide

Posted on December 9, 2016December 23, 2018 by Osama Mustafa in News

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

2016 Another Year In this world

Posted on December 2, 2016December 23, 2018 by Osama Mustafa in News

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.