Solved

Oracle databse and application errors

Posted on 2009-04-08
5
434 Views
Last Modified: 2013-12-19
Hello Experts,
I recently upgraded my os AIX5.3 TL6 to AIX 5.3 TL8 sp4 .After doing this we are having some issues with oracle9.0.4 applications (Heavy I/O on rootvg ,looks like lot of paging activity ) .we did some tuning on the vmo side ,but still seeing I/O issues. does any body know if there any patches we need to apply for the application server. We Opened a TAR with oracle ,but didnt hear any thing back . Just curious if anyone encountered these kind of issues .
0
Comment
Question by:vishwakarmak
  • 3
  • 2
5 Comments
 
LVL 8

Expert Comment

by:LindaC
ID: 24102758
That combination is not supported.  ORacle MEtalink Note #169706.1 mention combination of 9.0, with Aix 4.3 64 bit.

Hope you have a good export.

Remove the oracle then install 9.2 and apply latest patchset 9.2.0.8.  Also check that Note so that you can be sure that all patches needed are installed.

Import to the new db.
0
 

Author Comment

by:vishwakarmak
ID: 24103859
I do not have access to metalink ...can you please copy paste or provide me with the details..that would greatly help...
0
 
LVL 8

Accepted Solution

by:
LindaC earned 500 total points
ID: 24110226
I have asked the Community if I can upload the MEtalink note.
So uploading based on the comments from Mod...

http://www.experts-exchange.com/Community_Support/General/Q_24310366.html?cid=239#a24110145
169706-1.pdf
0
 

Author Comment

by:vishwakarmak
ID: 24111104
Thank you so much for all the help . Keep up the good work. :)
0
 
LVL 8

Expert Comment

by:LindaC
ID: 24111175
Well, thank you!

I have uplaoded the same document but with the font smaller so that you can see the column in Aix for oracle version 9.0.1.


ShowDoc.pdf
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction A previously published article on Experts Exchange ("Joins in Oracle", http://www.experts-exchange.com/Database/Oracle/A_8249-Joins-in-Oracle.html) makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…

930 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now