Monthly Archives: May 2012

Oracle RAC 11g R2 on AIX 7.1 installation issue on irman relink

If you are installing Oracle RAC 11g R2 on AIX 7.1, you may have the following error:

You press retry and the installation finish without any more errors. This error will occour on both CRS installation and Database installation.

After that I had a ORA-03113: end-of-file on communication channel on dbca database creation.

Checking installation log I found the following error:

0711-780 SEVERE ERROR: Symbol .ksmpfpva

It can happen during installation, re-linking or patching

If the relink error is ignored, the following error is reported when shutting down database:

ORA-03113: end-of-file on communication channel

In instance alert.log:

ORA-07445 [ksmpclrpga()+23248]

Call stack from trace file:

skdstdst ksedst1 ksedst dbkedDefDump ksedmp ssexhd 47dc opidcl opidrv sou2o opimai_real ssthrdmain main start

This problem is also known to generate large core files at the time of hitting ORA-7445 [ksmpclrpga]:
A core file is likely generated in $ORACLE_HOME/dbs

Cause

AIX OS issue.

Solution

The following AIX fix needs to be applied:

For AIX 7.1 apply IFIX IV09541: https://www-304.ibm.com/support/docview.wss?uid=isg1IV09541

At the time of this writing, IBM has pre-built the iFixes and uploaded to:

ftp://public.dhe.ibm.com/aix/efixes/

where the APAR numbers are:

5.3 TL11 – iv10538
5.3 TL12 – iv11158
6.1 TL4 – iv11167
6.1 TL5 – iv10576
6.1 TL6 – iv10539
6.1 TL7 – iv09580
7.1 TL0 – unaffected
7.1 TL1 – iv09541

Once the OS patch is applied, relink oracle binary so it will be effective.

in Oracle Support

This worked for me…

I hope it was useful!!!
Cheers

VIO: Virtual Media Library

Steps:

$ mkrep -sp rootvg -size 8G
Virtual Media Repository Created
Repository created within "VMLibrary" logical volume

We’ve now created an empty VML repository which backs onto the /var/vio/VMLibrary filesystem. You can view the VML repository by running the lsrep command.

Check the VML repository to see the new image available for use.

$ lsrep
Size(mb) Free(mb) Parent Pool         Parent Size      Parent Free
   8158     4865 rootvg                   279552           182272

Name                                    File Size Optical         Access
AIX71base.7100-01-00.1of2.iso                 4040 None            ro

Increase repository:

$ chrep -size 5G +5GB

Command Description:

mkrep Creates a virtual media repository
chrep Changes the characteristics of a virtual media repository
rmrep Removes the virtual media repository
lsrep Displays information about the virtual media repository

mkvopt Creates file-backed virtual optical media
lsvopt Displays information about file-backed virtual optical devices
chvopt Changes the characteristics of a virtual optical media
rmvopt Removes file-backed virtual optical media

mkvdev Creates file-backed virtual optical devices
unloadopt Unloads file-backed virtual optical media from a file-backed virtual optical device
loadopt Loads file-backed virtual optical media from a file-backed virtual optical device

Example to mount an ISO:

$ mkvdev -fbo -vadapter vhost1
vtopt0 Available

Now let’s load the image from the VML into vtopt0.

$ loadopt -vtd vtopt0 -disk AIX71base.7100-01-00.1of2.iso
$ lsmap -vadapter vhost1
SVSA            Physloc                                      Client Partition ID
--------------- -------------------------------------------- ------------------
vhost1          U9133.55A.066EB4H-V1-C34                     0x00000000

VTD                   vtopt0
Status                Available
LUN                   0x8200000000000000
Backing device        /var/vio/VMLibrary/AIX71base.7100-01-00.1of2.iso
Physloc
Mirrored              N/A

To unload the image.

$ unloadopt -vtd vtopt0

If you’re prompted for another disk (for example, disc 2 during the AIX install).

$ loadopt -f -vtd vtopt0 -disk AIX7100-01-00.2of2.iso
 Cheers 🙂

