10 Replies Latest reply: Feb 26, 2012 12:41 AM by CKPT RSS

    oracle database 11g basic concepts

    899838
      Hello,

      I am installing oracle 11g database. But before using this database I just want to get the basic knowledge related to this database.

      First of all I want to know what is the difference between schema and instance. What is the difference between domain and user and connection?

      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.
        • 1. Re: oracle database 11g basic concepts
          NikolayIvankin
          Here is a good [url http://docs.oracle.com/cd/E11882_01/server.112/e10897/toc.htm]start for you.
          • 2. Re: oracle database 11g basic concepts
            user345760_bplmanju
            Hi,

            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

            http://jpk.cptc.cn/jsjx/oraclejpk/pdf/9iDBA1_1.pdf

            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.
            • 3. Re: oracle database 11g basic concepts
              Helios-GunesEROL
              Hi;

              You should read some documentations pages from Oracle Concept guide

              See:
              http://docs.oracle.com/cd/E14072_01/server.112/e10713.pdf
              http://docs.oracle.com/cd/E11882_01/server.112/e25789/toc.htm
              http://docs.oracle.com/cd/B28359_01/server.111/b28318/toc.htm

              Regard
              Helios
              • 4. Re: oracle database 11g basic concepts
                899838
                Hello I have successfully installed Oracle 11g database on windows 7. Now I print http://loclahost:1521/em_ in the browser and I don't know what to enter to Login in the database. I mean which username and Password should I have to give?
                • 5. Re: oracle database 11g basic concepts
                  Shivananda Rao
                  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
                  http://st-curriculum.oracle.com/obe/db/10g/r1/2day_dba/gettingstarted/gettingstarted.htm
                  • 6. Re: oracle database 11g basic concepts
                    899838
                    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?
                    • 7. Re: oracle database 11g basic concepts
                      Girish Sharma
                      kush wrote:
                      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?
                      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.

                      Regards
                      Girish Sharma
                      • 8. Re: oracle database 11g basic concepts
                        899838
                        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?
                        • 9. Re: oracle database 11g basic concepts
                          CKPT
                          kush wrote:
                          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?
                          Read this below manual, everything detailed.

                          http://docs.oracle.com/cd/B19306_01/server.102/b14220/intro.htm#i62345
                          • 10. Re: oracle database 11g basic concepts
                            Girish Sharma
                            Whenever I am confused with any word/term, first I consults Oracle Database Master Glossary to get into the definition of that word/term :
                            http://docs.oracle.com/cd/E11882_01/mix.112/b14388/toc.htm

                            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...!

                            Regards
                            Girish Sharma