Category: Premium Content

How To Change SYS Password On ExaCC

Changing Oracle Database SYS user password is more complicated in Exacc Gen 2 environment.

The following should be considered, and takes action appropriately when changing SYS user password:

Subscribe to get access

Read more of this content when you subscribe today.

Subscribe

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

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