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
zeeshan047
Messages: 99
Registered: June 2010
Location: PAKISTAN
Member

hi,

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 10.2.0.1.0 - 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
s.inst_id,s.addr,s.in...","Typecheck","seg:kggfaAllocSeg")
  • Attachment: INITorcli.ORA
    (Size: 1.74KB, Downloaded 1819 times)
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: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Increase the shared pool and retry.
In addition, use a large pool.

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


Current Time: Thu Mar 28 03:05:42 CDT 2024