My Oracle Support Banner

ORA-45540: Call To SRVCTL Failed With Status 1, Errors: PRKO-3146 : Missing Required \'-preferred\' (Doc ID 2677557.1)

Last updated on JUNE 28, 2020

Applies to:

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

Goal

GDSCTL command sync database got the warning below for physical standby pool database:

GDSCTL> sync database -database <pool database db_unique_name> -gdspool <GDS pool name>
GSM Warnings:
<pool database db_unique_name>:ORA-45540: Call to SRVCTL failed with status 1, errors: PRKO-3146 : Missing required \'-preferred\' option
.[ at modify local params : <service name> ]


srvctl config service -s <service name> -d <pool database db_unique_name>
Service name: <service name>
Server pool:
Cardinality: 2
Service role: PRIMARY
Management policy: MANUAL
DTP transaction: false
AQ HA notifications: true
Global: true
Commit Outcome: false
Failover type: SELECT
Failover method: BASIC
Failover retries: 20
Failover delay: 15
Failover restore: NONE
Connection Load Balancing Goal: LONG
Runtime Load Balancing Goal: SERVICE_TIME
TAF policy specification: NONE
Edition:
Pluggable database name:
Hub service:
Maximum lag time: any
SQL Translation Profile:
Retention: 86400 seconds
Replay Initiation Time: 300 seconds
Drain timeout:
Stop option: none
Session State Consistency: DYNAMIC
GSM Flags: 0
Service is enabled
Preferred instances: <instance1 name>,<instance2 name> <=============
Available instances:
CSS critical: no
Service uses Java: false

 

GDSCTL> config service -service <service name> -gdspool <GDS pool name>  doesn't show the preferred instance

Solution

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
Goal
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.