9 Replies Latest reply: Jan 2, 2013 5:58 AM by Fran RSS

    no entries in oratab

    redologger
      hi guys,

      just in doubt. Is there a security reason as to why there is no entries on the ORATAB on a production or any databases.

      I find it quite useful in cron script.
        • 1. Re: no entries in oratab
          Fran
          Please check:
          http://www.orafaq.com/faq/what_is_oratab_and_what_is_it_used_for

          oratab should has entries if you didn't modified it.
          • 2. Re: no entries in oratab
            redologger
            Fran wrote:
            Please check:
            http://www.orafaq.com/faq/what_is_oratab_and_what_is_it_used_for

            oratab should has entries if you didn't modified it.
            yes , understand it was use to log into any instances.

            What is the reason behind for modifying it ? Security reason.

            Yes, by right after installing, there will be an entries. Now looking at some database /etc/oratab and realise there is no entries. NOt Too sure whether is it save to just add it in.
            • 3. Re: no entries in oratab
              hitgon
              Its not at all a big issue, as long as you set the proper file permissions. What can you do even if you get the SID, without knowing the passwords?
              • 4. Re: no entries in oratab
                redologger
                hitgon wrote:
                Its not at all a big issue, as long as you set the proper file permissions. What can you do even if you get the SID, without knowing the passwords?
                ok ...hmmmm .... ..
                • 5. Re: no entries in oratab
                  hitgon
                  http://www.oracledistilled.com/oracle-database/administration/automating-database-startupshutdown-on-oracle-enterprise-linux/
                  • 6. Re: no entries in oratab
                    imran khan
                    I dont think so by having entries in /etc/oratab there will be any security threat as it contains only the ORACLE_SID and to which ORACLE_HOME it corresponds to . If you give the entries in this file either you can auto start the instance when the OS server gets rebooted by specifying "Y" option in the last column and you can disable the auto start by specifying "N" at the last column.

                    It is just an autostart of the DB instance and to export the ORACLE_SID with ORACLE_HOME .. For example,


                    $ . oraenv --> it prompts for ORACLE_SID just specify the SID available in /etc/oratab file, then it automatically exports the ORACLE_HOME. you no need to manually export the ORACLE_HOME. ( In Linux and some flavours of UNIX)



                    Hope you understand it


                    Regards,
                    Imran Khan
                    • 7. Re: no entries in oratab
                      Fran
                      Modify this file is not for a security reason, just only if you want to auto-start database or not when for example the server is rebooted. (you have another options like ASM too).

                      what is the meaning of "no entries", you mean an empty file?

                      You should have at least this
                      #
                      
                      
                      
                      # This file is used by ORACLE utilities.  It is created by root.sh
                      # and updated by the Database Configuration Assistant when creating
                      # a database.
                      
                      # A colon, ':', is used as the field terminator.  A new line terminates
                      # the entry.  Lines beginning with a pound sign, '#', are comments.
                      #
                      # Entries are of the form:
                      #   $ORACLE_SID:$ORACLE_HOME:<N|Y>:
                      #
                      # The first and second fields are the system identifier and home
                      # directory of the database respectively.  The third filed indicates
                      # to the dbstart utility that the database should , "Y", or should not,
                      # "N", be brought up at system boot time.
                      #
                      # Multiple entries with the same $ORACLE_SID are not allowed.
                      #
                      #
                      If you have an empty file, is not a problem anyway. Database will be works fine, but you have to start it manually every time.
                      • 8. Re: no entries in oratab
                        redologger
                        imran khan wrote:
                        I dont think so by having entries in /etc/oratab there will be any security threat as it contains only the ORACLE_SID and to which ORACLE_HOME it corresponds to . If you give the entries in this file either you can auto start the instance when the OS server gets rebooted by specifying "Y" option in the last column and you can disable the auto start by specifying "N" at the last column.

                        It is just an autostart of the DB instance and to export the ORACLE_SID with ORACLE_HOME .. For example,


                        $ . oraenv --> it prompts for ORACLE_SID just specify the SID available in /etc/oratab file, then it automatically exports the ORACLE_HOME. you no need to manually export the ORACLE_HOME. ( In Linux and some flavours of UNIX)



                        Hope you understand it


                        Regards,
                        Imran Khan
                        yupz..tks.
                        • 9. Re: no entries in oratab
                          redologger
                          Fran wrote:
                          Modify this file is not for a security reason, just only if you want to auto-start database or not when for example the server is rebooted. (you have another options like ASM too).

                          what is the meaning of "no entries", you mean an empty file?

                          You should have at least this
                          #
                          
                          
                          
                          # This file is used by ORACLE utilities.  It is created by root.sh
                          # and updated by the Database Configuration Assistant when creating
                          # a database.
                          
                          # A colon, ':', is used as the field terminator.  A new line terminates
                          # the entry.  Lines beginning with a pound sign, '#', are comments.
                          #
                          # Entries are of the form:
                          #   $ORACLE_SID:$ORACLE_HOME:<N|Y>:
                          #
                          # The first and second fields are the system identifier and home
                          # directory of the database respectively.  The third filed indicates
                          # to the dbstart utility that the database should , "Y", or should not,
                          # "N", be brought up at system boot time.
                          #
                          # Multiple entries with the same $ORACLE_SID are not allowed.
                          #
                          #
                          If you have an empty file, is not a problem anyway. Database will be works fine, but you have to start it manually every time.
                          oh yes, i wasn't clear with my asking. Yes only the above. No new entries.