Re: X5-2 ODA issues
Posted by Colby Merchlewitz on Mar 06, 2018; 10:33pm
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/X5-2-ODA-issues-tp5322p5331.html
Alex,
We have not encountered VM's getting hung as of yet...
This is the command run from ODA_BAS 00 as it does not currently work from ODA_BASE 01
[root@wdcoda01cn00 ~]# oakcli show repo
NAME TYPE NODENUM FREE SPACE STATE SIZE
odarepo1 local 0 N/A N/A N/A
odarepo2 local 1 N/A N/A N/A
templates shared 0 16.21% ONLINE 256000.0M
templates shared 1 N/A OFFLINE N/A
vmprod shared 0 5.00% ONLINE 1689600.0M
vmprod shared 1 N/A OFFLINE N/A
It's funny that you mention the second bit about ORA-09925: Unable to create audit trail file... once we were able to get ODA_BASE 01 up we used TSM to restore back all of the old ORACLE_HOMES.. in doing so i noticed that /adump directory was missing from each individual oracle home in /u01/app/oracle/diag/rdbms. Once I created new /adump dirs & also restored my WALLET I was able to startup the databases.. all except for one.. which was complaining about the following
Fri Mar 02 12:09:23 2018
PAGESIZE AVAILABLE_PAGES EXPECTED_PAGES ALLOCATED_PAGES ERROR(s)
Fri Mar 02 12:09:23 2018
2048K 0 2050 0 NONE
Fri Mar 02 12:09:23 2018
Reason for not supporting certain system pagesizes:
Fri Mar 02 12:09:23 2018
4K - Large pagesizes only
Fri Mar 02 12:09:23 2018
RECOMMENDATION:
Fri Mar 02 12:09:23 2018
1. Configure system with expected number of pages for every
supported system pagesize prior to the next instance restart operation.
I then found that hugepages were not working correctly and had to add an entry to /etc/sysctl.conf bounced everything and seemed to get the database started along with the hugepages working.
# Added by ODA Development. Do not remove fix_control=19265077
vm.nr_hugepages=25821
I am seeing the following when checking for iNode usage..
[root@wdcoda01cn01 ~]# df -i
Filesystem Inodes IUsed IFree IUse% Mounted on
/dev/xvda2 3637248 51172 3586076 2% /
tmpfs 12366284 625 12365659 1% /dev/shm
/dev/xvda1 121920 39 121881 1% /boot
/dev/xvdb1 12214272 470641 11743631 4% /u01
/dev/asm/datastore-72
71303168 59336960 11966208 84% /u01/app/oracle/oradata/datastore
/dev/asm/flashdata-409
585105408 76940584 508164824 14% /u02/app/oracle/oradata/flashdata
/dev/asm/acfsvol-38 104857600 19355080 85502520 19% /cloudfs
/dev/asm/nfsifa_ad01-231
104857600 49433696 55423904 48% /nfsifinapp_ad01
/dev/asm/nfsifa_au01-231
104857600 5302000 99555600 6% /nfsifinapp_au01
/dev/asm/nfsefa_c01-231
104857600 966080 103891520 1% /nfsefinapp_c01
/dev/asm/nfsefa_au02-231
209715200 572192 209143008 1% /nfsefinapp_au02
/dev/asm/nfsifa_au03-231
209715200 572192 209143008 1% /nfsifinapp_au03
/dev/asm/nfsifa_c01-231
629145600 228323784 400821816 37% /nfsifinapp_c01
/dev/asm/nfsifa_au02-231
209715200 96213448 113501752 46% /nfsifinapp_au02
/dev/asm/templates-231
524288000 439291888 84996112 84% /u01/app/sharedrepo/templates
/dev/asm/nfsefa_ad02-231
838860800 692813808 146046992 83% /nfsefinapp_ad02
/dev/asm/nfsifa_ad02-231
1258291200 622119104 636172096 50% /nfsifinapp_ad02
/dev/asm/c01-231 2097152000 1232540064 864611936 59% /c01
/dev/asm/datastore-231
24735907840 13605734504 11130173336 56% /u02/app/oracle/oradata/datastore
/dev/asm/vmprod-231 3460300800 3287124080 173176720 95% /u01/app/sharedrepo/vmprod
/dev/asm/datastore-38
4062183424 493625160 3568558264 13% /u01/app/oracle/fast_recovery_area/datastore