$ 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:.

Omega002Asked:
Who is Participating?
 
Daniel StanleyConnect With a Mentor Database engineerCommented:
if you are unable to create a /home/oracle directory as root user for your oracle user then you have something wrong with your os and permissions; seek help from one of your SA's.

that looks like sort of a crazy mount point '/oms-db/' make sure that is correct as well.

good luck,
daniels
0
 
Daniel StanleyDatabase engineerCommented:
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
0
 
Daniel StanleyDatabase engineerCommented:
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


0
Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

 
Omega002Author Commented:
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?
0
 
Daniel StanleyDatabase engineerCommented:
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

0
 
Omega002Author Commented:
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
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.