Monday, December 22, 2014

2014 Achievement as an Oracle ACE

2014 is almost finished , new year will starting soon usually i don't list what i have done, but there is always start point for everything. it was very busy year on all level : Personal, Work and as oracle ACE.

One of the major achievement for me this year is created and lead Jordan Amman Oracle User group which is the first Oracle Group in Jordan and I am working now to organize next event for this group and this is taking most of time now.

The 2014 Summary :-

Let's Start with Conference :-


  • Dublin Conference.
  • Dubai Conference.
  • OTN Mena Tour.
  • Dublin Again :) 
  • Oracle open World.
  • New Zealand.
Sure during most of these conferences i was organizing RAC ATTACK Event around the world and simply it successful year for this amazing event.

Don't forget the webinar as well. 

I have to mention One of the most amazing event all the time which is oracle open world, This is was my first time in SF OOW I met most of the people in oracle community i will try to mention all of them but i am sorry if i forgot someone :-
  • Gurcan Orhan
  • Yury Velikanov
  • Kai Yu
  • Jeff Smith 
  • Kellyn PotVin-Gorman.
  • Danny Bryant
  • Don Seiler.
  • Steve karam
  • Sarah Craynon Zumbrum
  • Leighton Nelson
  • RenĂ© AntĂșnez Berdejo ( i met twice this year ) .
  • Francisco Munoz ( i met him in NZ ).
And Sure other People , my first time in OOW was my first time to present in this Big Event I would like to thank Debra Lilley to give me this chance :)

I also enjoyed my time with best company Gurcan Orhan He is amazing person and would like to meet him again who knows next conference or maybe in Turkey.

i enjoyed my time hanging out with ACE and ACED, a lot of activity to do in OOW such as presentation, Concert .. etc.

don't forgot this year i wrote three articles to different magazine and i still have a lot of different topics to share, My Blog  i wrote blog post related to fusion middleware and Timesten in memory database most of these article what i faced in my real life challenging but amazing at the same time.

i was the first one in the middle east ( Jordan ) who appeared in Oracle Magazine Peer to Peer Thanks for Oracle ACE program i am really proud to be member of this amazing community.

I created magazine on flip-board that collect all the good articles posted by oracle community and share under one place and i am contribute in another one  Thanks for my friend Leighton Nelson.
the both magazine are simply amazing both sharing different idea.

I also passed Fusion middleware exam and upgrade my OCP certification. 

Finally I am really proud of one of the most achievement for this year which is created JAOUG ( Jordan Amman Oracle user group) i am working too hard to make this group success, i would like to give special thanks to Heli Helskyaho who supported me and gave me an idea to launch the group when i was in OOW.

i am sure 2015 will bring new things to me, 2014 was amazing year and fun at the same time. "Enshalla" 2015 will be more interesting i welcome any new challenge.

Cheers

Osama Mustafa


Thursday, December 18, 2014

Fusion Middleware Attack

New Idea, New Concept It's always nice to learn something new in next event, this time i create new attack called Oracle Fusion middleware attack or Short name "OFM ATTACK" that allow people to interact and learn more about oracle fusion middleware.

if you are interseted in this attack please contact me by leaving comment " Your name and Email Address" and i will contact you back to volunteer in this attack,


Thank You

osama mustafa

Wednesday, December 10, 2014

Oracle DBA Scripts

I Published Some Scripts that every DBA Needs, these Scripts available for everyone, I used GitHub to Upload the scripts, this Blog post will be updated and will contains new scripts.

The Scripts Here.

Cheers
Osama ....

Tuesday, December 9, 2014

Jordan Amman Oracle User Group


Jordan "officially the Hashemite Kingdom of Jordan" Capital Is Amman, More Here.

I have been working to create group for something i love ORACLE, and now it's officially created, the idea behind the group is so simple will let the member sharing their knowledge and ideas about oracle, answering their question and let them know more about oracle technology.

There is no condition to join this group Anyone is welcome to Join us.

The Website will be officially published Soon.
you can Like Us On Facebook Page here


Cheers
Osama 

Monday, December 1, 2014

Linux : Cannot Access .... Input/output error

/bin/ls: reading directory .: Input/output error
total 0

The above error indicate that i cannot access to the specific file on Linux, Delete not working. with root user as well.
so the error is not a problem to delete files, it's a problem about the file system itself and/or an hardware problem, but before announce that it's hardware issue :) try the below solution :-

 Option #1:-

use command dmesg.

(display message or driver message) is a command on most Linux- and Unix-based operating systems that prints the message buffer of the kernel. Read about that command here

Option #2 ( worked for me)

Use Fsck command to detect filesystem error and fix it.

How !!!

  1.  First Umount File system ( that file located ). Using Umount command if it's not able to un mount the file system use lsof command or fuser to check which user using this filesystem.
  2. run the fsck -y /dev/................. 
  3. mount file system again.
Fsck Command here

Cheers

Osama ...


Thursday, November 27, 2014

TT6003: Lock request denied because of time-out

Trying to create cache group lead to the below error :-

java.sql.SQLException: [TimesTen][TimesTen 11.2.1.4.0 ODBC Driver][TimesTen]TT6003: Lock request denied because of time-out
Details: Tran 143.23106 (pid 19946) wants Sn lock on rowid BMUFVUAAAAxogAALDp, table SUBSCRIBER. But tran 144.67398 (pid 19946) has it in Xn (request was Xn). Holder SQL (select ID,identifierType,identifiervalue,subscriberId,groupName,siid from subscriptionidentifie...) -- file "tindex.c", lineno 4277, procedure "sbTixNext()"

