Erroe 6 initializing SQL*Plus

I have recently installed Oracle 11g r2 on a RedHat 5.5 server. now I can't get the sqlplus to open or start, it just gives the error:

Eror 6 initializing SQL*Plus
SP2-0667:Message file sp1<lang>.msb not found
SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory

I have set and reset the ORACLE_HOME, ORACLE_BASE AND ORACLE_SID. I've exported them and can run the 'echo' command to see that they are set correctly, but still get the same error.
LVL 1
dmainternAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

slightwv (䄆 Netminder) Commented:
Did you manually add $ORACLE_HOME/bin to the PATH?

export PATH=$ORACLE_HOME/bin:$PATH
0
dmainternAuthor Commented:
Yes, now it shows up in the path, but the ./sqlplus command still returns the same error.
0
slightwv (䄆 Netminder) Commented:
If you have more than one Oracle product installed I think you are mixing versions.

Do not use the qualified path: ./sqlplus.  If it is in your path go to some non-oracle folder and try it:

cd /tmp
sqlplus
0
10 Tips to Protect Your Business from Ransomware

Did you know that ransomware is the most widespread, destructive malware in the world today? It accounts for 39% of all security breaches, with ransomware gangsters projected to make $11.5B in profits from online extortion by 2019.

dmainternAuthor Commented:
I don't have any other version of Oracle. This is the only one I've ever installed anywhere.
0
dmainternAuthor Commented:
When I try it from anywhere else it says the command connot be found.
0
slightwv (䄆 Netminder) Commented:
Post the results of:
echo $ORACLE_HOME
0
slightwv (䄆 Netminder) Commented:
>>When I try it from anywhere else it says the command connot be found.

Then ORACLE_HOME isn't set properly or $ORACLE_HOME/bin is not in the PATH
0
dmainternAuthor Commented:
The results are:
/home/sabrix/app/sabrix/product/11.2.0/dbhome_1

How would I put it into the path or set it correctly? How would I know if it was not set correctly?
0
ajones2600flCommented:
You can set those options when you log into sqlplus like this: sqlplus [your username]/[your password]@/[your hostname]/[your SID or Service name]

See if this works for you.
0
slightwv (䄆 Netminder) Commented:
Now the results of:
ls -al /home/sabrix/app/sabrix/product/11.2.0/dbhome_1/bin/sqlplus

>>How would I put it into the path or set it correctly?

re: http:#a37243905
0
slightwv (䄆 Netminder) Commented:
ajones2600fl,

How is that going to help with http:#a37243960 and the question in general?  The issue is not the command line parameters for sqlplus but the environment.
0
dmainternAuthor Commented:
The results are:
localhost:/ # ls -al /home/sabrix/app/sabrix/product/11.2.0/dbhome_1/bin/sqlplus
-rwxr-x--x 1 sabrix sabrix 9197 Dec  5 18:12 /home/sabrix/app/sabrix/product/11.2.0/dbhome_1/bin/sqlplus
0
slightwv (䄆 Netminder) Commented:
Then we are back to the PATH to resolve the command not found:

export PATH=$ORACLE_HOME/bin:$PATH
echo $PATH

If it has been set then you should not receive a command not found.
0
dmainternAuthor Commented:
Here's what I get with that:

localhost:/ # export PATH=$ORACLE_HOME/bin:$PATH
localhost:/ # echo $PATH
/home/sabrix/app/sabrix/product/11.2.0/dbhome_1/bin:/home/sabrix/app/sabrix/product/11.2.0/dbhome_1/bin:/usr/kerberos/sbin:/usr/kerberos/bin:/usr/local/bin:/usr/bin:/bin:/usr/X11R6/bin:/home/sabrix/bin

When I try just sqlplus it says command not found when I try ./sqlplus I get same error I got at the begining.
0
slightwv (䄆 Netminder) Commented:
>>when I try ./sqlplus I get same error I got at the begining.

