Author: dbalifeeasy

How to Check if TDE ( Transparent Data Encryption ) is Enabled in Oracle Database

This post shows us how to check if TDE ( Transparent Data Encryption ) has even been enabled or not in your Oracle database, even there is no encrypted tables or tablespaces in your Oracle database at the moment.

Subscribe to get access

Read more of this content when you subscribe today.

Subscribe

How to Know RAC Instance Disabled ?

The client RAC database has 4 nodes, but due to the resource and load reasons, two of the 4 instances were disabled by the following command :

$ srvctl disable instance -db TESTDB -instance TESTDB2, TESTDB4

But after a period of time, the client forgot which instances have been disabled exactly.

Here is the right way to report a RAC instance is disabled or not.

Subscribe to get access

Read more of this content when you subscribe today.

Subscribe

ORA-28040: No matching authentication protocol

After Oracle database server upgraded from 11.2.0.4 to 12.2.0.1, client application connections throw the following errors:

at org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1549)
at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1388)
at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044)
at org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider.getConnection(LocalDataSourceConnectionProvider.java:83)
at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:446)
... 27 more
Caused by: java.sql.SQLException: ORA-28040: No matching authentication protocol

SOLUTION

Add the following line into sqlnet.ora file of ORACLE_HOME:

SQLNET.ALLOWED_LOGON_VERSION_SERVER=8

Then client application connects to new database working fine.

asmcmd pwcopy password file into ‘DB_UNKNOWN’ directory

When trying to copy password file of primary databases for standby database, unfortunately the password file was located into a directory called “DB_UNKNOWN”.

$ asmcmd pwcopy /tmp/orapwTESTDB +DATAC1/TESTDB/PASSWORD/
copying /tmp/orapwTESTDB -> +DATAC1/TESTDB/PASSWORD/orapwTESTDB
$ asmcmd
ASMCMD> cd +DATAC1/TESTDB/PASSWORD/
ASMCMD> ls -lt
Type      Redund  Striped  Time             Sys  Name
PASSWORD  HIGH    COARSE   JUL 16 14:00:00  Y    pwdtestdb.372.1078064659
PASSWORD  HIGH    COARSE   JUL 16 17:00:00  N    orapwtestdb => +DATAC1/DB_UNKNOWN/PASSWORD/pwddb_unknown.266.1078077567

SOLUTION

Subscribe to get access

Read more of this content when you subscribe today.

Sorry! This product is not available for purchase at this time.

Finally you need modify the database configuration to use the new password file:

$ srvctl modify database -d TESTDB  -pwfile +DATAC1/TESTDB/PASSWORD/pwdtestdb.372.1078078773

RMAN Register Database : RMAN-03014 RMAN-03009 ORA-01403

The following errors occur while registering the database in RMAN into RMAN catalog:

RMAN> register database;

starting full resync of recovery catalog
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of register command at 07/16/2021 15:39:33
RMAN-03014: implicit resync of recovery catalog failed
RMAN-03009: failure of full resync command on default channel at 07/16/2021 15:
ORA-01403: no data found

INVESTIGATIONS AND SOLUTION

Subscribe to get access

Read more of this content when you subscribe today.

Subscribe