?
Solved

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

Posted on 2006-11-09
6
Medium Priority
?
10,182 Views
Last Modified: 2013-12-11
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:.

0
Comment
Question by:Omega002
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 2
6 Comments
 
LVL 7

Expert Comment

by:Daniel Stanley
ID: 17908323
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
 
LVL 7

Expert Comment

by:Daniel Stanley
ID: 17908411
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
 

Author Comment

by:Omega002
ID: 17910259
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
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 7

Expert Comment

by:Daniel Stanley
ID: 17910286
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
 

Author Comment

by:Omega002
ID: 17910368
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
 
LVL 7

Accepted Solution

by:
Daniel Stanley earned 1500 total points
ID: 17928372
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

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Working with Network Access Control Lists in Oracle 11g (part 2) Part 1: http://www.e-e.com/A_8429.html Previously, I introduced the basics of network ACL's including how to create, delete and modify entries to allow and deny access.  For many…
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.

765 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question