Moving Oracle Database Between Mount points

Ø Take Backup of the database through RMAN. Below are some configuration changes which helps you take the backup effectively. Run the below commands in RMAN prompt.
1. Configure the backup location
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '/backup_dumps/IDC/RMAN_Backups/RMAN_MX210XRL_%U';
2. Switch on contrfolfile autobackup
CONFIGURE CONTROLFILE AUTOBACKUP ON;
3. Set parallel parameter to 2 for the speedy backup.
CONFIGURE DEVICE TYPE DISK PARALLELISM 2 BACKUP TYPE TO BACKUPSET;
Ø Take Backup of the database along with archives.
RMAN> Backup database plus archivelog;
Ø Create the new logfile groups with new mount point and drop the groups with old logfile members.
SQL>alter database ADD LOGFILE GROUP 4 ('/mwm_oradata_01/MX210XRL/redo04.log') size 100m;
SQL>Alter database drop logfile group 1;
Ø Once the backup is done shut down the database and change the parameter file for appropriate location of controlfiles.
Ø Move the control files physically from OS level to the new mount point(or Create the controlfile from the from rman backup by bringing the database in nomount state).
For 2nd option here is the command:
RMAN>restore controlfile from '/backup_dumps/IDC/MWM21DEV_HotBackup_03082011/RMAN_04mj1i6m_1_1';
Ø Mount the database and run the below command from rman to change the newname for datafiles and to restore the database from latest backup set.
RMAN>run
{
set newname for datafile '/mwm_oradata_03/MX210XRL/system01.dbf' TO '/mwm_oradata_01/MX210XRL/system01.dbf';
set newname for datafile '/mwm_oradata_03/MX210XRL/SYSAUX.dbf' TO '/mwm_oradata_01/MX210XRL/SYSAUX.dbf';
set newname for datafile '/mwm_oradata_03/MX210XRL/UNDOTBS1.dbf' TO '/mwm_oradata_01/MX210XRL/UNDOTBS1.dbf';
set newname for datafile '/mwm_oradata_03/MX210XRL/tools01.dbf' TO '/mwm_oradata_01/MX210XRL/tools01.dbf';
set newname for datafile '/mwm_oradata_03/MX210XRL/cists01.dbf' TO '/mwm_oradata_01/MX210XRL/cists01.dbf';
set newname for datafile '/mwm_oradata_03/MX210XRL/xmldbts01.dbf' TO '/mwm_oradata_01/MX210XRL/xmldbts01.dbf';
Restore database;
switch datafile all;
}
Ø Once done connect to the database as sysdba and run the below command.
SQL> Recover database;
Ø Check the datafile,controlfile and redo log file locations.
SQL> select name from v$datafile;
SQL> select name from v$controlfile;
SQL> select member from v$logfile;

Joomla Errors

Below Listed are Joomla Common errors:
*Unable to connect to database or database error:
If you are unable to find any of the error messages in the previous section then please see below you may find it here!!!
Database Errors:
I am not going to list out the error messages since all needs the basic procedure. Which I have listed below
1.Verify database settings, usually database settings for any application are found in these files: config.php, configuration.php, include(s)/config.php,wp-config.php, Settings.php, etc….
2.Check whether database name and Username are correct if they are correct then reset the database password.
3.Check the database host. It may be usully ‘localhost’ unless your server has separate MySQL server.
4.If everything is okay then try uploading the testdatabase script and check.
5.If the test database script too fails then contact your host.
6.If test database script success then the issue is with your application or other settings.
7. If any table is corrupted and you see table name in error message then try run this SQL query.

* Database Error where a database Table name is specified usually sessions table:
Fix: This is caused by crashing Table, Repair the table.
* Joomla links are not working results in Page not found.
Fix: Usually a .htaccess.txt file comes with Joomla rename it to ,htaccess, try disabling SEO options SEF URL redirect. Not got the ,htaccess the try adding this file:
RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d
RewriteCond %{REQUEST_URI} !^/index.php
RewriteCond %{REQUEST_URI} (/|\.php|\.html|\.htm|\.feed|\.pdf|\.raw|/[^.]*)$ [NC]
RewriteRule (.*) index.php
RewriteRule .* - [E=HTTP_AUTHORIZATION:%{HTTP:Authorization},L]

What is frameset ?

The frameset element is used to hold and display a separate document on a web page.

<html>
<frameset cols=”50%,*,25%”>
<frame src=”test1.html” />
<frame src=”test2.html” />
<frame src=”test3.html” />
</frameset>
</html>

