File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and the fly likes getting Listener refused the connection with the following error:  ORA-12514 Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "getting Listener refused the connection with the following error:  ORA-12514" Watch "getting Listener refused the connection with the following error:  ORA-12514" New topic
Author

getting Listener refused the connection with the following error: ORA-12514

Omkar onky
Greenhorn

Joined: Oct 12, 2012
Posts: 11
I just installed the oracle 11 g -win x 64 bit software in win 7 home premium operating system.
1)with the following details
global database name: "orcl"
admin password: "Oracle11g"
oracle system identifier(SID): "orcl"
user: "system"
after installation complete then it displayed
The db control URL is : "https://localhost:1158/em".

2)This is my tnsnames.ora..


3)and i checked this..

when i use this..

But i get this exception at runtime! can anyone help me out please!




Martin Vajsar
Sheriff

Joined: Aug 22, 2010
Posts: 3606
    
  60

Welcome to the Ranch, Omkar!

The URL you've provided (https://localhost:1158/em) is the address of the Enterprise Manager (hence the "em" in that URL) -- it is an application that you can use to manage your database. It has nothing to do with the JDBC connect string, neither the port, nor the "em" should appear there.

Various possible formats of Oracle JDBC connect string are described here.

I believe that the correct connect string in your case (based on the TNSNAMES) would be jdbc:oracle:thin:@//localhost:1521/orcl, but I may be wrong.
 
Don't get me started about those stupid light bulbs.
 
subject: getting Listener refused the connection with the following error: ORA-12514
 
Similar Threads
JDBC connection issue with RAC database
Oracle database connection problem
Error in opening connection
Error facing while trying to connect Oracle XE
WSAD-Oracle10