Hi,
I just installed Oracle 9i,I have been working on oracle since one year(in college).At that time I was not requiring to use the oracle options i.e. I did'nt needed to specify which database serivice to use and all that I just had to run query in SQL *plus.
At this time I am working in a office so I require to know every options in oracle i.e. Application Development,configuration migration tools,Enterprise manager console... So I lke to know from where I will be able to learn all this I tried using HELP but it did'nt help me .
Please HELP me.

Hi
When you run oracle at work space, you need to know about SID your going to coenct, which'll be specified in TNSNAMES.ORA. The file is available in orant or oracle8i\network\admin. The TNSnames will specify to which database you connect and what's the IP address of the server.

You can make entries in tnsnames.ora by opening in text file or You can also modify add the contents by Net easy configurations.

If you give wrong SID, you can not connect to SQL.

I recommend that you find some books or formal training classes. There is a lot to oracle.

Hi,

Find useful details on Oracle absolutely free of cost at:

New Oracle DBA (http://neworacledba.blogspot.com/)