After check the Timesten parameter found the issue was with LockWait


Lockwait :- Allows an application to configure the lock wait interval for the connection.

LockWait may be set to any value between 0 and 1,000,000 inclusive to a precision of
tenths of a second. The default is 10 seconds.

Actual lock wait response time is imprecise and may be exceeded by up to one tenth of
a second, due to the scheduling of the agent that detects timeouts. This imprecision
does not apply to zero second timeouts, which are always reported immediately.

Cheers

Osama ...


Wednesday, November 26, 2014

Attempt to connect to a data store that has been manually unloaded from R AM

Timesten in-memory Database :-

ttisql DSN_NAME

ttIsql (c) 1996-2005, TimesTen, Inc. All rights reserved.
Type ? or "help" for help, type "exit" to quit ttIsql.
All commands must end with a semicolon character.
connect "DSN=DSN_NAME";
707: Attempt to connect to a data store that has been manually unloaded from R
AM

The command failed.

This should be easy to resolve. A TimesTen datastore (physical database), which is what a DSN points at, has a property called its 'ramPolicy' The default value for this is inUse which means that TimesTen will load the datastore into memory whenever it is being used.

Solution :

ttAdmin -ramload DSN_NAME


Reference :-
1- Oracle OTN Forum here

Cheers

Osama ....

Sunday, November 9, 2014

Cannot Integrated JDeveloper with SOA Server

When trying to integrated JDeveloper with SOA server the below error Appeared :-

Testing JSR-160 Runtime ... failed.
Cannot establish connection.
Testing JSR-160 DomainRuntime ... skipped.
Testing JSR-88 ... skipped.
Testing JSR-88-LOCAL ... skipped.
Testing JNDI ... skipped.
Testing JSR-160 Edit ... skipped.
Testing HTTP ... success.
Testing Server MBeans Model ... skipped.

all my searching on internet not working most of the blogs indicate it's proxy setting which is already disables in my case.

After invesgtation and check logs on the both side adminserver and Jdeveloper i found it's DNS server issue therefore i edited hosts in windows like the below

Adminserver-IP   Hostname

After do this and put hostname instead of IP it's worked Successfully.


Cheers
Osama Mustafa


Monday, November 3, 2014

OWB GUI Is Slow

Sometimes the default setting is not enough , therefore you need to apply some changes depend on your requirement and the work load. Today while working on OWB I faced huge slowness while open , mapping or even press any button.

to solve this issue all you have to do increasing JVM, to do this follow the below steps :-


  • Depend on OS, Open the following File :- 
    • Windows :- C:\oracle\product\owb11_1\owb\bin\win32\owbclient.bat
Or


    • Linux : $ORACLE_HOME/owb11_1\owb\bin\win32\owbclient.bat.
This file will indicate to setownenv.sh or setowbenv.bat usually in the same path. Open it with any editor.

be careful while adding this file  If you notice or read this file there is more than one line looking the same, these lines only depend on OS for example in my case i am working on LINUX then i have to add Line that indicate for Linux only.

Next to the line -d64 add new parameter -Xmx=1024M or depend on your work.

Restart OWB now.

Cheers.

Osama Mustafa


Sunday, October 26, 2014

Pool EDNLocalTxDataSource is Suspended, cannot allocate resources to applications..

Connection test failed with the following exception: weblogic.common.resourcepool.ResourceDisabledException: Pool EDNLocalTxDataSource is Suspended, cannot allocate resources to applications..


This Error Appeared on Weblogic Depend on Managed Server, Tuning Connection Pool By Increasing Maximum Capacity parameter in Datasource.

My Case Datasource EDNLOCALTXDatasource as the above error.

Solution :-




Increase depend on your application.


Thank you 
Osama Mustafa



Oracle SOA Tablespace Is full

When Creating Domain for Oracle SOA it's Mandatory to Run Oracle RCU before to create SOA Repository, This will create tables configuration and information about Oracle SOA.

But What happened the this tablespace was getting full, increase it 20GB is not enough which mean it's strange case and not acceptable.

after investigation Table Called "REFERENCE_INSTANCE" include information about Running Composite in SOA ans instances. the size for this table 18GB.

Select * from Reference_instance; 

Check the data in the above query, just in case you can use export data-bump utility for this table, however after this Truncate the table and from full tablespace toonly 2% usage.


Thank you
Osama Mustafa


Thursday, October 23, 2014

NP_SOAINFRA.WL_LLR_ADMINSERVER Access Failed

 java.sql.SQLException: JDBC LLR, table verify failed for table 'NP_SOAINFRA.WL_LLR_ADMINSERVER', row 'JDBC LLR Domain//Server' record had unexpected value

The above error appeared when trying to start Adminserver nothing changed on the Domain

Solution :-


  • Goto  domain location --> config folder.
  •  remove this line from the config.xml file, Take backup before you do this.



    wlsbjmsrpDataSource
    AdminServer,osb_server1
    jdbc/wlsbjmsrpDataSource-jdbc.xml
 


Thank you
Osama Mustafa 

Wednesday, October 22, 2014

Resource temporarily unavailable in tsStartJavaThread

