Tag: database

Datascape Episode 55: The State of Database Security in 2022

episode 55

Episode 55 Shownotes Welcome to another episode of the Datascape Podcast. In today’s show, Simon Pane talks about what database security will look like in 2022. Together the hosts discuss various topics, including the current state of enterprise database security,…

Read More >

Moving your Oracle Database to the Cloud? Here’s Why You Should be Thinking Google Cloud

Oracle has long been a top choice for relational databases—but migrating those workloads to the cloud requires a lot more effort than a simple lift and shift. Oracle databases are typically large and complex, so if you’re looking to migrate…

Read More >

How to Transform Your Legacy SAP Environment with Google Cloud

In the enterprise resource planning (ERP) market, SAP is the recognized market leader, with a massive installed base around the world. But much of that installed base is running on-premises ERP. As part of its commitment to the future of…

Read More >

Best Practices to Follow When Migrating to Google Cloud

If you’ve been running workloads on-premises for years, migrating to the cloud can be a daunting prospect. You probably already have some workloads in the cloud (public, private or both), but they’re most likely workloads that were considered ‘low-hanging fruit’…

Read More >

Bugs with iscsi-initiator-utils*-6.2.0.878-5

This is a quick post for anyone experiencing iSCSI (Internet Small Computer Systems Interface) target login issues on Linux 8. Symptoms include: 1. Upon machine start, iSCSI node target logon does not succeed automatically during the boot process. (This was…

Read More >

How to Clean up Trace and Audit Files for Multiple Homes

I’ve been working on a simple method to clean up audit and trace files for multiple homes. Let’s see how grid and database homes can be found from oratab. $ sort -u -t : -k 2,2 /etc/oratab | grep -v…

Read More >

Creating a Read-Only Account on Database with VPD or Label Security

I have an interesting case to share in this post. The story started when a client asked for a read-only account (let’s call it RO_USER) with access to objects under another schema (let’s call it SCHEMA_OWNER). Easy going, right? Create…

Read More >

Five Best Practices for Setting Dispatchers on Shared Connections

In this post I’d like to present five best practices/tips for setting dispatchers for database shared connections: 1. Set local_listener on both instances of the database alter system set LOCAL_LISTENER=”(address=(protocol=tcp)(port=1521)(host=yourhost))” scope=both sid=’instance_name’; Ref: Shared Server: Dispatchers Are Not Registered With…

Read More >

Select vs Assign – How To Assign PL/SQL Variables

When writing PL/SQL, should you use ‘select from dual’ to assign variable values? The answer may surprise you.

Read More >

Automating Oracle Patching With an Ansible Module

Editor’s Note: Because our bloggers have lots of useful tips, every now and then we bring forward a popular post from the past. We originally published today’s post on February 13, 2019. This blog post has been on my To…

Read More >
Page 1 of 512345