Pages

Tuesday

Awhile back I found a tip which has come in handy quite a few times. Just recently I was troubleshooting an ORA-03124 error which occurred during a run of a BI tool. The BI tool spawns many sessions while gathering and processing data so its not practical to sit there, grab the sessions information and turn on tracing manually.

Wednesday

Every now and then I get a request asking which port a specific service is using. The server team may ask for a list of ports so they can be reserved, etc. The Metalink document below lists all the ports required and which services run on them. It also has a nice utility which will calculate the ports required depending on the port pool you choose when installing or cloning.

See question number 21: What is the port pool? What if I want to give a specific value to a Server Port?

Note: the port calculations given by the utility are defaults. They may have been changed in your environment for various reasons. For example, we may have to change the port listed below because it interfered with another application.