Configure NTP on AIX 7.1 for Oracle RAC

  1. Verify that you have a server suitable for synchronization. Enter:
  1. # ntpdate -d ip.address.of.server

    The offset must be less than 1000 seconds for xntpd to synch. If the offset is greater than 1000 seconds, change the time manually on the client and run the ntpdate -d again.

    If you get the message, "no server suitable for synchronization found", verify xntpd is running on the server (see above) and that no firewalls are blocking port 123.

  2. Specify your xntp server in /etc/ntp.conf, enter:
  1. # vi /etc/ntp.conf

    (Comment out the “broadcastclient” line and add server ip.address.of.server prefer.)Leave the driftfile and tracefile at their defaults.

  2. Start the xntpd daemon:
  1. # startsrc -s xntpd

    (Use the -x flag if it is appropriate for your environment.)

  1. Uncomment xntpd from /etc/rc.tcpip so it will start on a reboot.
  1. # vi /etc/rc.tcpip

    Uncomment the following line:

    start /usr/sbin/xntpd "$src_running" "-x"

    NOTE: Use the -x flag to prevent the clock from changing in a negative direction.

  2. Verify that the client is synched.
  1. # lssrc -ls xntpd

    NOTE: Sys peer should display the IP address or name of your xntp server. This process may take up to 6 minutes.

in IBM Support

ATENTION!!!

Check your Time Zone settings. We had to change to our Time Zone (Lisbon).

The default value is CST6DST. Run the commad:

smit chtz_user

and change the values to GMT0WET.

Here’s a list of the values you can use: http://pic.dhe.ibm.com/infocenter/aix/v6r1/index.jsp?topic=%2Fcom.ibm.aix.files%2Fdoc%2Faixfiles%2Fenvironment.htm

I hope it was useful!!!
Cheers

Install Adobe Flash Plugin on Ubuntu 12.04 LTS Precise Pangolin

After upgrade my Ubuntu 11.10 to the new Ubuntu 12.04 LTS almost everything worked perfectly.

The first thing I notice was that some of the shell extentions I had didn’t work (Alternate Menu). But that was not an issue.

The real issue was that the installation of Adobe Flash Player run successfully but the installation of flash plugin didn’t work that well…it raised the following error:

Failure to download extra dat file Name-or.UTF-8

After days of research, yesterday I found a question on Launchpad.net related to Ubuntu 12.04 Beta2 Adobe Flash Player Update issue.

Turns out that the solution to that issue, was the solution to my issue.

Here’s the commands to solve Adobe Flash Player Plugin installation on Ubuntu 12.04 LTS:

sudo apt-get --purge remove adobe-flash-properties-gtk adobe-flashplugin
sudo dpkg -P flashplugin-installer
sudo apt-get --purge autoremove
sudo apt-get update
sudo apt-get upgrade
sudo apt-get install adobe-flashplugin

in Launchpad.net Answers

I hope it was useful!!!
Cheers

Install / Configure utl_mail and utl_smtp on Oracle 11g R2

Install utl_mail/utl_smtp

[host@oracle]$ cd $ORACLE_HOME/rdbms/admin
[host@oracle]$sqlplus / as sysdba
SQL> @utlmail
SQL> @utlsmtp
SQL> @prvtmail.plb
SQL> GRANT EXECUTE ON utl_mail TO PUBLIC;
SQL> GRANT EXECUTE ON utl_smtp TO PUBLIC;
SQL> alter system set smtp_out_server='mail.server.com' scope=both;

ACL: Access Control List

in White Horses Blog

Create ACL and privileges

Now first create an ACL as SYS (or any other user with DBMS_NETWORK_ACL_ADMIN execute granted), this will hold the privileges. You can add as many privileges as you like to this file, but I would recommend to split privileges in the ACL to specific tasks or users. You must create an ACL with at least one privilege, so lets start with the ‘connect’ privilege for user SCOTT, (also a role can be added as principal):

begin
  dbms_network_acl_admin.create_acl (
    acl         => 'utl_mail.xml',
    description => 'Allow mail to be send',
    principal   => 'SCOTT',
    is_grant    => TRUE,
    privilege   => 'connect'
    );
    commit;
end;

Add Privilege

Great, now that the ACL is created, you can add more privileges like the ‘resolve’ privilege:

begin
  dbms_network_acl_admin.add_privilege (
  acl       => 'utl_mail.xml',
  principal => 'SCOTT',
  is_grant  => TRUE,
  privilege => 'resolve'
  );
  commit;
end;

Assign ACL

Cool, you granted SCOTT to connect and resolve, but you have not defined to which resources he is allowed to connect:

begin
  dbms_network_acl_admin.assign_acl(
  acl  => 'utl_mail.xml',
  host => 'smtp server host name or address'
  );
  commit;
end;

I hope it was useful!!!
Cheers

Optimization WordPress Plugins & Solutions by W3 EDGE