Hi there ya'll

This is a long POST, but please read it, cause you can make the difference.

I need help urgently.
I am in this predicament where i have studied for a OAD-(oracle Application Developer). My boss is aware of this, but wants me to do DBA work and not OAD.

O.k. NExt.

1st Problem

I have downloaded and installed Oracle 9i database.
The installation was straight forward and easy, but it froze @ this one stage. I deinstalled oracle and ten reinstalled it. Now i get these ocl.dll file that is missing. Init.ora is missing as well. So, does anyone have any idea what i should do?

2nd Problem

I can work in Oracle Enterprise. I want to know the following:
I created a user with DBA rights. I can connect to the database i created with this user, but can't connect to SQL+.
It gives me the following error.

ORA-12154 TNS:could not resolve service name.

???????? Any ideas??????

Problem 3

I have to import a database from some telemanagement program. Import DHCP and email addresses in our company, and write a script that will run using all three these information which will tell my boss who dialled to this number who visited that site who received exe programs in there emails.


Does anyone have any DBA tutorials for Oracle 9i.

I should have done the DBA track instead of the OAD track, but it is to late now.

This is a matter of life and death. I have 30 days to teach myself all about oracle databases, or else i am fired!

Any help is welcome!

Thanx a Mill in Advance!!!!
I appreciate your help!

Charlton