Wednesday, April 30, 2014

Managed Server ERROR: transport error 202: bind failed: Address already in use

ERROR: transport error 202: bind failed: Address already in use
ERROR: JDWP Transport dt_socket failed to initialize, TRANSPORT_INIT(510)
JDWP exit error AGENT_ERROR_TRANSPORT_INIT(197): No transports initialized [../../../src/share/back/debugInit.c:750]
This Error Appeared when trying to start Managed server the Log Shown the above error, which already clear, in my case i have 2 managed server SOA and OSB in the same AdminServer each of them trying to access on the same PID process using Node Manager to solve this issue please follow the below steps.

Solutions :-

  • Inside Domain Path for example /u01/app/fmw/domains/Base_domain/bin
  • Edit setDomainEnv.sh and search for the below :-
if [ "${DEBUG_PORT}" = "" ] ; then
        DEBUG_PORT="8453"
        export DEBUG_PORT
fi
if [ "${SERVER_NAME}" = "" ] ; then
        SERVER_NAME="AdminServer"
        export SERVER_NAME
fi

  •  Add New Lines under the above to contain server name and available DEBUG_PORT on the server like the below:-


if [ "${SERVER_NAME}" = "soa_server1" ] ; then
   DEBUG_PORT="7453"
   export DEBUG_PORT
fi

if [ "${SERVER_NAME}" = "osb_server1" ] ; then
   DEBUG_PORT="7454"
   export DEBUG_PORT
fi

 Now Restart AdminServer and Try to start Managed Server, Take Backup from setDomainEvn.sh before editing.

Thank you
Osama mustafa



Oracle Solaris 11.2 Launch On 29/04

Today 29/04/2014 Oracle Launched new version of operating system Solaris 11.2, This Version will contain significant Features and it's fully supported for Cloud

Some of the new features :-


  • Reduce management effort via OpenStack integration
  • Further increase the flexibility of Solaris system virtualization
  • Add unique software-defined networking (SDN) capabilities
  • Simplify the creation of private and public clouds

The Link for the Event Here.


Thank you 
Osama mustafa

Tuesday, April 29, 2014

Oracle Linux 7 First Look Installation

Since My Last Post about Oracle Linux 7 Beta, Today i am posing about Oracle Linux 7 First Look
( Installation Part ) , You can Download and Check the Document Here.


Thank you
Osama mustafa

Oracle Linux 7 Beta Released

Oracle has announced that the initial beta build of Oracle Linux 7.0,a distribution built from source for
Red Hat and enhanced with an "unbreakable" Linux kernel and now it's Ready for your Testing.


  • RHEL 7 Will now format drives with the XFS filesystem by default.
  • enabling volumes of up to 500TB in size.
  •  if you prefer the older ext4 filesystem it's now supports 50TB volumes. 
  • improves support for large-scale enterprise storage arrays.
  • provides new tools for managing heterogeneous storage.
  • New Version of SAMBA 4.1.
You Can Download it From Here.

Thank you
Osama mustafa

Friday, April 25, 2014

NQSError 46036 Oracle BI Administration Tools Client



when trying to open oracle bi administration tool client, You can download oracle bi administration tool client from here.

Cause :-

Most probably this error related to version mismatch between OBIEE Server and Administration Tool Client in my case OBIEE Version 11.1.1.7.1 and Administration Tool client 11.1.1.7.0

Solution :-

1- Download Upgrade Patch 17530796 From http://support.oracle.com depend on operating system
2- Patch contain multiple file search for this one :- p17463403_111170_Generic.zip
3- inside this zip file browse
17463403\files\clients\biserver\
4- you will find two files biee_client_install_x64.exe Or biee_client_install.exe depend on version.
5- Install One of this file to upgrade Administration tools, Use Repair Option.

Thank you
Osama Mustafa



Monday, April 21, 2014

No Backup !!! Think Again

While I was drinking my coffee yesterday in the office, A Customer Called me complaining that Non Production Database Is not working and Database Administrator quit his job without any Handover the situation was so creepy, This database hold Fusion middleware Repository and configuration, The development team use it before deploy anything on Production Database ( No Backup configured !!!! ),  

