Thursday, October 31, 2013

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 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 

Wednesday, October 30, 2013

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%';
---------- ---------- ------------------------------
       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


System altered.

System altered.

System altered.

Thank you 
Osama Mustafa

Monday, October 28, 2013


Lately I was little busy with Lot of work, regarding to this i didn't post anything new within two last week, i would like to apology for all people about this.

And I promise to update the blog with new contents and Documents that will be Useful for everyone.

Thank you 
Osama mustafa 

Monday, October 14, 2013

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

Tuesday, October 8, 2013


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.


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.


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 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

Sunday, October 6, 2013 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:

./ -domain=/u01/app/oracle/domains/IDMDomains -template=/u01/shared/IDMdomains.jar

The below error appear :

ERROR !!! ./ -name=Value Missing
The Solution is simple :

-template attribute should come first. 

./  -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

" 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

Managed Server BI_Server Unable To Start After Create Node manager Service

Problem Description :

After Install Weblogic and BI On Windows, And Create Admin Server as Services BI_server unable to start, Node manager Created Service Created Without Any Error.

Cause & Solution : 

After Investigation I found Class Path is too Long So what i did like the following, Edit installSVC.cmd To set Classpath  to be Short

you will find the below line in the InstallSvc.cmd all you have to do is change it to be like Line in Red Color :

@echo off


if "%ADMIN_URL%" == "" goto runAdmin
@echo on
-classpath @%USERDOMAIN_HOME%\ 
-Dweblogic.ProductionModeEnabled=%PRODUCTION_MODE%\"%WL_HOME%\server\lib\weblogic.policy\" weblogic.Server"

goto finish

Thank you
Osama Mustafa

Saturday, October 5, 2013

Social media Information

This is Post will be Short and Simple , I Only Wants To Share My Social Media Information

Twitter Here
Linkedin Here

If you need Any Help you find me in the above Social Media

Thank you
Osama Mustafa