aspose file tools
The moose likes JDBC and Relational Databases 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


Win a copy of Groovy Fundamentals video training course this week in the Groovy forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
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 chary
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: 3708
    
  61

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.
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: getting Listener refused the connection with the following error: ORA-12514