Using Oracle 10G for the first time in ubuntu

I assume you have installed oracle 10G using the tutorial from here

This instruction can be used for all versions of Oracle such as lite, XE or full:)

now, you can login as sys, or sysdba, but you won't be able to do the database related tasks. It is because the example databases are under the user HR which is locked.

But fear not, this tutorial is going to show you the way about how to enable the HR user and then use it.

Enabling the HR user:

Execute the following commands after you start "Run SQL command line" from oracle menu from applications.

Code:


conn sys as sysdba;


It will ask for password, enter iit123
To be sure that you are really sys, enter this command:

Code:


show user;


if the output is

user is "SYS"

you are really sys now.

now execute the following commands:

Code:


alter user HR account unlock ;
alter user HR identified by iit123;
exit


Now, HR is unlocked and you are out of sqlplus window. Open a terminal, you can now login as HR using this command:

Code:


sqlplus HR


it will ask for your password, enter iit123
Now, you can do all the commands mentioned in book.
How about starting with:

Code:


select * from employees;


Enjoy!

NOTE:

I have checked and double checked the instructions myself. I went to the
trouble of uninstalling Squirrel and then reinstalling it again so that
i can take the screenshots in each steps. If it does not work for you,
there is probably something wrong. And remember, starting database is a
lengthy process. Wait at least 2 minutes before you panic and start
shouting "HELP! it is not working!! I can't connect!!" .



Go to http://127.0.0.1:8080/apex and see if your page loads. If it does
not load, It means your oracle database is still being opened, mounted,
instantiated etc etc. Still if you can't connect.. you probably did
something wrong. Post the details under this topic, and we will see what
we can do for you.

Thanks a lot..

vote koi :/

eije vote +++

thanku thanku

Thanks for the nice instructions!

rep++

Oops..its not here
Just forgot that, voting has been removed
missing that

By the way, I faced problem 1st time due to "starting database is a
lengthy process."
But now its working properly.

That's really weird three people said rep++, and only 2 in the counter

Asif, you didn't think that just saying will do the clicking( on + ) for you, right?

May be Asif has given the vote. But I couldn't

Thanks for the nice instructions! Very Happy

rep++

Oops..its not here No
Just forgot that, voting has been removed Mad
missing that Sad

Now I am giving your vote

A sorry goes to Asif then