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).
Monday, November 15, 2010
EXPDP to NFS disk fails with ORA-27054 which does not have "noac" set
| Reactions: |
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>
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>
| Reactions: |
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.
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.
| Reactions: |
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.
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.
| Reactions: |
Subscribe to:
Posts (Atom)
Tag Cloud
10.2g
10g
11g
11gR2
Abasa
About Oracle
Administration
Adsense
Alerts
Archival
ASM
ASP.Net
Audit
Audit Vault
Backup
Bangladesh
Block Corruption
Blogger
Browser
Bug
Business
Clone
Clusterware
Comments
Concepts
Connection
Controlfiles
Crime
CSS
Data Block
Data Dictionary
Data Guard
Data Mining
Data Pump
Data Type
Database Administration
Database Vault
DBConsole
Developer
Economics
EM
Excel
Exercise
Explain plan
Export
External Table
Facebook
Firefox
Firmware
Flashback
Forum
Functions
Games
Globalization Support
Grid Control
Hardware
History
HTML
IE
Import
Indexes
initializaion parameter
initialization parameter
Installation
Internals
Internet
Interview
isql*plus
Java
JavaScript
Job
Joins
Joke
Limitation
Linux
Listener
Logminer
Magento
Mail
Materialized View
Medical
Memory
Mobile
Money
Multimedia
MySQL
Net Services
Network
OCP
Operators
Oracle
Oracle Concepts
Oracle Recovery
OS
Others
OUI
Package
Packages
Parameters
Partitioning
Patchset
Performance
Perl
Pfile
Photos
PHP
PL/SQL
Profile
Pseudocolumns
Puzzle
Quiz
Quota
RAC
RAC Installation
Recovery
Recovery Problems
Redo Log
Reports
RMAN
Scripts
Security
SEO
Server Administration
SGA
Shell Script
Smarty
Social Marketing
Solaris
Spfile
SQL
SQL Tuning
SQL*Loader
Sql*Plus
Startup Problem
Streams
SwingBench
System Analysis
Tablespaces
Technology
Temp
TNS Error
Tools
Troubleshooting
Tuning
Undo
UNIX
Upgradation
Utilities
Version
Views
Vmware
Windows
Wordpress
XML