Starting service on pluggable database failed with error ORA-44786 (Doc ID 2862842.1)

Last updated on APRIL 17, 2023

Applies to:

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

Symptoms

NOTE: In the images, examples and document that follow, user details, cluster names, hostnames, directory paths, filenames, etc. represent a fictitious sample (and are used to provide an illustrative example only). Any similarity to actual persons, or entities, living or dead, is purely coincidental and not intended in any manner.

Unable to start service on a PDB in a RAC cluster.

Configuration

3 node RAC cluster - Node1, Node2 and Node3
PDB name - TEST1_TEST_01_TS_TEST_DEPLOY_L0
Service name - TEST1_TEST_01_TS_TEST_DEPLOY_L0_SVC1

Starting the service fails with below errors:

srvctl start service -db <DB_NAME>1 -service TEST1_TEST_01_TS_TEST_DEPLOY_L0_SVC1

PRCD-1133 : failed to start services test1_test_01_ts_test_deploy_l0_svc1 for database <DB_NAME>1

PRCR-1095 : Failed to start resources using filter ((NAME == ora.<DB_NAME>1.test1_test_01_ts_test_deploy_l0_svc1.svc) AND (TYPE == ora.service.type))

CRS-5017: The resource action "ora.<DB_NAME>1.test1_test_01_ts_test_deploy_l0_svc1.svc start" encountered the following error:

ORA-44786: Service operation cannot be completed.

ORA-06512: at "SYS.DBMS_SERVICE", line 76

ORA-06512: at "SYS.DBMS_SERVICE", line 483

ORA-06512: at line 1

. For details refer to "(:CLSN00107:)" in "/opt/grid/diag/crs/Node1/crs/trace/crsd_oraagent_oracle.trc".

CRS-2674: Start of 'ora.<DB_NAME>1.test1_test_01_ts_test_deploy_l0_svc1.svc' on 'Node1' failed

CRS-5017: The resource action "ora.<DB_NAME>1.test1_test_01_ts_test_deploy_l0_svc1.svc start" encountered the following error:

ORA-44786: Service operation cannot be completed.

ORA-06512: at "SYS.DBMS_SERVICE", line 76

ORA-06512: at "SYS.DBMS_SERVICE", line 483

ORA-06512: at line 1

. For details refer to "(:CLSN00107:)" in "/opt/grid/diag/crs/Node2/crs/trace/crsd_oraagent_oracle.trc".

CRS-2674: Start of 'ora.<DB_NAME>1.test1_test_01_ts_test_deploy_l0_svc1.svc' on 'Node2' failed

CRS-5017: The resource action "ora.<DB_NAME>1.test1_test_01_ts_test_deploy_l0_svc1.svc start" encountered the following error:

ORA-44786: Service operation cannot be completed.

ORA-06512: at "SYS.DBMS_SERVICE", line 76

ORA-06512: at "SYS.DBMS_SERVICE", line 483

ORA-06512: at line 1

. For details refer to "(:CLSN00107:)" in "/opt/grid/diag/crs/Node3/crs/trace/crsd_oraagent_oracle.trc".

CRS-2674: Start of 'ora.<DB_NAME>1.test1_test_01_ts_test_deploy_l0_svc1.svc' on 'Node3' failed

CRS-2632: There are no more servers to try to place resource 'ora.<DB_NAME>1.test1_test_01_ts_test_deploy_l0_svc1.svc' on that would satisfy its placement policy

Service test_perm_01_ts_test_deploy_l4_svc is not running.

Starting service using DBMS_SERVICE.START_SERVICE failed too.

>exec DBMS_SERVICE.START_SERVICE('TEST1_TEST_01_TS_TEST_DEPLOY_L0_SVC1');

BEGIN DBMS_SERVICE.START_SERVICE('TEST1_TEST_01_TS_TEST_DEPLOY_L0_SVC1'); END;

ERROR at line 1:

ORA-44786: Service operation cannot be completed.

ORA-06512: at "SYS.DBMS_SERVICE", line 76

ORA-06512: at "SYS.DBMS_SERVICE", line 483

ORA-06512: at line 1

Changes

Create a pluggable database TEST1_TEST_01_TS_TEST_DEPLOY_L0 from PDB$SEED.

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.

Starting service on pluggable database failed with error ORA-44786 (Doc ID 2862842.1)

Applies to:

Symptoms

Changes

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!