Topic
No replies
ericomtx
ericomtx
1 Post
ACCEPTED ANSWER

Pinned topic configuring oracle data source in a jboss/linux environment

‏2011-08-09T13:45:36Z |
Hello

I am facing problems to establish connection type 4 with a JBoss 5.1.0

my Data Source is the following :

<datasources>
<local-tx-datasource>
<jndi-name>jdbc/ilogDataSource</jndi-name>
<connection-url>jdbc:oracle:thin:@127.0.0.1:1521:XE</connection-url>

<driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
<user-name>SYSTEM</user-name>
<password>senha</password>

<exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter</exception-sorter-class-name>
</local-tx-datasource>
</datasources>

I do have a ORacle XE (10.2.0) local and it is working fine (I can access its APEX in port 6060 and I am also able to access it throught eclipse)

running the command : bash-3.2# lsnrctl status XE

I get :

LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 08-AUG-2011 15:55:30

Copyright (c) 1991, 2005, Oracle. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=ericomtx)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=XE)))
STATUS of the LISTENER
Alias LISTENER
Version TNSLSNR for Linux: Version 10.2.0.1.0 - Production
Start Date 08-AUG-2011 15:10:37
Uptime 0 days 0 hr. 44 min. 53 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Default Service XE
Listener Parameter File /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/admin/listener.ora
Listener Log File /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC_FOR_XE)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ericomtx)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ericomtx)(PORT=6060))(Presentation=HTTP)(Session=RAW))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "XE" has 1 instance(s).
Instance "XE", status READY, has 1 handler(s) for this service...
Service "XEXDB" has 1 instance(s).
Instance "XE", status READY, has 1 handler(s) for this service...
Service "XE_XPT" has 1 instance(s).
Instance "XE", status READY, has 1 handler(s) for this service...
The command completed successfully
bash-3.2#

....

my problem is the following : my application is not establishing the connection ... when it is the time to do so it gets stuck

my OS is a red hat and my computer name is ericomtx as follows :

bash-3.2# hostname
ericomtx

I have changed my computer name in the following files :
/etc/hosts
/etc/sysconfig/network

I also have oracle environment variables in /etc/profile:
bash-3.2# echo $ORACLE_HOME
/usr/lib/oracle/xe/app/oracle/product/10.2.0/server

my linux user is added in DA group created by oracle install

please can some one help me out ?

Thks&Regards
Érico