My Oracle Support Banner

Create Test Master: SQL Plus Error Code Is 256 Fetch_acl_status0.sql (Doc ID 2556576.1)

Last updated on FEBRUARY 04, 2020

Applies to:

Enterprise Manager for Oracle Database - Version 13.2.2.0.0 and later
Information in this document applies to any platform.

Symptoms

EM 13.2.2
Errors on the step CONFIG_ACL of creating the TestMaster database to create a SnapClone

Navigation:
Cluster Database > Cloning > Create Test Master

The procedure running errors:
Procedure Activity: Test Master Creation_SYSMAN_
Procedure Steps:
-Configure ACL in ASM diskgroup
--Configure Database diskgroup and datafile
---<HOSTNAME>
----Configure Database diskgroup

Final command line to execute is $PERL_HOME/perl "/tmp/JOB_8AAA4C9985EC59E7E053181B0A0A3481/confASMDisk.pl" -workDir="/tmp" -asmHome="<GRID_HOME>" -asmSID="+ASM1" -userId="" -dataFiles="<DISKGROUP_NAME>/ORCLTM1/DATAFILE/system.2271.1010221957,<DISKGROUP_NAME>/ORCLTM1/DATAFILE/sysaux.2292.1010221965,<DISKGROUP_NAME>/ORCLTM1/DATAFILE/undotbs1.2293.1010221971,<DISKGROUP_NAME>/ORCLTM1/DATAFILE/undotbs2.2294.1010221977,<DISKGROUP_NAME>/ORCLTM1/DATAFILE/users.2295.1010221983" -operation="CONFIGURE_ACL" -asmVersion="18.0.0.0.0" -rdbmsVersion="18.0.0.0.0" -aclDfOwner="<USER>" -aclDfGroup="<GROUP>" -aclDfOwnerPerm="read only" -aclDfGroupPerm="read only" -aclDfOtherPerm="" -sysasmusername="SYS" -asmconndesc="(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = <HOSTNAME>)(PORT = <DB_PORT>))(CONNECT_DATA = (SID = +ASM1)(SERVER = DEDICATED)))"

The output of the directive is:
[INFO] - Starting configure database Script...
[INFO] - Work Dir = /tmp
[INFO] - ASM Home = <GRID_HOME>
[INFO] - ASM SID = +ASM1
[INFO] - User ID =
[INFO] - Data Files =<DISKGROUP_NAME>/ORCLTM1/DATAFILE/system.2271.1010221957,<DISKGROUP_NAME>/ORCLTM1/DATAFILE/sysaux.2292.1010221965,<DISKGROUP_NAME>/ORCLTM1/DATAFILE/undotbs1.2293.1010221971,<DISKGROUP_NAME>/ORCLTM1/DATAFILE/undotbs2.2294.1010221977,<DISKGROUP_NAME>/ORCLTM1/DATAFILE/users.2295.1010221983
[INFO] - Operation = CONFIGURE_ACL
[INFO] - ASM version = 18.0.0.0.0
[INFO] - RDMBS version = 18.0.0.0.0
[INFO] - Datafiles owner = <USER>
[INFO] - Datafiles group = <GROUP>
[INFO] - Datafiles owner permissions = read only
[INFO] - Datafiles group permissions = read only
[INFO] - Datafiles other users permissions =
[INFO] - ASM sys username = SYS
[INFO] - ASM connect Desc = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = <HOSTNAME>)(PORT = <DB_PORT>))(CONNECT_DATA = (SID = +ASM1)(SERVER = DEDICATED)))
[INFO] - Work Dir = /tmp/ASM6719
[INFO] - Validating Params...
[INFO] - Checking Access control list for database
[INFO] - Diskgroup is <DISKGROUP_NAME>
[INFO] - HOME is <GRID_HOME>
[INFO] - SID is +ASM1


ERRORS THOUGH WITH:
When SQL*Plus starts, and after CONNECT commands, the site profile
(e.g. $ORACLE_HOME/sqlplus/admin/glogin.sql) and the user profile
(e.g. login.sql in the working directory) are run. The files may
contain SQL*Plus commands.

Refer to the SQL*Plus User's Guide and Reference for more information.
[INFO] - Error code is 256
[ERROR] - Error occured while executing /tmp/ASM6719/fetch_acl_status0.sql

Deleted temporary destination directory /tmp/JOB_8AAA4C9985EC59E7E053181B0A0A3481
Process returned : 1.
------------------------------------------------------------

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!


In this Document
Symptoms
Cause
Solution
References


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