• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Liutauras Vilda
  • Jeanne Boyarsky
  • Devaka Cooray
  • Paul Clapham
Sheriffs:
  • Tim Cooke
  • Knute Snortum
  • Bear Bibeault
Saloon Keepers:
  • Ron McLeod
  • Tim Moores
  • Stephan van Hulst
  • Piet Souris
  • Ganesh Patekar
Bartenders:
  • Frits Walraven
  • Carey Brown
  • Tim Holloway

Oracle 10g Express Edition problem

 
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I hope someone can help me on this.

I've installed Oracle 10g Express Edition on a Linux box, for development and testing purposes, but still cannot make jForum work with it.

It seems Oracle 10g EE uses a single database, and you must use one schema for each application. The thing is I haven't been able to install jForum using this approach.

The installer shows this:


java.sql.SQLException: Io exception: Connection refused(DESCRIPTION=(TMP=)(VSNNUM=169869568)(ERR=12505)(ERROR_STACK=(ERROR=(CODE=12505)(EMFI=4))))



Obviously Im doing something wrong. I created the username/passwd jforum/jforum, but Im not sure what to put in the dbname, because of the schema approach.

Any ideas?
[originally posted on jforum.net by roberlamerma]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
The dbname is "xe"

Rafael
[originally posted on jforum.net by Rafael Steil]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

Rafael Steil wrote:The dbname is "xe"

Rafael



Thanks for your comment. That is true, but actually my problem was that the "XE" instance was no properly set. For those with the same problem, look at this link:
http://www.davidpashley.com/articles/oracle-install.html

If still not working, check if the lsnrctl (utility that manages the Oracle listener processes) is up:


su - oracle
lsnrctl status



if doesn't find lsnrctl, or you get permission problems, or any other issue, you have to set up your oracle env:


su - oracle
export ORACLE_HOME=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server
export ORACLE_SID=XE
export NLS_LANG=$ORACLE_HOME/bin/nls_lang.sh
PATH=$ORACLE_HOME/bin:$PATH
export PATH
if [ $?LD_LIBRARY_PATH ]
then
LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH
else
LD_LIBRARY_PATH=$ORACLE_HOME/lib
fi
export LD_LIBRARY_PATH



And now check it


lsnrctl stop
lsnrctl start
lsnrctl status



You should see now your Oracle instances, and connect easily with the resource USER/PASSWD@INSTANCE


sqlplus myuser/mypasswd@xe



Hope it saves someone time...
[originally posted on jforum.net by roberlamerma]
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!