Forum Stats

  • 3,783,301 Users
  • 2,254,754 Discussions
  • 7,880,358 Comments

Discussions

Problem with sqlplus connection

chileme88
chileme88 Member Posts: 52 Blue Ribbon
edited Sep 16, 2021 7:55AM in Heterogeneous Connectivity

Hi all,

I have 2 nodes rac database 19c with 1 node Data Guard.

In my production I create the service for the pdb PDBMW called PDBMWSRV:

Service name: PDBMWSRV

Server pool:

Cardinality: 2

Service role: PRIMARY

Management policy: AUTOMATIC

DTP transaction: false

AQ HA notifications: true

Global: false

Commit Outcome: true

Failover type: AUTO

Failover method:

Failover retries: 1

Failover delay: 3

Failover restore: AUTO

Connection Load Balancing Goal: LONG

Runtime Load Balancing Goal: THROUGHPUT

TAF policy specification: NONE

Edition:

Pluggable database name: PDBMW

Hub service:

Maximum lag time: ANY

SQL Translation Profile:

Retention: 86400 seconds

Replay Initiation Time: 600 seconds

Drain timeout: 300 seconds

Stop option: immediate

Session State Consistency: AUTO

GSM Flags: 0

Service is enabled

Preferred instances: CDB11,CDB12

Available instances:

CSS critical: no

Service uses Java: false


Yesterday i power off the the data guard node and when I connect from sqlplus to the production service PDBMWSRV the exit hanging for 30 sec. When I use the default service PDBMW I dont have this issue.

In my tns I have:

PDBMWSRV =

 (DESCRIPTION =

  (ADDRESS_LIST =

        (FAILOVER = ON)

        (LOAD_BALANCE = OFF)

        (ADDRESS = (PROTOCOL = TCP)(HOST = oraclung.animasgr.net)(PORT = 1541))

        (ADDRESS = (PROTOCOL = TCP)(HOST = oradrclung.animasgr.net)(PORT = 1541))

    )

  (CONNECT_DATA =

   (SERVER = DEDICATED)

   (SERVICE_NAME = PDBMWSRV)

  )

 )

PDBMW =

 (DESCRIPTION =

  (ADDRESS_LIST =

        (FAILOVER = ON)

        (LOAD_BALANCE = OFF)

        (ADDRESS = (PROTOCOL = TCP)(HOST = oraclung.animasgr.net)(PORT = 1541))

        (ADDRESS = (PROTOCOL = TCP)(HOST = oradrclung.animasgr.net)(PORT = 1541))

    )

  (CONNECT_DATA =

   (SERVER = DEDICATED)

   (SERVICE_NAME = PDBMW)

  )

 )


What is the cause of this issue?

Tagged: