Good luck. I forgot to answer the question in your OP: 9.2 is 9i.
The recent versions go like this:
9.0 = 9i (i = “internet”)
9.2 = 9iR2 (9i release 2)
10.1 = 10g (g = “grid”)
10.2 = 10gR2
11.1 = 11g
You need to sign up for a technet account. http://otn.oracle.com lets you create a free account. Once you have that account, you can download the latest Oracle software and also post questions at the forums. You can also download the documentation.
What you need to do:
- Download the Oracle 9.2 software and burn a CD with that. Keep that handy.
- Download the Oracle 9.2 documentation and burn a CD with that. Keep that handy.
- Install the documentation on your PC (in HTML form) so that you can easily look up Oracle commands.
- Install the Oracle 9.2 enterprise edition database software on your PC (I am assuming that your company is using the enterprise edition) and create a small local database on your personal Windows machine. You will use this to practice commands before doing anything on the production system. If your PC database gets hosed then you just throw it away and start from scratch. Oracle SQL commands will be identical for any Oracle database regardless of the server operating system (you say that you have one Windows database and one Linux database.) Most of the utilities will also work exactly the same on Windows and Redhat except that Windows will have more “GUI” tools.
Does your company pay for Oracle support? I am assuming they do. Find out who is in charge of the support contract and have them get you a Metalink account. Metalink is how you ask questions directly from Oracle support. http://metalink.oracle.com
Metalink is also where you would go to download patches, lookup bug reports, etc.
Your first order of business, now that you are in charge of a database, is practice a recovery. Not a backup - a recovery. e.g. User X had dropped table ORDER_HISTORY in the database. How are you going to get it back? A disk with the datafiles for the SALES_HISTORY tablespace has gone bad. What are you going to do? This is the most necessary skill for a DBA to have.