OraFAQ Forum: Server Administration » Data guard implementation on oracle 9i

Home » RDBMS Server » Server Administration » Data guard implementation on oracle 9i (9.0.4.0)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Data guard implementation on oracle 9i [message #330280]

Sat, 28 June 2008 15:11

saharookiedba
Messages: 56
Registered: September 2007
Location: PUNE

Member

hi
we are trying to implement dataguard in Oracle 9i.
we facing the below issue.
please let us know is it due to some parameteres in init file in standby and primary database..

kcrrfail: dest:2 err:4031 force:0
ORA-04031: unable to allocate  bytes of shared memory ("","","","")
Error 4031 attaching RFS server to standby instance at host 'STANDBY'
Error 4031 attaching to destination LOG_ARCHIVE_DEST_2 standby host 'STANDBY'

Report message to a moderator

Re: Data guard implementation on oracle 9i [message #330283 is a reply to message #330280]

Sat, 28 June 2008 15:19

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

http://www.orafaq.com/forum/t/88153/0/
Please read & FOLLOW the Posting Guideline as stated in URL above

V9.0.4 is unsupported & VERY buggy

What is the hardware configuration?

>please let us know is it due to some parameteres in init file in standby and primary database..
It is due to parameter is spfile.

What results from:
SQL> SHOW SGA

Report message to a moderator

Re: Data guard implementation on oracle 9i [message #330288 is a reply to message #330283]

Sat, 28 June 2008 17:49

saharookiedba
Messages: 56
Registered: September 2007
Location: PUNE

Member

sga parameters of primary and standby database is same

Total System Global Area 2097786968 bytes
Fixed Size 458840 bytes
Variable Size 1048576000 bytes
Database Buffers 1048576000 bytes
Redo Buffers 176128 bytes

Report message to a moderator

Re: Data guard implementation on oracle 9i [message #330289 is a reply to message #330280]

Sat, 28 June 2008 18:34

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

SQL> sho sga
Total System Global Area 1610612736 bytes
Fixed Size                  2073088 bytes
Variable Size             285216256 bytes
Database Buffers         1308622848 bytes
Redo Buffers               14700544 bytes

Report message to a moderator

Previous Topic:	ASM database rebuild
Next Topic:	PFILE and SPFILE

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Sep 08 23:28:59 CDT 2024