Resource temporarily unavailable in tsStartJavaThread (lifecycle.c:1096).
Java heap 3G reserved, 3G committed
Paged memory=3145728/36425712K.
Your Java heap size might be set too high.
Try to reduce the Java heap size using -Xmx: (e.g. "-
java.lang.OutOfMemoryError: Resource temporarily unavailable in tsStartJavaThread (lifecycle.c:1096).
Java heap 6G reserved, 6G committed
Paged memory=3145728/36425712K.
Your Java heap size might be set too high.
Try to reduce the Java heap size using -Xmx: 


The Above error appeared on OEDQ when trying to run the process this error related to Java Heap Size the OS control the Heap Size to solve this issue add the below parameters depend on your enviroment  :-


  • Add the following to /etc/sysctl.conf:

kernel.shmmni = 4096
kernel.sem = 256 32000 100 142
net.ipv4.ip_local_port_range = 9000 65500
net.core.rmem_default = 4194304
net.core.rmem_max = 4194304
net.core.wmem_default = 4194304
net.core.wmem_max = 4194304
fs.file-max = 134283264
fs.aio-max-nr = 1048576
vm.min_free_kbytes = 512000 
  • Add the following to /etc/security/limits.conf:

oracle soft nproc 16384
oracle hard nproc 63536
oracle soft nofile 16384
oracle hard nofile 63536

  •  Add the following to /etc/pam.d/login:
session required /lib/security/pam_limits.so


Thank you
Osama Mustafa

Monday, October 13, 2014

SF 34004 Serivce initialization failed error

This error appeared on informtica when you are trying to create informtica services to solve this error all you have to do :-

Change the following Exclusive to Normal.



Thank you 
Osama Mustafa

Sunday, October 12, 2014

ORA-01465: Invalid Hex Number



Solution :-

With your Query Use the below function :- RAWTOHEX( raw )

For More information how to use this function read here:-



Thank you 
Osama Mustafa

Saturday, September 27, 2014

Dublin TECH SIG Day Impression

Third time in Dublin, and i still love this country i arrived to Dublin on 23-Sept to present about Oracle Security Features and how to protect Oracle Database it was exciting trip regarding to my reservation i supposed to be in Dublin at 2:00 PM But What i didn't notice that my flight delayed Therefore i missed my flight and arrived to Dublin at 8:00 PM.

However TECH SIG was really amazing day meeting the people chatting with them, and presenting about Oracle Security with Full Room of people.


After the event me and Pete start chatting about Oracle Security and Talking about other stuff, my next Stop to SF Oracle Open World 2014.

Looking forward to meet everyone there.

Good time with Good People.

Thank you
Osama Mustafa

Monday, September 22, 2014

the version of the data that you are trying to import is not compatible with current dac version

This Error Appear On DAC Server when trying to Import Data  from the following :

Tools --> DAC Repository Management --> import

This error appears :-

the version of the data that you are trying to import is not compatible with current dac version

After trying to many Solution with no luck , i discover new Solution for this error and it's simple :-

export from tools ( Empty files ) will generate 3 folder in DAC Folder Leave this folder without any copy or replace.



Now in my case i installed BIAPPS Copy the folder without Replace the old one.



after start copying the windows will ask dont replace these three folders DON'T REPLACE IT.


Start Import successfully.





Now The Import is done,


Thank you 
Osama Mustafa


Monday, September 8, 2014

My Presentation in OOW14



If you are joining oracle open world 2014 this year , Join me at EOUC short talk and let's chat :)

Session Number :- 
12 Looks at Oracle Database 12c: EOUC Short Talks [UGF8949]

Welcome anytime


More Information Press Here

Thank you for Debra, Jonthan and Kashif for this opportunity

Thank you
Osama Mustafa

Thursday, August 28, 2014

java.lang.securityexception access denied. required roles admin

Weblogic Adminserver logs indicated to the below error :-

java.lang.securityexception access denied. required roles admin


To solve the above error, Follow the below steps :-

From the Navigation Tree --> Security Realms :-



New Page Will be Opened click on my Realms :-


From the configuration --> General 



Thank you 
Osama Mustafa

weblogic.socket.MaxMessageSizeExceededException


I recently encountered below error,Adminserver.log Indicate to :-
weblogic.socket.MaxMessageSizeExceededException: Incoming message of size: '10000080' bytes exceeds the configured maximum of: '10000000' bytes for protocol: 't3'.
weblogic.socket.MaxMessageSizeExceededException: Incoming message of size: '10000080' bytes exceeds the configured maximum of: '10000000' bytes for protocol: 't3'
        at weblogic.socket.BaseAbstractMuxableSocket.incrementBufferOffset(BaseAbstractMuxableSocket.java:230)
        at weblogic.rjvm.t3.MuxableSocketT3.incrementBufferOffset(MuxableSocketT3.java:351)
        at weblogic.socket.SocketMuxer.readFromSocket(SocketMuxer.java:989)
        at weblogic.socket.SocketMuxer.readReadySocketOnce(SocketMuxer.java:920)
        at weblogic.socket.SocketMuxer.readReadySocket(SocketMuxer.java:897)
        at weblogic.socket.EPollSocketMuxer.dataReceived(EPollSocketMuxer.java:215)
        at weblogic.socket.EPollSocketMuxer.processSockets(EPollSocketMuxer.java:177)
        at weblogic.socket.SocketReaderRequest.run(SocketReaderRequest.java:29)
        at weblogic.socket.SocketReaderRequest.execute(SocketReaderRequest.java:43)
        at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:145)
        at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:117)

to fix this error follow the following steps :-

From Environment, Press on Adminserver  :-


Chose the tab like the below picture :-


Add the following parameter in arguments box, Save usually there is no need to restart :- 

Or if you would like change MaxMessageSize Directly from the console follow the below screen :-





Option #2 :- 
From the navigation tree :- 



Click on Module-FMWDFW



