Using Oracle 10G for the first time in ubuntu
5 posters
IITDU Forum :: TechTalks :: Ubuntu
Page 1 of 1
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.
To be sure that you are really sys, enter this command:
now execute the following commands:
Now, HR is unlocked and you are out of sqlplus window. Open a terminal, you can now login as HR using this command:
it will ask for your password, enter iit123
Now, you can do all the commands mentioned in book.
How about starting with:
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.
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;
To be sure that you are really sys, enter this command:
- Code:
show user;
you are really sys now.
user is "SYS"
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.
Last edited by BIT0122-Amit on Sun Aug 08, 2010 1:10 am; edited 1 time in total
Re: Using Oracle 10G for the first time in ubuntu
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.
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.
BIT0119-Asif- Study Moderator
- Course(s) :
- BIT
Blood Group : B+
Posts : 163
Points : 432
Re: Using Oracle 10G for the first time in ubuntu
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?
Asif, you didn't think that just saying will do the clicking( on + ) for you, right?
Re: Using Oracle 10G for the first time in ubuntu
May be Asif has given the vote. But I couldn't
Now I am giving your vote
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
Similar topics
» Installing Oracle 10G in ubuntu 10.04 LTS
» Using Squirrel SQL client to Connect to Oracle 10G in ubuntu
» how to install oracle 10g express edition in ubuntu
» Swap Problem while installing Oracle 10g
» Oracle Conceptual documentations
» Using Squirrel SQL client to Connect to Oracle 10G in ubuntu
» how to install oracle 10g express edition in ubuntu
» Swap Problem while installing Oracle 10g
» Oracle Conceptual documentations
IITDU Forum :: TechTalks :: Ubuntu
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum
|
|
Tue Sep 29, 2015 2:45 pm by Sophiawood
» Cisco EHWIC SFP/GE WAN Card
Mon Sep 07, 2015 11:08 am by Sophiawood
» Huawei S1700-28GFR-4P-AC Price
Thu Jun 25, 2015 2:31 pm by Sophiawood
» teach yourself C++ / Herbert Schildt Solutions
Wed Jun 03, 2015 1:52 pm by Abdullah Al Noman
» teach yourself c by herbert schildt pdf
Wed May 13, 2015 11:01 pm by Raquib Ridwan
» ASA 5506X With Firepower ASA5506-K9
Fri Apr 10, 2015 4:31 pm by Sophiawood
» New Trends in Deal Business
Tue Feb 03, 2015 9:38 pm by nersoa
» PoE Power Allocation for WS-C2960S-24PS-L
Wed Nov 05, 2014 11:12 am by Sophiawood
» How to cure back pain
Fri Oct 31, 2014 7:15 pm by Bergen Guildford