Here page test1 using 50% of layout and test3 using 25% occupy the layout. The rest of the space transfer to test2.html that is 25% (100%-50%+25%= 25%).

Play background music in your blogger!!

The simplest method of adding background sound is to include a line like this in your blog template.

<bgsound src="http://yoursite.com/background.mp3" loop=infinite>
Steps to add:  Go to Blogger dashboard Design-> Edit HTML-> below body tag add this code.
<bgsound src="http://yoursite.com/yoursound.mp3" loop=infinite>

Example:
 <body>
 <bgsound src="http://yoursite.com/yoursound.mp3" loop=infinite>


 Here http://yoursite.com/yoursound.mp3 is path of mp3file.

Add facebook comment to blogger!!!

Step 1: Visit http://developers.facebook.com/setup/ give your website URL and website name.
Step 2:  Create new app at https://developers.facebook.com/apps
step3: Now change  App ID in the code

<b:if cond='data:blog.pageType == &quot;item&quot;'>
  <p align='left'><img alt='Mangalre news' class='icon-action' src='https://lh6.googleusercontent.com/-nfUWFHVQt9U/TnylcyEO5_I/AAAAAAAAAOE/O_TfQUF1l8M/h80/comments.png'/></p>
  <div id='fb-root'/>
  <script>
  window.fbAsyncInit = function() {
  FB.init({appId: &#39;654329081782653&#39;, status: true, cookie: true,
  xfbml: true});
  };
  (function() {
  var e = document.createElement(&#39;script&#39;); e.async = true;
  e.src = document.location.protocol  +
  &#39;//connect.facebook.net/en_US/all.js&#39;;
  e.async = true;
  document.getElementById(&#39;fb-root&#39;).appendChild(e);
  }());
  </script>
  <fb:comments/>
  </b:if>

Step5: Place this code in  Blogger dashboard and navigate to  Edit HTML in Templates. 

Design->edit html->

Search for the code <data:post.body/> or <div class=’post-header-line-1′/> and paste the code below <data:post.body/> or <div class=’post-header-line-1′/> and save the template.

Step4: Hide the comments 

Settings->Comments->Select Hide 

Thats all............

Website will not show updated design!!!

Some times your website code content changes will not appear on the Website page. In that case you need to enter the following code in your .htaccess file.

How to create .htacces file

Header set Cache-Control: "private, pre-check=0, post-check=0, max-age=0"
Header set Expires: 0
Header set Pragma: no-cache

Note: Only for UNIX platform.

Unable to install the templates or modules in Drupal.

Drupal can run with a 18M PHP memory limit. However, a 32M PHP memory limit or above is recommended, especially if your site uses additional custom or contributed modules. Increase the memory limit by editing the memory_limit parameter in the file php.ini (iPage, IPOWER, Fatcow) .

Steps:
1. Log into the control panel.
2. Click on ‘CGI and Scripted Language.
3. Click on ‘PHP Scripting’.
4. If php.ini file and make the changes.

Also, change the PHP register global enabled settings: Drupal requires this configuration directive to be disabled. Your site may not be secure when register_globals is enabled.

Cron/Scheduled jobs

Cron is a time-based job scheduler in Unix-like computer operating systems. Cron enables users to schedule jobs (commands or shell scripts) to run periodically at certain times or dates.

The cron/scheduled jobs is available in some Hosting companies. If your hosting service provider doesn't provide cron/scheduled jobs in such case, you can use third party cron job service (eg: http://cronless.com/ ) or search free cronjob services in any search engines.

Trouble in your Form Mail?

Check it whether special characters used in FormMail ?
The special characters are converting to ascii code.
* This is intentional; FormMail should not include special characters.
* Remove the special characters from the FormMail; it will work properly.
* A few examples of special characters are: % & $ ; -

System Requirements Not Met

Unfortunately, the system requirements for this script were not met by your server.

If you are getting this error while installing liveSite then, you need to insert Zend Optimizer code in your php.ini file.

Zend : 2.6.2

[Zend]
zend_extension = /usr/local/lib/ioncube/ioncube_loader_lin_4.3.so
zend_optimizer.optimization_level=15
zend_extension_manager.optimizer=/usr/local/Zend/Zend-2.6.2/lib/Optimizer-2_6_2
zend_extension_manager.optimizer_ts=/usr/local/Zend/Zend-2.6.2/lib/Optimizer_TS-2_6_2
zend_optimizer.version=2.6.2
zend_extension=/usr/local/Zend/Zend-2.6.2/lib/ZendExtensionManager.so
zend_extension_ts=/usr/local/Zend/Zend-2.6.2/lib/ZendExtensionManager_TS.so

Zend : 3.2.0
[Zend]
zend_optimizer.optimization_level=15
zend_extension = /usr/local/lib/ioncube/ioncube_loader_lin_5.2.so
zend_extension_manager.optimizer=/usr/local/Zend/lib/Optimizer-3.2.0
zend_extension_manager.optimizer_ts=/usr/local/Zend/lib/Optimizer_TS-3.2.0
zend_optimizer.version=3.2.0
zend_extension=/usr/local/Zend/lib/ZendExtensionManager.so
zend_extension_ts=/usr/local/Zend/lib/ZendExtensionManager_TS.so

Applicable to Startlogic, iPage, Webhost4life, fatcow, IPWER

Weebly [an error occurred while processing this directive]

[an error occurred while processing this directive] error at the footer of the website. This can be resolved by updating the following code in .htaccess:

AddType application/x-httpd-php .php .htm .html

AddHandler x-httpd-php .php .htm .html

2. If the RSS feed URL is not working or getting errors related to RSS feed, then you need to update the .htaccess with the following code:

#Support Addition

RewriteEngine On

# check if requested file exists

RewriteCond %{REQUEST_FILENAME} !-d

RewriteCond %{REQUEST_FILENAME} !-f

# if not, pass it to 404.php

RewriteRule ^(.*) /404.php [L]

#Support Addition End

Applicable to ipage, IPOWER, Bizland, Readyhosting, Startlogic

Basic SEO

Improve your website traffic

The genuine visitors are important to Adsense because the click from same visitors will earn nothing.
eg: A visitors arrives your site and click your ads, you earn and then next time the same visitors arrive your site and click your ads again, this time you will not earn. If you want earn more you need more visitors to your website. It is the only search engines which bring visitors to your website.
To improve your website traffic, please follow these instructions:

* robots.txt: If you are not familiar with robots.txt, avoid robots text file which disable your website content from crawling.
Search engines will crawl and index your site on search results if you do not want to crawl the specific directory, search engine agent, page then you can use robots.txt file to block the crawling.
In your WordPress website, you do not wish crawl the directory 'wp-admin' then disallow that directory, then search engine will not crawl the directory 'wp-admin' .
Sample code:

User-agent: *
Disallow: /cgi-bin
Disallow: /wp-admin
Disallow: /wp-includes
Disallow: /tag
User-agent: Mediapartners-Google
Allow: /
User-agent: Adsbot-Google
Allow: /
Sitemap: http://www.domain.com/sitemap.xml#
Please note that your robots file extension should be .txt (eg: robots.txt) and it placed in the website root directory.


* Images: The search engine will not crawling the images, so use more text contents rather than heavy images. You can minimize the image size athttp://www.smushit.com/
How to show images in Search Results ?

In reality search engine not crawling the images and it will not recognize, do that you need to use HTML alt tag.
Code: <img src="pix/seo.jpg" width="257" height="329" alt="SEO">

* Frames: Try to avoid Frames on your webpage. The contents on the Frames SEO does not recognize.
* Forms: If you use more forms tags on your website then you will not get best ranking. eg: text form, list form.
Tips improve your website traffic:
Comment on other blogs: Post your useful comments on other blogs. The blog readers will take time to visit your blog if your comment looks informative.
Social Network: Use facebook and twitter page widget on your web page. Social network audience are always more active than search engine visitors.
Internal Links: When building new links, make sure that the relevant keywords within the content.
Domain name: When you buy new domain try to register the high value domains eg: .com, .net.
Keyword Placement: Use the Keyword placement in title tag, Meta description tag and Meta keywords tag:
Example:
<head>
<title>Website Issue</title>
<meta name="description" content="In this website learn website issues">
</meta><meta name="keywords" content="website,issue, error">
</meta>
</head>
Page Factors: Good quality in content helps to get more visitors, so you need to update your website contents regularly for the best search results. You can get brief information regarding this at Way2webhost
Most imported do not duplicate the content: You can check the duplicated content at copyscape.com .

The main 3 factors influence in Yahoo search engine:

*The web pages contents value .
*Web pages updates.
*The internal links to the websites.
The main 3 factors influence in Bing search engine:

*One topic per page.
*All pages to be a reasonable size and avoid big size images.
*Make sure that at least one static text link accessible to each webpage
The main 3 factors influence in Google search engine:

*Website with a clear text links and hierarchy.
*Title tag and meta tag properly desciribed.
* Create website with rich contents which useful for website user.