Q

Upgrading client machines

Before upgrading our database to Oracle 10g, we are slowly upgrading the 200 client workstations to 10g using the Oracle9i database. Are there scripts to monitor the sessions from the 10g client machines to see if everything is OK?

Hi Maria. Before upgrading our database to Oracle 10g, we are slowly upgrading the 200 client workstations to 10g using the Oracle9i database. Are there scripts to monitor the sessions from the 10g client machines to see if everything is OK?
I am not aware of a specific tool, per se, that will monitor sessions from the client machines, although you can see connections to your database by using a tool like Toad or Oracle's Enterprise Manager. You can also monitor the listener log for any non-zero return codes, or search for TNS errors. If you cannot connect from a client machine to your database after the client upgrade, you can turn on client tracing via Oracle Net to troubleshoot the problem.
This was first published in June 2006

Dig deeper on Oracle database installation, upgrades and patches

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

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.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close