My Oracle Support Banner

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

Last updated on JANUARY 06, 2020

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.

NOTE:  scott/tiger user is being used in the example, this is not an actual PRODUCTION or Customer Data.  It is solely for testing purposes to access data from the Oracle Supplied samples.

$ 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---

ÛS-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

Changes

 

Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.