After choose the above tab, 3 options will be appear, press on each of them and Uncheck on Enable Watch  :-


Tuesday, August 26, 2014

Increase Transaction timeout in SOA Server

I received the below error in soa_server1 :-

Transaction Rolledback.: weblogic.transaction.internal.TimedOutException: Transaction timed out after 603 seconds BEA1-3FB6FB464035C13E3227 at 

From the above error, transaction timeout should be increased regarding to heavy transaction on soa server.

to do this follow the following steps :-

access weblogic console --> Deployment --> and search for Soa_infra. ( expand it)


Check the below EJBS services and click on it configuration tab :-

BPELActivityManagerBean
BPELEngineBean
BPELInstanceManagerBean
BPELProcessManagerBean
BPELServerManagerBean





If this not working on you have to increase transaction timeout for JTA, Access Weblogic Console select Services > JTA


Thank you 
Osama Mustafa

Thursday, August 21, 2014

WSM-02557 When Trying to Deploy On SOA Server.


AdminServer indicates to the following error:-

AdminServer-diagnostic.log:[2014-07-16T10:40:43.681+02:00] [AdminServer] [ERROR] [WSM-02353] [oracle.wsm.resources.policymanager] [tid: [ACTIVE].ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: admin] [ecid: bf57ca3361a7ecd1:-39746f30:1473e26749c:-8000-000000000000026a,0] [APP: em] Unable to get the Action Executor.
to solve this issue make sure the following Users were created in Weblogic console :-

From AdminConsole --> Security ---> myrealms --> Choose Users and Group Tab.

Create the below user :-

OracleSystemUser

Create the below Group

OracleSystemGroup


The following Pictures describes users and Group ( how supposed to be ) :-




and assign this group to OracleSystemUser , Restart Console and managed Server Try again.


Thank you
Osama Mustafa

Wednesday, August 20, 2014

Unable to Login to OBIEE ( Bi Publisher ) With Any User Except Weblogic User

When Trying to Login With Any Bi Publisher User Expect Weblogic User the BIP Unable to connect and raise the below error :-

Error 500 -- Internal Server Error
Form RFC 2068 HyperText Transfer Protocol -- HTTP/1.1

In the Log :-

<[ACTIVE] ExecuteThread: '3' for queue: 'weblogic.kernel.Default (self-tuning)'> <> <> <2acf00f7cbd603fb:-5c1355d7:145fa9793d9:-8000-0000000000001235> <1400071598517> <[ServletContext@63404769[app:bipublisher module:xmlpserver path:/xmlpserver spec-version:2.5 version:11.1.1]] Servlet failed with Exception
java.lang.RuntimeException: User: weblogic, absPath: /~weblogic/user~.profile, locale: null, message: null

