Results 1 to 7 of 7
  1. #1
    Join Date
    Aug 2002
    Posts
    7

    Unanswered: sqlplus internal error 9iR2

    I install Oracle 9iR2 on default installation of SuSE 7.2 prof with
    java1.1.8b3 patch, and requared glibc patches.
    My env:
    ORACLE_BASE=/u/uff/oracle
    ORACLE_HOME=/u/uff/oracle/product/oracle
    ORACLE_SID=base105
    ORA_NLS33=/u/uff/oracle/product/oracle/ocommon/nls/admin/data
    TNS_ADMIN=/u/uff/oracle/product/oracle/network/admin
    ORACLE_SID=base105

    I have the folowing problems:
    1. when I run sqlplus
    oracle@base105:~ > sqlplus
    Error 46 initializing SQL*Plus
    Internal error

    2. When I use netca (I know that it editor for very simple files) for
    adding listener it fails without any error messages on part of saving listener configuration.

    Any ideas?

  2. #2
    Join Date
    Apr 2002
    Location
    California, USA
    Posts
    482

    Cool

    Check what is the value of http_proxy in your shell env.

    $ echo http_proxy

    then do this
    $ unset http_proxy
    $ export http_proxy=http://www.domain.com

    Include this sentenct in your profile/login/bashrc file.

    Also, I don't see the LD_LIBRARY_PATH variable in your env output. make sure you have that one setup too.

    Hope that helps,

    clio_usa
    OCP - DBA

    .
    .
    .

  3. #3
    Join Date
    Aug 2002
    Posts
    7
    Thank for your answer, but after second similar install of OS and Oracle I am happy.


    Originally posted by clio_usa
    Check what is the value of http_proxy in your shell env.

    $ echo http_proxy

    then do this
    $ unset http_proxy
    $ export http_proxy=http://www.domain.com

    Include this sentenct in your profile/login/bashrc file.

    Also, I don't see the LD_LIBRARY_PATH variable in your env output. make sure you have that one setup too.

    Hope that helps,

    clio_usa
    OCP - DBA
    Visit our Web Site
    .
    .
    .

  4. #4
    Join Date
    Apr 2002
    Location
    California, USA
    Posts
    482

    Cool

    Lucky you !!! Now many people have a time to do second OS and Oracle installation on Linux? I don't....

    Glad you solved the problem,

    clio_usa
    OCP - DBA

    .
    .
    .

  5. #5
    Join Date
    Aug 2002
    Posts
    7
    That's all take about 40-60 minutes
    I have enough time for install, test, test and test. You don't, why?
    WBR, Alexander

    Originally posted by clio_usa
    Lucky you !!! Now many people have a time to do second OS and Oracle installation on Linux? I don't....

    Glad you solved the problem,

    clio_usa
    OCP - DBA
    Visit our Web Site

  6. #6
    Join Date
    Apr 2002
    Location
    California, USA
    Posts
    482

    Cool

    When someone has to manage more than 100 instances, time became precious commodity. I have tar balls for every possible version and patch level of Oracle and solid OS images ready to restore on Solaris and Linux. For Windows Norton Ghost can do the job too.

    Check on the Internet for open source program to burn your OS on CD-ROM and make it bootable. Helps when something go south.


    Hope that helps,

    clio_usa
    OCP - DBA

    .

  7. #7
    Join Date
    Jan 2003
    Posts
    1

    any idea why this happens

    Thanks for posting this answer here, I have run many versions of Oracle on lInux and have not seent is problem before. Any idea what this problem is related too? Should I raise a tar to get it fixed or is it a feature hidden inthe release notes?

    thanks again

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •