Oracle NZ - Francisco Munoz Alvarez

28. February 2009

Great News for the APEX Community

Filed under: Application Server, News — admin @ 10:22

The big day for the APEX community is here! The new version of Apex (v3.2) is now available for download here.  (The apex_3.2.zip file size is only 97.3M)

  • For New features, please refer to here.
  • For New APEX 3.2 Oracle by Examples, please refer to  here.

Oracle Application Express 3.2 is supported on all Standard and Enterprise Edition versions of the Oracle database, 9.2.0.3 and higher, and specifically support the following platforms:

  • Linux x86
  • Microsoft Windows (32-bit)
  • Mac OS X Server
  • Linux on Power
  • Linux x86-64
  • z/Linux
  • Linux Itanium
  • Solaris x86
  • Microsoft Windows (64-bit Itanium)
  • Microsoft Windows (x64)
  • Solaris Operating System (SPARC) (64 bit)
  • AIX5L
  • HP-UX PA-RISC
  • HP Tru64 UNIX

Enjoy it ;)

20. February 2009

New Oracle ACE Director

Filed under: News, General — admin @ 02:11

I’m very proud to announce that this morning I’ve been awarded the Oracle ACE Director  ACE Director status, an Oracle ACE Director is someone who is not only recognized for past efforts and achievements but is also willing to commit themselves to ongoing participation and involvement in assisting the Oracle community.

I’d like to thank Lillian Buziak for all her help and support on this process, this will help me to intensify my activities around Asia Pacific and LAD in general.

Kind Regards, and  bye bye  Ace  welcome ACE Director

Francisco Munoz Alvarez  

12. February 2009

Forms to APEX, Finally coming soon…

Filed under: News, Others, General — admin @ 07:43

Finnaly we are able to test and check the new release of APEX (3.2), this version will enable you to load your Oracle Forms and Report source into an Oracle Application Express project and generate an initial APEX application.

To see more about this and other release 3.2 new features details, please click here!

Forms to ApexCurrently Oracle Application Express 3.2 is only available from Oracle hosted development site for   test it. It is not available for download yet, when ready, it will be released to download from the Oracle Technology Network  (OTN Web) at http://otn.oracle.com/apex.

Also check David Peak blog for more info about it: http://dpeake.blogspot.com/ 

Don’t lose more time, and let’s try it ;) now!

Enjoy it,

Francisco Munoz Alvarez

7. February 2009

Auckland Lantern Festival, Chinese New Year Celebrations

Filed under: Others — admin @ 10:32

As one of Auckland’s most popular summer events, the Auckland Lantern Festival brings Chinese New Year celebrations to a glowing finale with hundreds of beautiful lanterns, including brand new designs from China, some performers from New Zealand and overseas, as well as crafts, fortune-telling, fireworks and martial arts displays.

2009 is the Year of the Ox, great I’m an OX :) , here are some pictures of my family on these beatiful event:

Lantern Festival #1Lantern Festival #2

Lantern Festival #3Lantern Festival #4

 Lantern Festival #5Lantern Festival #6

 Lantern Festival #7Lantern Festival #8

Happy New Year!!!!

Francisco Munoz Alvarez ace-2.gif

2. February 2009

Installing Grid Control – Part I

Filed under: Grid Control, Tutorials, White Papers — admin @ 10:26

By Francisco Munoz Alvarez ace-2.gif

Before you start with an installation of Grid Control, I’ll recommend you to go thru the documentation to understand all the minimum requirements and the installation process. For reference purpose, I’ll resume some important points of it here.

Let’s start taking  a close look in the components of the Grid Control  and some important information:

Component Definition
Grid Control Console

From the Grid Control console, you can monitor and administer your entire computing environment from one location on the network. All the services within your enterprise, including hosts, databases, listeners, application servers, Oracle Collaboration Suite applications, and Web applications are easily managed from one central location (console).

Management Agent

The Management Agent is a process that is deployed on each monitored host. It is responsible for monitoring all targets on the host, for communicating that information to the middle-tier Management Service, and for managing and maintaining the host and its targets.

Management Service

The Management Service is a J2EE Web application that renders the user interface for the Grid Control console. It works with all Management Agents to process monitoring and jobs information, and uses the Management Repository to store data.

Management Repository

The Management Repository consists of objects such as database jobs, packages, procedures, views, and two tablespaces in Oracle Database that contain all available information about administrators, targets, and applications managed within Enterprise Manager.

The Management Service uploads the monitoring data received from the Management Agents to the Management Repository. The Management Repository then organizes all data collected, so that it can be retrieved by the Management Service and displayed in the Grid Control console, making our life easy. Because all data is stored in the Management Repository, it can be shared between any number of administrators accessing the Grid Control console.

Licensing Information