at oracle.xdo.servlet.resources.StructuredSawMtomResourceProvider.writeResource(StructuredSawMtomResourceProvider.java:2375)
at oracle.xdo.servlet.resources.StructuredSawMtomResourceProvider.writeResource(StructuredSawMtomResourceProvider.java:2283)
...
Caused By: java.lang.NullPointerException
at java.lang.StringBuilder.(StringBuilder.java:92)
at oracle.xdo.servlet.resources.CatalogSawMtomResourceProvider.getRealPath(CatalogSawMtomResourceProvider.java:2670)
at oracle.xdo.servlet.resources.CatalogSawMtomResourceProvider._writeResource(CatalogSawMtomResourceProvider.java:1794)
##########
Check the bipublisher.log file and messages like this appear.
java.rmi.RemoteException: access denied for user to path /users/weblogic.; nested exception is: [[
javax.xml.ws.soap.SOAPFaultException: access denied for user to path /users/weblogic. 


Regarding to above Error the user Enable to login regarding to User Atr. In Catalog m Solving this issue follow the below steps :-

cd $BI_HOME/insance1/bifoundation/OracleBIPresentationServicesComponent/coreapplication_obips1/catalog/shared/root/users. 
and Delete User.atr.
After doing this you will be able to Login.


Thank you
Osama Mustafa

SOA_SERVER ( Managed Server ) Take too Long time to Start/Restart

On the weblogic console when trying to start managed Server it's take too long time to start in my case it's SOA_SERVER, almost 25 min only to start, which is not correct . to avoid this problem you need to follow the below steps simple but effective :-

Under Java Home ( That Used by Weblogic ) :-

cd /u01/app/fmw/jdk/jre/lib/security 

There's file called Java.Security 

Edit this File using any Editor ( vi for example ).

Search for the following line :-

securerandom.source=file:/dev/urandom

And Change it to :-

securerandom.source=file:/dev/./urandom
Or Another way add the below line to startup script in weblogic :-

-Djava.security.egd=file:/dev/./urandom

Hope this will solve your problem.


Thank you
Osama Mustafa

Monday, August 11, 2014

Invalid User name and password OBIEE 11g (Analytics)

When trying to Access to the URL:// hostname:9704/analytics with username weblogic the below error generated in the Adminserver logs :-

<[ACTIVE] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'> <> <500ca139326a7892:3e1b9fff:147c4ada0c4:-8000-000000000000004c> <1407754348812>
java.security.AccessControlException: access denied (oracle.security.jps.service.credstore.CredentialAccessPermission context=SYSTEM,mapName=oracle.bi.system,keyName=system.user read)
at java.security.AccessControlContext.checkPermission(AccessControlContext.java:374)
at java.security.AccessController.checkPermission(AccessController.java:546)
at oracle.security.jps.util.JpsAuth$AuthorizationMechanism$3.checkPermission(JpsAuth.java:463)
at oracle.security.jps.util.JpsAuth.checkPermission(JpsAuth.java:523)
at oracle.security.jps.util.JpsAuth.checkPermission(JpsAuth.java:549)
at oracle.security.jps.internal.credstore.util.CsfUtil.checkPermission(CsfUtil.java:684)
at oracle.security.jps.internal.credstore.ssp.SspCredentialStore.getCredential(SspCredentialStore.java:562)
at oracle.bi.security.opss.CredentialReader.getPasswordCredential(CredentialReader.java:69)
at oracle.bi.security.opss.CredentialReader.getPasswordCredential(CredentialReader.java:57)
at oracle.bi.security.service.SystemUserValidator$ReadSystemUserCredentialsAction.run(SystemUserValidator.java:291)
at oracle.bi.security.service.SystemUserValidator$ReadSystemUserCredentialsAction.run(SystemUserValidator.java:278)
at oracle.bi.security.service.SystemUserValidator.readSystemUserCredential(SystemUserValidator.java:186)
at oracle.bi.security.service.SystemUserValidator.validateSystemUserCredentials(SystemUserValidator.java:146)
at oracle.bi.security.service.SystemUserValidator.access$000(SystemUserValidator.java:26)
at oracle.bi.security.service.SystemUserValidator$1.run(SystemUserValidator.java:107)
at oracle.bi.security.service.SystemUserValidator$1.run(SystemUserValidator.java:101)
at oracle.bi.security.service.SystemUserValidator.validate(SystemUserValidator.java:117)
at oracle.bi.security.service.SecurityServiceBean.initialise(SecurityServiceBean.java:89)
at oracle.bi.security.service.SecurityServiceBean.getAuthenticatedUserWithLanguageAndProperties(SecurityServiceBean.java:129)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)


If you recive the above error, you don't have permission to access to the analytics, permission saved  in Files called

system-jazn-data.xml

Located :-

 $DOMAIN_HOME/config/fmwconfig

Edit the files and add these lines :-

   
Or copy this file from another OBIEE Environment after backup the old one, and restart AdminServer and managed Server


Thank you
Osama Mustafa

Sunday, August 10, 2014

Tuesday, July 22, 2014

Oracle database Version 12.1.0.2

Oracle database Version 12.1.0.2 released today .. available to download.. The important new feature in this release is the Oracle Database In-Memory other new features...
Oracle Database In-Memory
Oracle Big Data SQL
Advanced Index Compression
Zone Maps
Approximate Count Distinct
Attribute Clustering
Full Database Caching
Rapid Home Provisioning


Download Here

Thank you
Osama Mustafa

Friday, July 18, 2014

Install Oracle TimeSten On Linux ( Video )

This Post will include link for Video , How to install oracle Timesten (TT) On Linux, to watch the video press HERE.

Thank you
Osama Mustafa

Install Oracle BI On Linux 64bit (video)

This Post will include link for Video , How to install oracle  Business Intelligence (BI) On Linux, to watch the video press HERE


Thank you 
Osama mustafa

Saturday, July 12, 2014

Install Database On Oracle Linux ( Video)

This Post will include link for Video , How to install oracle Database 11.2.0.4 On Oracle Linux 6 Update 4 Using Vmware.


You Can check the video here


Thank you
Osama Mustafa

Wednesday, July 9, 2014

[Security:090482]BAD_CERTIFICATE alert was received from Hostname

[Security:090482]BAD_CERTIFICATE alert was received from Hostname. Check the peer to determine why it rejected the certificate chain (trusted CA configuration, hostname verification). SSL debug tracing may be required to determine the exact reason the certificate was rejected.>
javax.net.ssl.SSLKeyException: [Security:090482]BAD_CERTIFICATE alert was received from Hostname. Check the peer to determine why it rejected the certificate chain (trusted CA configuration, hostname verification). SSL debug tracing may be required to determine the exact reason the certificate was rejected.
at com.certicom.tls.interfaceimpl.TLSConnectionImpl.fireException(Unknown Source)
at com.certicom.tls.interfaceimpl.TLSConnectionImpl.fireAlertReceived(Unknown Source)
at com.certicom.tls.record.alert.AlertHandler.handle(Unknown Source)
at com.certicom.tls.record.alert.AlertHandler.handleAlertMessages(Unknown Source)
at com.certicom.tls.record.MessageInterpreter.interpretContent(Unknown Source)
at com.certicom.tls.record.MessageInterpreter.decryptMessage(Unknown Source)
at com.certicom.tls.record.ReadHandler.processRecord(Unknown Source)
at com.certicom.tls.record.ReadHandler.readRecord(Unknown Source)
at com.certicom.tls.record.ReadHandler.readUntilHandshakeComplete(Unknown Source)
at com.certicom.tls.interfaceimpl.TLSConnectionImpl.completeHandshake(Unknown Source)
at com.certicom.tls.record.ReadHandler.read(Unknown Source)
at com.certicom.io.InputSSLIOStreamWrapper.read(Unknown Source)
at sun.nio.cs.StreamDecoder.readBytes(StreamDecoder.java:264)
at sun.nio.cs.StreamDecoder.implRead(StreamDecoder.java:306)
at sun.nio.cs.StreamDecoder.read(StreamDecoder.java:158)
at java.io.InputStreamReader.read(InputStreamReader.java:167)
at java.io.BufferedReader.fill(BufferedReader.java:136)
at java.io.BufferedReader.readLine(BufferedReader.java:299)
at java.io.BufferedReader.readLine(BufferedReader.java:362)
at weblogic.nodemanager.server.Handler.run(Handler.java:71)
at java.lang.Thread.run(Thread.java:662)


You need to recreate the certification again :-

Depend on your Operating system :-

$WL_HOME/server/bin/setWLSEnv.sh Or setWLSEnv.cmd
cd $WL_HOME/server/lib
 Copy DemoIdentity.jks to another directory as backup.


then inside the WLS_HOME/server/lib run:-

Generate the private key.
java utils.CertGen -keyfilepass DemoIdentityPassPhrase -certfile newcert -keyfile newkey 
Import the key generated


java utils.ImportPrivateKey -keystore DemoIdentity.jks -storepass DemoIdentityKeyStorePassPhrase -keyfile newkey.pem -keyfilepass DemoIdentityPassPhrase -certfile newcert.pem -alias demoidentity 

 Restart AdminConsole and Nodemanager and try to start managed server.

Thank you
Osama mustafa

Sunday, July 6, 2014

Timesten 15022: OraclePwd connection attribute


con1: Command> call ttgridcreate ('samplegrid');
15022: OraclePwd connection attribute needs to be specified and has to be non-empty for using IMDB Cache features
 5109: Cache Connect general error: BDB connections not open.

As you see from the error,The OraclePWD connection attribute is not specified. which mean caching will not be enabled till you are set OraclePWD parameter , to do this reconnect with the following connection :-

connect "dsn=tt_orcldwh;uid=cacheadm;OraclePWD=cacheadm";

Run your command again

Thank you
Osama Mustafa 

Thursday, July 3, 2014

Oracle Application Adapter installation.

Regarding to Oracle Documentation :-

The Application Adapter installer for 11g Release 1 (11.1.1.3.0) is applicable for the Oracle Service-Oriented Architecture (SOA) Suite and Oracle Service Bus (OSB). The Application Adapters that are installed can be used with Business Process Execution Language (BPEL), Mediator, Business Process Management (BPM), and OSB components. Using this installer, Application Adapters can be installed in a standalone SOA environment, standalone OSB environment, or mixed (SOA and OSB) environment.


You can check from here

The installation is not that hard , it's all about configuration. i will post about later.

You Can Download it from here.

Operating system : Oracle Linux.

Installation Steps :-






As You see you should installed Oracle SOA Or Oracle OSB.

If you are using Oracle SOA the path will be like the below :-
\Oracle_SOA1\

For Oracle OSB :-

\Oracle_OSB1\

Be Notice this application installed in the following Path :-
\Oracle_SOA1\soa\thirdparty\ApplicationAdapters\


Thank you 
Osama mustafa

Thursday, June 26, 2014

unrecognized class file version

This error appear on linux while trying to run iwae.sh ( Oracle Application adapter ).



Starting java

---------------------------------------------------------------
Exception in thread "main" java.lang.ClassFormatError: com.ibi.bse.gui.BseFlashScreen (unrecognized class file version)
at java.lang.VMClassLoader.defineClass(libgcj.so.7rh)
at java.lang.ClassLoader.defineClass(libgcj.so.7rh)
at java.security.SecureClassLoader.defineClass(libgcj.so.7rh)
at java.net.URLClassLoader.findClass(libgcj.so.7rh)
at java.lang.ClassLoader.loadClass(libgcj.so.7rh)
at java.lang.ClassLoader.loadClass(libgcj.so.7rh)
at gnu.java.lang.MainThread.run(libgcj.so.7rh)

Solution :-

 export JAVACMD=/Oracle/Java/bin/java


And try again.

Thank you
Osama mustafa 

Wednesday, June 25, 2014

Extend LVM Disk Linux

This Article Will Describe step by step how to extend LVM Disk On Linux :-

1- After adding New Harddisk to the server you have to ReScan The Scsi using 

echo "- - -" > /sys/class/scsi_host/host?/scan
? :- Depend on you host number. 
2-  Use Fdisk to create new partition.

>fdisk -l
Disk /dev/sda: 107.3 GB, 107374182400 bytes
255 heads, 63 sectors/track, 13054 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes
   Device Boot      Start         End      Blocks   Id  System
/dev/sda1   *           1          13      104391   83  Linux
/dev/sda2              14       13054   104751832+  8e  Linux LVM
Disk /dev/sdb: 10.7 GB, 10737418240 bytes
255 heads, 63 sectors/track, 1305 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes

Disk /dev/sdb doesn't contain a valid partition table
 Check the below :-



#fdisk /dev/sdb
Device contains neither a valid DOS partition table, nor Sun, SGI or OSF disklab el
Building a new DOS disklabel. Changes will remain in memory only,
until you decide to write them. After that, of course, the previous
content won't be recoverable.






The number of cylinders for this disk is set to 1305.
There is nothing wrong with that, but this is larger than 1024,
and could in certain setups cause problems with:
1) software that runs at boot time (e.g., old versions of LILO)
2) booting and partitioning software from other OSs
(e.g., DOS FDISK, OS/2 FDISK)
Warning: invalid flag 0x0000 of partition table 4 will be corrected by w(rite)



