Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Oracle ASM 12c passwordfile location problem???

DBA84Sep 6 2018 — edited Sep 10 2018

OS: Oracle Linux Server release 7.4

DB: Oracle RAC Database 12.2.0.1 (upgraded from 11.2.0.4)

My Oracle RAC Database which is configured with ASM successfully upgraded from 11g.

After successful upgrade I want to move ASM passwordfile from host to ASM in shared location.

Initially password location is

[oracle@testrac1 dbs]$ asmcmd pwget --asm

/u02/app/12.2.0/grid/dbs/orapw+ASM

I change environment variables ORACLE_HOME and ORACLE_SID to enter ASM environment. Then move asm password file to ASM.

ASMCMD [+] > pwmove --asm /u02/app/12.2.0/grid/dbs/orapw+ASM +DATA/test/orapwasm -f

moving /u02/app/12.2.0/grid/dbs/orapw+ASM -> +DATA/test/orapwasm

Until here everything is OK. I check the new location as

[oracle@testrac1 dbs]$ asmcmd pwget --asm

+DATA/test/orapwasm

But when I check  the diskgroup content I saw the following DB_UNKNOWN directory created automatically.

ASMCMD [+data] > ls

DB_UNKNOWN/

TEST/

_mgmtdb/

testrac/

I realize that password extension was created in DB_UNKNOWN directory.

ASMCMD [+data/test] > ls -l

Type           Redund  Striped  Time             Sys  Name

                                                 Y    CONTROLFILE/

                                                 Y    DATAFILE/

                                                 Y    ONLINELOG/

                                                 Y    PARAMETERFILE/

                                                 Y    TEMPFILE/

PASSWORD       UNPROT  COARSE   SEP 06 11:00:00  N    orapwasm => +DATA/DB_UNKNOWN/PASSWORD/pwddb_unknown.306.986125843

PARAMETERFILE  UNPROT  COARSE   SEP 05 17:00:00  N    spfiletest.ora => +DATA/TEST/PARAMETERFILE/spfile.267.984680767

Actually orapwasm file extension must be created in +DATA/TEST/PASSWORD/pwddb_unknown.306.986125843

What is the reason for this? How can I move or copy passwordfile to ASM diskgroup 'have to' location?

THANKS!!

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 4 2018
Added on Sep 6 2018
2 comments
879 views