My cadillac catera has oil licking from the bottom of the oil pan

Here's a link to your oil filter. Oil Filter Change Cadillac Catera 1997 2001 1997 Cadillac Catera 3 0L V6 Here's a new filter. STP Oil Filter S8806 Read1Reviews onSTP S8806

www.youtube.com/watch?v=8n8YS6t3qn8

heres one of scotty kilmers how to videos to on performing this, you can decide after watching if you are up to the job . GL :)

Sounds to be maybe a oil pan leak, may need replaced, As for the smell you may want to take to muffler shop and get your catalic converter, checked. good luck to you.

it is normal to have that paste stuff on the underside of your oil cap and some on the tube the cap goes on. this is condensation it goes to the highest points in the engine alot of short trips makes this worse
if the oil thats drained out looks like regular dirty old oil then dont worry about it
if it looks pastie white then you got trouble

If you are asking where is the oil pump it is inside the oil pan under the engine

There isnt one. It only has a filler hole on the tranny itself. It is a sealed unit. Your Cadillac, like many newer vehicles, does not have one.
Instead, there is a fluid levelinspection port, that in your case, is in the oil pan of the transmission. To correctly check the fluid level requires the engine to be running with the transmission at operating temperature, about a 15 mile drive. In addition, the vehicle has to be level.
You can jack the vehicle up evenly on both ends, but a lift is the preferred way. The fluid should be even with the bottom of the threaded opening the transmission pan when the plug is removed.
A quart of tranny fluid with a screw on nozzle will help you add fluid as needed until it slightly flows back out of the threaded plug hole.
Recheck the plug for any leaking of tranny fluid once you have completed adding fluid and reinstalled the inspection plug.

Fluid - A/T: Service and Repair
Transmission Fluid and Oil Filter Changing
REMOVAL PROCEDURE
1. Raise and suitably support the vehicle. Refer to Vehicle Lift Points.
2. Place drain pan under pan
3. Remove oil pan bolts from front and sides only.
4. Loosen the rear oil pan bolts approximately four turns.
5. Lightly tap the oil pan with a rubber mallet or pry to drain the fluid from main case.
6. Remove the oil pan bolts from rear oil pan and gasket.
7. Remove front oil pan bolts leaving one corner bolt in loosely.
8. Lightly tap oil pan with rubber mallet or pry to drain fluid.
9. Remove the following remaining components:
^ The front oil pan bolts
^ The oil pan
^ The gasket
10. Remove the oil filter bolts and filter.
11. Clean the following components:
^ The transmission case
^ The front adapter case
^ The oil pan gasket surfaces with solvent
^ Air dry
^ All traces of gasket material must be removed
INSTALLATION PROCEDURE
1. Install the gasket.
2. Install the oil filter.
3. Install the bolts.
^ Tighten the transmission oil filter bolts to 20 Nm (15 ft. lbs.).
NOTICE: Refer to Fastener Notice in Service Precautions.
4. Install the front oil pan.
5. Install the front oil pan gasket
6. Install the front oil pan bolts
^ Tighten the front oil pan bolts to 11 Nm (96 inch lbs.).
7. Install the following components:
^ Install the pan
^ Install the gasket
^ Install the bolts
^ Tighten the oil pan bolts to 11 Nm (96 inch lbs.).
8. Refill the transmission with DEXRON III through oil pan fill plug on the side of the (main case) oil pan. Fill the transmission to lower edge of oil
pan fill. Fill plug opening using and oil suction gun.
^ Tighten the oil pan fill plug to 45 Nm (33 ft. lbs.).
9. Lower the vehicle.
10. Check the transmission fluid level. Refer to Transmission Fluid Checking Procedure.

If you can't see the oil, wait for the engine to cool, with the key out of the ignition and the battery preferably disconnected for safety, feel for the oil leak. There are a great many places that oil can be coming from, but large leaks tend to start at the pan or the heads.

Red oil, radiator trans cooler has failed....Brown oil, iether intake or head gasket has failed...do not drive car...have it towed to a shop .

Northstar engine, that's about right. They do take about 8 quarts.
The most common place they leak at is at the oil filter housing that attaches to the block of the engine.