RDBPROD: %SQLSRV-E-BADDBAUTHATTR, Unsupported or Unknown DB Access Authorization (Doc ID 101588.1)

Last updated on JUNE 07, 2017

Applies to:

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


Symptoms

An OCI Services executor fails to start.
Attempts to connect to it fail.

$ sqlplus scott/tiger@personnel

SQL*Plus: Release 10.2.0.4.0 - Production on Tue May 25 06:50:26 2010

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

ERROR:
ORA-28547: connection to server failed, probable Oracle Net admin error


The dispatcher log shows errors like

---EVENT BEG: EVENT_LOG ------------------------ Tue May 25 08:53:40.640 2010---
%SQLSRV-I-EVENT_LOG, event logged at line 9477 in file CMD.C;1
Error returned from monitor in creating executor
%SQLSRV-E-EXECSTARTFAIL, Executor startup failed for executor
%SQLSRV-I-CONNECTNAME, Connect : CONNECT_0000040
%SQLSRV-I-CONNECTSTATE, Connect state: 3 (RUNNING)
%SQLSRV-I-SERVICENAME, Service : OCISERV
---EVENT END: EVENT_LOG ------------------------ Tue May 25 08:53:40.640 2010---

---EVENT BEG: EVENT_LOG ------------------------ Tue May 25 08:53:40.640 2010---
%SQLSRV-I-EVENT_LOG, event logged at line 920 in file MSG_COM_OCI.C;1
%SQLSRV-I-OCI_DISCONNECT, OCI client disconnected from OCISERV service due to the following reason:
%SQLSRV-E-EXECSTARTFAIL, Executor startup failed for executor
---EVENT END: EVENT_LOG ------------------------ Tue May 25 08:53:40.640 2010---


The executor log shows errors like

---EVENT BEG: EVENT_LOG ------------------------ Tue May 25 08:53:33.840 2010---
%SQLSRV-I-EVENT_LOG, event logged at line 344 in file SRVEXEUTL.C;1
%SQLSRV-I-EXECSTARTING, Executor OCISER0170001 starting for service OCISERV
---EVENT END: EVENT_LOG ------------------------ Tue May 25 08:53:33.840 2010---

---EVENT BEG: EVENT_LOG ------------------------ Tue May 25 08:53:33.840 2010---
%SQLSRV-I-EVENT_LOG, event logged at line 518 in file SRVEXEUTL.C;1
%SQLSRV-E-BADDBAUTHATTR, Unsupported or unknown database access authorization attribute 0
---EVENT END: EVENT_LOG ------------------------ Tue May 25 08:53:33.840 2010---

%DBS-F-BUGCHECK: bugcheck dump will be written to DISK$:[USER]SQS_node_OCISER0170001.DMP;1
%NONAME-F-NOMSG, Message number 0731C26C


The bugcheck dump summary (produced using the script from <Document 165466.1>) starts

Alpha OpenVMS 8.3
Oracle SQL/Services 7.3.0.2.0
SQL*Net for Rdb
DBS-F-BUGCHECK in SRVEXEUTL at line 524
Database authorization Service Owner not supported
Called from RDB$NATCONN73\gtwmai Module GTWMAI + 000009B8; line 399773

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