Oracle Bits and Pieces


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

Advertisements


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s