Command (m for help): n
Command action
e extended
p primary partition (1-4)
p
Partition number (1-4): 1
First cylinder (1-1305, default 1):
Using default value 1
Last cylinder or +size or +sizeM or +sizeK (1-1305, default 1305):
Using default value 1305



Command (m for help): w
The partition table has been altered!



Calling ioctl() to re-read partition table.



WARNING: Re-reading the partition table failed with error 16: Device or resource busy.
The kernel still uses the old table.
The new table will be used at the next reboot.
Syncing disks.


3-  Lets start increasing :-

pvcreate /dev/sdb1
Writing physical volume data to disk "/dev/sdb1"
Physical volume "/dev/sdb1" successfully created
vgdisplay
--- Volume group ---
VG Name Oracle
System ID
Format lvm2
Metadata Areas 1
Metadata Sequence No 4
VG Access read/write
VG Status resizable
MAX LV 0
Cur LV 3
Open LV 3
Max PV 0
Cur PV 1
Act PV 1
VG Size 99.88 GB
PE Size 32.00 MB
Total PE 3196
Alloc PE / Size 3196 / 99.88 GB
Free PE / Size 0 / 0
VG UUID MZ04D3-jZLy-0BWi-2WSP-oi9E-hBkl-e3a08d

vgextend Oracle /dev/sdb1  Volume group "Oracle" successfully extended
 pvscan
  PV /dev/sda2   VG Oracle   lvm2 [99.88 GB / 0    free]
  PV /dev/sdb1   VG Oracle   lvm2 [9.97 GB / 9.97 GB free]
  Total: 2 [109.84 GB] / in use: 2 [109.84 GB] / in no VG: 0 [0   ]
