This content has been marked as final. Show 10 replies
1st i would like to know your background experience on the Oracle database? do let me know your experience.
First of all I want to know what is the difference between schema and instance.
Schema : you can consider this as a set of related DB objects belonging to one particular user is termed as Schema /user in DB terminology.
Instance: It is combination of allocated memory and processes (background ) and you can think instance as means of interface between Oracle server and Oracle database.
What is the difference between domain and user and connection?
If you really wanted to start with good basics don't Jump on to 11g, 9i has got very good concepts. refer to the below link most of your questions will be answered
And when I install my database on windows 7 then why I have to make some changes in host file ?
And When I install my database Then I get an error While installer installing Oracle Database Configuration Assistant.
Connect with user "sys" and password of the sys user. Connect "as sysdba".
Use sys user if you need to perform any administrative tasks
Refer this http://docs.oracle.com/cd/B13789_01/server.101/b10742/em_manage.htm
kush wrote:Then I think OEM (Oracle Enterprise Manager) and/or free open source GUI tools for database management would be your first choice. Just try to play around with OEM and other GUI tools which comes with a menu bar with fixed options. These tools don't require deeper knowledge and work goes on. I am sure, these Open source GUI tools are easily downloaded by just a little google search.
I don't want to be DBA/../ I just want to perform basic task of oracle 11g database. Like create database , schema , user and tables. So Can anyone suggest me a tutorial about this basic task of oracle 11g database?
kush wrote:Read this below manual, everything detailed.
I don't want to go with any other gui tool/. I want to prefer OEM. But Actually I am Little confuse about What is schema , database , instance , user , domain and connection?
Can anyone explain me by giving just simple example?
Whenever I am confused with any word/term, first I consults Oracle Database Master Glossary to get into the definition of that word/term :
This will give you the actual meaning of all the words which you are looking for. Just explore it, understand them and then post what you got it from these meaning in your own words. We are here to make any correction (if required any).
Lets start Right from Now...!