Monday, October 17, 2011

Oracle OEM 12c unzipping.....

I decided to download the OEM12c software from Oracle to install the new OEM.
After downloading the software, I had some trouble unzipping the two files.
The files downloaded where :

When unzipping the files, the following error occurred :

[oracle@localhost software]$ unzip
End-of-central-directory signature not found. Either this file is not
a zipfile, or it constitutes one disk of a multi-part archive. In the
latter case the central directory and zipfile comment will be found on
the last disk(s) of this archive.
unzip: cannot find zipfile directory in one of or, and cannot find, period.

The same error occured at both zip files, so I decided to download them again.... :(
After the second download, the unzip still showed the same errors. I downloaded the unzip from the download site...still no change. Then I downloaded the unzip for large files, the LINUX Intel (32bit and 64bit - Large file support) unzip tool. This time no errors...

Tuesday, October 11, 2011

Oralce eBS R12 Financials Cookbook

Last week I was reading a Oracle eBS R12 Financials Cookbook.

This book is written for Oracle functional eBS specialists.

The book describes the most important processes in financials, and how to execute those processes. For example, voiding a payment. The book is showing screen prints of how to do this in R12. Not only is the book using screen pints from R12, but also a step by step explanation is given.

Each process is divided into a few steps. First step is getting ready, next one is 'How to do it...' followed by a 'How it works' and sometimes a 'See also' at the end of each process. So, each process in financials is clearly presented by using screen prints of that process and the steps to follow.

Other important processes that are mentioned in the cookbook are :

- Entering a prepayment

- Defining the chart of accounts

- Defining E-Business Tax

- Paying invoices

- Creating Items (inventory)

more processes are displayed in the cookbook. A must have for everybody who is working with the Oracle E-Business Suite R12.

Interested in this book ? Check

Also I am able to give away 3 e-copies of this book to anyone who can answer the following eBS question.

'What is the realtionship between the operating unit and the set of books in Oracle eBS ?'

Leave your email and name and a e-copy will be sent to you.

Monday, January 03, 2011

Oem Agent not starting anymore..

This morning I noticed a database down in our OEM application. I also received an email from the inicident, so I decided to look into this problem. I found a sollution very quick. It seemed the dbsnmp password of the target database was not valid anymore. So I changed the password in OEM, configured the target again en the problem was solved...

But then the agent stopt running and was producing al lot of errors like ..

EMAgent exited with signal 6

EMAgent is Thrashing. Exiting watchdog

oem agent Segmentation Fault

Could this have something to do with the password reset I did before ? I looked into the log/trace files but could not find anything special, except these errors. I decided to change the dbsnmp password again and not to change it in OEM, so the agent could not connect to the target. This time the agent started.

Chekcing the target again, I found the follwoing when executing sqlplus as system...

ORA-28002: the password will expire wuthin 7 days.

The target is a 11g database, could this be the problem ? I decided to edit the 'DEFAULT' profile.

alter profile default limit password_life_time unlimited;

Changed the system password back to is't previous value (so nothing changed...) and everything was fine.
The target is up and running in OEM..