###

lvdisplay
--- Logical volume ---
LV Name /dev/Oracle/LogVol00
VG Name Oracle
LV UUID wKMZ16-LHsc-ktsc-3dTT-ieiq-pEfT-tODhqc
LV Write Access read/write
LV Status available
# open 1
LV Size 9.75 GB
Current LE 312
Segments 1
Allocation inherit
Read ahead sectors auto
- currently set to 256
Block device 253:0

--- Logical volume ---
LV Name /dev/Oracle/LogVol02
VG Name Oracle
LV UUID UabZCO-G8ID-dh1a-xv6t-Ss4O-QqEx-fnIy5g
LV Write Access read/write
LV Status available
# open 1
LV Size 82.34 GB
Current LE 2635
Segments 1
Allocation inherit
Read ahead sectors auto
- currently set to 256
Block device 253:1

--- Logical volume ---
LV Name /dev/Oracle/LogVol01
VG Name Oracle
LV UUID 78Y3bv-UZZI-Iu2w-gAyD-HXe1-Fx25-gmGuKn
LV Write Access read/write
LV Status available
# open 1
LV Size 7.78 GB
Current LE 249
Segments 1
Allocation inherit
Read ahead sectors auto
- currently set to 256
Block device 253:2
Now Let's Extend :-

lvextend /dev/Oracle/LogVol00 /dev/sdb1 Extending logical volume LogVol00 to 19.72 GB
Logical volume LogVol00 successfully resized
 Finally :-

resize2fs /dev/Oracle/LogVol00resize2fs 1.39 (29-May-2006)
Filesystem at /dev/Oracle/LogVol00 is mounted on /; on-line resizing required
Performing an on-line resize of /dev/Oracle/LogVol00 to 5169152 (4k) blocks.

Notes :

  1. The Red Color for Command Line.
  2. The Brown Color For necessary Output. 
  3. /dev/Oracle/LogVol00 it's the name for LVM Disk.
  4. /dev/sdb1 disk that we created using fdisk.


Thank you
Osama Mustafa


Monday, June 23, 2014

java.lang.ClassNotFoundException: oracle.dms.wls.DMSServletFilter

This Error Appeared while trying to start managed Server "edq_server1" , The starting results it's completed with successfully status but some deployment end with Failed status , which mean edq_server will not work correctly, therefore i checked the logs which the below error :-

Caused By: java.lang.ClassNotFoundException: oracle.dms.wls.DMSServletFilter
        at weblogic.utils.classloaders.GenericClassLoader.findLocalClass(GenericClassLoader.java:297)
        at weblogic.utils.classloaders.GenericClassLoader.findClass(GenericClassLoader.java:270)
        at weblogic.utils.classloaders.ChangeAwareClassLoader.findClass(ChangeAwareClassLoader.java:64)
        at java.lang.ClassLoader.loadClass(ClassLoader.java:424)
        at java.lang.ClassLoader.loadClass(ClassLoader.java:357)
        at weblogic.utils.classloaders.GenericClassLoader.loadClass(GenericClassLoader.java:179)
        at weblogic.utils.classloaders.ChangeAwareClassLoader.loadClass(ChangeAwareClassLoader.java:43)
        at weblogic.servlet.internal.WebComponentContributor.getNewInstance(WebComponentContributor.java:224)
To solve this error :-

cd /u01/app/oracle/product/fmw/wlserver_10.3/common/nodemanager
vi nodemanager.properties

And search for 

StartScriptEnabled=false

change it to

StartScriptEnabled=true


Restart Node manager and try again.
Thank you
Osama Mustafa

Wednesday, June 18, 2014

Oracle to MySQL step by Step

In this Document i tried to explain step by step configure oracle to MySQL Database Link Using Oracle Gateway, The document uploaded Here.

Operating system : Solaris 11.1
Database : 11.2.0.3

You can Use the same step for Linux/Unix.

Thank you
Osama Mustafa

Monday, June 16, 2014

ORA-01031: insufficient privileges On ASM - Grid Infrastructure 11gR2

Today like any other day started with customer call , Telling me There is problem on Grid infrastructure after restarting both node, They change heartbeat from cables to connected on switch after i told them to do this.

The Error in the logs like the  below :-
CRS-5011:Check of resource "+ASM" failed: details at "(:CLSN00006:)"

Node #2 was running without any problem , the issue was with node #1 and nothing changed recently.

