Oracle Database Discussions

Hi all

I'm not sure if this is the correct place to ask this but I was wondering whether Anyone has ran into a similar problem or know how to solve this seeing as this is a listener problem.

I am running Oracle 10g 10.2.0.4 and Oracle SOA 10.1.3.3. I've also written a piece of code that connects to the database using the database's jndi name from a connection pool. I can start the DB and the SOA with no problems however, if I try and connect to the database using one of the connection objects from the connection pool , i.e.

db = connection.getConnection("jdbc/LocalASDBDataSource");

the listener stops working and I get the error message


ORA-12514: TNS:listener does not currently know of service requested in connect descriptor

I know that prior to trying to get the connection from the connection pool, the listener works because if i run lsnrctl services, it reports that the listener is up and running but after the point where I try to get the connection i.e.

db = connection.getConnection("jdbc/LocalASDBDataSource");

the listener stops working. If run lsnrctl services, it then reports that the listener supports no services. The only way I can get the service and the listener to start working is to delete the listener and the Service using Net Manager and then recreating it again but then every time that I run the code again, I get back to the error

the funny thiing is that this only started when I increased the processes because I was gettig ORA-12518: TNS:listener could not hand off client connection

The jndi properties file that I use to create my initial context is

java.naming.factory.initial=com.evermind.server.ApplicationClientInitialContextFactory
java.naming.provider.url=opmn:ormi://localhost:6003:oc4j_soa
java.naming.security.principal=oc4jadmin
java.naming.security.credentials=password1

My Listener.ora is


# listener.ora Network Configuration File: C:\oracle\product\10.2.0\db_1\network\admin\listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\oracle\product\10.2.0\db_1)
(PROGRAM = extproc)
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = DEVPSTEXP)(PORT = 1521))
)
)

My TNS Names.ora is

# tnsnames.ora Network Configuration File: C:\oracle\product\10.2.0\db_1\NETWORK\ADMIN\tnsnames.ora
# Generated by Oracle configuration tools.

ASDB =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ASDB)
)
)

EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)


Any help will be greatly appreciated

Thanks!