RDBPROD ORA-01031 when Connecting to an Oracle Rdb database after Reinstalling SQL/Services
(Doc ID 262176.1)
Last updated on APRIL 13, 2020
Applies to:Oracle SQL/Services for Rdb on OpenVMS - Version 7.1 to 7.1 [Release 7.1]
HP OpenVMS VAX
HP OpenVMS Alpha
Oracle SQL/Services 7.1 for Rdb on OPENVMSThis problem can occur on any platform.
- When your SQL*Net clients connect to an Oracle Rdb database the following error is returned:
ERROR: ORA-01031: insufficient privileges
Database not setup correctly for Oracle SQL*Net for Rdb.
For details, look in Oracle SQL/Services executor log file:
- You have just reinstalled (deinstall+install) SQL/Services in your system (or you have deinstalled old version and, later, have installed new version).
- You only have a version of SQL/Services in your system.
- SHOW PROTECTION ON DATABASE doesn't show SQLNET4RDB identifier but a hexadecimal identifier is showed with all privileges:
SQL> SHOW PROTECTION ON DATABASE RDB$DBHANDLE;
Protection on Alias RDB$DBHANDLE
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document