Unable to start SQLPLUS

UNIX Solaris
1

I upgraded my system to Solaris 11 and everything works but I can't start my database or what (I am a noob).

OS:

-bash-4.1$ uname -a
SunOS Solaris11 5.11 11.0 i86pc i386 i86pc
-bash-4.1$ isainfo -kv
64-bit amd64 kernel modules

Database version is 11g2 Enterprise edition, installed on ZFS file system.

When I try to start sqlplus command I get

-bash-4.1$ ./sqlplus /as sysdba
Error 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

Bash profile for oracle user looks

-bash-4.1$ cat $HOME/.bash_profile
ORACLE_BASE=/opt/oracle
ORACLE_HOME=$ORACLE_BASE/112/baza
ORACLE_SID=ORA11GR2
LD_LIBRARY_PATH=$ORACLE_HOME/baza/software/lib
PATH=$PATH:/usr/local/bin:$ORACLE_HOME/baza/software/bin

export ORACLE_BASE ORACLE_HOME ORACLE_SID LD_LIBRARY_PATH PATH

I tried to solve problem myself but > :wall:

Thanks

2

Try sourcing .bash_profile first (it's read automatically only upon login):

. "$HOME"/.bash_profile
sqlplus / as sysdba

Please post the complete output if it still doesn't work.

If I recall correctly, you'll need to relink the Oracle executable files after an OS upgrade ...

3

Thanks for quick response, here is output, same errors

oracle@Solaris11:/opt/oracle/112/baza/software/bin$ . "$HOME"/.bash_profile
oracle@Solaris11:/opt/oracle/112/baza/software/bin$ ./sqlplus /as sysdba
Error 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
4

Could you also post the output of the following commands:

set | fgrep ORA
env | fgrep ORA
5 
ORACLE_BASE=/opt/oracle
ORACLE_HOME=/opt/oracle/112/baza
ORACLE_SID=ORA11GR2
oracle@Solaris11:/opt/oracle/112/baza/software/deinstall$ env | fgrep ORA
ORACLE_SID=ORA11GR2
ORACLE_BASE=/opt/oracle
ORACLE_HOME=/opt/oracle/112/baza
6
  1. Your ORACLE_HOME seems to be incorrectly set: /opt/oracle/112/baza instead of /opt/oracle/112/baza/software .
  2. You'll need to relink the Oracle executable files after an OS upgrade (see How to Relink Oracle Database Software on UNIX (Doc ID 131321.1) on MOS).
7

I reinstalled database and I can now connect to sqlplus

oracle@Solaris11:/opt/oracle/112/baza/bin$ ./sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Mon Nov 28 13:07:36 2011

Copyright (c) 1982, 2009, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, Oracle Label Security, OLAP, Data Mining,
Oracle Database Vault and Real Application Testing options

SQL>

Will try to reboot PC and see if I can access to SQL

First reboot and the same thing :frowning: