2 Replies Latest reply: Jul 21, 2013 8:46 AM by John Spencer RSS

    Error 6 initializing SQL*Plus

    7ca21887-590e-4d55-a538-843222f3385e

      Hi all,

       

      I have searched through the forums and google over the past few days trying to solve the above error message I am getting when I try to login to sqlplus. The full message is:

       

      Error 6 initializing SQL*Plus

      SP2-0667: Message file sp1<lang>.msb not found

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

       

      I found lots of resources of people experiencing the very same issue but none of the solutions offered have worked for me (admittedly I could potentially have misunderstood them as i'm new to Solaris and oracle 11g R2)

       

      I have installed Solaris 11 and Oracle 11g Release 2. I am accessing the server through MobaXterm.

       

      Bash profile file contents:

       

      case ${SHELL} in

      *bash)

          typeset +x PS1="\u@\h:\w\\$ "

      B    ;;

      esac

       

       

      umask 022

      uBlimit -s 32768

      ulimit -n 4096

      ORACLE_BASE=/u01/app/oracle

      ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_1

      ORACLE_SID=orcl

      ORACLE_UNQNAME=orcl

      ORACLE_HOSTNAME=192.x.x.x

      PABTH=$ORACLE_HOME/bin:$PATH

      LANG="en_US.UTF-8"

      export LANG

       

      ##TZ=Etc/GMT+1

       

      The above isn't exactly how it was when I first installed and set everything up due to editing it to try and see if I can get things working.

       

      listener.ora file is

       

      # listener.ora Network Configuration File: /u01/app/oracle/product/11.2.0/db_1/networ$

      # Generated by Oracle configuration tools.

       

       

      LISTENER =

        (DESCRIPTION_LIST =

          (DESCRIPTION =

            (ADDRESS = (PROTOCOL = TCP)(HOST = 192.x.x.x)(PORT = 1521))

            (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))

          )

        )

       

       

       

       

      ADR_BASE_LISTENER = /u01/app/oracle

       

       

      SID_LIST_LISTENER=

        (SID_LIST=

          (SID_DESC=

            (GLOBAL_DBNAME=quill.com)

            (ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_1)

            (SID_NAME=orcl))

          (SID_DESC=

            (SID_NAME=orcl)

            (ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_1)

            ))

       

      tnsnames.ora contents

       

      orcl =

        (DESCRIPTION =

          (ADDRESS_LIST =

            (ADDRESS = (PROTOCOL = TCP)(HOST = 192.x.x.x)(PORT = 1521))

          )

          (CONNECT_DATA =

            (SERVER = SHARED)

            (SERVICE_NAME = orcl)

          )

        )

       

      If I try connecting through sqldeveloper (which is the true endgame) I get the following error:

       

      The network Adaptor could not establish the connection.

       

      Hopefully the above is enough information.