1 Reply Latest reply on May 15, 2012 8:03 PM by Alex Keh - Product Manager-Oracle

    ORA 12514 once again..

      Hello, I knew, there are thousends of topics similiar to mine. I read them all. Nothing works for me. And there i will discribe my problem: I created a Oracle database using Oracle SQL developer setting values :

      connection name: test,

      username: bob,

      password: qwerty

      Connection type: basic,

      role: defoult,

      Hostname: localhost,

      port: 1521,

      SID : orcl.

      Reason im writing all of this is that i rally did everything possible, and i hope that by providing each kind of data someone will be able to help me.

      My next step was downloading and instaling ODAC 11.2 Release 4 ( with Oracle Developer Tools for Visual Studio.

      When i want make a connection to databese from my application using server explorer im entering following data:

      data source name: //localhost:1521/test

      user name: ADMIN

      password : qwerty

      connection name is being set automaticly.

      When im trying to test connection im getting ORA 12514... and here it is how i changed mine tnsname.ora:

      (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))

      orcl =
      (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
      (SERVICE_NAME = orcl)