• 15. Re: COMMAND NOT FOUND - ORACLE GRID
      Ujjwal Rana

      [grid@storage Desktop]$ . oraenv

      ORACLE_SID = [+ASM] ? +ASM

      ORACLE_BASE environment variable is not being set since this

      information is not available for the current user ID grid.

      You can set ORACLE_BASE manually if it is required.

      [grid@storage Desktop]$

       

      AND THIS ONE TOO :-

       

      [grid@storage Desktop]$ source ~/.bash_profile

      [grid@storage Desktop]$ echo $ORACLE_BASE

      /u01/app/grid

       

      [grid@storage Desktop]$ sqlplus / as sysdba

      bash: sqlplus: command not found

      [grid@storage Desktop]$

      • 16. Re: COMMAND NOT FOUND - ORACLE GRID
        Aman....

        Ujjwal Rana wrote:

         

        [grid@storage Desktop]$ . oraenv

        ORACLE_SID = [+ASM] ? +ASM

        ORACLE_BASE environment variable is not being set since this

        information is not available for the current user ID grid.

        You can set ORACLE_BASE manually if it is required.

        [grid@storage Desktop]$

        Did you do the installation using this user-GRID or the Oracle user ?

         

        What happens when you manually set the parameters ORACLE_HOME and ORACLE_BASE?

         

        Aman....

        • 17. Re: COMMAND NOT FOUND - ORACLE GRID
          Aman....

          Ujjwal Rana wrote:

           

          You might want to see this

           

          [oracle@storage ~]$ sqlplus / as sysdba

           

          SQL*Plus: Release 11.2.0.1.0 Production on Sun Dec 27 15:23:43 2015

           

          Copyright (c) 1982, 2009, Oracle.  All rights reserved.

           

          Connected to an idle instance.

           

          SQL>

          This tells nothing but only this that either you are trying to connect to a wrong SID or your DB is not yet started.

           

          Aman....

          • 18. Re: COMMAND NOT FOUND - ORACLE GRID
            Ujjwal Rana

            This is what it happens

             

            [grid@storage Desktop]$ vi ~/.bash_profile

            [grid@storage Desktop]$ source ~/.bash_profile

            [grid@storage Desktop]$ echo $ORACLE_BASE

            /u01/app/grid

            [grid@storage Desktop]$ sqlplus / as sysdba

            bash: sqlplus: command not found

            [grid@storage Desktop]$ asmca

            bash: asmca: command not found

            [grid@storage Desktop]$ asmcmd

            bash: asmcmd: command not found

            • 19. Re: COMMAND NOT FOUND - ORACLE GRID
              Aman....

              I didn't ask you to do this. I asked -one, have you done the installation of ASM using GRID user and two , what happens when you manually set both the environment variables. We can't see what you are doing so please follow what you are suggested to do.

               

              Aman....

              • 20. Re: COMMAND NOT FOUND - ORACLE GRID
                Ujjwal Rana

                yes i did the installation of ASM using GRID user. However i have paste the oraenv output for both grid and oracle user below. This time i have paste the output doing manually this time.

                 

                ok for grid as per your advise i did it manually here is the oraenv output

                 

                [grid@storage Desktop]$ . oraenv

                ORACLE_SID = [+ASM] ? +ASM

                ORACLE_BASE environment variable is not being set since this

                information is not available for the current user ID grid.

                You can set ORACLE_BASE manually if it is required.

                [grid@storage Desktop]$ export ORACLE_BASE=/u01/app/grid

                [grid@storage Desktop]$ echo $ORACLE_BASE

                /u01/app/grid

                [grid@storage Desktop]$

                [grid@storage Desktop]$ sqlplus / as sysdba

                bash: sqlplus: command not found

                 

                And for oracle user here is the oraenv output

                 

                [oracle@storage ~]$ . oraenv

                ORACLE_SID = [orcl] ? orcl

                The Oracle base remains unchanged with value /u01/app/oracle

                [oracle@storage ~]$

                [oracle@storage ~]$ sqlplus / as sysdba

                 

                SQL*Plus: Release 11.2.0.1.0 Production on Sun Dec 27 15:57:26 2015

                 

                Copyright (c) 1982, 2009, Oracle.  All rights reserved.

                 

                Connected to an idle instance.

                 

                SQL>

                • 21. Re: COMMAND NOT FOUND - ORACLE GRID
                  Ujjwal Rana

                  Hi Pavan,

                  I have past the oraenv output for grid and oracle user on the last comment. Please advise.

                  • 22. Re: COMMAND NOT FOUND - ORACLE GRID
                    Aman....

                    Switch the user using su - grid. Then set both the environment variables ORACLE_BASE and ORACLE_HOME and show us the output. Do not  miss the dash(-) while switching to the GRID user.

                     

                    Also , show the output of

                    ls -l $ORACLE_HOME/inventory/ContentsXML/oraclehomeproperties.xml


                    Aman....

                    • 23. Re: COMMAND NOT FOUND - ORACLE GRID
                      Ujjwal Rana

                      [oracle@storage ~]$ su - grid

                      Password:

                      [grid@storage ~]$ export ORACLE_BASE=/u01/app/grid

                      [grid@storage ~]$ export ORACLE_HOME=/u01/app/11.2.0/grid

                      [grid@storage ~]$ ls -l $ORACLE_HOME/inventory/ContentsXML/oraclehomeproperties.xml

                      ls: cannot access /u01/app/11.2.0/grid/inventory/ContentsXML/oraclehomeproperties.xml: Permission denied

                      [grid@storage ~]$

                      • 24. Re: COMMAND NOT FOUND - ORACLE GRID
                        Pavan Kumar

                        Hi,

                         

                        Does your asm is up and running ? ps -ef | grep pmon

                        Check what Aman posted, a big doubt whether have you done installation correctly or not

                         

                        - Pavan Kumar N

                        • 25. Re: COMMAND NOT FOUND - ORACLE GRID
                          Ujjwal Rana

                          It was working perfectly before.

                           

                          [grid@storage ~]$ ps -ef | grep pmon

                          grid      6241  6058  0 16:12 pts/1    00:00:00 grep pmon

                          [grid@storage ~]$

                          • 26. Re: COMMAND NOT FOUND - ORACLE GRID
                            Aman....

                            Ujjwal Rana wrote:

                             

                            [oracle@storage ~]$ su - grid

                            Password:

                            [grid@storage ~]$ ls -l $ORACLE_HOME/inventory/ContentsXML/oraclehomeproperties.xml

                            ls: cannot access /u01/app/11.2.0/grid/inventory/ContentsXML/oraclehomeproperties.xml: Permission denied

                            [grid@storage ~]$

                            So you have messed up something somewhere. If as you said, the installation is correctly done as GRID user, it should had the permission to do the listing of the file.

                             

                            Execute the following commands,

                            #chmod 666 $ORACLE_HOME/inventory/ContentsXML/oraclehomeproperties.xml

                            #chmod 775 /u01/app/11.2.0/grid/inventory/ContentsXML/

                            And show us that you have the ASM instance running  using,

                             

                            ps -ef| grep pmon

                             

                            Aman....

                            • 27. Re: COMMAND NOT FOUND - ORACLE GRID
                              Aman....

                              Ujjwal Rana wrote:

                               

                              It was working perfectly before.

                               

                              [grid@storage ~]$ ps -ef | grep pmon

                              grid      6241  6058  0 16:12 pts/1    00:00:00 grep pmon

                              [grid@storage ~]$

                              Before when? You are not having proper permissions for the user GRID . I doubt that your ASM instance worked fine ever. Execute the commands that I mentioned in my last reply and re-execute the . oraenv and share the output here.

                               

                              Aman....

                              • 28. Re: COMMAND NOT FOUND - ORACLE GRID
                                Ujjwal Rana

                                [root@storage ~]# chmod 666 $ORACLE_HOME/inventory/ContentsXML/oraclehomeproperties.xml

                                chmod: cannot access `/inventory/ContentsXML/oraclehomeproperties.xml': No such file or directory

                                [root@storage ~]# chmod 775 /u01/app/11.2.0/grid/inventory/ContentsXML/

                                [root@storage ~]# ps -ef| grep pmon

                                root      6774  6703  0 16:21 pts/1    00:00:00 grep pmon

                                [root@storage ~]#

                                 

                                [grid@storage ~]$ ps -ef| grep pmon

                                grid      6880  6058  0 16:23 pts/1    00:00:00 grep pmon

                                [grid@storage ~]$

                                 

                                [oracle@storage ~]$ ps -ef| grep pmon

                                oracle    6954  6930  0 16:24 pts/1    00:00:00 grep pmon

                                [oracle@storage ~]$

                                 

                                BUT GETTING INSIDE THIS LOCATIONS oraclehomeproperties.xml FILE DOES EXIST here is an output

                                [root@storage ContentsXML]# pwd

                                /u01/app/11.2.0/grid/inventory/ContentsXML

                                [root@storage ContentsXML]#

                                 

                                [root@storage ContentsXML]# ls

                                comps.xml  config.xml  ConfigXML  libs.xml  oraclehomeproperties.xml

                                [root@storage ContentsXML]#

                                • 29. Re: COMMAND NOT FOUND - ORACLE GRID
                                  Aman....

                                  You are not following what you are being told to do.

                                   

                                  [root@storage ~]# chmod 666 $ORACLE_HOME/inventory/ContentsXML/oraclehomeproperties.xml

                                  chmod: cannot access `/inventory/ContentsXML/oraclehomeproperties.xml': No such file or directory

                                  The error is quite self-explanatory because ROOT doesn't have any ORACLE_HOME variable set. So you need to give the absolute PATH and if you have noticed, I had typed in the absolute path in my last reply.  Also show us the output of the LS command as asked before.

                                   

                                  Aman....