One of the most valuable sources of information for JBoss is our Wiki
Just about any questions you may have (and some you don't) can generally be answered by first reading the appropriate section.
For you datasource question, you will want to take a look at
And more specifically
This will get you started. Note, the classes12.zip file is the OracleOCI driver (native). You probably want the ojdbc14.jar included with your Oracle distribution as this has the latest Type4 drivers that do not require the installation of the Oracle client.
Thanks so much for the sites. I will check them out and see if I can finish this thing up.
I have yet another question?
my question is on this line what does "yoursid" come from is it the name of the database?
That's your global SID for your Oracle instance. Your DB admin should be able to give you this.