JDeveloper DB Connection Issues
737759Nov 29 2009 — edited Nov 29 2009Hi,
I'm new to JDeveloper (11g R1) but am having some issues making a DB connection (). Below are the details that I am trying to connect with:
Connection Name: test1
Connection Type: Oracle (JDBC)
Username: mooneyb
Driver: oci8 (have tried with Thin also)
Hostname: MOONEY
JDBC Port: 1522
SID: tsthome
When I try the connection test, I am getting a ORA-12541 No Listener message. I know the Listener is running, I'm able to connect to the DB with SQLPlus as per below. I think I'm probably doing something stupid (like I said above, I'm new to this :-) ), any help would be greatly appreciated.
C:\Documents and Settings\HP_Administrator>lsnrctl
LSNRCTL for 32-bit Windows: Version 11.1.0.6.0 - Production on 29-NOV-2009 16:51
*:40*
Copyright (c) 1991, 2007, Oracle. All rights reserved.
Welcome to LSNRCTL, type "help" for information.
LSNRCTL> status
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1522)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 32-bit Windows: Version 11.1.0.6.0 - Produ
ction
Start Date 28-NOV-2009 19:13:31
Uptime 0 days 21 hr. 38 min. 45 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File C:\Oracle\mooneyb\product\11.1.0\db_1\network\admin\li
stener.ora
Listener Log File c:\oracle\mooneyb\diag\tnslsnr\MOONEY\listener\alert\l
og.xml
Listening Endpoints Summary...
*(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1522ipc)))*
*(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=MOONEY)(PORT=1522)))*
Services Summary...
Service "TSTHOMEXDB" has 1 instance(s).
Instance "tsthome", status READY, has 1 handler(s) for this service...
Service "TSTHOME_XPT" has 1 instance(s).
Instance "tsthome", status READY, has 1 handler(s) for this service...
Service "tsthome" has 1 instance(s).
Instance "tsthome", status READY, has 1 handler(s) for this service...
The command completed successfully
LSNRCTL> exit
C:\Documents and Settings\HP_Administrator>sqlplus mooneyb@tsthome
SQLPlus: Release 11.1.0.6.0 - Production on Sun Nov 29 16:52:41 2009*
Copyright (c) 1982, 2007, Oracle. All rights reserved.
Enter password:
Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> select instance_name, host_name, status from v$instance;
INSTANCE_NAME
----------------
HOST_NAME STATUS
---------------------------------------------------------------- ------------
tsthome
MOONEY OPEN
SQL>
Edited by: user8708526 on 29-Nov-2009 09:02