Tag: Osama ACE

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 

Steps To Create ODBC Connection in Linux

Posted on by Osama Mustafa in Articles, Operating system


In this Document i will describe how to create ODBC Connection in Linux Step by Step. I uploaded my document to slideshare as usual you can download it from here.

Thanks for my friend Ilmar Kerm . 

Thank you 
Osama mustafa 

Oracle Linux 6.5 released

Posted on by Osama Mustafa in Operating system
Oracle Announced the release of Oracle Linux 6.5, The Latest Version Of Oracle Linux, It’s only Other Operating System Because this version Contain Some New Features :

  • Unbreakable Enterprise Kernel Release 3
  • Support DTrace.
  • Delivering Better Performance, scalability   and reliability For Companies.
  • New File System : btrfs enable administrators to implement an efficient incremental backup mechanism using file system snapshots.
And More Features.
You Can download Oracle Linux 6.5 Here
It will be Available soon On Oracle Software Delivery Here

User Not Able To Drop Even When I killed the session.

Posted on by Osama Mustafa in Database
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)

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

Create Group using Em12c

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

unpack.sh Error -name=Value

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

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

Managed Server BI_Server Unable To Start After Create Node manager Service

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

echo %CLASSPATH% > %USERDOMAIN_HOME%\cp.properties

if “%ADMIN_URL%” == “” goto runAdmin
@echo on
set CMDLINE=”%JAVA_VM% %MEM_ARGS% %JAVA_OPTIONS%
-classpath @%USERDOMAIN_HOME%\cp.properties 
-Dweblogic.Name=%SERVER_NAME% -Dweblogic.management.username=%WLS_USER%
-Dweblogic.management.server=\”%ADMIN_URL%\”
-Dweblogic.ProductionModeEnabled=%PRODUCTION_MODE%
-Djava.security.policy=\”%WL_HOME%\server\lib\weblogic.policy\” weblogic.Server”

goto finish

Thank you
Osama Mustafa