1 2 3 Previous Next 43 Replies Latest reply on May 21, 2013 11:19 AM by EdStevens

    Linux oratab File

    1008534
      Dear Friends ,

      We Install Oracle Database 11g 11.1.0.7 for (ERP applicatoin ) Linux version 2.6.18-194.el5


      Now When I try to Install Symantech Agent for backup Purpose . The Oratab File Missing .
      e
      its not there On /etc or /var/opt



      cd oratab >>>>>>>>>>>>>
      -bash: cd: oratab: Not a directory


      please advise How I can create oratab file , and it will not affect anything on my database


      Thansk
        • 1. Re: Linux oratab File
          P.Forstmann
          /etc/oratab is a text file that you can create with any text editor or copy and adapt from another machine. Note that /etc/oratab should only exist on machines where Oracle database instance runs (if only Oracle Client is installed on this machine you don't need /etc/oratab).


          Please read following documentation http://docs.oracle.com/cd/B28359_01/rac.111/b28252/install_rac.htm#TDPRC0328 (this is for RAC database but applies also non RAC databases).

          Edited by: P. Forstmann on 14 mai 2013 21:04
          • 2. Re: Linux oratab File
            Vishnusivathej
            /etc/oratab file is automatically created once you installed the database or updated each time you create a database using the DBCA utility...

            use the following command to check the contents
            cat /etc/oratab

            If you really didnt have the oratab or if it is missing for some reason... you can create a simple text file with the entries as follows:
            ORACLE_SID:$ORACLE_HOME:Y/N
            orcl:/u01/app/oracle/product/11.2.0/dbhome_1:Y

            Y/N indicates whether the databases have to started automatically using a script (i dont rememeber)
            • 3. Re: Linux oratab File
              1008534
              Hi,
              Thanks For reply .

              now on my Linux 2 Instacne there u01= Instance1 u02=Instance2

              I run this comman [root@xyz / ] # vi /etc/oratab
              ------------------------------------------------------------------------------------------
              E325: ATTENTION
              Found a swap file by the name "/etc/.oratab.swp"
              owned by: root dated: Tue May 14 22:20:03 2013
              file name: /etc/oratab
              modified: no
              user name: root host name: erp.redsea.com
              process ID: 29784 (still running)
              While opening file "/etc/oratab"
              dated: Wed Aug 8 11:03:09 2012

              (1) Another program may be editing the same file.
              If this is the case, be careful not to end up with two
              different instances of the same file when making changes.
              Quit, or continue with caution.

              (2) An edit session for this file crashed.
              If this is the case, use ":recover" or "vim -r /etc/oratab"
              to recover the changes (see ":help recovery").
              If you did this already, delete the swap file "/etc/.oratab.swp"
              to avoid this message.
              "/etc/oratab" 0L, 0C
              Press ENTER or type command to continue
              ----------------------------------------------------------------------------
              what i have to do

              thanks
              • 4. Re: Linux oratab File
                P.Forstmann
                If you know which contents /etc/oratab should have (ORACLE_SID and ORACLE_HOME) then modify /etc/oratab using vi command
                :recover
                • 5. Re: Linux oratab File
                  Alvaro
                  Isn't the oratab file created by the post-installation root.sh of the Oracle Home?

                  Did you run root.sh correctly after instalation ?
                  • 6. Re: Linux oratab File
                    1008534
                    Dear ,

                    Actully the Oracle DB install since 2010 ( I was not here during installation ) .

                    Now What the advise I can create oratab or how i can make my oratab file avalible on my isntance

                    thanks
                    • 7. Re: Linux oratab File
                      swapnil kambli
                      1005531 wrote:
                      Dear ,

                      Actully the Oracle DB install since 2010 ( I was not here during installation ) .

                      Now What the advise I can create oratab or how i can make my oratab file avalible on my isntance

                      thanks
                      Did you try what P. Forstmann suggested.

                      ls -alrt /etc|grep *oratab.swp

                      cat /etc/oratab (do not open in vi)

                      This should show you the oratab entry, if they are correct go ahead and rename the .swp file and this oratab file to something else and the create a oratab with content that you will get above.

                      Experts,could you please confirm?
                      • 8. Re: Linux oratab File
                        1008534
                        Dear ,

                        Thanks , but sorru Iam not understand your answer well . so may be i will wait the expert to give me the steps what i have to do .

                        becousr ist Production Server . -:)

                        thanks
                        • 9. Re: Linux oratab File
                          swapnil kambli
                          Can you show us the output of both above commands do not rename yet.
                          • 10. Re: Linux oratab File
                            1008534
                            which one


                            cat /etc/oratab

                            [root@erp /]# cat /etc/oratab
                            [root@erp /]#

                            after press enter nothing happen
                            • 11. Re: Linux oratab File
                              swapnil kambli
                              1005531 wrote:
                              which one


                              cat /etc/oratab

                              [root@erp /]# cat /etc/oratab
                              [root@erp /]#

                              after press enter nothing happen
                              ls -ltr /etc/oratab

                              ls -alrt /etc|grep *.swp
                              • 12. Re: Linux oratab File
                                1008534
                                [root@erp /]# ls -ltr /etc/oratab
                                -rw-r--r-- 1 root root 0 Aug 8 2012 /etc/oratab
                                • 13. Re: Linux oratab File
                                  Azar
                                  Step 1: Login as oracle user

                                  [root@cignadev ~]# su - oracle

                                  Step 2: confirm your oracle home directory and your database sid like below
                                  cignadev -- database sid
                                  /u01/oracle/product/10.2.0/db_1 -- database home directory

                                  Note this directory

                                  Step 3: edit the /etc/oratab file using vi editor

                                  [oracle@cignadev ~]$ vi /etc/oratab

                                  cignadev:/u01/oracle/product/10.2.0/db_1:N


                                  After edited save the file using command :wq
                                  • 14. Re: Linux oratab File
                                    1008534
                                    [root@erp /]# ls -alrt /etc|grep *.swp
                                    [root@erp /]#


                                    nothing happen
                                    1 2 3 Previous Next