Problem running under Vista

[tomaten]

Hello. Under Vista I cannot login myself at Oracle. Only if I let the program run as administrator function it. I have also the rights for everyone on Oracle folder set. That does not bring improvement.

 

[Marco Kalter]

What exactly goes wrong? Any error messages?

 

[tomaten]

No, no error. Only a small Messagebox with a "Ok" button and without any text.

 

[Marco Kalter]

Can you press the OK button, go to Help > About, press the 'Info' button, press the 'Copy all pages' button on this info screen, and send me this text?

 

[tomaten]

Originally posted by Marco Kalter:
Can you press the OK button, go to Help > About, press the 'Info' button, press the 'Copy all pages' button on this info screen, and send me this text?

I sent you a email with the information.

 

[Marco Kalter]

Thanks. We are looking into it.

 

[tomaten]

Any Solution?

 

[Marco Kalter]

Not yet. I will let you know our findings.

 

[Bo Pedersen]

I think this is a problem with SQL*net/OCI on Vista. No Oracle Clients are certified on Vista. And from my small test then even SQL*plus from Oracle Client 10.2.0.1 fails. The window version just disappears and the command line version with "SP2-1503: Unable to initialize Oracle call interface".

But Oracle Instant Client seems to work on Vista.

Bo Pedersen

 

[tomaten]

Was there any solution for this problem?

 

[Marco Kalter]

We have not been able to reproduce this. It works just fine on Windows Vista. If you have any additional information that could help use reproduce this, let me know.

 

[tomaten]

Did you work as a normal user and have UAC enabled?

 

[Marco Kalter]

Yes. Are you using the final Vista version or a Beta/RC?

 

[Marco Kalter]

Furthermore:

1. Did you install the Oracle Client as Administrator or as a Normal user?
2. Did you install the PL/SQL Developer as Administrator or as a Normal user?

 

[tomaten]

1. I use the final german "Ultimate" Version from our MSDN account.
2. I was logged in as normal user and run the setups as Administrator.

 

[Marco Kalter]

That's exactly the same as my setup (except for the German lamguage). Were both Oracle and PL/SQL Developer installed as Administrator?

 

[tomaten]

Originally posted by Marco Kalter:
Were both Oracle and PL/SQL Developer installed as Administrator?

Yes.

 

[Marco Kalter]

In my case too, so we have the exact same setup.

To obtain some more diagnostic information, can you modify the shortcut and add the debug parameter? For example:

"C:\Program Files\PLSQL Developer\plsqldev.exe" debug

Reproduce the problem and send me the debug.txt file that is generated in the PL/SQL Developer directory.

 

[Bruce Drake]

Hi,

I have exactly the same problem using the latest versions of the Oracle client and PLSQL Developer.

I installed (twice, uninstalling first and removing directories) them as Administrator on Vista Ultimate.

The debug.txt file is simply not produced when I try the above. All I get is a little box with no text and an 'Ok' button, which takes me back the logon prompt for PLSQL Developer.

Interestingly enough when installing Oracle client, in the test the connection bit, it says the connection works.

Is this really not a problem for other people?

Bruce

 

[Marco Kalter]

You are not the only one with this problem, as indicated by this thread.

About the missing debug.txt file: can you check if you have write access to the PL/SQL Developer installation directory? If you do not have write access, log on as admin and grant write access, log on as a normal user, and try the debug option again.

Can you also check if \Bin is listed in the PATH environment variable?

 

[Jesmond]

Hi,

I have installed Oracle client 10.2.0 on Vista business following the procedure on this blog:
http://cshay.blogspot.com/2007/02/getting-ready-for-windows-vista.html
You will need access to Metallink!

Additionally have installed PL/SQL developer ver. 7.0.3.1123 successfully, however the folloiwng registry entries were not defined, and had to import them manually into Vista in order to install the add-ins (BE extender, Active Query Builder, PlSQL doc).

Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINE\SOFTWARE\Classes\PL/SQL Developer]
@="PL/SQL Developer file"

