Oracle 11g?

[Lass]

Hi everyone.

I'm having problems connecting to an oracle 11.1 database using the current version (4.1) of DOA. I'm using the evaluation version (downloaded it this morning).

At first I thought that I made a mistake, so I looked at your demo applications. I compiled the QueryGrid demo. I was able to connect to an oracle 10g on a remote machine, but when I tried to connect to my local 11g it gives me the error:

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

Here is my TNS (created by oracle installation):

NEELIX11 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = Neelix)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = NEELIX11)
    )
  )

On another machine with oracle 11g I get a different error message:

Initialization error
Could not load "D:\oracle\product.1.0\bin\oci.dll"

OracleHomeKey: SOFTWARE\ORACLE\Key_OraDb11g
OracleHomeDir: D:\oracle\product.1.0
Found: oci.dll
Using: D:\oracle\product.1.0\bin\oci.dll
LoadLibrary(D:\orace\product.1.0\bin\oci.dll) returned 0

I have no clue what is going wrong here.
I'm able to connect to the oracle 11 databases using oracles SQLDeveloper, so the database seems to be up and running.
TNSPing is also working.

Do you have any idea what the problem is?

Thanks so far.

 

[Marco Kalter]

Can you connect with SQL*Plus to your local 11g database?

 

[Lass]

Hi Marco. Thanks for your reply.

I'm not sure what the problem was, but reinstalling oracle 11 fixed it. I also installed oracle in a another (virtual) machine and this works fine too. So the problem was in my oracle installations and not DOA. Sorry for cluttering the forums.