Solved

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

Posted on 2006-11-09
6
10,073 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
  • 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
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
Space Delimited Sql File 4 71
Salary Amount Format 13 56
Oracle Syntax 8 42
unable to get sorting resultset 15 48
Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
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 setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…

743 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now