3 Replies Latest reply: Sep 6, 2011 12:58 AM by 817202 RSS

    sqlplus command not found

    817202
      Hi All,



      OS : Solaris
      Oracle Version : 10.1.0.2.0

      When i am trying to connect to database by typing sqlplus

      i am getting error

      -bash: sqlplus: command not found



      previously when i connect like that i am able to connect to database

      when i check space

      I have 32 GB Drive and free space is 288M.

      Can anyone tell me is this the space issue or any other issue.

      I logged in with Oracle User
        • 1. Re: sqlplus command not found
          Azar
          Set Bash_profile like below

          login as oracle user

          vi .bash_profile


          #Oracle Settings
          TMP=/tmp; export TMP
          TEMPDIR=$TMP; export TEMPDIR

          ORACLE_SID=orcl; export ORACLE_SID
          ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE
          ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1; export ORACLE_HOME
          PATH=/usr/sbin:$PATH; export PATH
          PATH=$ORACLE_HOME/bin:$PATH; export PATH
          LD_LIBRARY_PATH=$ORACLE_HOME/lib:/usr/lib; export LD_LIBRARY_PATH
          CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATH

          if [ $USER = "oracle" ]; then
          if [ $SHELL = "/bin/ksh" ]; then
          ulimit -p 16384
          ulimit -n 65536
          else
          ulimit -u 16384 -n 65536
          fi
          fi

          and then save it.

          now execute sqlplus command on terminal.
          • 2. Re: sqlplus command not found
            Kamran Agayev A.
            Vikas Kohli wrote:
            Hi All,



            OS : Solaris
            Oracle Version : 10.1.0.2.0

            When i am trying to connect to database by typing sqlplus

            i am getting error

            -bash: sqlplus: command not found



            previously when i connect like that i am able to connect to database

            when i check space

            I have 32 GB Drive and free space is 288M.

            Can anyone tell me is this the space issue or any other issue.

            I logged in with Oracle User
            Set the environment variable PATH correclty and make sure you've added $ORACLE_HOME/bin folder to it
            export PATH=$ORACLE_HOME/bin:$PATH
            sqlplus / as sysdba
            Kamran Agayev A.
            Oracle ACE
            - - - - - - - - - - - - - - - - - - - - -
            My Oracle Video Tutorials - http://kamranagayev.wordpress.com/oracle-video-tutorials/
            • 3. Re: sqlplus command not found
              817202
              Thanks Kamran


              Now I am able to login