Unable to start SQLPLUS | Unix Linux Forums | Solaris

  Go Back    


Solaris The Solaris Operating System, usually known simply as Solaris, is a Unix-based operating system introduced by Sun Microsystems. The Solaris OS is now owned by Oracle.

Unable to start SQLPLUS

Solaris


Closed Thread    
 
Thread Tools Search this Thread Display Modes
    #1  
Old 11-28-2011
solaris_user solaris_user is offline
Registered User
 
Join Date: Aug 2009
Last Activity: 4 February 2014, 4:18 PM EST
Location: Croatia
Posts: 424
Thanks: 28
Thanked 17 Times in 16 Posts
Unable to start SQLPLUS

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

OS:


Code:
-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


Code:
-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


Code:
-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 >

Thanks
Sponsored Links
    #2  
Old 11-28-2011
radoulov's Avatar
radoulov radoulov is offline Forum Staff  
Moderator
 
Join Date: Jan 2007
Last Activity: 17 April 2014, 10:17 AM EDT
Location: Варна, България / Milano, Italia
Posts: 5,638
Thanks: 177
Thanked 607 Times in 565 Posts
Try sourcing .bash_profile first (it's read automatically only upon login):


Code:
. "$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 ...
Sponsored Links
    #3  
Old 11-28-2011
solaris_user solaris_user is offline
Registered User
 
Join Date: Aug 2009
Last Activity: 4 February 2014, 4:18 PM EST
Location: Croatia
Posts: 424
Thanks: 28
Thanked 17 Times in 16 Posts
Thanks for quick response, here is output, same errors


Code:
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  
Old 11-28-2011
radoulov's Avatar
radoulov radoulov is offline Forum Staff  
Moderator
 
Join Date: Jan 2007
Last Activity: 17 April 2014, 10:17 AM EDT
Location: Варна, България / Milano, Italia
Posts: 5,638
Thanks: 177
Thanked 607 Times in 565 Posts
Could you also post the output of the following commands:


Code:
set | fgrep ORA
env | fgrep ORA

Sponsored Links
    #5  
Old 11-28-2011
solaris_user solaris_user is offline
Registered User
 
Join Date: Aug 2009
Last Activity: 4 February 2014, 4:18 PM EST
Location: Croatia
Posts: 424
Thanks: 28
Thanked 17 Times in 16 Posts

Code:
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

Sponsored Links
    #6  
Old 11-28-2011
radoulov's Avatar
radoulov radoulov is offline Forum Staff  
Moderator
 
Join Date: Jan 2007
Last Activity: 17 April 2014, 10:17 AM EDT
Location: Варна, България / Milano, Italia
Posts: 5,638
Thanks: 177
Thanked 607 Times in 565 Posts
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).
Sponsored Links
    #7  
Old 11-28-2011
solaris_user solaris_user is offline
Registered User
 
Join Date: Aug 2009
Last Activity: 4 February 2014, 4:18 PM EST
Location: Croatia
Posts: 424
Thanks: 28
Thanked 17 Times in 16 Posts
I reinstalled database and I can now connect to sqlplus


Code:
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

Last edited by solaris_user; 11-28-2011 at 06:20 AM..
Sponsored Links
Closed Thread

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

More UNIX and Linux Forum Topics You Might Find Helpful
Thread Thread Starter Forum Replies Last Post
unable to start shell script venhart UNIX for Dummies Questions & Answers 2 08-24-2011 07:06 AM
Unable to Start X in Centos - VPS - SSH mselvaprakash Red Hat 0 10-19-2010 08:38 AM
SQLPLUS unable to execte query automatically from solaris script jyotisree Solaris 2 08-11-2008 06:03 AM
unable to start sqlplus from unx MSHETTY UNIX for Dummies Questions & Answers 1 09-28-2007 10:05 AM
unable to start SMC selvassd@gmail Solaris 1 12-21-2006 08:17 PM



All times are GMT -4. The time now is 11:27 AM.