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
Can I use /var/opt/oracle/oratab to specify listener information?
We would like to migrate our database from Oracle 8.1.7 to Oracle 10g. We would like to know the impact for our application developed using Delphi ...
I have been trying to install Oracle 8.1.7 on SUSE Linux 9.0 and got the error:
"Error in invoking target install of makefile /opt/oracle/...../*.mk."
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.