File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JForum and the fly likes Oracle 10g Express Edition problem Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » JForum
Bookmark "Oracle 10g Express Edition problem" Watch "Oracle 10g Express Edition problem" New topic

Oracle 10g Express Edition problem

Migrated From
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
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 by roberlamerma]
Migrated From
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
The dbname is "xe"

[originally posted on by Rafael Steil]
Migrated From
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
Rafael Steil wrote:The dbname is "xe"


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:

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 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 by roberlamerma]
Don't get me started about those stupid light bulbs.
subject: Oracle 10g Express Edition problem
Similar Threads
Oracle XML SQL Utility Liabrary
How to connect jdk1.7 and oracle 10g express edition in eclipse
accept command in .sql file not working from ant
"oracle 9i Client" and "Oracle 9i personal edition"
Insert or Update (Hibernate JPA + Jboss 5.0.0GA)