1 2 3 4 Previous Next 95 Replies Latest reply on Jan 8, 2016 10:02 AM by Ujjwal Rana Go to original post
      • 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....

                                    1 2 3 4 Previous Next