SQLPLUS Error

[yamujasv]

Hi,

I've just installed 8.1.7 version of Oracle on a sun machine. When I try to run
sqlplus, it gives me an error saying:

Message file sp1.msb not found
Error 6 initializing SQL*Plus

Can anyone give me any insight as to what needs to be fixed - is it related to NLS
variable - do I need to set any variable for the shell environment.

Your help is very much appreciated.

Thanks and BRgds,
Sri

[molonede]

Make sure you have your environment variable for ORACLE_HOME set correctly.

[sonofsita]

r u able to get connected to server manager.
then check for set
set shmsys:shminfo_shmmax=4294967295
set shmsys:shminfo_shmmin=1
set shmsys:shminfo_shmmni=100
set shmsys:shminfo_shmseg=20
set semsys:seminfo_semmns=2000
set semsys:seminfo_semmsl=310
set semsys:seminfo_semmni=200
if still you have you have a problem
then the sql plus is to be reinstall after
cleaning that out.

[yamujasv]

ORACLE_HOME is set properly.

Here are the system settings:

shmsys:shminfo_shmmax=4294967295
shmsys:shminfo_shmmin=1
shmsys:shminfo_shmmni=100
shmsys:shminfo_shmseg=10

semsys:seminfo_semmni=100
semsys:seminfo_semmsl=110
semsys:seminfo_semmns=630
semsys:seminfo_semopm=100
semsys:seminfo_semvmx=32767

When I tried to start server manager, I get an error as:

Oracle Server Manager Release 3.1.7.0.0 - Production

Message 4505 not found; No message file for product=SVRMGR, facility=MGR

Error while trying to retrieve text for error ORA-12545
SVRMGR>


Any thoughts, as to where I may have committed some mistakes during installation?

All the oracle software is installed under /u01/app/oracle/product/8.1.7 and all the database files are put
under /u02 and here are my env settings:
ORACLE_BASE=/u01/app/oracle
ORACLE_HOME=/u01/app/oracle/product/8.1.7

Thanx,
Sri

[saurabhg29]

please set the environment variable .

this has been set up on linux 7.1.

PATH=$PATH:$HOME/bin:/usr/local/jdk1.2.2/bin:/home/saurabh/OraHome1/bin:.
BASH_ENV=$HOME/.bashrc

export ORACLE_HOME=/home/saurabh/OraHome1
export ORACLE_SID=test
export ORACLE_BASE=/home/saurabh
export NLS_LANG='AMERICAN_AMERICA.WE8ISO8859P1'
export ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data
export ORACLE_TERM=xterm
export PATH=$PATH:$ORACLE_HOME/bin:/usr/local/jdk1.2/bin
export TNS_ADMIN=$ORACLE_HOME/network/admin
if [ -z $LD_LIBRARY_PATH ]
then
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
else
export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/lib
fi
if [ -z $CLASSPATH ]
then
CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib
CLASSPATH=$CLASSPATH:$ORACLE_HOME/network/jlib
export CLASSPATH
else
CLASSPATH=$CLASSPATH:$ORACLE_HOME/JRE:$ORACLE_HOME/jlib
CLASSPATH=$CLASSPATH:$ORACLE_HOME/rdbms/jlib:$ORACLE_HOME/network/jlib
export CLASSPATH
fi
export BASH_ENV PATH
unset USERNAME


this will do the thing

saurabh

[yamujasv]

Thanks Saurabh - that helped a lot but I still have another problem -

When I try to connect to the sample database I've created when installing,

ORACLE_SID is sample1 and the database files for these exist under /u02/oradata/sample1

SQLPLUS gives me an error after prompting for userid and password. Below is the actual message:

>sqlplus

SQL*Plus: Release 8.1.7.0.0 - Production on Fri Oct 5 12:46:41 2001
(c) Copyright 2000 Oracle Corporation. All rights reserved.

Enter user-name: scott
Enter password:
ERROR:
ORA-12545: Connect failed because target host or object does not exist.

Same error comes even with server manager, any advise/thoughts?

Thanx again,
Sri

[yamujasv]

Oh one more thing -
when I give

sqlplus scott/tiger@sample1 - it connects correctly to the database.

but when I give sqlplus and then type username and password when prompted, it says
ERROR:
ORA-12545: Connect failed becoz target host or object does not exist.

same error for svrmgrl.

Any ideas, please.

Thanx,
Sri

[jm]

check your oracle_sid

echo $ORACLE_SID

if it is wrong, set the correct value

[saurabhg29]

hi,
please check the oracle_sid .if it it correct then problem is with your listener.

delete and create a new listener.

saurabh

[sonofsita]

the sid name in tnsnames is not correctly set as is in listener.
do that it shall help. check bothe listener and tnsnames files so that you may be knowing the error crept in