The Error in Node #1 :-

crsctl start cluster
PRCR-1079 : Failed to start resource ora.asm
ORA-01031: insufficient privileges
CRS-5017: The resource action "ora.asm start" encountered the following error:
ORA-01031: insufficient privileges
. For details refer to "(:CLSN00107:)" in "/u01/app/grid/11.2.0.4/log/lux335/agent/ohasd/oraagent_oracle/oraagent_oracle.log".
as you see from the above error "ORA-01031: insufficient privileges" i was running this command as root.
After check node #1 the solution so simple :-

Under $GRID_HOME/network/admin
vi sqlnet.ora

SQLNET.AUTHENTICATION_SERVICES = (NONE)

which is wrong and to be changed to the following value :-

SQLNET.AUTHENTICATION_SERVICES = (NTS)

Reboot Node #1 and everything running successfully.

Thank you
Osama mustafa

Tuesday, June 3, 2014

Oracle Enterprise Manager Cloud Control 12c Release 4 (12.1.0.4)

Now Officially #EM12c 12.1.0.4 released with new features you can download also oracle announce about this in official document here included with new features.

You can start downloading from here


Thank you
Osama mustafa

Monday, June 2, 2014

OTN MENA Tour Experience - Dubai

Don't be dismayed by good-byes. A farewell is necessary before you can meet again. And meeting again, after moments or lifetimes, is certain for those who are friends.


I Thought it will be nice to share this quotation before start talking about Oracle OTN Tour - MENA TOUR 2014. 

Fir the people who dosen't know anything about this Tour it's happened for the first time in middle-east, 

"Courtesy of the Oracle Technology Network (OTN) and the ARABOUG, the inaugural 2014 OTN MENA Tour brings a star-studded cast, consisting of some of the world's best Oracle ACEs, ACE Directors and Rock Star Speakers to the region. The tour aims at sharing cutting edge knowledge and independent research in the MENA region, by accomplished Oracle experts from all over the world"

Covered the following countries :-
  • Tunisia
  • KSA- Saudi Arabia
  • Dubai.
Link Here.

Picture for the speaker getting ready for the event :-


Introduction about the Speaker :-



I will talking about Dubai, The event location was In Habtoor Grand Beach Resort & Spa. started at 8 Am - 5 pm During this time Oracle experts start sharing their knowledge and  chatting with them.

Different Topics , Different Speaker But it's Only About Oracle, Performance tips, I/O , 12c , Fusion middleware , RAC 12c ...

I spoke about Oracle Fusion middleware high Availability and crowd was really amazing.


 


I will do it again for sure Enshalla.

Thank you
Osama mustafa.


Sunday, May 18, 2014

Enable Samba to Share from Linux to Windows

To Setup and configure Shared Folder From Linux to Windows Follow the Below Steps :-


  • Install Samba Package on OS using the below command.
    • rpm -ivh samba Or yum install samba
  • After Install The Package configure   Username and password using the below command :-
    • smbpasswd -a oracle ( Or Any other user you want to share folder with )
  • On Linux Side --> Create Directory using mkdir /u01/share.
  • edit vi /etc/samba/smb.conf and configure the file to allow share to the above folder.
[Folder-name]
path = Folder_path
available = yes
valid users = User_will_user_folder.
read only = no
browsable = yes
public = yes
writable = yes

  • Restart Samba Services --> service smb restart
  • On Windows you can access the folder using Run --> \\Linux-Ip and enter the username and password.

Thank you
Osama Mustafa

Thursday, May 8, 2014

Middle east Tour 2014


Courtesy of the Oracle Technology Network (OTN) and the ARABOUG ( Arab Oracle User Group ), the inaugural 2014 OTN MENA Tour brings a star-studded cast, consisting of some of the world's best Oracle ACEs, ACE Directors and Rock Star Speakers to the region. The tour aims at sharing cutting edge knowledge and independent research in the MENA region, by accomplished Oracle experts from all over the world - "The 2014 OTN Middle East & North Africa (MENA) Tour" - 5 Cities, 3 Countries, 2 Continents with more than 50 Action-Packed Oracle Sessions, last stop at Dubai June 1 - Dubai, UAE.

Speakers List :-

Bjoern Rost
Michael Ault
Syed Jaffar Hussain
Edward Roske
Osama Mustafa.
Dr.Mohammad Houri 
Joel Perez
Tariq Farooq
Jim Czuprynski

We Are Glad to see you there and chatting with you.

Link Here

Thank you 
Osama Mustafa

Wednesday, May 7, 2014

OTech Magazine 2014

Independent magazine for Oracle technology professionals. OTech Magazine will be published digitally four times a year. Every season. 

The first edition will be published Fall 2013. OTech Magazine articles are written by the Top-100 consultants in the Oracle-field around the globe. Only selected authors can publish in OTech Magazine.

OTech Magazine offers insight in complex Oracle projects and solutions.

My Article Included in this Version of OTech Magazine You Can Check The Magazine Here

 I Want to take this Opportunity to Thanks Douwe Pieter for his great efforts.

Thank you 
Osama Mustafa 

Friday, May 2, 2014

Weblogic 12c installation

there are over 200 new features in weblogic 12c, some of this features
are:-


 Simplified Deployment and Management with Virtualization
 Integrated Traffic Management
 Integrated WebLogic/RAC Clusters
 Seamless Upgrade From WebLogic, iAS and Others

This Document Describe steps to install Oracle weblogic 12c, operating system Oracle Linux 6.4, You can Download Document here

Thank you
Osama Mustafa 

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