Oracle Bits and PiecesPosted: August 31, 2010
There a loads of little tips for adminastring Oracle, I am just starting out with a full system 10gR2 on Red Hat ES 4.
A very steep learning curve, got the SQL and PLSQL sorted its just the Oracle bit now. We have 3rd party DBA’s so it helps, some
of these tips are from me and some are from the professionals.
I will highlight any in RED if they have the potential to harm your system, please be careful though with any commands unless you are in your own test environment.
To see what databases are running
ps -ef | grep mon
To see what listners are active
ps -ef | grep lsnr