This discussion is archived
2 Replies Latest reply: Jul 21, 2013 7:48 AM by Zack.L RSS

Error 6 initializing SQL*Plus

7ca21887-590e-4d55-a538-843222f3385e Newbie
Currently Being Moderated

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.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points