use_password fails with globally identified user

Hello,

Our users are created in Oracle as globally identifed users.

E.g.:

CREATE USER oracle_user
  IDENTIFIED GLOBALLY AS 'oid-context'

When I use the use:

begin

   jchem_core_pkg.use_password('password');
end;

I get the error message:

ORA-20104: ORA-01017: invalid username/password; logon denied
ORA-06512: at "JCHEM.JCHEM_CORE_PKG", line 36
ORA-06512: at "JCHEM.JCHEM_CORE_PKG", line 59
ORA-06512: at line 2

Using a test user with "identified by password" and the same privileges as the user above it works fine.

Is there an error in our configuration?

 

Oracle environment:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
PL/SQL Release 11.2.0.1.0 - Production
CORE    11.2.0.1.0    Production
TNS for Linux: Version 11.2.0.1.0 - Production
NLSRTL Version 11.2.0.1.0 - Production

JChem owner: JCHEM

JChem Server environment:
Java VM vendor: Sun Microsystems Inc.
Java version: 1.6.0_38
Java VM version: 20.13-b02
JChem version: 5.11.4
JChem Index version: 5110000
JDBC driver version: 11.1.0.7.0-Production

Best regards,

Mike

Hello,

I'm afraid it is not supported to have a user with IDENTIFIED EXTERNALLY or GLOBALLY in the use_password function. But you can create a simple user or use any existing user with a password which can connect to the database. Than you can use the two-parameter version of use_password:

exec jchem_core_pkg.use_password('reconnect_user', 'password');

Or you can set this login name and password in the conf/jcart.properties file as described here:

http://www.chemaxon.com/jchem/doc/admin/cartridge.html#jcserver_dbaccess_credentials

I hope you can solve the your case with these!

Regards,

Tamas

Hello Tamas,

I know that there is a similar problem when using jdbc to connect to such users.This can be solved by adding -Doracle.jdbc.thinLogonCapability=o3 as start parameter for the application.

Is it possible, that this might help here, too?

 

Best regards,

 

Mike

Hello,

I couldn't try it out, but I think it might be able to help. To use this parameter, add this line to the conf/jcart.properties file:

sysprop.oracle.jdbc.thinLogonCapability=o3

 

After restarting the server, the server will start with your parameter, and hopefully you can connect successfully to the database with the use_password command.

 

Regards,

Tamas

Hello Tamas,

We put the parameter into the config file and the cartridge access works now fine (after restart).

 

Best regards,

 

Mike