Although the installation media in your media pack contain many Oracle components, you are permitted to use only those components for which you have purchased licenses. Oracle Support Services does not provide support for components for which licenses have not been purchased. For more information please refer to Oracle Enterprise Manager Licensing Information.

Oracle Directory

If you choose to install Enterprise Manager Grid Control using a new database on a computer with no other Oracle software installed, Oracle Universal Installer creates an Oracle base directory for you. If Oracle software is already installed, then one or more Oracle base directories already exist. In the latter case, you must specify the Oracle base directory into which you want to install Oracle Database.

You are not required to create an Oracle base directory before installation, but you can do so if desired. You can set the ORACLE_BASE environment directory to point to this directory, which the Oracle Universal Installer will recognize.

Multiple Oracle Home Support

Enterprise Manager is installed on multiple Oracle homes within the Oracle base directory. This means that a typical Enterprise Manager Grid Control installation creates three Oracle homes in different Oracle home directories. For example, oms10g, db10g, and agent10g.

Permissions Required for Executing UTL_FILE

The management audit log package of the scheme owner uses the UTIL package. For this package to function properly, the Enterprise Manager schema user (for example, sysman) must have permissions to execute this package.

To grant permissions, run this command (where sysman is the schema user):

grant execute on utl_file to sysman;
Enterprise Manager 10g Grid Control Certification Matrix

Before you download the software, Oracle recommends you to read the Oracle Enterprise Manager 10g Grid Control Certification matrix. The certification matrix shows the operating systems and browser versions on which Enterprise Manager Grid Control and Management Agent are certified.

The Enterprise Manager 10g Grid Control Certification matrix is available on Oracle Metalink at:

https://metalink.oracle.com/

Login and select the Certify tab. On the Certify page, click View Certifications by Product and select Enterprise Manager 10g Grid Control, and then click Submit.

Preinstallation Requirements for Enterprise Manager

For small environments (100 monitored targets):

  • 1 Host with 1 CPU (3GHz) 2 GB RAM and 2 GB Space to install the Oracle Management Service.
  • 1 Host with 1 COU (3GHz) 2 GB RAM and 10 GB space to the Oracle Management Repository

Note: On small environments it’s ok to share the same host for the Oracle Management Service and Repository.

  • 400 MB hard disk space to install the Oracle Management Agent for all Unix platforms and 500 MB for Windows,

For information regarding Preinstallation requirements, please refer to the OEM Documentation here.

Certified Enterprise Manager Targets

This is a resume of the list, for full list, please refer to the documentation.

Supported Targets     Release
Oracle Application Server
  • 9.0.4.2 and later patchsets
  • 10.1.2.0.0 (Phase 1)
  • 10.1.0.2.0.1 (SEONE)
  • 10.1.2.0.2 (Phase 2)
  • 10.2.0.2.1 Patchset
  • 10.1.3 (Standalone OC4J)
Oracle Database, Listener
  • 8.1.7.4
  • 9.0.1.5
  • 9.2.0.7 and later patchsets
  • 10.1.0.4 and later patchsets
  • 10.2
Oracle Real Application Clusters Database
  • 9.2.0.6
  • 10.1.0.4
  • 10.1.0.5
  • 10.2
Oracle Collaboration Suite
  • 9.0.4.2 and later 10.1.1

Note: Oracle recommends that the target host on which you are installing the Management Agent have a static IP address and not DHCP.

Reference material: Enterprise Manager Grid Control Installation and Basic Configuration Guide.

1. February 2009

CLOUG, new Challenge

Filed under: News, General — admin @ 04:24

Until last Thursday I was the Vice President of CLOUG (Chilean Oracle Users Group, www.cloug.org), but by request of the members I was now elected president of CLOUG. This will be a big challenge due to the distance between my primary house and my birth country (over 10.000 km), but I love it, and I’ll keep working hard to improve the Oracle knowledge in the region.

I want to express my gratitude to OTN, Oracle Chile, Tim Hall, Plinio Arbizu, Mauricio Naranjo, Marcelo Ochoa, Dennis Remmer, Dan Norris, Juan Camilo Ruiz, Robert Freeman, Ben Prusinski and Lillian Buziak. They believed on my project (my baby, CLOUG 2009), and thanks to them I’m 100% sure that CLOUG 2009 will be a huge success, this will be the first time that an Oracle event in South America will receive this number of Oracle celebrities and experts, the ACE’s are invading Chile, that is fantastic. I’ll also take this oportunity to invite our fellow Oracle professionals to nominate the best in their region to the ACE Program, please, help OTN to award the best of  the best in the Oracle world, If you know some one that is constantly contributing to the Oracle community, always willingly to share their knowledge and experiences. Please, don’t be shy and nominate it.

I’ll finish this note full of hope that other users groups  in the region will follow our example, and I’ll be glad to help and participate if requested.

Kind Regards,

Francisco Munoz Alvarez Oracle ACE

CLOUG

Powered by WordPress