Solved

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

Posted on 2006-11-09
6
10,160 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
Creating Instructional Tutorials  

For Any Use & On Any Platform

Contextual Guidance at the moment of need helps your employees/users adopt software o& achieve even the most complex tasks instantly. Boost knowledge retention, software adoption & employee engagement with easy solution.

 
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 500 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

Technology Partners: 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

Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
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 recover a database from a user managed backup

690 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