Tag: Oracle

Using FreeRadius to Authorize Oracle Connections

Jared Still shows you how to setup the open source RADIUS server FreeRadius so it may be used to authenticate database connections.

Read More >

How to Read Oracle Traces from SQL*Plus

Let’s say you need to read trace files from Amazon Relational Database Service (RDS). How do you do it? Here is an example of how to list and read those files using rdsadmin: SQL> select * from dba_directories; OWNER DIRECTORY_NAME…

Read More >

Use RMAN KEEP Backup To Roll Back From an Upgrade

There is a requirement to back up a database before an application upgrade to be able to rollback. Guarantee Restore Point (GRP) was first considered by us; however, it looks like there is insufficient space from Flash Recovery Area (FRA)….

Read More >

PART 4: Implementing Oracle Database Single Sign-on Using Kerberos, Active Directory, and Oracle CMU

This is the fourth and final article in a four-part series related to testing Oracle Database 18c Centrally Managed Users (CMU) by leveraging the Oracle Cloud Infrastructure (OCI) for Oracle DBAs to create a lab or testbed. The third article…

Read More >

PART 3: Implementing Oracle Database Active Directory Password Synchronization using Oracle CMU

This is the third in a four-part article series related to testing Oracle Database 18c Centrally Managed Users (CMU) by leveraging the Oracle Cloud Infrastructure (OCI) for Oracle DBAs to create a lab or testbed. The second article covered Configuring…

Read More >

Let DataGuard Broker Do ALL The Work

What’s the reason for implementing DataGuard Broker? It does all the work. eg. Test system has been shutdown and upon startup, encountered error as shown. Shutdown database and startup mount. Check DataGuard status using dgmgrl. Note: standby recovery was automatically…

Read More >

How to Stop All Database Instances Running From ORACLE_HOME

At times, there may be a requirement to stop database instances, for example, to perform patching. When there is only one database instance running on the server, it is sufficient to stop the instance using srvctl stop instance -d db_unique_name…

Read More >

PART 2: Configuring Windows and Linux Servers for CMU Testing

This is the second in a four-part article series related to testing Oracle Database 18c Centrally Managed Users (CMU) by leveraging the Oracle Cloud Infrastructure (OCI) for Oracle DBAs to create a lab or testbed. The first article covered how…

Read More >

OEM 13c Monitoring Features – Part 5, Best Practices and Automatic Incident Creation

This is the fifth in a series of blog posts covering the most important topics you should know to completely monitor your IT infrastructure with Oracle Enterprise Manager Cloud Control 13c. The previous posts covered basic monitoring, extended metrics, metric…

Read More >

PART 1: Creating an Oracle 18c Centrally Managed Users Testbed using Oracle Cloud Infrastructure

Oracle Database 18c introduced a new feature called Centrally Managed Users (CMU) to allow simplified database user management through integration with Microsoft Active Directory (AD). This is an exciting and much-needed enhancement. Previously, complex additional tiers such as Oracle Unified…

Read More >
Page 3 of 16412345...10...Last Page »