Home » RDBMS Server » Server Administration » Data guard implementation on oracle 9i (9.0.4.0)
Data guard implementation on oracle 9i [message #330280] Sat, 28 June 2008 15:11 Go to next message
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'
Re: Data guard implementation on oracle 9i [message #330283 is a reply to message #330280] Sat, 28 June 2008 15:19 Go to previous messageGo to next message
BlackSwan
Messages: 25050
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
Re: Data guard implementation on oracle 9i [message #330288 is a reply to message #330283] Sat, 28 June 2008 17:49 Go to previous messageGo to next message
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


Re: Data guard implementation on oracle 9i [message #330289 is a reply to message #330280] Sat, 28 June 2008 18:34 Go to previous message
BlackSwan
Messages: 25050
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
Previous Topic: ASM database rebuild
Next Topic: PFILE and SPFILE
Goto Forum:
  


Current Time: Sat Dec 10 07:16:38 CST 2016

Total time taken to generate the page: 0.25456 seconds