SQLPLUS Error
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 12

Thread: SQLPLUS Error

  1. #1
    Join Date
    Oct 2001
    Posts
    6
    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

  2. #2
    Join Date
    Dec 1999
    Location
    Cincinnati, Ohio USA
    Posts
    99
    Make sure you have your environment variable for ORACLE_HOME set correctly.
    Doug

  3. #3
    Join Date
    Sep 2001
    Location
    Fort Smith
    Posts
    184
    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

  4. #4
    Join Date
    Oct 2001
    Posts
    6
    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

  5. #5
    Join Date
    Sep 2001
    Posts
    120

    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

  6. #6
    Join Date
    Oct 2001
    Posts
    6
    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

  7. #7
    Join Date
    Oct 2001
    Posts
    6
    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

  8. #8
    Join Date
    Nov 2000
    Posts
    245

    check your oracle_sid

    echo $ORACLE_SID

    if it is wrong, set the correct value

  9. #9
    Join Date
    Sep 2001
    Posts
    120

    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

  10. #10
    Join Date
    Sep 2001
    Location
    Fort Smith
    Posts
    184
    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
  •  



Click Here to Expand Forum to Full Width