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,
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
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:
When I tried to start server manager, I get an error as:
Oracle Server Manager Release 220.127.116.11.0 - Production
Message 4505 not found; No message file for product=SVRMGR, facility=MGR
Error while trying to retrieve text for error ORA-12545
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:
please set the environment variable .
this has been set up on linux 7.1.
if [ -z $LD_LIBRARY_PATH ]
if [ -z $CLASSPATH ]
export BASH_ENV PATH
this will do the thing
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:
SQL*Plus: Release 18.104.22.168.0 - Production on Fri Oct 5 12:46:41 2001
(c) Copyright 2000 Oracle Corporation. All rights reserved.
Enter user-name: scott
ORA-12545: Connect failed because target host or object does not exist.
Same error comes even with server manager, any advise/thoughts?
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
ORA-12545: Connect failed becoz target host or object does not exist.
same error for svrmgrl.
Any ideas, please.
check your oracle_sid
if it is wrong, set the correct value
please check the oracle_sid .if it it correct then problem is with your listener.
delete and create a new listener.
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
Click Here to Expand Forum to Full Width