oracle home windows 7 not logging in

[Jeff Kish]

Hi.

I have been trying to figure this out for a while, but keep getting pulled off. I have windows 7 64 bit, and pl/sql developer 8 installed. At the very bottom of this post is my information from oracle info.

When I try to connect I tgeht ora-12154: TNS:could not resolve the conect identifier specified.

Now althought the oracle info sees I have/had 2 oracle client installes, I actually have three entries in my start | PROGRAMS :
Oracle - OraClient11g_home1
Oracle - OraClient11g_home2
Oracle - OraDb11g_home1

sql*plus from the first is not found, from the second comes up but can't seem to recognize anything
in a TNS sense, and from the third works fine.

So I'm assuming that the third which pl/sql developer does not 'see' is the oracle_home that it should be
getting TNS info from.
Properties fo sqldeveloper from this third oracle shows this:
C:\app\jeffk\product\11.2.0\dbhome_1\sqldeveloper\sqldeveloper\bin\sqldeveloper.exe

what is the right way to get pl/sql developer to point to this oracle home?

thanks
Jeff

PL/SQL Developer
Version 8.0.4.1514
01.61003 - 1 user license
Windows 7 (64-bit) 6.1 Build 7600

Physical memory : 4,194,304 kB (1,082,548 available)
Paging file : 4,194,304 kB (4,194,304 available)
Virtual memory : 2,097,024 kB (1,936,256 available)

Parameters
C:\)\PLSQLDeveloper\plsqldev.exe

Preferences
Session mode: Multi
OCI Library:
Use OCI7: False

Preference Files
C:\)\PLSQLDeveloper\Preferences\Default\Default.ini
C:\Users\jeffk\AppData\Roaming\PLSQL Developer\Preferences\jeffk\default.ini

Plug-Ins

Aliases

Homes
OraClient11g_home1 (C:\app\jeffk\product\11.2.0\client_1)
OraClient11g_home2 (C:\app\jeffk\product\11.2.0\client_2)

DLLs
C:\app\jeffk\product\11.2.0\client_2\bin\oci.dll

TNS File
C:\app\jeffk\product\11.2.0\client_2\Network\Admin\tnsnames.ora

Using
Home: OraClient11g_home2
DLL: C:\app\jeffk\product\11.2.0\client_2\bin\oci.dll
OCI: version 11.1

 

[MartinF]

Hi,
I know there is an Oracle bug with 64 bits OS when using 32 client application (Metalink note 334528.1).
By default 32 bits application is installed in folder c:\program files (x86)\.... and Oracle have some problem with folder that contain parenthesis. You can try reinstalling PLSQL Dev directly in the c:\program files\... and see if it solve your problem

Hope it help

 

[Jeff Kish]

I reinstalled into c:\program files\sqldeveloper but I"m getting ORA-12560: TNSrotocol adapter error.
I can run sqldeveloper just fine (but don't want to ;> ) )

Thanks for any hints.

Jeff

 

[Marco Kalter]

Can you connect with C:\app\jeffk\product\11.2.0\client_2\bin\sqlplus.exe?

 

[Jeff Kish]

Can you connect with C:\app\jeffk\product\11.2.0\client_2\bin\sqlplus.exe?

Hi.
I can login from here:
C:\app\jeffk\product\11.2.0\dbhome_1\BIN>

but not these places:

C:\app\jeffk\product\11.2.0\client_1\bin
C:\app\jeffk\product\11.2.0\client_2\bin

 

[Marco Kalter]

Does C:\app\jeffk\product\11.2.0\dbhome_1\BIN\oci.dll exist? If so, can you enter C:\app\jeffk\product\11.2.0\dbhome_1\BIN\oci.dll in the OCI Library field in the preferences (Tools > Preferences > Oracle / Connection), restart PL/SQL Developer, and try to connect again?

 

[Jeff Kish]

Hi Marco. No luck yet.I got this messagebox when I restarted.
PL/SQL Developer
Initialization error
Could not initialize "c:\app\jeffk\product\11.2.0\dbhome_1\BIN\oci.dll"
Make sure you have the 32 bits Oracle Client installed.
OCIDLL forced to C:\app\jeffk\product\11.2.0\dbhome_1\BIN\oci.dll
LoadLibrary(C:\APP\JEFFK\PRODUCT\11.2.\DBHOME_1\bin\OCI.DLL) RETURNED 0

OK button

Thanks for helping me and I appreciate any more assistance you can render/suggest.

Jeff

 

[Marco Kalter]

I assume that c:\app\jeffk\product\11.2.0\dbhome_1 is a 64 bit Oracle Home? This would explain why oci.dll cannot be loaded.

If you cannot connect from C:\app\jeffk\product\11.2.0\client_1\bin\sqlplus.exe or C:\app\jeffk\product\11.2.0\client_2\bin\sqlplus.exe then this is the problem that needs to be resolved first. You will need a properly functioning 32 Bit Oracle Client.

 

[Jeff Kish]

That i interesting since sql*plus and sql developer both work, as well as the normal Oracle utilties. Are you suggesting I reinstall the Oracle client? thanks much!
Jeff

 

[Gustavo]

You can have the 32-bit client installed to a different Oracle Home. It
can co-exist with your 64-bit version. There is no need to uninstall it.

Regards,
Gustavo

 

[Jeff Kish]

I ripped Oracle off my pc and did a complete new install of 10.2.0.1. The old stuff is out of the registry (yeah I had to manually do it since the standalone deinstaler from Oracle and the 'deinstall products' was not working.

If I go to this directory I can login to sqlplus and sqlplusw just fine:

C:\oracle\product\10.2.0\db_1\BIN

When I start up pl/sql developer I get an empty messagebox after my login fails.

I tried setting oracle home to OraDb10_home1 and separately OCI library to C:\oracle\product\10.2.0\db_1\bin\oci.dll.

Each time I get the empty messagebox.

In the login I have all the Database SID's I have in oracle tnsnames.ora.

Is there some steps to address this or have I burned my support bridges through intense mediocrity? Thanks, thanks, and more thanks.
Jeff

 

[Jeff Kish]

This is mildly interesting. I can login if I go to

C:\oracle\product\10.2.0\db_1\BIN

and enter

"C:\Program Files\PLSQLDeveloper\plsqldev.exe"

 

[Jeff Kish]

OK I guess I figured it out? my dos box was in administrator mode. I can run but it has to be in administrator mode. I can deal with this though I don't know if it is normal.

regards Jeff