Oracle Database Discussions

This has been bugging me for weeks.... I get this error only on some tables and not all of them so I am wondering if maybe it is a permissions grant thing. This web application I have allows a visitor to post information into the DB, this works fine, but the weird thing is that when they click to view the information they submitted only the information that is generated server side is displayed yet all the information the visitor submitted was entered into the table! Here is all the info I think you will need to figure this one out...

Note that it has nothing to do with my web application I know this because as I said it works fine on some of the tables...


Here is the exception I am getting...


Io exception: Connection refused(DESCRIPTION=(TMP=)(VSNNUM=153093120)(ERR=12505)(ERROR_STACK=(ERROR=(CODE=12505)(EMFI=4))))
java.sql.SQLException: Io exception: Connection refused(DESCRIPTION=(TMP=)(VSNNUM=153093120)(ERR=12505)(ERROR_STACK=(ERROR=(CODE=12505)(EMFI=4))))
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:333)
at oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java:404)
at oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java:468)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:314)
at java.sql.DriverManager.getConnection(DriverManager.java:512)
at java.sql.DriverManager.getConnection(DriverManager.java:171)




When I run lsnrctl services this is what I get...





[oracle@ds26 network]$ lsnrctl services

LSNRCTL for Linux: Version 9.2.0.4.0 - Production on 17-JUL-2005 19:54:40

Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0
LOCAL SERVER
Service "db9i" has 2 instance(s).
Instance "db9i", status UNKNOWN, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0
LOCAL SERVER
Instance "db9i", status READY, has 2 handler(s) for this service...
Handler(s):
"D000" established:762 refused:0 current:73 max:1002 state:ready
DISPATCHER
(ADDRESS=(PROTOCOL=tcp)(HOST=203.432.54.66)(PORT=32769))
"DEDICATED" established:0 refused:0 state:ready
LOCAL SERVER
The command completed successfully





Here is my listener.ora file...




# LISTENER.ORA Network Configuration File: /home/oracle/Oracle9i/product/9.2.0/network/admin/listener.ora
# Generated by Oracle configuration tools.

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = some.domain.net)(PORT = 1521))
)
)
)

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /home/oracle/Oracle9i/product/9.2.0)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = db9i)
(ORACLE_HOME = /home/oracle/Oracle9i/product/9.2.0)
(SID_NAME = db9i)
)
)






Here is my tnsnames.ora...





# TNSNAMES.ORA Network Configuration File: /home/oracle/Oracle9i/product/9.2.0/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.

DB9I.432.54.66 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = some.domain.net)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = db9i)
)
)

EXTPROC_CONNECTION_DATA.432.54.66 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)

INST1_HTTP.432.54.66 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = MODOSE)
(PRESENTATION = http://HRService)
)
)






Here is the listener.log file...






TNSLSNR for Linux: Version 9.2.0.1.0 - Production on 16-MAY-2005 23:37:18

Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.

System parameter file is /home/oracle/Oracle9i/product/9.2.0/network/admin/listener.ora
Log messages written to /home/oracle/Oracle9i/product/9.2.0/network/log/listener.log
Trace information written to /home/oracle/Oracle9i/product/9.2.0/network/trace/listener.trc
Trace level is currently 0

Started with pid=11876
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))
Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=432.54.66.203.sfldmi01.ce.domain.net)(PORT=1521)))
TNS-12545: Connect failed because target host or object does not exist
TNS-12560: TNS:protocol adapter error
TNS-00515: Connect failed because target host or object does not exist

No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))




And my sqlnet.ora file...





# SQLNET.ORA Network Configuration File: /home/oracle/Oracle9i/product/9.2.0/network/admin/sqlnet.ora
# Generated by Oracle configuration tools.

NAMES.DEFAULT_DOMAIN = 432.54.66

NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)





Here is the output from a tnsping...





[oracle@ds26 oracle]$ tnsping DB9I.432.54.66

TNS Ping Utility for Linux: Version 9.2.0.4.0 - Production on 18-JUL-2005 23:24:15

Copyright (c) 1997 Oracle Corporation. All rights reserved.

Used parameter files:
/home/oracle/Oracle9i/product/9.2.0/network/admin/sqlnet.ora


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = some.domain.net)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = db9i)))
OK (10 msec)








And I can connect fine with...




sqlplus user/password@DB9I.432.54.66