My Oracle Support Banner

Cannot Create Asmsnmp User ORA-01990 (Doc ID 2028970.1)

Last updated on APRIL 12, 2024

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.2 and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.

Symptoms

When trying to create asmsnmp it fails

 


SQL> create user ASMSNMP identified by xxxx;
create user ASMSNMP identified by xxxx
                                 *
ERROR at line 1:
ORA-01990: error opening password file
'+DATA_NRC1/ORCL/PASSWORD/orapworcl'
ORA-17503: ksfdopn:2 Failed to open file
+DATA_NRC1/ORCL/PASSWORD/orapworcl
ORA-15173: entry 'orcl' does not exist in directory '/'
ORA-06512: at line 4
ORA-17503: ksfdopn:2 Failed to open file
+DATA_NRC1/ORCL/PASSWORD/orapworcl
ORA-15173: entry 'ORCL' does not exist in directory '/'
ORA-06512: at line 4

 

Changes

 12.1.0.2 GI 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.