Link to home
Start Free TrialLog in
Avatar of Omega002
Omega002Flag for Afghanistan

asked on

$ sqlplus '/as sysdba 'Message file sp1<lang>.msb not found Error 6 initializing SQL*Plus

Greetings,

I installed Oracle 10g Grid Control software on a Sun Solaris Sparc Server and everything installed successful but I am getting this error when I attempt to set my side and the other error when I attempt to launch  sqlplus. My .profile for the oracle os user is listed below.

First Error:
$ export ORACLE_SID=omsrep
ORACLE_SID=omsrep: is not an identifier
Second Error:
$ sqlplus '/as sysdba'
Message file sp1<lang>.msb not found
Error 6 initializing SQL*Plus


############################
#oracle .profile           #
############################
umask 022
ORACLE_BASE=/oradata
ORACLE_HOME=/oradata/oracle/product/10.1.0/db_1
TEMP=/tmp
TMPDIR=/tmp
ORACLE_SID=omsrep
PATH=$ORACLE_HOME:$ORACLE_HOME/bin:$ORACLE_HOME/sqlplus/mesg:$PATH:.

Avatar of Daniel Stanley
Daniel Stanley
Flag of United States of America image

does not look like you're exporting those environment variables.

$ echo $ORACLE_HOME
if blank then check your .profile file.

should look like:
# .profile #
ORACLE_SID=orcl
export ORACLE_SID
ORACLE_BASE=/orasw/app/oracle
export ORACLE_BASE
# [ Oracle home product directory ]
ORACLE_HOME=${ORACLE_BASE}/product/9.2.0
export ORACLE_HOME


good luck,
daniels
nevermind,  just check all of your environment variables..  one of them is causing the problem..

here is my solaris 9 .profile file and i know it works.

testwdb2*/home/oracle
$ cat .profile
#!/bin/ksh
#
#   JWH 2001 default profile for Oracle
# Bourne/Korn shell profile for the "oracle" user
#
# [ base directory for Oracle software install ]
clear
echo Today is `date +%A` - `date +%B` `date +%d`, `date +%Y`
echo The time is `date +%H`:`date +%M`

PATH=/usr/bin:/usr/sbin:/usr/ccs/bin:/usr/ucb:/etc:/usr/local/bin
export PATH
#Prompt
#
PS1="
`hostname`*\${PWD}
$ "
#

umask 022
#
#    ORACLE VARIABLES
#
#ORACLE_SID=testdb
ORACLE_SID=orcl
export ORACLE_SID
ORACLE_BASE=/orasw/app/oracle
export ORACLE_BASE
# [ Oracle home product directory ]
ORACLE_HOME=${ORACLE_BASE}/product/9.2.0
export ORACLE_HOME
ORACLE_DOC=$ORACLE_HOME/doc
export ORACLE_DOC
ORACLE_VAR=/var/opt/oracle;export ORACLE_VAR
# [ library path ]
LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:${ORACLE_HOME}/lib:/usr/dt/lib
export LD_LIBRARY_PATH
#
# [ terminal type ]
ORACLE_TERM=xsun5;export ORACLE_TERM
#
# [ Directory search path ]
#  Make sure that the /usr/ccs/bin is before the /usr/ucb
#
PATH=${PATH}:${ORACLE_HOME}/bin:/usr/bin:/etc:/usr/ccs/bin:/usr/openwin/bin:/usr/ucb
export PATH

# [ Language variable ]
NLS_LANG=american_america.WE8ISO8859P1;export NLS_LANG
ORA_NLS32=$ORACLE_HOME/ocommon/nls/admin/data;export ORA_NLS32

# [ Temporary directory ]
TMPDIR=/tmp;export TMPDIR

# [ Text editor preference ]
EDITOR=vi;export EDITOR
VISUAL=vi; export VISUAL

#alias custom
alias ll='ls -la'
alias cl='clear'
alias la='ls -a'
alias e='export'
alias catn='cat -n'
alias l='ls -a'

stty erase ^h
stty istrip

unset TWO_TASK


Avatar of Omega002

ASKER

I reinstalled everything and the install was successful but the oracle unix account does not have a home directory (/home/oracle). the /home directory is empty so how would I fix this problem at this point? Will I have to start over again or is there a way I can create the oracle home directory (/home/oracle) and create a .profile within that directory?
modify the /etc/passwd file to change you oracle users home directory to '/oradata' or something like that. then place the .profile file in that directory.

that should do the trick; that or create the /home/oracle directory from the root user account.

good luck,
daniels

well I did that and I logged on as root and I was still unable to create the oracle directory in the home directory(/home) and I am try to do this(/home/oracle). Listed below is my oracle home and oracle base directory path

$ORACLE_HOME=/oms-db/u01/app/oracle/product/10.1.0/db_1
ASKER CERTIFIED SOLUTION
Avatar of Daniel Stanley
Daniel Stanley
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial