Kbase P134860: Starting SQL*Plus fails with: Error 6 initializing SQL*Plus Message file sp1<lang>.msb not found SP
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
25/06/2009 |
|
Status: Unverified
SYMPTOM(s):
Starting SQL*Plus fails with the following messages:
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
Connecting Progress client to Oracle 10G instance using OpenEdge DataServer for Oracle fails
ORACLE error see "ORACLE Error Messages and Codes Manual". (1252)
Oracle error -1019 see "ORACLE Error Messages and Code manual". (1252)
** unable to allocate memory in the user side
Failed to connect to ORACLE database . (1451)
Failed to connect to ORACLE database <database name>. (1451)
BROKER: The server could not open the foreign database. (1891)
From the dataserv.lg file:
<time stamp> SERVER : BROKER: The server could not open the foreign database. (1891)
Problem accessing Oracle 10G database with the Oracle DataServer
FACT(s) (Environment):
All Supported Operating Systems
OpenEdge 10.x
Progress 9.x
ORACLE_HOME environment variable is set correctly
UNIX
Oracle DataServer
Oracle 10g
CAUSE:
Oracle installer issue is causing problems accessing some directories/files for other users than the installer account.
FIX:
Change the permissions of the following directories and files using the chmod command:
chmod 755 $ORACLE_HOME/sqlplus
chmod 755 $ORACLE_HOME/sqlplus/mesg
chmod 755 $ORACLE_HOME/sqlplus/mesg/sp1us.msb
chmod 755 $ORACLE_HOME
ls
chmod 755 $ORACLE_HOME
ls/data
chmod 755 $ORACLE_HOME
ls/data/lx1boot.nlb
chmod 755 $ORACLE_HOME/oracore
chmod 755 $ORACLE_HOME/oracore/zoneinfo
chmod 755 $ORACLE_HOME/oracore/zoneinfo/timezlrg.dat