Wednesday, March 15, 2017

ORA-27054: NFS file system where the file is created or resides is not mounted with correct options


issue:
whenever we used to take the control file backup ,we used to get the below failure error
RMAN-03009: failure of Control File and SPFILE Autobackup command on ORA_DISK_1 channel at 03/14/2017 14:42:00
ORA-19504: failed to create file "/tmp/DD_Backup/DBname/database/DB_ctl_spfile_c-4186713025-20170314-02"
ORA-27054: NFS file system where the file is created or resides is not mounted with correct options
Additional information: 5
Additional information: 20

Solution:
mount the data domain with proper configuration settings
nointr,llock,rsize=32768,wsize=32768,NFSv3 

Monday, March 6, 2017

unable to start Db after SGA upgrade.

we are trying to upgrade SGA on 12.1 DB on Linux but unfortunately after the SGA upgrade ,we  could not bring up the database and got the below error.


ORA-27137: unable to allocate Large Pages to create a shared memory segment

ERROR:
  Failed to allocate shared global region with large pages, unix errno = 1.
  Aborting Instance startup.
  ORA-27137: unable to allocate Large Pages to create a shared memory segment

ACTION:
1. Check the permission to access system large pages.
2. Large pages are automatically locked into physical memory.

Increase the per process memlock (soft) limit to at least 14 GB to lock

cause:
we noticed that huge-pages enabled on the server and we need to adjust huge pages related parameter to accommodate new SGA memory.

Solution:
1)check and update limits.conf hard/soft  values based on new SGA values
2)VM.NR-huge-pages values derive from oracle provided script.

pitfalls,
we cant use AMM