Wednesday, January 23, 2019

'DB_UNKNOWN' directory was created when using asmcmd pwcopy (Doc ID 2329386.1)

In this Document
Symptoms
Changes
Cause
Solution
References


APPLIES TO:

Oracle Database - Enterprise Edition - Version 12.2.0.1 and later
Information in this document applies to any platform.

SYMPTOMS

'DB_UNKNOWN' directory was created when using asmcmd pwcopy to copy the password file.
ASMCMD> pwcopy /tmp/pworcl +DATAP/orcl/PASSWORD/pwdorcl
copying /tmp/pworcl -> +DATAP/orcl/PASSWORD/pwdorclASMCMD> ls -l
Type Redund Striped Time Sys Name
PASSWORD UNPROT COARSE NOV 16 16:00:00 N pwdorcl => +DATAP/DB_UNKNOWN/PASSWORD/pwddb_unknown.256.960224193

CHANGES

DB resource is not present on CRS when coping password file by pwcopy.
[grid@duke1 ~]$ crsctl stat res ora.orcl.db -t
CRS-2613: Could not find resource 'ora.orcl.db'.

CAUSE

This is expected behavior. 
When DB resource is not present on CRS and "--dbuniquename" option is not specified in pwcopy command,
the password file will be created within 'DB_UNKNOWN' directory as pwcopy can not get DB name. 
if "--dbuniquename" was specified, the password file will be created within the DB name directory that specified by "--dbuniquename" option.

When DB resource is present on CRS, 'DB_UNKNOWN' was not observed even "--dbuniquename" option is not specified in pwcopy command
as the DB name can be got from CRS.

SOLUTION

Specifie DB name by "--dbuniquename" option when DB resource is not present on CRS.
[grid@duke1 ~]$ asmcmd
ASMCMD> pwcopy --dbuniquename orcl /tmp/pworcl +DATAP/orcl/PASSWORD/pwdorcl
PRCD-1120 : The resource for database orcl could not be found.
PRCR-1001 : Resource ora.orcl.db does not exist
ASMCMD-9457: an internally issued srvctl command failed with errors
copying /tmp/pworcl -> +DATAP/orcl/PASSWORD/pwdorcl
ASMCMD-9453: failed to register password file as a CRS resourceNote: These errors are expected due to "orcl" is not present on CRS.
ASMCMD> ls -l
Type Redund Striped Time Sys Name
PASSWORD UNPROT COARSE NOV 16 17:00:00 N pwdorcl => +DATAP/orcl/PASSWORD/pwdorcl.256.960224879
PASSWORD UNPROT COARSE NOV 16 17:00:00 Y pwdorcl.256.960224879
OR
Copy password file by pwcopy after ran "srvctl add database" to add database to CRS. 
[oracle@duke1 ~]$ srvctl add database -d orcl -o $ORACLE_HOME -n orcl -p "+DATAP/ORCL/PARAMETERFILE/spfile.268.959095489"
[oracle@duke1 ~]$ su - grid
[grid@duke1 ~]$ asmcmd
ASMCMD> pwcopy /tmp/pworcl +DATAP/orcl/PASSWORD/pwdorcl
copying /tmp/pworcl -> +DATAP/orcl/PASSWORD/pwdorcl
ASMCMD> ls -l
Type Redund Striped Time Sys Name
PASSWORD UNPROT COARSE NOV 16 17:00:00 N pwdorcl => +DATAP/orcl/PASSWORD/pwdorcl.256.960226829
PASSWORD UNPROT COARSE NOV 16 17:00:00 Y pwdorcl.256.960226829