This is because Oracle cannot find the associated files it needs.  Likely do to the same thing causing the 'command not found'.

>>When I try just sqlplus it says command not found

I'm not seeing how this is possible.  I mean I believe you but sqlplus should be found in the PATH if everything you posted is correct.

I have to ask:  You are running everything form the same shell prompt correct?


0
dmainternAuthor Commented:
No I am running all commands exceept the ./sqlplus from on shell and have another shell open for running the ./sqlplus.
0
slightwv (䄆 Netminder) Commented:
>>from on shell and have another shell open for running the ./sqlplus.
 
Run everything from the same shell.  Environment commands set from the command prompt are local to that shell.

from a NEW single shell window (then copy/paste the results):
cd /tmp
export ORACLE_HOME=/home/sabrix/app/sabrix/product/11.2.0/dbhome_1
export PATH=$ORACLE_HOME/bin:$PATH
sqlplus
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
dmainternAuthor Commented:
Awesome!! That worked!! now I have a new question real fast I hope. Where do I find my user name and password, I forgot what they where.
0
slightwv (䄆 Netminder) Commented:
>>That worked!!

You can add those export commands to your .profile of other shell startup script (like .bashrc, .cshrc, etc...). Thne they will be set for every new shell window.

>>Where do I find my user name and password, I forgot what they where.

As long as the Unix user is in the dba OS group:
sqlplus / as sysdba

alter user system identified by newPassword;
alter user sys identified by newPassword;

Same for any database user.
0
dmainternAuthor Commented:
How do I add those commands and where is the .profile? This is my first time really using Unix for anything outside of a classroom.
0
slightwv (䄆 Netminder) Commented:
>>How do I add those commands

once logged in to sqlplus.  Those are database commands.  I thought you were asking about database passwords.

>>This is my first time really using Unix for anything outside of a classroom.

I suggest you take a little time and read on on Unix basics.  For example, below you will need to use vi (or some editor).  vi is NOT easy to learn.

If you are using the GUI and the default editor, then you should be OK.

>>where is the .profile?

If the OS users home directory:
vi ~/.profile

Note: the '~' is a *nix shortcut to a users home directory.

If you are not familiar with vi then I suggest not trying it.
0
dmainternAuthor Commented:
Is there a simpler way of adding these commands to the shell start up or will have to do more research on vi.

I was asking how to find my loggin username and password, the ones that I thought I had set up during the install are not working.
0
slightwv (䄆 Netminder) Commented:
>>Is there a simpler way of adding these commands to the shell start up or

Do you have the Linux GUI installed or is everything command line?

The GUI should have a Windows-like notepad program.  Command-line, I always use vi.  I'm not sure what else might be out there.

>>I was asking how to find my loggin username and password,

Unix/OS login or Oracle database login?

0
dmainternAuthor Commented:
>>I was asking how to find my loggin username and password,

>>Unix/OS login or Oracle database login?

Oracle database login.

>>Do you have the Linux GUI installed or is everything command line?
I have the GUI installed, I've been using the cmd only because that's how the install instructions explain how to do everything. where to I find the .profile so I can add those commands? is there a certain way that they should be added?
0
slightwv (䄆 Netminder) Commented:
>>I was asking how to find my loggin username and password,

You cannot 'find' it.  If you do not remember what you set it to, you need to reset it.


>>where to I find the .profile so I can add those commands

I mentioned this above.  It is in the users home directory.  If you do not know it, look in /etc/password.

>>is there a certain way that they should be added?

You need to understand the shell startup scripts and how they work.  You just need to add them in a location in the script that makes sense.

I typically have an 'oracle' section in the scripts.

If you want ALL users to be able to use sqlplus then there is a 'system' level profile script in /etc/profile.

Again, you need a basic understanding of Unix/Linux to know what is 'best' and even then at times there is no 'best'.

You will eventually adopt a personal preference on how you like things configured.
0
dmainternAuthor Commented:
Thank you for your help!
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.