[HKEY_LOCAL_MACHINE\SOFTWARE\Classes\PL/SQL Developer\DefaultIcon]
@="c:\\program files\\plsql developer\\plsqldev.exe,1"

[HKEY_LOCAL_MACHINE\SOFTWARE\Classes\PL/SQL Developer\Shell]

[HKEY_LOCAL_MACHINE\SOFTWARE\Classes\PL/SQL Developer\Shell\Open]

[HKEY_LOCAL_MACHINE\SOFTWARE\Classes\PL/SQL Developer\Shell\Open\Command]
@="\"c:\\program files\\plsql developer\\plsqldev.exe\""

[HKEY_LOCAL_MACHINE\SOFTWARE\Classes\PL/SQL Developer\Shell\Open\ddeexec]
@="[Open(\"%1\")]"

Regards,

Jesmond

 

[Bo Pedersen]

If you are using the default setup with User Account Control (UAC) then try right-clicking on PL/SQL Developer short cut and select 'Run as Administrator'. If you are not logged in as an administrator user then you will be prompted for an administrator username and password. Even if you are logged in as an administrator then the programs are not executed with administrator privileges unless you select 'Run As Administrator'.

This procedure allowed me to run PL/SQL Developer successfully. And SQL*Plus too. My problem was actually with SQL*Net as stated earlier. The resulting error in PL/SQL Developer was the before mentioned empty message box with and OK button.

If UAC is disabled and you are logged in as an local administrator, I don't think this is required.

Bo Pedersen

 

[eidylon]

I am experiencing the same issue with v.6 of PL/SQL. The different thing is, i CAN run sqlplusw.exe without having to run it as administrator. But PL/SQL Developer, if not run as Admin, will have the same problem above, ... just a tiny little message box comes up with no message and no title, and just an OK button. But, if i run it as Administrator it works perfectly fine.

Everything was installed under Administrator account. Using PL/SQL Developer 6.0.6.947, Oracle 10g Client, on Vista Ultimate (RTM).

Is there any ideas or fixes on this yet? I tried the debug switch mentioned above, but also, i do not get any debug output file, although i do have full permissions to the PL/SQL Developer directory.

 

[Marco Kalter]

Does this empty error message also occur if you do not log on?

 

[eidylon]

no, if i cancel the logon dialog, then i do not get the msgbox. Then if i try to log on from inside the app after it loads, i get a small msgbox saying simply "Could not logon as myusername".

If i put the debug switch back on and try loggin on from inside like that though, i still do not get any debug file, sorry. :-\

 

[Bo Pedersen]

Try 'Run as Administrator'. A normal user on Vista does not have access to the Program Files directory, HKLM in the registry etc. Both SQL*Net and PL/SQL Developer assumes access to that.

And with UAC, programs started by a local administrator does not execute with administrator privileges.

I got pass the empty dialog box by using 'Run as Administrator'. But now file extension associations and drag'n'drop does not work since a program with lower privileges (Explorer) cannot access a program with higher privileges (PL/SQL Developer) .

Bo Pedersen

 

[lofftjm]

Right clicking on the PL/SQL Developer shortcut and selecting "Run as Administrator" worked for me.

FYI I am running PL/SQL Developer 7.1.1.1339 with Oracle client 10.2.0.1.0.

 

[eidylon]

Yah, RaA worked for me too; Thanks!

 

[lofftjm]

I was just informed of disconencts even when running as admin. The disconnects do not occur with SQL*Plus from the same client. Anyone experienced this?

 

[Bo Pedersen]

It's not necessary to run as administrator when using Oracle Database Client 10.2.0.3 for Vista. See http://www.oracle.com/technology/software/products/database/oracle10g/htdocs/10203vista.html

Bo

 

[lofftjm]

Maybe not the Oracle client, but PL/SQL Developer will not log in without running as admin.