Problem solve Get help with specific problems with your technologies, process and projects.

Could PL/SQL procedures fail after OS migration?

Could our PL/SQL procedures fail on a new OS after migration?

I have Oracle 9i database running on IBM AIX 5.1. Now that we are thinking of migrating our OS to AIX 5.3, I wanted to check if there could be a reason that PL/SQL procedures written might fail on a new OS. Is there some sort of checklist that I can refer to before initiating this upgrade?
Generally, an operating system upgrade should not impact PL/SQL procedures within the database. If there are any packages, however, that write to or reference files on the operating system, you will want to ensure that permissions or ownership on those subdirectories do not change with the upgrade. As well, performing this operating system upgrade in a non-production environment should catch most potential problems.
This was last published in January 2007

Dig Deeper on Using Oracle PL-SQL

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.