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

[Omkar chary]

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..

# tnsnames.ora Network Configuration File: C:\app\amma\product\11.2.0\dbhome_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

ORACLR_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    )
    (CONNECT_DATA =
      (SID = CLRExtProc)
      (PRESENTATION = RO)
    )
  )

ORCL =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl)
    )
  )

3)and i checked this..

C:\>lsnrctl services

LSNRCTL for 64-bit Windows: Version 11.2.0.1.0 - Production on 13-OCT-2012 13:06
:55

Copyright (c) 1991, 2010, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
Services Summary...
Service "CLRExtProc" has 1 instance(s).
  Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
    Handler(s):
      "DEDICATED" established:0 refused:0
         LOCAL SERVER
Service "orcl" has 1 instance(s).
  Instance "orcl", status READY, has 1 handler(s) for this service...
    Handler(s):
      "DEDICATED" established:80 refused:0 state:ready
         LOCAL SERVER
Service "orclXDB" has 1 instance(s).
  Instance "orcl", status READY, has 1 handler(s) for this service...
    Handler(s):
      "D000" established:0 refused:0 current:0 max:1022 state:ready
         DISPATCHER <machine: AMMA-VAIO, pid: 3548>
         (ADDRESS=(PROTOCOL=tcp)(HOST=amma-VAIO)(PORT=49173))
The command completed successfully

when i use this..

Class.forName("oracle.jdbc.OracleDriver");
DriverManager.getConnection("jdbc:oracle:thin:@//localhost:1158/em","system","Oracle11g");
                                                              // and i tried with 1521/em also 

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

java.sql.SQLException: Listener refused the connection with the following error:

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

        at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:412)
        at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:
531)
        at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:221)
        at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtensio
n.java:32)
        at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:503)
        at java.sql.DriverManager.getConnection(Unknown Source)
        at java.sql.DriverManager.getConnection(Unknown Source)
        at DbOperations_Oracle_Type4.<init>(DbOperations_Oracle_Type4.java:26)
        at DbOperations_Oracle_Type4.main(DbOperations_Oracle_Type4.java:141)
Caused by: oracle.net.ns.NetException: Listener refused the connection with the
following error:
ORA-12514, TNS:listener does not currently know of service requested in connect
descriptor

        at oracle.net.ns.NSProtocol.connect(NSProtocol.java:385)
        at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1042)
        at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:301)
        ... 8 more
Select ur choise!
1.Creating table
2.Drop table
3.inserting data
4.view data
5.exit
Exception in thread "main" java.lang.NullPointerException
        at DbOperations_Oracle_Type4.go(DbOperations_Oracle_Type4.java:155)
        at DbOperations_Oracle_Type4.main(DbOperations_Oracle_Type4.java:141)

[Martin Vashko]

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.