2 Replies Latest reply: Feb 18, 2012 9:11 PM by EdStevens RSS

    Getting the error "Message file sp1<lang>.msb not found" on Oracle 10 gR2 o

    917623
      When I am trying to integrate Oracle 10g R2 with Data Protector, I am getting the following error:
      RETVAL8106
      Process exit code: 1, Signal: 0
      SQLPLUS PID=2275

      CHILDERROR:0
      Process exit code: 0, Signal: 0
      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

      The ORACLE_HOME path is set and we are able to connect to the database also through sqlplus.

      -bash-3.2$ echo $ORACLE_HOME
      /orahome/oracle/product/dbhome
      -bash-3.2$ which sqlplus
      /orahome/oracle/product/dbhome/bin/sqlplus
      -bash-3.2$ export ORACLE_SID=IPR1

      -bash-3.2$ sqlplus "/as sysdba"

      SQL*Plus: Release 10.2.0.1.0 - Production on Wed Feb 15 00:33:49 2012

      Copyright (c) 1982, 2005, Oracle. All rights reserved.

      Connected to:
      Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
      With the Partitioning, Real Application Clusters, OLAP and Data Mining options

      SQL> select * from v$instance;

      INSTANCE_NUMBER INSTANCE_NAME
      --------------- ----------------
      HOST_NAME
      ----------------------------------------------------------------
      VERSION STARTUP_T STATUS PAR THREAD# ARCHIVE LOG_SWITCH_WAIT
      ----------------- --------- ------------ --- ---------- ------- ---------------
      LOGINS SHU DATABASE_STATUS INSTANCE_ROLE ACTIVE_ST BLO
      ---------- --- ----------------- ------------------ --------- ---
      1 IPR1
      xxxxxx.ind.hp.com
      10.2.0.1.0 09-FEB-12 OPEN YES 1 STARTED
      ALLOWED NO ACTIVE PRIMARY_INSTANCE NORMAL NO

      The Profile file is also set properly. Please help me what can be done to resolve this issue.

      Appreciate your help. Thanks in Advance.
        • 1. Re: Getting the error "Message file sp1<lang>.msb not found" on Oracle 10 gR2 o
          19426
          Since native environment works I would say the problem is in the Data Protector layer. I recommend you move to a HP support forum:

          http://h30499.www3.hp.com/t5/Data-Protector-Support-and-News/bd-p/itrc-251
          • 2. Re: Getting the error "Message file sp1<lang>.msb not found" on Oracle 10 gR2 o
            EdStevens
            914620 wrote:
            When I am trying to integrate Oracle 10g R2 with Data Protector, I am getting the following error:
            RETVAL8106
            Process exit code: 1, Signal: 0
            SQLPLUS PID=2275

            CHILDERROR:0
            Process exit code: 0, Signal: 0
            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

            The ORACLE_HOME path is set and we are able to connect to the database also through sqlplus.
            But is the session environment when you "prove" it with sqlplus the same session environment that is running your Data Protector process. Remember, environment variables are set at the session level. One common error is scheduling jobs on cron ... where the user's .profile (or .bash_profile) is NOT executed, as it is when you actually log on and establish a session in your own right.
            -bash-3.2$ echo $ORACLE_HOME
            /orahome/oracle/product/dbhome
            -bash-3.2$ which sqlplus
            /orahome/oracle/product/dbhome/bin/sqlplus
            -bash-3.2$ export ORACLE_SID=IPR1

            -bash-3.2$ sqlplus "/as sysdba"

            SQL*Plus: Release 10.2.0.1.0 - Production on Wed Feb 15 00:33:49 2012

            Copyright (c) 1982, 2005, Oracle. All rights reserved.

            Connected to:
            Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
            With the Partitioning, Real Application Clusters, OLAP and Data Mining options

            SQL> select * from v$instance;

            INSTANCE_NUMBER INSTANCE_NAME
            --------------- ----------------
            HOST_NAME
            ----------------------------------------------------------------
            VERSION STARTUP_T STATUS PAR THREAD# ARCHIVE LOG_SWITCH_WAIT
            ----------------- --------- ------------ --- ---------- ------- ---------------
            LOGINS SHU DATABASE_STATUS INSTANCE_ROLE ACTIVE_ST BLO
            ---------- --- ----------------- ------------------ --------- ---
            1 IPR1
            xxxxxx.ind.hp.com
            10.2.0.1.0 09-FEB-12 OPEN YES 1 STARTED
            ALLOWED NO ACTIVE PRIMARY_INSTANCE NORMAL NO

            The Profile file is also set properly. Please help me what can be done to resolve this issue.

            Appreciate your help. Thanks in Advance.