RDBPROD: Error: -RDMS-E-RTNUSENOTALL, Routine "ORA_SET_NLS" Can Not Be Used (Doc ID 68390.1)

Last updated on JUNE 07, 2017

Applies to:

Oracle Rdb Server on OpenVMS - Version 7.0.4 and later
Oracle SQL/Services for Rdb on OpenVMS - Version 7.1.6 and later
HP OpenVMS VAX
HP OpenVMS Itanium
HP OpenVMS Alpha

Symptoms

Connnecting to Rdb via OCI Services fails with RDMS-E-RTNUSENOTALL:

$ sqlplus scott/tiger@personnel

SQL*Plus: Release 10.2.0.4.0 - Production on Fri May 21 04:47:02 2010

Copyright (c) 1982, 2007, Oracle. All Rights Reserved.

ERROR:
ORA-32800: internal error [No corresponding Oracle message for Rdb error]
%RDB-E-EXTFUN_FAIL, external routine failed to compile or execute successfully
-RDMS-E-RTNUSENOTALL, routine "ORA_SET_NLS" can not be used, too many
privileges available


Older versions could give a slightly different error:

$ sqlplus dmb/password@dmbociu

SQL*Plus: Release 3.1.3.1.3 - Production on Tue Mar 31 11:06:53 1998

Copyright (c) Oracle Corporation 1979, 1994. All rights reserved.

ERROR: ORA-00001: unique constraint (%s.%s) violated
%RDB-E-EXTFUN_FAIL, external routine failed to compile or execute successfully
-RDMS-E-RTNUSENOTALL, routine "ORA_SET_NLS" can not be used, too many privileges available

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms