1 Reply Latest reply: May 15, 2012 3:03 PM by Alex.Keh .Product.Manager-Oracle RSS

    ORA 12514 once again..

    937262
      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 (11.2.0.3.0) 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:


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

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