Tag: database

Interesting variations in outcome when cloning a CDB with a subset of PDBs in Oracle

Recently I was working on a client request where a CDB along with a subset of its PDBs had to be cloned to a new server for testing purposes. This post illustrates that in certain circumstances the outcome of this…

Read More >

Slow Query in eBS AutoConfig with DB 19c

slow query

We recently completed a few e eBS R12.2 database upgrade installations and noticed an issue with a particular SQL running as part of the AutoConfig.       The query sql_id is 5da8tjzfafw6j and it looks like this (formatted): select…

Read More >

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 >
Page 1 of 512345