Amazines Free Article Archive
www.amazines.com - Tuesday, February 19, 2019
Read about the most recent changes and happenings at Amazines.com
Log into your account or register as a new author. Start submitting your articles right now!
Search our database for articles.
Subscribe to receive articles emailed straight to your email account. You may choose multiple categories.
View our newest articles submitted by our authors.
View our most top rated articles rated by our visitors.
* Please note that this is NOT the ARTICLE manager
Add a new EZINE, or manage your EZINE submission.
Add fresh, free web content to your site such as newest articles, web tools, and quotes with a single piece of code!
Home What's New? Submit/Manage Articles Latest Posts Top Rated Article Search
Google
Subscriptions Manage Ezines
CATEGORIES
 Article Archive
 Advertising (133276)
 Advice (160791)
 Affiliate Programs (34733)
 Art and Culture (73657)
 Automotive (145588)
 Blogs (75015)
 Boating (9841)
 Books (17129)
 Buddhism (4122)
 Business (1328119)
 Business News (426299)
 Business Opportunities (366247)
 Camping (10951)
 Career (72754)
 Christianity (15838)
 Collecting (11636)
 Communication (115054)
 Computers (241956)
 Construction (38986)
 Consumer (49660)
 Cooking (17059)
 Copywriting (6567)
 Crafts (18210)
 Cuisine (7537)
 Current Affairs (20375)
 Dating (45771)
 EBooks (19684)
 E-Commerce (48191)
 Education (185157)
 Electronics (83433)
 Email (6389)
 Entertainment (159796)
 Environment (28932)
 Ezine (3038)
 Ezine Publishing (5443)
 Ezine Sites (1552)
 Family & Parenting (110891)
 Fashion & Cosmetics (196378)
 Female Entrepreneurs (11841)
 Feng Shui (130)
 Finance & Investment (310229)
 Fitness (105870)
 Food & Beverages (62832)
 Free Web Resources (7937)
 Gambling (30212)
 Gardening (25073)
 Government (10522)
 Health (629172)
 Hinduism (2203)
 Hobbies (44019)
 Home Business (91543)
 Home Improvement (251263)
 Home Repair (46110)
 Humor (4811)
 Import - Export (5447)
 Insurance (45098)
 Interior Design (29544)
 International Property (3485)
 Internet (190962)
 Internet Marketing (146294)
 Investment (22824)
 Islam (1168)
 Judaism (1357)
 Law (80453)
 Link Popularity (4592)
 Manufacturing (20825)
 Marketing (98738)
 MLM (14136)
 Motivation (18211)
 Music (26997)
 New to the Internet (9476)
 Non-Profit Organizations (4048)
 Online Shopping (129606)
 Organizing (7799)
 Party Ideas (11855)
 Pets (38083)
 Poetry (2234)
 Press Release (12668)
 Public Speaking (5620)
 Publishing (7522)
 Quotes (2407)
 Real Estate (126606)
 Recreation & Leisure (95232)
 Relationships (87441)
 Research (16155)
 Sales (80298)
 Science & Technology (110145)
 Search Engines (23445)
 Self Improvement (153074)
 Seniors (6223)
 Sexuality (35941)
 Small Business (49277)
 Software (82937)
 Spiritual (23461)
 Sports (116068)
 Tax (7658)
 Telecommuting (34076)
 Travel & Tourism (307044)
 UK Property Investment (3117)
 Video Games (13421)
 Web Traffic (11724)
 Website Design (56796)
 Website Promotion (36556)
 World News (1000+)
 Writing (35761)
Author Spotlight
SUNNY NASH

Sunny Nash is the award-winning American author of Bigmama Didn’t Shop At Woolworth’s, recognized by...more
ALFRED MEARS

Former English Teacher; Musician (20+ years); Freelance Writer ...more
ADRIAN JOELE

I have been involved in nutrition and weight management for over 12 years and I like to share my kn...more
HANVEY HUANG

I'm a Chief Operated Officer from KIMKOO Mattress machinery.The pen is mightier than the sword.so I ...more
KIMBERLY MCCLOSKEY

I provide off-site administrative and creative writing support to busy professionals. I have been a ...more


Useful Pre Oracle Upgrade and Migration Steps by Gitesh Trivedi





Useful Pre Oracle Upgrade and Migration Steps by
Article Posted: 03/31/2012
Article Views: 121
Articles Written: 83
Word Count: 457
Article Votes: 0
AddThis Social Bookmark Button

