Tag: Osama blog

WorkFlowCA: NullError : Could not Connect to the Remote Server

Posted on by Osama Mustafa in Application

This Error Appear When Trying to Run Oracle Ware-House Builder On Linux , in this tools you are connecting to Database to Setup some configuration for Workflow in DWH, Every Thing Run Successfully Till i received the error in the picture :

WorkFlowCA: NullError : Could not Connect to the Remote Server

You Can ignore this error simply , I didn’t configure Oracle Enterprise manager in my database , which is the reason for this Error.if you want create enterprise manager and re run the tool again.

Thank you
Osama Mustafa 

Enable Automatic Memory Management (AMM)

Posted on by Osama Mustafa in Database
SQL> show parameter target

NAME                                               TYPE        VALUE
———————————— ———–       ——-
archive_lag_target                                     integer     0
db_flashback_retention_target                  integer     1440
fast_start_io_target                                   integer     0
fast_start_mttr_target                                integer     0
memory_max_target                                 big integer 26048M
memory_target                                         big integer 0
parallel_servers_target                              integer     2048
pga_aggregate_target                               big integer 6502M
sga_target                                                big integer 19520M

SQL> ALTER SYSTEM SET MEMORY_MAX_TARGET = 16384M scope=spfile ;

SQL > SHUTDOWN IMMEDIATE;
SQL > STARTUP ;
SQL> ALTER SYSTEM SET SGA_TARGET = 0 scope=spfile ;
System altered.
SQL> ALTER SYSTEM SET PGA_AGGREGATE_TARGET = 0 scope=spfile ;
System altered.
SQL> ALTER SYSTEM SET MEMORY_TARGET=12288M scope=spfile ;
System altered.
Thank you 
Osama Mustafa

Are we in the Cloud

Posted on by Osama Mustafa in Cloud
What is The Cloud Computing ? Are We in the Cloud ? Where Can I Find it ? Simple Question but It’s has been asked a lot.

Simply Cloud Computing Storing and accessing Data and programs Using Over Internet instead of Local Computer.

I Found the Below Chart on the internet and it’s The Best Describe for the cloud “Source Cloud For Dummies” :

Cloud is the next Stage for everything, Because it can be defined as set of hardware,Platforms , Databases, Networking it will safe lot of money for the companies.

Check the below video :

http://youtube.googleapis.com/v/ae_DKNwK_ms&source=uds

You need to know some  Definition you will heard when we are talking about Cloud:
Xaas is Term said for number of things “X as a Services” / ” Anything as a Services”

The Most Common Examples on the above :

  • DBaas : Database as a Service.
  • Paas : Platform as a Service.
  • SaaS : Software as a Service/Storage as a Service.
  • IaaS : Infrastructure as a Service.
  • Caas : Communication as Service.
  • Naas : Network as Service.
It’s New Future.
Thank you 
Osama mustafa

Oracle Business Intelligence Installation

Posted on by Osama Mustafa in Articles, DevOps Tools, Fusion Middleware
Before start describes steps, I would like to share some notes:
  •     Extend Weblogic Server will not work (config.sh).
  •    BI server should be added first before any managed server otherwise AdminServer will corrupted.
  •   If you already have AdminServer configured you can created new BI Domain, Or backup your AdminServer  domain and Reconfigure again.

The above notes are useful and must be considered before installing Oracle BI.
You can download the document from Here
Thank you

Osama Mustafa

Enterprise manager Performance Hub (Real Time) 12c

Posted on by Osama Mustafa in Database
Enterprise manager express is 

SQL> drop user osama cascade ;
User dropped.

SQL> create user osama identified by osama;
User created.

SQL> grant select any table to osama;
Grant succeeded.

SQL> grant select any dictionary to osama ;
Grant succeeded.

SQL> grant create session to osama;
Grant succeeded.

SQL> conn osama/osama ;
Connected.

