Comments for Virtual-DBA Remote DBA Services & Support – Certified Database Experts https://virtual-dba.com/ Remote Database Administration Wed, 12 Nov 2025 16:46:19 +0000 hourly 1 https://wordpress.org/?v=6.9.4 Comment on The DBA’s Role in Application Security by Madurai Jewellery https://virtual-dba.com/blog/the-dbas-role-in-application-security/#comment-17185 Wed, 02 Apr 2025 14:26:42 +0000 https://virtual-dba.com/?p=242544#comment-17185 I’m impressed by how well you’ve articulated your points!

]]>
Comment on Setting up FSLogix with Azure Virtual Desktop by Anonymous_026 https://virtual-dba.com/blog/setting-up-fslogix-with-azure-virtual-desktop/#comment-12726 Sat, 07 Sep 2024 11:10:53 +0000 https://virtual-dba.com/?p=240895#comment-12726 Thanks for sharing the above info, really useful Jerrad!

]]>
Comment on ORA-12560 Error Message TNS Protocol Adapter Error by Anonymous https://virtual-dba.com/blog/ora-12560-error-message-tns-protocol-adapter/#comment-12378 Fri, 30 Aug 2024 05:22:11 +0000 https://virtual-dba.com/?p=237900#comment-12378 Great article! The ORA-12560 error can be really frustrating, and your step-by-step troubleshooting tips were super helpful. I especially appreciated the section on checking the listener status. Thanks for sharing your insights!

]]>
Comment on How to Set SSIS Package ‘Connection Timeout’ to Unlimited by Jim M. https://virtual-dba.com/blog/ssis-package-connection-timeout-unlimited/#comment-11857 Mon, 12 Aug 2024 19:41:18 +0000 https://virtual-dba.com/?p=29655#comment-11857 This is an old post. . . n.b. the connection string settings vary by the driver used to connect to the database. e.g. MSOLEDBSQL/MSOLEDBSQL19 drivers use Timeout rather than Connect Timeout. When using the oledb drivers, setting a value for Connect Timeout the connecition GUI does nothing. You must modify the connection string and save it.

]]>
Comment on Resolving the ORA-24247: network access denied by access control list (ACL) error by Joaquin https://virtual-dba.com/blog/resolving-the-ora-24247/#comment-11500 Thu, 01 Aug 2024 14:45:38 +0000 https://virtual-dba.com/?p=37585#comment-11500 Hola, paso a responder, que encontré otra manera de resolver este error:

BEGIN
DBMS_NETWORK_ACL_ADMIN.CREATE_ACL(
acl => ‘http_access.xml’,
description => ‘HTTP Access’,
principal => ‘SCHEMA_NAME’, — Reemplaza ‘SCHEMA_NAME’ con el esquema del usuario que ejecuta el procedimiento
is_grant => TRUE,
privilege => ‘connect’
);
END;
/

BEGIN
DBMS_NETWORK_ACL_ADMIN.ADD_PRIVILEGE(
acl => ‘http_access.xml’,
principal => ‘SCHEMA_NAME’, — Reemplaza ‘SCHEMA_NAME’ con el esquema del usuario que ejecuta el procedimiento
is_grant => TRUE,
privilege => ‘resolve’
);
END;
/

BEGIN
DBMS_NETWORK_ACL_ADMIN.ASSIGN_ACL(
acl => ‘http_access.xml’,
host => ‘tu_url’, — El host de la URL
lower_port => 8100, — El puerto de la URL
upper_port => 8100 — El puerto de la URL
);
END;

COMMIT;

SELECT * FROM DBA_NETWORK_ACLS;
SELECT * FROM DBA_NETWORK_ACL_PRIVILEGES;

]]>
Comment on Sockets, Cores, and Threads, oh my! by Scott Scoville https://virtual-dba.com/blog/sockets-cores-and-threads/#comment-9339 Thu, 06 Jun 2024 12:24:08 +0000 https://virtual-dba.com/?p=37336#comment-9339 Very good article, very clear, yet does not mention “dual-core,” “quad-core,” or what is meant by these idioms. Would have been helpful to say whether the machine in the final example would be called a “quad-core.”

]]>
Comment on Setting up FSLogix with Azure Virtual Desktop by Jerrad Dahlager https://virtual-dba.com/blog/setting-up-fslogix-with-azure-virtual-desktop/#comment-8095 Tue, 14 May 2024 14:41:20 +0000 https://virtual-dba.com/?p=240895#comment-8095 In reply to Vinod.

I have not finalized this with Entra Domain Services, formally known as Azure AD Domain Services, but I plan to here soon.

]]>
Comment on MariaDB Galera Cluster WSREP_SST_METHOD Explained by Cheryl Bryll https://virtual-dba.com/blog/mariadb-galera-cluster-explained/#comment-7926 Tue, 07 May 2024 19:40:30 +0000 https://virtual-dba.com/?p=240438#comment-7926 In reply to Max Adamo.

Hi Max –
In MariaDB 10.3 Percona XtraBackup is not supported at all. Prior to 10.3 there may be partial support for using XtraBackup if certain condictions are met.

MariaDB’s website will help clear this up for you.
https://mariadb.com/kb/en/percona-xtrabackup-overview/#compatibility-with-mariadb

]]>
Comment on How to Troubleshoot and Fix ORA-00257: archiver error by Cheryl Bryll https://virtual-dba.com/blog/troubleshoot-ora-00257-archiver-error/#comment-7127 Mon, 08 Apr 2024 21:41:11 +0000 https://virtual-dba.com/?p=237465#comment-7127 In reply to suresh.

Yes – if your ASM diskgroup is +FRA instead of +RECO then you follow the same steps but use the appropriate ASM diskgroup.

]]>
Comment on Resolving the ORA-24247: network access denied by access control list (ACL) error by jose https://virtual-dba.com/blog/resolving-the-ora-24247/#comment-5582 Mon, 29 Jan 2024 16:45:55 +0000 https://virtual-dba.com/?p=37585#comment-5582 ORA-20001: The following error has occured: ORA-24247: network access denied by access control list (ACL)
ORA-00001: unique constraint (RECEDE.PK_TB_SUJETO) violated
ORA-02063: preceding line from DBL_YAXHA
ORA-06512: at “RECEDE.PKG_MIGRACION_CONSULTA”, line 32
ORA-06512: at “RECEDE.PKG_MIGRACION_CONSULTA”, line 341
ORA-06512: at “RECEDE.PKG_MIGRACION_CONSULTA”, line 947
ORA-06512: at line 7

]]>