If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > Oracle > sqlplus internal error 9iR2

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 08-29-02, 10:09
sanek1978 sanek1978 is offline
Registered User
 
Join Date: Aug 2002
Posts: 7
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?
Reply With Quote
  #2 (permalink)  
Old 09-01-02, 19:31
clio_usa clio_usa is offline
Registered User
 
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

.
.
.
Reply With Quote
  #3 (permalink)  
Old 09-02-02, 00:49
sanek1978 sanek1978 is offline
Registered User
 
Join Date: Aug 2002
Posts: 7
Thank for your answer, but after second similar install of OS and Oracle I am happy.


Quote:
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
.
.
.
Reply With Quote
  #4 (permalink)  
Old 09-02-02, 01:21
clio_usa clio_usa is offline
Registered User
 
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

.
.
.
Reply With Quote
  #5 (permalink)  
Old 10-13-02, 01:12
sanek1978 sanek1978 is offline
Registered User
 
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

Quote:
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
Reply With Quote
  #6 (permalink)  
Old 10-13-02, 13:56
clio_usa clio_usa is offline
Registered User
 
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

.
Reply With Quote
  #7 (permalink)  
Old 01-13-03, 21:13
eejut eejut is offline
Registered User
 
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
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On