Showing posts from October, 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 …

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

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> ALTER SYSTEM SET SGA_TARGET = 0 scope=spfile ; System altered.


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 

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


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

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

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