Trying to Recover Database and Open it with Resetlogs will lead to this error :-

ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: '/u01/app/oracle/oradata/NPDB/system01.dbf'

This Error is only apart of the problem, To solve it :-

Recover database using file name (Redolog) to get the current filename :-

SQL > Startup mount ;
 SQL > select member from v$logfile lf , v$log l where l.status='CURRENT' and lf.group#=l.group#;

 MEMBER
-------------------------------------------
/u01/app/oracle/oradata/NPDB/redo03.log
SQL > Recover database using backup controlfile until cancel ; 
 Specify log: {=suggested | filename | AUTO | CANCEL}
 /u01/app/oracle/oradata/NPDB/redo03.log ( From the Above Query ).
Log applied.
Media recovery complete.
 Trying to open database :-
SQL > Alter database open Resetlogs ;

Failed !!!! with Another Datafile which is UNDO.

 ORA-01110: data file 4:'/u01/app/oracle/oradata/NPDB/UNDOTBS01.DBF'

SQL  > Create Pfile from Spfile ;

Modify the pfile and add the hidden parameter :-

_allow_resetlogs_corruption=True  
But this Not Solved the problem either.

Again Edit Pfile But this Time :-

undo_management=manual
undo_tablespace=UNDOTBS1 
SQL> select name from v$datafile; 
NAME
--------------------------------------------
/u01/app/oracle/oradata/NPDB/SYSTEM01.DBF
/u01/app/oracle/oradata/NPDB/UNDOTBS01.DBF
/u01/app/oracle/oradata/NPDB/SYSAUX01.DBF
/u01/app/oracle/oradata/NPDB/USERS01.DBF
........................

SQL > alter database datafile '/u01/app/oracle/oradata/NPDB/UNDOTBS01.DBF' offline drop;
ERROR at line 1:
ORA-01548: active rollback segment ‘_SYSSMU11$’ found, terminate dropping tablespace
Check Segment that Needs Recovery :-
SQL>select segment_name,status,tablespace_name from dba_rollback_segs where status='NEEDS RECOVERY'; 

SEGMENT_NAME STATUS TABLESPACE_NAME
—————————— —————- —————–
_SYSSMU11$ NEEDS RECOVERY UNDOTBS1
_SYSSMU12$ NEEDS RECOVERY UNDOTBS1
_SYSSMU13$ NEEDS RECOVERY UNDOTBS1 
Add the following line to pfile:

_corrupted_rollback_segments = ('_SYSSMU11$','_SYSSMU12$','_SYSSMU13$');

SQL > Startup mount pfile='/u01/osama.ini';
SQL > drop rollback segment "_SYSSMU11$" --> Drop all the above Segments ;

Drop the Undo And Recreate it again.

SQL > Startup ;
SQL> create undo tablespace UNDOTBS2 
datafile '/u01/app/oracle/oradata/NPDB/UNDOTBS02.DBF' size 1G;

Remove All Hidden Parameter and restore UNDO_Managment Parameter to AUTO and UNDO_TABLESPACE=UNDOTBS2 then :-

SQL> create spfile from pfile; 

first Advice  Enable RMAN Please

 Thank you
Osama Mustafa

Reference :-
1- Doc ID 94114.1
2- Doc ID 1295294.1
3- Doc ID 28226.1


Wednesday, April 9, 2014

Configure PHP With Oracle HTTP Server (OHS)

Regarding to Oracle Documentation :-

Oracle HTTP Server is the web server component in Oracle Fusion Middleware. Based on the Apache infrastructure, Oracle HTTP Server allows developers to program their site in a variety of languages and technologies.

PHP (recursive acronym for "PHP: Hypertext Preprocessor") is a general-purpose scripting language often used for generating web sites. The object model of PHP 5 facilitates project development using standard object-oriented methodologies.

To Configure PHP with Oracle OHS Follow the below steps :-

Step #1:-

export ORACLE_HOME=/Siebel/ohs/Middleware/Oracle_WT1/
export ORACLE_INSTANCE=/Siebel/ohs/Middleware/Oracle_WT1/instances/instance1/
export CONFIG_FILE_PATH=/Siebel/ohs/Middleware/Oracle_WT1/instances/instance1/config/OHS/ohs1/

