-
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.
Doug
-
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.
sonofsita
http://www.ordba.net
-
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
-
environment variable
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
Saurabh Garg
OCP 9i
-
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
-
oracle_sid
hi,
please check the oracle_sid .if it it correct then problem is with your listener.
delete and create a new listener.
saurabh
Saurabh Garg
OCP 9i
-
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
sonofsita
http://www.ordba.net
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|