Q
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.

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.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close