Home » RDBMS Server » Server Administration » dataguard server (physical standby) is restarted automatically (Sun Solaris , 12c (12.1.0.1.0))
dataguard server (physical standby) is restarted automatically [message #667988] Tue, 30 January 2018 01:40 Go to next message
daulat01
Messages: 62
Registered: May 2011
Location: Delhi
Member
Hi team,

My dataguard server is restarted automatically & database goes down.

Please refer to below the attached file & my finding in OS file. So I request to you please help me on this issue.

bash-3.00# pwd
/var/crash/solaris
bash-3.00# ls
bounds unix.7 vmcore.7 vmdump.0 vmdump.4 vmdump.5 vmdump.6 vmdump.7
/usr/bin/mdb -k 7
bash-3.00# mdb -k unix.7 vmdump.7
mdb: failed to read 'platform' string from kernel: Error 0
mdb: failed to initialize target: Error 0 bash-3.00# mdb -k unix.7 vmcore.7 Loading modules: [ unix krtld genunix specfs dtrace cpu.generic uppc pcplusmp ufs mpt ip hook neti sctp arp usba fcp fctl nca lofs zfs nfs random crypto md cpc fcip login sppp ipc ]
> : (worry) tatus
debugging crash dump vmcore.7 (64-bit) from vmoracle-tfr-02 operating system: 5.10 Generic_142910-17 (i86pc) panic message: BAD TRAP: type=e (#pf Page fault) rp=fffffe80004d7ac0 addr=7b5e01ff8 occurred in module "vmmemctl" due to an illegal access to a user address dump content: kernel pages only
> : (worry) tack
Balloon_QueryAndExecute+0x387()
0xffffffffec62cfa3()
thread_start+8()

Regards,
Daulat





[Updated on: Tue, 30 January 2018 01:44]

Report message to a moderator

Re: dataguard server (physical standby) is restarted automatically [message #667989 is a reply to message #667988] Tue, 30 January 2018 01:52 Go to previous messageGo to next message
Flyby
Messages: 188
Registered: March 2011
Location: Belgium
Senior Member
According to the web "vmmemctl" is probably a VMWare-driver.
Maybe it needs patching? Security might been stricter due Meltdown,Spectre... patch
Re: dataguard server (physical standby) is restarted automatically [message #667990 is a reply to message #667988] Tue, 30 January 2018 02:56 Go to previous messageGo to next message
John Watson
Messages: 8960
Registered: January 2010
Location: Global Village
Senior Member
Can you explain the problem again, please? It is not clear to me what it is, or if it is Oracle related. For example if your server machine failed for some reason, the database may not be relevant.
Re: dataguard server (physical standby) is restarted automatically [message #667991 is a reply to message #667988] Tue, 30 January 2018 02:56 Go to previous messageGo to next message
John Watson
Messages: 8960
Registered: January 2010
Location: Global Village
Senior Member
Can you explain the problem again, please? It is not clear to me what it is, or if it is Oracle related. For example if your server machine failed for some reason, the database may not be relevant.
Re: dataguard server (physical standby) is restarted automatically [message #667998 is a reply to message #667991] Tue, 30 January 2018 04:22 Go to previous messageGo to next message
daulat01
Messages: 62
Registered: May 2011
Location: Delhi
Member
Hi Johan,

My DB server gets restarted repeatedly. I am not able to understand why? Please see the os logs & alert logs which is already attached.

bash-3.00# pwd
/var/crash/solaris
bash-3.00# ls
bounds unix.7 vmcore.7 vmdump.0 vmdump.4 vmdump.5 vmdump.6 vmdump.7
/usr/bin/mdb -k 7
bash-3.00# mdb -k unix.7 vmdump.7
mdb: failed to read 'platform' string from kernel: Error 0
mdb: failed to initialize target: Error 0 bash-3.00# mdb -k unix.7 vmcore.7 Loading modules: [ unix krtld genunix specfs dtrace cpu.generic uppc pcplusmp ufs mpt ip hook neti sctp arp usba fcp fctl nca lofs zfs nfs random crypto md cpc fcip login sppp ipc ]
> : (worry) tatus
debugging crash dump vmcore.7 (64-bit) from vmoracle-tfr-02 operating system: 5.10 Generic_142910-17 (i86pc) panic message: BAD TRAP: type=e (#pf Page fault) rp=fffffe80004d7ac0 addr=7b5e01ff8 occurred in module "vmmemctl" due to an illegal access to a user address dump content: kernel pages only
> : (worry) tack
Balloon_QueryAndExecute+0x387()
0xffffffffec62cfa3()
thread_start+8()


thanks.

[Updated on: Tue, 30 January 2018 04:24]

Report message to a moderator

Re: dataguard server (physical standby) is restarted automatically [message #668000 is a reply to message #667998] Tue, 30 January 2018 04:32 Go to previous messageGo to next message
cookiemonster
Messages: 13959
Registered: September 2008
Location: Rainy Manchester
Senior Member
If it's the actual server that's restarting, as opposed to the DB, then you'd probably be better off asking your question in a forum that caters to questions about the server.
Re: dataguard server (physical standby) is restarted automatically [message #668030 is a reply to message #668000] Wed, 31 January 2018 20:08 Go to previous messageGo to next message
trantuananh24hg
Messages: 744
Registered: January 2007
Location: Ha Noi, Viet Nam
Senior Member
debugging crash dump vmcore.7 (64-bit) from vmoracle-tfr-02 operating system: 5.10 Generic_142910-17 (i86pc) panic message: BAD TRAP: type=e (#pf Page fault) rp=fffffe80004d7ac0 addr=7b5e01ff8 occurred in module "vmmemctl" due to an illegal access to a user address dump content: kernel pages only
> : (worry) tack
Balloon_QueryAndExecute+0x387()
0xffffffffec62cfa3()
thread_start+8()

It's related to memory allocation from oracle virtual machine control manager, it's not a Database error or accident problem.
There's many reasons due to bug associated to ovm, or running x86_64 solaris on vmware. The error log BAD TRAP: type=e (#pf Page fault) rp=fffffe80004d7ac0 addr=7b5e01ff8 occurred in module "vmmemctl" shows paging not clear, as said as swapped not well, for example, at 7b5e01ff8 hexa address. Dumping the address can read more informations.
You should consider to ask to system manager.

[Updated on: Wed, 31 January 2018 20:09]

Report message to a moderator

Re: dataguard server (physical standby) is restarted automatically [message #668108 is a reply to message #668030] Wed, 07 February 2018 03:11 Go to previous message
daulat01
Messages: 62
Registered: May 2011
Location: Delhi
Member
Dear all,

Thanks for your suggestion & comments. I have shared this issue to my Network & storage team. They are doing some R&Ds at their end. I will write down the solution once I will received and implemented successfully.
Previous Topic: ORA-12012, ORA-04021, ORA-06512
Next Topic: ORA-12012+ORA-00959 + ORA-06512
Goto Forum:
  


Current Time: Thu Nov 28 11:49:53 CST 2024