Useful Pre Oracle Upgrade and Migration Steps


 
Computers,Software,Business
To ensure a trouble free conversion, Oracle suggests that you take several actions before you begin the upgrade or migration of your Oracle database to newest version or latest version of Oracle database. Some of these actions are required only if you are migrating the database. When this is the case, we will note this specifically. Here are the steps you should take to prepare for upgrading or migrating your database. First you should need to become familiar with the new features of latest version Oracle database.

You should need to check proper SYSTEM tablespace and SYSAUX tablespace space usage and proper free space availability.

If you are upgrading, decide which method to use. If you are upgrading, determine whether you want to do the upgrade manually or use the migration assistant utility.

If you are migrating database with change platform then you should need to advantage of export or data-pump utility.

Determine the system resources required for the conversion.

Create proper action plan to maintain upgrade activity track.

Plan your recovery strategy for any disaster.

Test your conversion process by performing a test migration on a database other than the production database. Conduct this test in an environment as close to the production database environment as possible. Run your test on this platform and validate the results. After upgrading test database, run all applications and reports for further testing.

Prepare and preserve the production database. Schedule the outage time required to do the database upgrade. Perform full backups of the current production. If time allows and database size allows, do an export of the database as well. Always try to keep full cold backup of database as well as Oracle software home. Test your backup to make sure it's recoverable.

Check the all obsolete parameters of new version of database and if any obsolete parameter needs to discontinue then discuss with application team prior to Oracle database upgrade.

Make sure the procedural option is installed. You can determine this by checking the SQL*Plus banner when starting SQL*Plus.

Check all invalid objects and run validation utility to compile. Take final invalid object list from production database before proceed for upgrading.

Make sure sufficient memory available for Oracle instance and check memory requirement for new latest version of Oracle database version.

Remove all pending transactions with all users for any possible unresolved distributed transactions, and resolve them appropriately.

Disable all obsolete parameters from parameters.

Check all tablespaces and data files in the database to be migrated are online.

Before upgrading Oracle database, check Oracle support migration guide properly and follow every action.

About Author: Author is having 15+ years experience and providing Oracle Consulting, and author of Oracle DBA Interview Questions book of Kendba.

Related Articles - oracle upgrade, oracle migration, database migration,

Email this Article to a Friend!

Receive Articles like this one direct to your email box!
Subscribe for free today!

 Rate This Article  
Completely useless, should be removed from directory.
Minimal useful information.
Decent and informative.
Great article, very informative and helpful.
A 'Must Read'.

 

Do you Agree or Disagree? Have a Comment? POST IT!

 Reader Opinions 
Submit your comments and they will be posted here.
Make this comment or to the Author only:
Name:
Email:
*Your email will NOT be posted. This is for administrative purposes only.
Comments: *Your Comments WILL be posted to the AUTHOR ONLY if you select PRIVATE and to this PUBLIC PAGE if you select PUBLIC, so write accordingly.
 
Please enter the code in the image:



 Author Login 
LOGIN
Register for Author Account

 

Advertiser Login

 

ADVERTISE HERE NOW!
   Limited Time $60 Offer!
   90  Days-1.5 Million Views  

 

Great Paranormal Romance

World News


STEVE HANEY

Steve is the owner/operator of Whiskey Jack Painters, a premier painting company based out of Alma, ...more
STEPHEN BYE

Steve Bye is currently a fiction writer, who published his first novel, ‘Looking Forward Through The...more
SUSAN FRIESEN

Susan Friesen, founder of the award-winning web development and digital marketing firm eVision Media...more
LAURA JEEVES

At LeadGenerators, we specialise in content-led Online Marketing Strategies for our clients in the t...more
GENE MYERS

Author of four books and two screenplays; frequent magazine contributor. I have four other books "in...more
NAIMA ROCCA

Since Naima was a child, writing has been her passion. Influenced by her passion, she received both ...more
JAVIER VBOIX

For the time being just a newbie in the Insurance Industry but a quick learner, soon-to-be expert Ja...more
LARRY WHITTLER

Author of Wrestler/That Dog Hunts; Available at the Kindle Store ...more
STEVERT MCKENZIE

Stevert Mckenzie, Travel Enthusiast. ...more
MICHAEL BRESCIANI

Rev Bresciani is the author of two Christian books. One book is an important and concisely written b...more

HomeLinksAbout UsContact UsTerms of UsePrivacy PolicyFAQResources
Copyright © 2019, All rights reserved.
Some pages may contain portions of text relating to certain topics obtained from wikipedia.org under the GNU FDL license