Today I would like to share this document step by step how to install Oracle ODI and SOA On Oracle Linux 6.4.
As Usual I upload it to my slide share account here
Thank you
Osama mustafa
BLOG
From DBA to Cabling Job
Simple Post, Describe i have been Busy Lately and the work not finished Yet.
Thank you
Osama Mustafa
Oracle Sun Server X3-2 And Exalytics BI
The Hardware delivered to us today and would like to share some pictures for this amazing servers
Failed to create secure socket for OPMN at LocalHost:9501
The Below Error Appear when you enter to the following URL : http://LocalHost:9704/analytics
oracle.as.management.opmn.optic.OpticBadConnectException: Failed to create secure socket for OPMN
Change Directory to the to BI instance/Bin Folder and :
[oracle@exalytic bin]$ ./opmnctl stopall
opmnctl stopall: opmn is not running.
[oracle@exalytic bin]$ ./opmnctl startall
opmnctl startall: starting opmn and all managed processes…
[oracle@exalytic bin]$ ./opmnctl status
Processes in Instance: obiee1
———————————+——————–+———+———
ias-component | process-type | pid | status
———————————+——————–+———+———
coreapplication_obiccs1 | OracleBIClusterCo~ | 19837 | Alive
coreapplication_obisch1 | OracleBIScheduler~ | 0 | NONE
coreapplication_obijh1 | OracleBIJavaHostC~ | 19836 | Alive
coreapplication_obips1 | OracleBIPresentat~ | 19840 | Alive
coreapplication_obis1 | OracleBIServerCom~ | 19838 | Alive
Thank you
Osama Mustafa
User Not Able To Drop Even When I killed the session.
Today while i was working on Database trying to Drop user called PRD_MDS the normal error appearing to me :
SQL> drop user PRD_MDS cascade ;
drop user PRD_MDS cascade
*
ERROR at line 1:
ORA-01940: cannot drop a user that is currently connected
Which is very normal error and the first thing you are trying to check is v$session
SQL> select sid,serial# ,username from v$session where username like ‘%PRD%’;
SID SERIAL# USERNAME
———- ———- ——————————
745 821 PRD_MDS
SQL> alter system kill session ‘745,821’ immediate ;
System altered.
After this i should be able to drop this user without any problem BUT !!!!
SQL> drop user PRD_MDS ;
drop user PRD_MDS
*
ERROR at line 1:
ORA-01940: cannot drop a user that is currently connected
I tried to figure out what is going on , Even i tried alter system kill session 10 times the above error will appear BUT there’s always solutions :
SQL> startup force restrict;
ORACLE instance started.
Total System Global Area 7686086656 bytes
Fixed Size 2228032 bytes
Variable Size 1811939520 bytes
Database Buffers 5729419264 bytes
Redo Buffers 142499840 bytes
Database mounted.
Database opened.
SQL> drop user PRD_MDS cascade ;
User dropped.
Enable Automatic Memory Management (AMM)
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
Create Group using Em12c
Sometimes you need to create Certain group for Enterprise manager to make monitor more easy , sepcially if you have lot of agent and components such as database , Host , application server … so if you want to manage them individually it will consume time and seems to be impossible.
Enterprise manager provide you with Group Features to combine components, and there’s two type :
- Target at the same type
- Target contain different components such as database, Application server , Host.
Check the below screenshot :
From Setup –> Add Target –> Group
you have five tab each one of them contain different parameters, Choose the right option that works with your Work:
After Choose the name for the group you need to add Agents, from search button new popup screen will be open choose which agent type you want.
Another example on Chart tab :
After Create Group :
For More information about Enterprise Manager 12c Group Read Oracle Documentation Here
Thank you
Osama mustafa
MOLAP, ROLAP And HOLAP
I would like to share this article that i found recenly on internet talking about Online Analytic Processing By John Here
Cubes in a data warehouse are stored in three different modes. A relational storage model is called Relational Online Analytical Processing mode or ROLAP, while a Multidimensional Online Analytical processing mode is called MOLAP. When dimensions are stored in a combination of the two modes then it is known as Hybrid Online Analytical Processing mode or HOLAP.
MOLAP
This is the traditional mode in OLAP analysis. In MOLAP data is stored in form of multidimensional cubes and not in relational databases. The advantages of this mode is that it provides excellent query performance and the cubes are built for fast data retrieval. All calculations are pre-generated when the cube is created and can be easily applied while querying data. The disadvantages of this model are that it can handle only a limited amount of data. Since all calculations have been pre-built when the cube was created, the cube cannot be derived from a large volume of data. This deficiency can be bypassed by including only summary level calculations while constructing the cube. This model also requires huge additional investment as cube technology is proprietary and the knowledge base may not exist in the organization.
ROLAP
The underlying data in this model is stored in relational databases. Since the data is stored in relational databases this model gives the appearance of traditional OLAPs slicing and dicing functionality. The advantages of this model is it can handle a large amount of data and can leverage all the functionalities of the relational database. The disadvantages are that the performance is slow and each ROLAP report is an SQL query with all the limitations of the genre. It is also limited by SQL functionalities. ROLAP vendors have tried to mitigate this problem by building into the tool out-of-the-box complex functions as well as providing the users with an ability to define their own functions.
HOLAP
HOLAP technology tries to combine the strengths of the above two models. For summary type information HOLAP leverages cube technology and for drilling down into details it uses the ROLAP model.
Comparing the use of MOLAP, HOLAP and ROLAP
The type of storage medium impacts on cube processing time, cube storage and cube browsing speed. Some of the factors that affect MOLAP storage are:
Cube browsing is the fastest when using MOLAP. This is so even in cases where no aggregations have been done. The data is stored in a compressed multidimensional format and can be accessed quickly than in the relational database. Browsing is very slow in ROLAP about the same in HOLAP. Processing time is slower in ROLAP, especially at higher levels of aggregation.
MOLAP storage takes up more space than HOLAP as data is copied and at very low levels of aggregation it takes up more room than ROLAP. ROLAP takes almost no storage space as data is not duplicated. However ROALP aggregations take up more space than MOLAP or HOLAP aggregations.
All data is stored in the cube in MOLAP and data can be viewed even when the original data source is not available. In ROLAP data cannot be viewed unless connected to the data source.
MOLAP can handle very limited data only as all data is stored in the cube.
Thank you
Osama Mustafa
unpack.sh Error -name=Value
The pack command creates a template archive (.jar) file that contains a snapshot of either an entire domain or a subset of a domain. You can use a template that contains a subset of a domain to create a Managed Server domain directory hierarchy on a remote machine.
The unpack command Creates a full domain or a subset of a domain used for a Managed Server domain directory on a remote machine. You may use unpack only with a template compatible with your current installation. The template can be any of the following:
- A domain template provided by BEA and packaged with your current installation
- A domain template created using the Domain Template Builder or WLST Offline
- A domain template created using the pack command
- A Managed Server template created using the pack command. A Managed Server template, by default, contains only the files necessary for creating a Managed Server domain directory.
You Can Check Oracle Documentation here for more information about the above commands.
When Trying to use unpack command with the below command:
./unpack.sh -domain=/u01/app/oracle/domains/IDMDomains -template=/u01/shared/IDMdomains.jar
The below error appear :
ERROR !!! ./unpack.sh -name=Value Missing
The Solution is simple :
-template attribute should come first.
./unpack.sh -template=/u01/shared/IDMdomains.jar -domain=/u01/app/oracle/domains/IDMDomains
Thank you
Osama Mustafa
Start Managed Server Failed With "Access not allowed for subject: principals=[]"
When Trying to Start Managed Server From Admin Console it’s Failed with
“weblogic.management.NoAccessRuntimeException: Access not allowed for subject: principals=[], on ResourceType: Application Action: write, Target: Deployed”
After Check Everything and Configuration i found the following :
- My Admin Server Already have More than one managed Server : SOA, ODI , BAM.
- SOA and ODI Using the Same Port which is 8001 Which caused Conflict.
I Changed SOA Port to Work On 8003 From Admin Server Console. Like the Below
Technology Geek 