Step #2:

Download PHP From here.
Upload the file to the server ( should be on the same OHS Server).

gunzip php-5.4.27.tar.gz
tar -xvf php-5.4.27.tar
cd /Siebel/php-5.4.27
Note :-
I Used this version because older version contains bugs
conflicting types for ‘zendparse’

Step #3:-

$./configure --with-apxs2=$ORACLE_HOME/ohs/bin/apxs --prefix=$ORACLE_HOME --with-config-file-path=$CONFIG_FILE_PATH

make
make install

Don't Run the Above command if nothing not complied successfully.

Once Complied successfully :-

libphp5.so is generated inside php/libs

Step #4:

Inside php folder 
cp php.ini-production $CONFIG_FILE_PATH/php.ini

cd $CONFIG_FILE_PATH
vi httpd.conf

add the below line:-
AddType application/x-httpd-php .php .phtml
Step #5:-

Restart OHS 

./opmnctl stopall
./opmnctl startall
Test PHP :

Install Demo Files HereExtract demo file to $CONFIG_FILE_PATH/htdocs
Using Browser :-

http://:/demo/phpinfo.php

Thank you 
Osama Mustafa

Reference :-
1- Oracle Document Here

Sunday, April 6, 2014

Flush Linux Buffer Cache

Cache is used to keep data to use frequently by operating system,  But sometimes memory is getting low linux provide some memory Command line to monitor Memory status Check the below link :-

1- Linux Check Memory Usage Here.
2- 18 Command Line Tools to Monitor Linux Performance here.

There are options available to flush cache of linux memeory :-


Flush everything ( Pagecache, dentries and inodes )  :-
 sync; echo 3 > /proc/sys/vm/drop_caches.
Flash dentries and inodes :-

 sync; echo 2 > /proc/sys/vm/drop_caches
Flash PageCache only

sync; echo 1 > /proc/sys/vm/drop_caches

All the command should be Run As root.

Schudle the above command as job using crontab , choose from the above command what you need :-

0  *  *  *  *  /root/memory.sh

Memorysh --> should be contain one the above script run as root.

Thank you
Osama mustafa
 

Unable to Determine Console Port when Trying to Run emctl start iasconsole

The Situation for me like this, Database version 11.2.0.3, Real Application Cluster two nodes, Enterprise manager working and configured without any problem,
emctl start dbcsonole 
Working without any errors, metrics collected, but when trying to run
emctl start iasconsole
Or
emctl istart iasconsole  
The Error " Unable to determine console port, default-web-site.xml : no such file or directory"

The File is exists, and configured to run oc4j on port 8888, http://hostname:888/em not working with error "iasconsole service should be stopped". Weird !!!!!


 Operating system Oracle Linux 64bit, After investigation i discovered that binary/files for oc4j in ORACLE_HOME was corrupted and not working correctly however this is what i did to fix this error :-

First Download OC4J_extend.zip from here, this zip file contain same directory files ( xml,config ) in oc4j ($ORACLE_HOME/oc4j) so extract this file inside this path, if oc4j not exist create one and extract the zip file into this directory.

But this is will not make oc4j works, complete the below steps to make sure everything is working fine.

[oracle@PROD bin]$ ./java -jar /u01/app/oraclenew/product/11.2.0/dbhome_1/oc4j/j2ee/home/oc4j.jar

Apr 3, 2014 2:51:51 PM com.evermind.server.XMLApplicationServerConfig randomizeJtaAdminPassword
INFO: Updating JtaAdmin account

14/04/03 14:52:30 Set OC4J administrator's password (password text will not be displayed as it is entered)
Enter password:            
Confirm password:          
The password for OC4J administrator "oc4jadmin" has been set.
14/04/03 14:52:35 The OC4J administrator "oc4jadmin" account is activated.
14/04/03 14:52:39 Oracle Containers for J2EE 10g (10.1.3.3.0)  initialized


Now Test the Link --> Http://localhost:8888/em and it's working

Thank you 
Osama Mustafa