Monday, November 15, 2010

EXPDP to NFS disk fails with ORA-27054 which does not have "noac" set

Problem Description
ORA-027054 error is reported by expdp when run against a RAC enabled database if the target location for the data pump file is an NFS disk which does not have the "noac" property set against it.

"noac" is required for datafiles and many other database file types but should not be needed for expdp output files.

Cause of the Problem
The problem happened due to Oracle bug 9115046.

Solution of the Problem
Solution 01
This bug is started in server patchset 10.2.0.4 and bug is remained in
Oracle version 11.1.0.7
Oracle version 11.1.0.6
Oracle version 10.2.0.4.
This bug is fixed in Oracle database Server Patch Set version 11.2.0.2. so upgrade your Oracle database version is a solution.

Solution 02
Workaround you can use a different destination for the datapump export file which does have relevant attributes, or use a local file system.

Solution 03
Use event 10298 level 32 to disable the noac check (but take care as this avoid all NFS checks for all file types which can lead to corruption scenarios if disks are not mounted with the correct options).

Sunday, November 14, 2010

how to enable email posting for wordpress

Wordpress can be configured to use e-mail to post to a blog.
What you need to enable email posting
1. An email account: You should choose a dedicated e-mail account to be used solely for posting to your blog. This email should be hard to guess and keep it secret.

2. Your mail server address and port: You need to know your mail server address. For example: mail.mailserver.com or webmail.mailserver.com. From hosting provider you can easily know your mail server address and port. By default the port is 110.

Enable Email posting for your wordpress
1. Login to your wordpress admin panel. If you domain name is demo-domain.net then url will be,
http://demo-domain.net/wp-admin/

2. Go to Settings and then click on Writings. If you domain name is demo-domain.net then url will be,
http://demo-domain.net/wp-admin/options-writing.php

3. Go to section Post via e-mail. Enter your Mail Server address, Mail server Port,
Login Name which should be your email address,
Password which should be the password of your email.

4. Click on Save changes.

5. At this stage you've created the new e-mail account and configured your WordPress blog to accept e-mails from that account, but you still need to set up WordPress to publish those e-mail messages on your blog. You can either Manual Browser Activation or Automated Browser Activation.

In case of Manual Browser Activation, each time you send a new post via email open the following link in your browser.
http://demo-domain.net/wp-mail.php

In case of Automated Browser Activation add the following iframe code in your website. May be in your footer or sidebar.

<iframe src="http://demo-domain.net/wp-mail.php" name="mailiframe" width="0" height="0" frameborder="0" scrolling="no" title=""></iframe>

ORA-27300 ORA-27301 ORA-27302: Failure Occurred at: skgxpvfymmtu

Problem Description
In Oracle RAC environment version 10.2.0.4 process fails and in the alert log the following errors are reported:
ORA-00603: ORACLE server session terminated by fatal error
ORA-27504: IPC error creating OSD context
ORA-27300: OS system dependent operation:sskgxp_select failed with status: 3
ORA-27301: OS failure message: No such process
ORA-27302: failure occurred at: skgxpvfymmtu
ORA-27303: additional information: MTU could not be verified. Did not
receive valid message.

Cause of the Problem
The problem occurred due to Oracle bug 7331323.
Above errors are caused by more aggressive checking introduced in Oracle database version 10.2.0.4. This only affects Oracle Real Application Clusters and can be reported in ASM as well as database instances. The issue was introduced in Oracle 10.2.0.4 so earlier versions are not affected. Note that, this issue also remains in Oracle database version 11.1.0.6.

Symptoms of the Problem
The errors stack can be reported by Oracle shadow processes or by background processes.
The symptoms can include:

- process failure

- startup failure

- processes spinning in function sskgxp_select with high CPU usage.

Solution of the Problem
There is no workaround available. However, if the instance fails to start, a reboot of the server supporting the instance will usually allow startup to succeed.
You can check whether Patch 7331323 is available in your system.
However, the problem is resolved in 11.1.0.7.

STARTUP UPGRADE turns off RECYCLEBIN with SPFILE - Bug 9768907

Problem Description
The command "STARTUP UPGRADE" turns off the RECYCLEBIN permanently when there is used SPFILE to startup the database instance. The alert log shows if the RECYCLEBIN was disabled with a message like:

ALTER SYSTEM SET recyclebin='OFF' DEFERRED;

The 11.1.0.7 PSU (Patch Set Updates) and CPU (Critical Patch Updates) include a one-time post-install step 'view recompilation' which requires a STARTUP UPGRADE. Hence STARTUP UPGRADE was issued and RECYCLEBIN parameter became OFF.

Cause of the Problem
The problem happened due to Oracle bug 9768907.
This problem affects all platforms on oracle database 11.2.0.1
but only the following platforms are affected for 11.1.0.7:
- Oracle Solaris on Sparc
- HPUX PARISC
- HPUX Itanium

Solution of the Problem
In fact it is ridiculous that while applying a patch a new bug is fired. So now to resolve this bug Oracle did not implement any new patch :) rather you need to fix it manually. Workaround you can enable the RECYCLEBIN using ALTER SYSTEM command.
You need to issue,
SQL> ALTER SYSTEM SET RECYCLEBIN=ON deferred SCOPE=BOTH;
once the upgrade steps are complete.