Printable View
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
Make sure you have your environment variable for ORACLE_HOME set correctly.
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.
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
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
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
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
check your oracle_sid
echo $ORACLE_SID
if it is wrong, set the correct value
hi,
please check the oracle_sid .if it it correct then problem is with your listener.
delete and create a new listener.
saurabh
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
it depends from where you are trying to connect.
always use
sqlplus username@service_name
Sam
Did you resolve the ora-12545 error? What caused it? I am getting the same error. My connection used to work fine. But recently there are some network system changes. But I can not point out what's causing this error. Will appreciate your response to [email protected]. Thanks.