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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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
821 views