Tag: Oracle 11g

Failed to create secure socket for OPMN at LocalHost:9501

Posted on by Osama Mustafa in Fusion Middleware
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 

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

Instance Caging

Posted on by Osama Mustafa in Database
Instance Caging

Sometimes When you are doing some testing on one machine and have more than one instance with limited hardware resource , Oracle let control that resource by caging its new feature in 11g its method to cage or bound the instance to use a certain number of cpu instead to take all available CPU simple way :

Alter system set CPU_Count = 2 

Just as note this method work with Resource Manager so you need to enable it , and create resource manager plan first before doing Instance Caging .

Instance Caging Benefits :

  1. Useful when you are using multiple instance .
  2. Allowing CPU , Resource allocation be done effectively .
  3. Control CPU Consumption of each Instance .

Thank you
Osama Mustafa