Home » Server Options » Data Guard » Error while connecting standby database (Oracle 10g windows OS)
Error while connecting standby database [message #503672] Tue, 19 April 2011 00:16 Go to next message
Messages: 99
Registered: June 2010
Location: PAKISTAN


During data guard configuration i have receive an error while connecting to stanby database from primary database rman prompt.

rman target sys/srk786@orcli

Recovery Manager: Release - Production on Tue Apr 19 09:59:26 2011

Copyright (c) 1982, 2005, Oracle. All rights reserved.

connected to target database: ORCLI (DBID=3754068166)

RMAN> connect auxiliary sys/srk786@stnd

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-12001: could not open channel clone_default
RMAN-10008: could not create channel context
RMAN-10024: error setting up for rpc polling
RMAN-10006: error running SQL statement: select action from gv$session where sid
=:1 and serial#=:2 and inst_id=:3
RMAN-10002: ORACLE error: ORA-00604: error occurred at recursive SQL level 1
ORA-04031: unable to allocate 404 bytes of shared memory ("shared pool","select
Re: Error while connecting standby database [message #503703 is a reply to message #503672] Tue, 19 April 2011 01:38 Go to previous message
Michel Cadot
Messages: 68500
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Increase the shared pool and retry.
In addition, use a large pool.

Previous Topic: Data Guard - Archivelogs with FAL request are created at different location
Next Topic: datagaurd configuration
Goto Forum:

Current Time: Sat Sep 23 18:19:53 CDT 2023