Omega002
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/oracl e/product/ 10.1.0/db_ 1
TEMP=/tmp
TMPDIR=/tmp
ORACLE_SID=omsrep
PATH=$ORACLE_HOME:$ORACLE_ HOME/bin:$ ORACLE_HOM E/sqlplus/ mesg:$PATH :.
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/oracl
TEMP=/tmp
TMPDIR=/tmp
ORACLE_SID=omsrep
PATH=$ORACLE_HOME:$ORACLE_
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:/u sr/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/ora cle
export ORACLE_BASE
# [ Oracle home product directory ]
ORACLE_HOME=${ORACLE_BASE} /product/9 .2.0
export ORACLE_HOME
ORACLE_DOC=$ORACLE_HOME/do c
export ORACLE_DOC
ORACLE_VAR=/var/opt/oracle ;export ORACLE_VAR
# [ library path ]
LD_LIBRARY_PATH=${LD_LIBRA RY_PATH}:$ {ORACLE_HO ME}/lib:/u sr/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/b in:/usr/op enwin/bin: /usr/ucb
export PATH
# [ Language variable ]
NLS_LANG=american_america. WE8ISO8859 P1;export NLS_LANG
ORA_NLS32=$ORACLE_HOME/oco mmon/nls/a dmin/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
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:/u
export PATH
#Prompt
#
PS1="
`hostname`*\${PWD}
$ "
#
umask 022
#
# ORACLE VARIABLES
#
#ORACLE_SID=testdb
ORACLE_SID=orcl
export ORACLE_SID
ORACLE_BASE=/orasw/app/ora
export ORACLE_BASE
# [ Oracle home product directory ]
ORACLE_HOME=${ORACLE_BASE}
export ORACLE_HOME
ORACLE_DOC=$ORACLE_HOME/do
export ORACLE_DOC
ORACLE_VAR=/var/opt/oracle
# [ library path ]
LD_LIBRARY_PATH=${LD_LIBRA
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
export PATH
# [ Language variable ]
NLS_LANG=american_america.
ORA_NLS32=$ORACLE_HOME/oco
# [ 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
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
that should do the trick; that or create the /home/oracle directory from the root user account.
good luck,
daniels
ASKER
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/a pp/oracle/ product/10 .1.0/db_1
$ORACLE_HOME=/oms-db/u01/a
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
$ echo $ORACLE_HOME
if blank then check your .profile file.
should look like:
# .profile #
ORACLE_SID=orcl
export ORACLE_SID
ORACLE_BASE=/orasw/app/ora
export ORACLE_BASE
# [ Oracle home product directory ]
ORACLE_HOME=${ORACLE_BASE}
export ORACLE_HOME
good luck,
daniels