SQL> EXEC  DBMS_SQL_MONITOR.BEGIN_OPERATION (‘My_First_JOB’, forced_tracking => ‘Y’);
BEGIN DBMS_SQL_MONITOR.BEGIN_OPERATION (‘My_First_JOB’, forced_tracking => ‘Y’); END;
      *
ERROR at line 1:
ORA-06550: line 1, column 7:
PLS-00221: ‘BEGIN_OPERATION’ is not a procedure or is undefined
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

to avoid this error :

SQL> VAR myjob_id NUMBER;

SQL> EXEC :myjob_id := DBMS_SQL_MONITOR.BEGIN_OPERATION (‘My_First_JOB’, forced_tracking => ‘Y’)

PL/SQL procedure successfully completed.

Where 
myjob_id : variable
My_first_Job : Job name.

Now Check Enterprise manager express Page : 

if you check the second picture you will see if you don’t stop the sql_monitor the Job will still running

SQL> EXEC DBMS_SQL_MONITOR.END_OPERATION(‘My_First_JOB’, :myjob_id) ;
PL/SQL procedure successfully completed.

Thank you 
Osama Mustafa

Enable Enterprise Express for Database 12c

Posted on by Osama Mustafa in Database
Oracle Database 12c comes with new feature called Enterprise manager 12c express, this new enterprise manager control Database 12c using GUI , manager storage , performance , user, roles, accounts and others new features added , No command to start or shutdown EM 12c express by default when you start/shutdown database it will be up/down.

  • export ORACLE_SID
  • Make sure listener is up and database is registered.

sqlplus / as sysdba
SQL> show parameter dispatcher ;
NAME     TYPE VALUE
———————————— ———– ——————————
dispatchers     string (PROTOCOL=TCP) (SERVICE=db12cX
DB)

  • Configure HTTP PORT 

SQL> exec DBMS_XDB_CONFIG.setHTTPPort (8080);

Check the below pictures that describe EM Express :

DBMS_XDB.setHTTPPort is deprecated

Thank you
Osama mustafa

New Features 12c EXPDP

Posted on by Osama Mustafa in Database
While i am testing Oracle 12c i notice new features in expdp , which you can export view like the following :

SQL> create table test ( id number);
Table created.

SQL> create view test_vw as select * from test ;
View created.

SQL> create directory dump as ‘/u01/dump’;
Directory created.

SQL> grant read,write on directory dump to osama ;
Grant succeeded.

[oracle@test12c u01]$ expdp directory=dump dumpfile=test.dmp logfile=test.log VIEWS_AS_TABLES=test_vw
Export: Release 12.1.0.1.0 – Production on Wed Jun 26 18:33:52 2013
Copyright (c) 1982, 2013, Oracle and/or its affiliates.  All rights reserved.
Username: osama
Password: 
Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 – 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
Starting “OSAMA”.”SYS_EXPORT_TABLE_01″:  osama/******** directory=dump dumpfile=test.dmp logfile=test.log VIEWS_AS_TABLES=test_vw 
Estimate in progress using BLOCKS method…
Processing object type TABLE_EXPORT/VIEWS_AS_TABLES/TABLE_DATA
Total estimation using BLOCKS method: 0 KB
Processing object type TABLE_EXPORT/VIEWS_AS_TABLES/TABLE
. . exported “OSAMA”.”TEST_VW”                              0 KB       0 rows
Master table “OSAMA”.”SYS_EXPORT_TABLE_01″ successfully loaded/unloaded
******************************************************************************
Dump file set for OSAMA.SYS_EXPORT_TABLE_01 is:
  /u01/dump/test.dmp
Job “OSAMA”.”SYS_EXPORT_TABLE_01″ successfully completed at Wed Jun 26 18:34:15 2013 elapsed 0 00:00:17
I dropped the view 

SQL> drop view Test_vw ;
View dropped.
impdp directory=dump dumpfile=test.dmp logfile=test.log VIEWS_AS_TABLES=test_vw


Thank you 
Osama mustafa