2 Replies Latest reply on Jun 14, 2019 8:56 PM by Dude!

    /etc/oratab is missing

    Jhil

      Dear Experts ,

       

      The file /etc/oratab is missing

      I suspect root.sh script may not executed by Unix team.

      In this case , copying the missing file from one node to another node is recommended or NOT ?

      SORACLE_HOME is not yet set for oracle user.

      I meant to following command does not provide oitpou.

       

      $echo $ORACLE_HOME

       

      2 Instances are running

      Kindly share your thoughts to fix this

       

      OS : RHEL 7.5

      Regards

        • 1. Re: /etc/oratab is missing
          EdStevens

          Jhil wrote:

           

          Dear Experts ,

           

          The file /etc/oratab is missing

          I suspect root.sh script may not executed by Unix team.

          In this case , copying the missing file from one node to another node is recommended or NOT ?

          SORACLE_HOME is not yet set for oracle user.

          I meant to following command does not provide oitpou.

           

          $echo $ORACLE_HOME

           

          2 Instances are running

          Kindly share your thoughts to fix this

           

          OS : RHEL 7.5

          Regards

          I don't think the root.sh script has anything to do with /etc/oratab.  If it was not run, you will have other problems due to incorrect permissions on some files under $ORACLE_BASE and $ORACLE_HOME.

           

          As you should know, /etc/oratab is just a simple text file, that is often modified by hand with a simple text editor. THus, no problem with copying one from another server, though the values very probably would not be correct.  But at least you'd have it as a template.  Have you actually created a database on this server?  I know that DBCA creates/modifies /etc/oratab, and having not yet created a database is the most likely reason I can think of for not having the file.

           

          As for $ORACLE_HOME not being set .. just like any other environment variable, it is up to you to set it  in your session.  This is usually done in your .bash_logon script, or by use of 'oraenv'.

          1 person found this helpful
          • 2. Re: /etc/oratab is missing
            Dude!

            Among other things, root.sh creates /etc/oratab, but it will be empty.

             

            https://docs.oracle.com/en/database/oracle/oracle-database/19/rilin/about-oratab-configuration-for-oracle-rac.html#GUID-…

             

            So this isn't going to help you. I suggest to restore the file from a system backup.

            You do have a backup of /etc ?! What else is missing?

             

            I think you can copy /etc/oratab from another mode but you have to modify the instance names to include the appropriate node number and verify ORACLE_HOME.

             

            For example:

             

            $ srvctl status database -d ORCL

            Instance ORCL_1 is running on node node01

            Instance ORCL_2 is running on node node02

             

            Btw, you've posted in the wrong forum.

            1 person found this helpful