| inconsistent ORA-12154 errors [message #66984] |
Wed, 14 May 2003 05:00  |
Christian Paterson
Messages: 3
Registered: May 2003
|
Junior Member |
|
|
Hi,
I have written a server side java application (on a Unix box) which processes a text file and adds entries into an oracle database table. After a number of entries, the application starts reporting "ORA-12154: TNS:could not resolve service name", and continues to do so until the text file has been processed. If the application is re-run on the same text file, it starts processing ok, manages to advance further than the previous run (entries already within the DB are not re-inserted) and then starts reporting the error again. Eventually all the entries get inserted, but it might take 6 or more runs. The same application on a different machine does not have this problem, so I am guessing this is not an issue with the application itself. Does anyone have any ideas on this ?
All help much appreciated.
|
|
|
|
|
|
| Re: inconsistent ORA-12154 errors [message #66987 is a reply to message #66985] |
Wed, 14 May 2003 06:52  |
Christian Paterson
Messages: 3
Registered: May 2003
|
Junior Member |
|
|
sqlnet.ora :
# SQLNET.ORA Network Configuration File: /soft/oracle/product/8.1.7/network/admin/sqlnet.ora
# Generated by Oracle configuration tools.
NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)
-----------
listener.ora :
# LISTENER.ORA Network Configuration File: /soft/oracle/product/8.1.7/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 = xxx-yyy)(PORT = 1521))
)
)
(DESCRIPTION =
(PROTOCOL_STACK =
(PRESENTATION = GIOP)
(SESSION = RAW)
)
(ADDRESS = (PROTOCOL = TCP)(HOST = xxx-yyy)(PORT = 2481))
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /soft/oracle/product/8.1.7)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = yyy)
(ORACLE_HOME = /soft/oracle/product/8.1.7)
(SID_NAME = yyy)
)
)
--------------------
(xxx and yyy have been changed from the original)
|
|
|
|
|
|
| Re: inconsistent ORA-12154 errors [message #66996 is a reply to message #66991] |
Thu, 15 May 2003 05:08 |
Christian Paterson
Messages: 3
Registered: May 2003
|
Junior Member |
|
|
|
thanks for your pointers, but in fact the errors seem to have come from java not closing DB connections correctly - this was seen on another machine with the same app treating a file containing many entries (although strangely the reported error message was different - ora00020).
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
