5 Replies Latest reply: Sep 28, 2013 9:43 AM by EdStevens RSS

    Absurd Startup Problems

    406c9deb-3b62-417a-9019-c66a3ca44be2

      Installed Oracle 11g on Red Hat Enterprise Linux 6.4

       

      Background:

      I have...laughable linux knowledge,  combed through a lot of the google results, and still have nothing

      I get this message trying to start sqlplus (have tried ./sqlplus / as sysdba; gives same message)

      Error 6 initializing SQL*Plus

      Message file sp1<lang>.msb not found

      SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory

       

      *Que in the laughable linux knowledge*  My PATH:

      /usr/lib64/qt-3.3/bin:/usr/local/bin:/usr/bin:/bin:/usr/local/sbin:/usr/sbin:/sbin:/home/victor/bin:$ORACLE_BASE/product/11.2.0/dbhome_1/bin

      ORACLE_HOME =  $ORACLE_BASE/product/11.2.0/dbhome_1

      ORACLE_BASE=HOME/app/oracle

      ORACLE_SID=orcl

       

      I have the .msb file

      I've set my ORACLE_HOME...did I set it correctly? If I didn't (and I know this is a very newbie question) may you please show me how?

       

      Even on the very off chance that I did set it correctly. I still get the same error.

      If the solution is a "simple" 'you need to set in bash.profile or you need to set this or w/e'... I can assure you that right now my mind is fuming and therefore I probably already tried the "simple" solution to the above mentioned PATH problem (I just don't remember having tried what).

      It is worth mentioning that even as superuser (#) I'm having trouble executing...everything (./bash....... ./bashrc ..... .listener.ora <-my findings indicate that the Error 6 problem may be connected with this and believe me that is whole other can of miserable worms on my system in order to set that)

      Nonetheless, please please help.

        • 1. Re: Absurd Startup Problems
          DK2010

          Hi,

          as per Your setting your ORCLE_HOME value depend on the ORACLE_BASE value and  seems your set the wrong value for ORACLE_BASE.

          it should be something like this if you have

          echo $HOME

          export ORACLE_BASE=$HOME/app/oracle

          echo $ORACLE_BASE

          export ORACLE_HOME =$ORACLE_BASE/product/11.2.0/dbhome_1

          echo $ORACLE_HOME

          export ORACLE_SID=orcl

          echo $ORACLE_SID

          export PTAH=$ORACLE_HOME/bin:$PATH

           

          verify the result from above  what echo print.

           

          HTH

          • 2. Re: Absurd Startup Problems
            Paul M.

            ORACLE_HOME =  $ORACLE_BASE/product/11.2.0/dbhome_1

            ORACLE_BASE=HOME/app/oracle

            You set ORACLE_BASE after ORACLE_HOME. Did you try the opposite ?

             

            Of course the same is valid for PATH.

            • 3. Re: Absurd Startup Problems
              406c9deb-3b62-417a-9019-c66a3ca44be2

              Thanks for the reply PaulM.

              Thanks DK2010. It worked but now there's another problem.

              Username: SYS Password: CHANGE_ON_INSTALL gives

              ERROR:

              ORA-01034: ORACLE not available

              ORA-27101: shared memory realm does not exist

              Linux-x86_64 Error: 2: No such file or director

               

              "ORA-01034 and ORA-27101 normally indicate that the database instance you're attempting to connect to is shut down and that you're not connected as a user who has permission to start it up."

               

              How would I go checking?

              Do I have to reinstall...?

               

              Note: I've installed this on a laptop so I can practice for a DB Architecture/Backup & Recovery class. So, in regards to ORA_01034, does that mean I can't run sqlplus since there IS no DB instance to connect to?

               

              Again, sorry for the newbie questions. The info IS helpful though even if I need to reinstall.

              • 4. Re: Absurd Startup Problems
                DK2010

                Hi,

                >>How would I go checking?

                ps -ef|grep pmon

                check the process for orcl is running or not or DB name you mentioned during database creation

                >>Do I have to reinstall...?

                Not Required, if your installation was successful,

                 

                show the result here

                • 5. Re: Absurd Startup Problems
                  EdStevens

                  406c9deb-3b62-417a-9019-c66a3ca44be2 wrote:

                   

                  Thanks for the reply PaulM.

                  Thanks DK2010. It worked but now there's another problem.

                  Username: SYS Password: CHANGE_ON_INSTALL gives

                  ERROR:

                  ORA-01034: ORACLE not available

                  ORA-27101: shared memory realm does not exist

                  Linux-x86_64 Error: 2: No such file or director

                   

                  "ORA-01034 and ORA-27101 normally indicate that the database instance you're attempting to connect to is shut down and that you're not connected as a user who has permission to start it up."

                   

                  How would I go checking?

                  Do I have to reinstall...?

                   

                  Note: I've installed this on a laptop so I can practice for a DB Architecture/Backup & Recovery class. So, in regards to ORA_01034, does that mean I can't run sqlplus since there IS no DB instance to connect to?

                   

                  Again, sorry for the newbie questions. The info IS helpful though even if I need to reinstall.

                   

                  there IS no DB instance to connect to

                   

                  What, exactly, did you install?

                  Obviously, you must have a database to work with.  SQLPlus is just a client interface TO a database.