DOCX is the Word document which is the "Microsoft Office Open XML Format Document". This is the new upcoming format for Microsoft Office documents. This extension came with Microsoft Office 2007. It is a combination of XML architecture and ZIP compression for size reduction.
Microsoft introduced the .docx file format in its Office 2007 and wants it to replace the commonly used doc format. Any word document in Office 2007 can be saved as .docx file extension but as .docx extension is latest version, so older version like Office 2000, Office XP, Office 98 are not still aware of the .docx file extension. So these software can't open the .docx file. Though Microsoft promised that .docx file will be compatible to old Microsoft word but they are still their promises.
Now, as many users still using old Microsoft Office so many users can't open the .docx file document. So the main question for these users is of course how they would open a docx file to be able to read and work with it. The answer depends on the platform you are using. Below is some solutions based on platform you are using as well as solution of platform independent.
For Older Version of Microsoft Office:
If you are on windows machine and you have older version of Microsoft Office like Office XP, Office 2000, Office 98 then the best way is to install Microsoft compatibility pack for previous Office versions that adds .docx support in Microsoft Word. You can download the compatibility pack from http://office.microsoft.com/en-us/word/HA100444731033.aspx.
If you use Open office Software:
If you use open office software then you can use the Open XML Translator for Open Office to be able to read and edit docx files.
Online Solution:
There are many websites over Internet that do the conversion job and most of them do offer the job for free. You can upload your .docx file in that site and then you will get back .doc document. There are many docx converter sites for it.
A hack way:
This procedure worked perfectly for Microsoft Office 2007 beta version. But if it is not beta then it will not work. Still you can get an idea about the contents inside your .docx file. The idea is as .docx file is the combination of XML architecture and ZIP compression. So first save the .docx file as .zip and then extract it using any extract utility like unzip. If you used beta version then word folder you will get your expected word file. If you don't you can still have an idea to rename big sized .XML to .HTML and open that file in your browser.
Related Documents
Sunday, July 5, 2009
Friday, July 3, 2009
Oracle forum list
Many one of you are so curious about the list of oracle forums exist because you like to join a oracle forum and want to learn from the discussion. From my point of view, it is always good to be a member of a forum and take participate their regularly. In fact, this is huge benefit for gathering knowledge. You share your ideas, other people also share their ideas and your concepts become clear. Along the oracle you must have some knowledge about operating system as well as shell script concept to get a better job. So it is good to join a forum which is a combination of these IT stuffs.
I like to present a list of oracle forums in the Internet that I am aware of. Note that all these forums may not be good.
1)Arju On IT Oracle Forum: I am the owner of the forum. I take regular participation over there and like to answer every unanswered post. Along with oracle it also contains Unix, Windows, Shell script, Hardware, Software, even Web developing section. I recommend you to join my forum and share your ideas with people. Here is the link of my Oracle Forum.
2)Oracle Forum: The official oracle forum is http://forums.oracle.com. You can find there all about oracle products which you don't have interest. Becuase you might not have interest on Oracle Business Intelligence product. In pick time you may got many people there, but in offpick time you may need to wait for a answer.
3)Orafaq Forum: Orafaq forum. The forum that I passed most of the time. Link is http://orafaq.com/forum. Also windows, unix section are there. Michael Cadot is a regular contributor there.
4)Club Oracle Forum: The forum that I participate sometimes. The link is http://club-oracle.com.
5)Oracle DBA forum: A forum of Burleson. There are many critics of him. Here is his forum link http://dbaforums.org/oracle/index.php.
6)Tech Tips forum: I have a little idea about the forum. Here is their link http://www.tek-tips.com/threadminder.cfm?pid=1177.
There may have thousands of oracle forum in the Internet. But I see most of them just exist for few days because I don't see regular contribution of people. If I am missing any oracle forum that you see useful then please add the forum with as a comment section.
Related Documents
I like to present a list of oracle forums in the Internet that I am aware of. Note that all these forums may not be good.
1)Arju On IT Oracle Forum: I am the owner of the forum. I take regular participation over there and like to answer every unanswered post. Along with oracle it also contains Unix, Windows, Shell script, Hardware, Software, even Web developing section. I recommend you to join my forum and share your ideas with people. Here is the link of my Oracle Forum.
2)Oracle Forum: The official oracle forum is http://forums.oracle.com. You can find there all about oracle products which you don't have interest. Becuase you might not have interest on Oracle Business Intelligence product. In pick time you may got many people there, but in offpick time you may need to wait for a answer.
3)Orafaq Forum: Orafaq forum. The forum that I passed most of the time. Link is http://orafaq.com/forum. Also windows, unix section are there. Michael Cadot is a regular contributor there.
4)Club Oracle Forum: The forum that I participate sometimes. The link is http://club-oracle.com.
5)Oracle DBA forum: A forum of Burleson. There are many critics of him. Here is his forum link http://dbaforums.org/oracle/index.php.
6)Tech Tips forum: I have a little idea about the forum. Here is their link http://www.tek-tips.com/threadminder.cfm?pid=1177.
There may have thousands of oracle forum in the Internet. But I see most of them just exist for few days because I don't see regular contribution of people. If I am missing any oracle forum that you see useful then please add the forum with as a comment section.
Related Documents
Earning money writing Articles about India
I already have several articles about how to earn money through online. There are many ways, believe me many ways to earn money through Internet. You can earn money through advertisement inside your site as is shown in Make money online for free. Also you can earn money from freelancing site as well as writing contents.
This post is the way of how to earn money by writing contents.
If you are Indian, have free time and decent English, you can make money writing articles for many sites that pay you for writing articles. It may an Indian squidoo like site. But you should probably choose any much better organized and with higher quality content. In fact, you can choose the site related to about.com and ehow. There are many web 2.0 user generated contents which are nothing but low quality spam, specially hubpages where lot of Indians hang out.
I have always felt that net lacked a site fully dedicated to India where you can find all information about India including how to and what is kind of type. There is yahoo answers and ibibo sawaal but they are not moderated and content is spread to thin. As far as sites are concerned, all of them are small and spammy with very little quality and value.
With a quick look at ekikrat, it looks that they have mainly focused on niches which Indians mostly search, education and bollywood. I can also see Indian railways related content on front page and looking at other recent added pages they are adding content in other verticals too.
I am not sure about how all of the article posting sites pay to screen writers and what is the payment structure, if I get time probably I will look into more detail of it.
The only bad thing about the any article writing site specially some Indian sites is the content is not properly organized and the navigation is not good, so you need to either go through all articles or use search. I wish they provide a better home page too. Though I hope one of my team member can register to the site, as soon as he inform me more experience with you, I will update the post with more information and let you know more about it.
To increase your page rank you can also submit your site links with text/topics to several websites and thus increase backlinks to your site. Like you can go to ezine.
Choose an category from there, write articles there, earn money from them as well as bring traffic to your site using backlinks.
Related Documents
This post is the way of how to earn money by writing contents.
If you are Indian, have free time and decent English, you can make money writing articles for many sites that pay you for writing articles. It may an Indian squidoo like site. But you should probably choose any much better organized and with higher quality content. In fact, you can choose the site related to about.com and ehow. There are many web 2.0 user generated contents which are nothing but low quality spam, specially hubpages where lot of Indians hang out.
I have always felt that net lacked a site fully dedicated to India where you can find all information about India including how to and what is kind of type. There is yahoo answers and ibibo sawaal but they are not moderated and content is spread to thin. As far as sites are concerned, all of them are small and spammy with very little quality and value.
With a quick look at ekikrat, it looks that they have mainly focused on niches which Indians mostly search, education and bollywood. I can also see Indian railways related content on front page and looking at other recent added pages they are adding content in other verticals too.
I am not sure about how all of the article posting sites pay to screen writers and what is the payment structure, if I get time probably I will look into more detail of it.
The only bad thing about the any article writing site specially some Indian sites is the content is not properly organized and the navigation is not good, so you need to either go through all articles or use search. I wish they provide a better home page too. Though I hope one of my team member can register to the site, as soon as he inform me more experience with you, I will update the post with more information and let you know more about it.
To increase your page rank you can also submit your site links with text/topics to several websites and thus increase backlinks to your site. Like you can go to ezine.
Choose an category from there, write articles there, earn money from them as well as bring traffic to your site using backlinks.
Related Documents
How to setup Google webmaster tool for your blog or site
May be you already heard the name of google webmaster tool. It is another google's free service/tool for the people who own a site or who own a blog. Owner of a site might have an interest for which keywords they are receiving traffic, which types of keyword they appear in google search engine including with many more features in their website or web blog. Google webmaster tool is perfect tool for that.
Before going into configure of google webmaster tool for your blog let's have a look at what this service can offer to us.
The Services offered by google webmaster tool
1)Submit sitemap(a list of pages of a web site accessible to crawlers) of your website. The purpose is to order google to crawl your site.
2)Disable crawler access. If you don't appear to list your site inside search engine then use a robots.txt file to specify how search engines should crawl your site's content.
3)Sitelinks. Google automatically links the interior pages within your website. However you can remove automatically generated sitelinks.
4)It also let you the option to target specific geographic area to improve search result for geographic queries.
5)You can setup your preferred domain(domain name with www. or without it) as well as crawl rate of your website.
6)You can see top searched queries and your page position of the queries. Also you can monitor the click activity to your pages through those searches.
7)To find the lists of external pages that link to your site.
8)List internal pages that link to the site.
9)Subscriber statistics. How may subscribers subscribe your feeds.
10)Crawl errors and crawl statistics.
11)Any recommendation of page title tags, duplicate titles etc.
Now let's have a look at how you can setup google webmaster tool for your own blog so that you can see or monitor above statistics. If you have a blospot blog then it is very easy to setup from the blog itself. To do setup,
How to setup google webmaster tool for a blog
1)Sign in to Blogger using your Google Account.
2)Click the Customize link. On top you will see the the Blogger Dashboard link, click dashboard.
3)In the lower of your dashboard page, under Tools and Resources, click Webmaster Tools.
4)Then just click "Enable Webmaster Tools" and you are done.
However if you have site rather than your blog then do following.
How to setup google webmaster tool for a website
1)Go to https://www.google.com/webmasters/tools. You will be asked your google account user name and password. Provide that.
2)If it is ok then you are entered into google webmaster tools homepage. Click on the button "Add a site" , type your url and press Continue button.
3)You can then see the verification metatag. In fact you can verify your site by two ways, either by metatag or by html. You can a simple example to do that. Follow that and after setup your site as per direction click verify link.
You are done! Enjoy the statistics and reports.
Related Documents
Before going into configure of google webmaster tool for your blog let's have a look at what this service can offer to us.
The Services offered by google webmaster tool
1)Submit sitemap(a list of pages of a web site accessible to crawlers) of your website. The purpose is to order google to crawl your site.
2)Disable crawler access. If you don't appear to list your site inside search engine then use a robots.txt file to specify how search engines should crawl your site's content.
3)Sitelinks. Google automatically links the interior pages within your website. However you can remove automatically generated sitelinks.
4)It also let you the option to target specific geographic area to improve search result for geographic queries.
5)You can setup your preferred domain(domain name with www. or without it) as well as crawl rate of your website.
6)You can see top searched queries and your page position of the queries. Also you can monitor the click activity to your pages through those searches.
7)To find the lists of external pages that link to your site.
8)List internal pages that link to the site.
9)Subscriber statistics. How may subscribers subscribe your feeds.
10)Crawl errors and crawl statistics.
11)Any recommendation of page title tags, duplicate titles etc.
Now let's have a look at how you can setup google webmaster tool for your own blog so that you can see or monitor above statistics. If you have a blospot blog then it is very easy to setup from the blog itself. To do setup,
How to setup google webmaster tool for a blog
1)Sign in to Blogger using your Google Account.
2)Click the Customize link. On top you will see the the Blogger Dashboard link, click dashboard.
3)In the lower of your dashboard page, under Tools and Resources, click Webmaster Tools.
4)Then just click "Enable Webmaster Tools" and you are done.
However if you have site rather than your blog then do following.
How to setup google webmaster tool for a website
1)Go to https://www.google.com/webmasters/tools. You will be asked your google account user name and password. Provide that.
2)If it is ok then you are entered into google webmaster tools homepage. Click on the button "Add a site" , type your url and press Continue button.
3)You can then see the verification metatag. In fact you can verify your site by two ways, either by metatag or by html. You can a simple example to do that. Follow that and after setup your site as per direction click verify link.
You are done! Enjoy the statistics and reports.
Related Documents
Draw google adsense money using western union
Now a day, I think almost all of the users have heard the name of google adsense or at least internet/on line advertisement. Out of the online advertisement network google adsense is at number 1. Most of the publishers use adsense ad code to earn their advertisement revenue.
Up to this it is fine. You are earning some money per month just by displaying ads on your site. But the major problem is how you draw money from adsense. If you are from USA then it is good. Within few days you will get the check and make it money. Also electronic fund transfer (EFT) also available there.
But I live in Bangladesh. In fact it is a great problem if you want to draw money from Bangladesh. According to adsense rule, if your advertisement revenue reaches $100 before/at the end of any month then they will send your payment before the end of the following month. Of course this is true if you have no holds on your account. Holds may be that - you manually hold your account or you did not receive/verify pin number. If you are in USA, you did not fill up tax information etc. Suppose if your account balance reaches the payment threshold during May, google will send you a payment at the end of June.
Normally google issue check to you between 21 to 29 of the month. However, google says in case of Standard delivery checks (which is the only option in this continent) check arrive within 1-2 weeks of the mailing date if you are inside USA. If you are outside USA then typically it would arrive in 2-3 weeks. But this is not the case always. Most of the time checks does not appear even after two months. What you do using their form you reissue check and at also need another 1 month. It may happen that after 5 months you get the check. And then you need to submit the check to a bank, bank may pass another 1 month to give you money! It is a great problem of drawing money from adsense and still it is not fixed in Bangladesh.
But a good news is that google now supports draw money through western union through different countries. Up to now (as of July 03, 2009) google supports following countries to send money using western union.
* Argentina
* Barbados
* Bolivia
* Bulgaria
* Chile
* China (Mainland)
* Colombia
* Dominican Republic
* Egypt
* Guatemala
* Indonesia
* Lithuania
* Malaysia
* Morocco
* Nepal
* Pakistan
* Panama
* Peru
* Philippines
* Romania
* Taiwan
* Uruguay
* Vietnam
If you use western union the time needed to draw money is dramatically reduced. Within a day you can get back your money! Just go to bank with your ID card(May be a national card, passport, office ID card, SSC/HSC registration copy or any other attested copy which contains photo of you) and fill up a form with MTCN number(google will mail you about Money Transfer Control Number) and then you will get your money. Though western union now only support individuals not company. But as most of the users are individual so a great help for the publishers. The country list to send money through western union is increased every month and we expect in Bangladesh it will arrive soon. So adsense users don't be disappointed. Do fair use of your account and you will be able to draw money in one day.
Related Documents
Up to this it is fine. You are earning some money per month just by displaying ads on your site. But the major problem is how you draw money from adsense. If you are from USA then it is good. Within few days you will get the check and make it money. Also electronic fund transfer (EFT) also available there.
But I live in Bangladesh. In fact it is a great problem if you want to draw money from Bangladesh. According to adsense rule, if your advertisement revenue reaches $100 before/at the end of any month then they will send your payment before the end of the following month. Of course this is true if you have no holds on your account. Holds may be that - you manually hold your account or you did not receive/verify pin number. If you are in USA, you did not fill up tax information etc. Suppose if your account balance reaches the payment threshold during May, google will send you a payment at the end of June.
Normally google issue check to you between 21 to 29 of the month. However, google says in case of Standard delivery checks (which is the only option in this continent) check arrive within 1-2 weeks of the mailing date if you are inside USA. If you are outside USA then typically it would arrive in 2-3 weeks. But this is not the case always. Most of the time checks does not appear even after two months. What you do using their form you reissue check and at also need another 1 month. It may happen that after 5 months you get the check. And then you need to submit the check to a bank, bank may pass another 1 month to give you money! It is a great problem of drawing money from adsense and still it is not fixed in Bangladesh.
But a good news is that google now supports draw money through western union through different countries. Up to now (as of July 03, 2009) google supports following countries to send money using western union.
* Argentina
* Barbados
* Bolivia
* Bulgaria
* Chile
* China (Mainland)
* Colombia
* Dominican Republic
* Egypt
* Guatemala
* Indonesia
* Lithuania
* Malaysia
* Morocco
* Nepal
* Pakistan
* Panama
* Peru
* Philippines
* Romania
* Taiwan
* Uruguay
* Vietnam
If you use western union the time needed to draw money is dramatically reduced. Within a day you can get back your money! Just go to bank with your ID card(May be a national card, passport, office ID card, SSC/HSC registration copy or any other attested copy which contains photo of you) and fill up a form with MTCN number(google will mail you about Money Transfer Control Number) and then you will get your money. Though western union now only support individuals not company. But as most of the users are individual so a great help for the publishers. The country list to send money through western union is increased every month and we expect in Bangladesh it will arrive soon. So adsense users don't be disappointed. Do fair use of your account and you will be able to draw money in one day.
Related Documents
Thursday, July 2, 2009
Google chrome problems -Checkbox and Radio button does not show
I have been using google chrome browser for more than 4 months. Google chrome is my first choice because to need a webpage I need minimal mouse/keyboard interaction. But from yesterday I puzzled while using google chrome. Today's date is July, 02, 2009 and I am using google chrome version 2.0.172.33.
The problem I am facing is, google chrome does not show up check boxes and radio button as well as in the drop down menu arrow sign is not displayed. So, whenever I need to select any check boxes or radio button from a site in fact it looks something odd to me. Just like a blind man either I have to click mouse around check boxes or by pressing tab keyword and then select the boxes/button by pressing space bar.
Till now the problem remains. But there are some workarounds by which you can solve the problems until google solve the chrome bug.
1)Restart the machine. After you starting start google chrome you will see they are shown properly. But restarting may be ridiculous while you are doing many jobs and you have many windows open at a time.
2)Keep your chrome window open.
Close any firefox/ internet explorer.
Just open firefox/internet explorer and close them.
Return to chrome window and if you move mouse around check boxes/radio button they will be displayed. For any new pages they would be displayed nice.
If you want to recreate problem then while keep opening google chrome open firefox/IE. Keep firefox window opens and problem will start. Whenever you close firefox/IE window problem will go away.
3)Some interesting observation is that, if you change the view in gmail from standard to basic html or from older version to newer version then it solve the problem. However if you again open a firefox window then problem again start and if again you change the gmail window from basic html to newer version or vice versa then it avoids problem.
4)A faster way to do solve the problem is right click on the task bar select properties and then select cancel. Now you will see your radio button, check boxes are appeared.
5)In Windows XP,
Right-click My Computer,
Select Properties,
Go to Advanced tab,
Select Performance Settings,
Under Visual Effect select "Use Visual Styles on windows and buttons."
And then click apply.
6)Just open task manager window and close it. That will solve the problem.
By pressing CTRL+ALT+DEL or right click on task bar then select Task Manager or by pressing CTRL+SHIFT+ESC you can bring Task manger. I saw that this option does not reproduce problem. But it only fix for open window.
Out of the above workarounds it seems to me that number 6 is the best option to avoid the problem because it needs less time to open a task manager and most important is
it does not reproduce problem. At least I could not do it at first glace.
Related Documents
The problem I am facing is, google chrome does not show up check boxes and radio button as well as in the drop down menu arrow sign is not displayed. So, whenever I need to select any check boxes or radio button from a site in fact it looks something odd to me. Just like a blind man either I have to click mouse around check boxes or by pressing tab keyword and then select the boxes/button by pressing space bar.
Till now the problem remains. But there are some workarounds by which you can solve the problems until google solve the chrome bug.
1)Restart the machine. After you starting start google chrome you will see they are shown properly. But restarting may be ridiculous while you are doing many jobs and you have many windows open at a time.
2)Keep your chrome window open.
Close any firefox/ internet explorer.
Just open firefox/internet explorer and close them.
Return to chrome window and if you move mouse around check boxes/radio button they will be displayed. For any new pages they would be displayed nice.
If you want to recreate problem then while keep opening google chrome open firefox/IE. Keep firefox window opens and problem will start. Whenever you close firefox/IE window problem will go away.
3)Some interesting observation is that, if you change the view in gmail from standard to basic html or from older version to newer version then it solve the problem. However if you again open a firefox window then problem again start and if again you change the gmail window from basic html to newer version or vice versa then it avoids problem.
4)A faster way to do solve the problem is right click on the task bar select properties and then select cancel. Now you will see your radio button, check boxes are appeared.
5)In Windows XP,
Right-click My Computer,
Select Properties,
Go to Advanced tab,
Select Performance Settings,
Under Visual Effect select "Use Visual Styles on windows and buttons."
And then click apply.
6)Just open task manager window and close it. That will solve the problem.
By pressing CTRL+ALT+DEL or right click on task bar then select Task Manager or by pressing CTRL+SHIFT+ESC you can bring Task manger. I saw that this option does not reproduce problem. But it only fix for open window.
Out of the above workarounds it seems to me that number 6 is the best option to avoid the problem because it needs less time to open a task manager and most important is
it does not reproduce problem. At least I could not do it at first glace.
Related Documents
Why I don't like yahoo services, problems of yahoo
While startup ORA-27046: file size is not a multiple of logical block size
Problem Description
While creating pfile from your spfile you got the following ORA-27046. Though the error message that it shows depends on oracle version.
In Oracle 11g the error message look like,
SQL> create pfile from spfile;
create pfile from spfile
*
ERROR at line 1:
ORA-01565: error in identifying file
'%ORACLE_HOME%\DATABASE\SPFILE%ORACLE_SID%.ORA'
ORA-27046: file size is not a multiple of logical block size
OSD-04012: file size mismatch (OS 911)
In Oracle 10g the error message looks like,
SQL> create pfile from spfile;
create pfile from spfile
*
ERROR at line 1:
ORA-27046: file size is not a multiple of logical block size
OSD-04012: file size mismatch (OS 3583)
In Oracle 9.2 the error message looks like,
SQL> create pfile='init.ora' from spfile='/oracle/oradata/product/spfileprod.ora';
create pfile='init.ora' from spfile='/oracle/oradata/product/spfileprod.ora'
*
ERROR at line 1:
ORA-27046: file size is not a multiple of logical block size
Additional information: 1
Additional information: 254
Cause of the Problem
Oracle database finds a spfile in the desired location but it was not able to read the file as the server parameter file was corrupted. If you try to create a pfile from a corrupted spfile then ORA-27046 error occurs. In the same way, if your database spfile with it's default name, found in default location which refer on windows under %ORACLE_HOME%\database, on unix under $ORACLE_HOME/dbs and your spfile is corrupted and then if you issue startup Oracle can report a ORA-1078.
Solution of the problem
It is simple to understand that there is no way the spfile can be repaired or modified manually because spfile is a binary file. To know more about spfile have a look at Pfile and Spfile in Oracle.
So now the solution is to restore a spfile from backup, or recreate a new spfile.
If a SPFILE backup exists, restore it to the original location. The backup could be a copy of the spfile or from a RMAN backup. How you can restore it from RMAN is discussed in Restore SPfile from RMAN and Restore an Spfile from Autobackup.
However if the spfile backup does not exist, one can use an existing pfile or the list of non-default parameters listed in the alert log at startup time, or one can also get the parameters from the corrupted spfile using utilities like strings available on unix, similar utilities can be found for Windows as well. On windows you can simply open the file using notepad ++ or ultra edit and copy readable part of the corrupted spfile and save it as a pfile.
After that using the SQL command CREATE SPFILE FROM PFILE create a spfile from the pfile.
A detail about the procedure is discussed inside solution part of the post
Different ways to discover spfile.
In unix simply,
$ strings spfile$ORACLE_SID.ora init$ORACLE_SID.ora
where $ORACLE_SID will be replaced by your oracle sid.
SQL> conn / as sysdba
SQL> create spfile from pfile ;
Will create a good spfile.
After you create spfile now you are done. You can startup your database as well as you can create as many pfile from spfile as you wish.
Related Documents
While creating pfile from your spfile you got the following ORA-27046. Though the error message that it shows depends on oracle version.
In Oracle 11g the error message look like,
SQL> create pfile from spfile;
create pfile from spfile
*
ERROR at line 1:
ORA-01565: error in identifying file
'%ORACLE_HOME%\DATABASE\SPFILE%ORACLE_SID%.ORA'
ORA-27046: file size is not a multiple of logical block size
OSD-04012: file size mismatch (OS 911)
In Oracle 10g the error message looks like,
SQL> create pfile from spfile;
create pfile from spfile
*
ERROR at line 1:
ORA-27046: file size is not a multiple of logical block size
OSD-04012: file size mismatch (OS 3583)
In Oracle 9.2 the error message looks like,
SQL> create pfile='init.ora' from spfile='/oracle/oradata/product/spfileprod.ora';
create pfile='init.ora' from spfile='/oracle/oradata/product/spfileprod.ora'
*
ERROR at line 1:
ORA-27046: file size is not a multiple of logical block size
Additional information: 1
Additional information: 254
Cause of the Problem
Oracle database finds a spfile in the desired location but it was not able to read the file as the server parameter file was corrupted. If you try to create a pfile from a corrupted spfile then ORA-27046 error occurs. In the same way, if your database spfile with it's default name, found in default location which refer on windows under %ORACLE_HOME%\database, on unix under $ORACLE_HOME/dbs and your spfile is corrupted and then if you issue startup Oracle can report a ORA-1078.
Solution of the problem
It is simple to understand that there is no way the spfile can be repaired or modified manually because spfile is a binary file. To know more about spfile have a look at Pfile and Spfile in Oracle.
So now the solution is to restore a spfile from backup, or recreate a new spfile.
If a SPFILE backup exists, restore it to the original location. The backup could be a copy of the spfile or from a RMAN backup. How you can restore it from RMAN is discussed in Restore SPfile from RMAN and Restore an Spfile from Autobackup.
However if the spfile backup does not exist, one can use an existing pfile or the list of non-default parameters listed in the alert log at startup time, or one can also get the parameters from the corrupted spfile using utilities like strings available on unix, similar utilities can be found for Windows as well. On windows you can simply open the file using notepad ++ or ultra edit and copy readable part of the corrupted spfile and save it as a pfile.
After that using the SQL command CREATE SPFILE FROM PFILE create a spfile from the pfile.
A detail about the procedure is discussed inside solution part of the post
Different ways to discover spfile.
In unix simply,
$ strings spfile$ORACLE_SID.ora init$ORACLE_SID.ora
where $ORACLE_SID will be replaced by your oracle sid.
SQL> conn / as sysdba
SQL> create spfile from pfile ;
Will create a good spfile.
After you create spfile now you are done. You can startup your database as well as you can create as many pfile from spfile as you wish.
Related Documents
Subscribe to:
Posts (Atom)