I just installed PSE9 from the box and it has no effects in the bar and I read some posts about databases in /applicationsupport/adobe but all I have in that adobe folder is presets. How do I get my effects?
You want the library at the top level of your hard drive. That isn't hidden, but it can be hard to see in 10.7 and 10.8. The easiest way is to go to the Finder preferences>sidebar and under Show these items in sidebar, turn on Hard Disks. Then it will be in the top level of what you see when you click on the name of your hard drive in the list on the left side of the window.
If that's really all that's in there, then you should uninstall/reinstall. If you use any kind of antivirus software, disable it during the install.