# cat /etc/redhat-releaseI don't check much oracle document, just read about configuration.
Red Hat Enterprise Linux Server release 5.3 (Tikanga)
Choose disk:
# fdisk -l /dev/sdcset Oracle initialization parameters:
Disk /dev/sdc: 24.5 GB, 24575868928 bytes
255 heads, 63 sectors/track, 2987 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes
Disk /dev/sdc doesn't contain a valid partition table
# chmod 777 /dev/sdc
$ sqlplus / as sysdbaStop/Start database
SQL> alter system set db_flash_cache_file='/dev/sdc' scope=spfile;
System altered.
SQL> alter system set db_flash_cache_size=10G scope=spfile;
System altered.
SQL> shutdown immediateI found above error, then asked ... and find out. I found (oracle docs):
SQL> startup
ORA-00439: feature not enabled: Server Flash Cache
ORA-01078: failure in processing system parameters
Your database is running on the Solaris or Oracle Enterprise Linux operating systems. The flash cache is supported on these operating systems only.So, I had plan to install OEL. But... I'd like to figure out on Redhat as well.
Thank You Kevin Closson for figure me out. He is helpful me. I can use flash cache feature on Redhat.
SQL> startup;-)
ORACLE instance started.
Total System Global Area 7549435904 bytes
Fixed Size 2214456 bytes
Variable Size 4026533320 bytes
Database Buffers 3489660928 bytes
Redo Buffers 31027200 bytes
Database mounted.
Database opened.
SQL> show parameter db_flash_cache_file
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_flash_cache_file string /dev/sdc
SQL> show parameter db_flash_cache_size
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_flash_cache_size big integer 10G
Remark:
Using db_flash_cache_file =/dev/sdc, Check -> A device name is Flash Cache File, isn't it?
$ dd if=/dev/sdc count=1024 | strings
Oracle RDBMS Flash Cache File
orcl
1024+0 records in
1024+0 records out
524288 bytes (524 kB) copied, 0.008165 seconds, 64.2 MB/s
Just Idea.
11 comments:
make sure to set filesystemio_options=setall too!
Thank You @kevinclosson.
SQL> show parameter filesystemio_options
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
filesystemio_options string SETALL
-)
Hey, thanks for this demo, it's really useful and congratulations for becoming Oracle ACE!
Regards,
Sve
Kevin Closson (http://kevinclosson.wordpress.com) helped me for idea.
About Oracle ACE, that's the beginning. I still to learn + improve skills more...
-)
Surachart -
I'm having difficulty following the necessary steps in order to enable the flash_cache in 11gR2 for Red Hat. Can you provide the list of steps you followed in order to enable it?
Thank you for the post...very interesting!
Martha Centeno
@Martha
flash_cache in 11gR2 supports on OEL or Solaris only
If you need to test it on RHEL. Please send email to me, I'll send some step to figure out it on RHEL.
surachart at gmail dot com
-)
Hi Surachart:
Can you please post the steps to get flash_cache to work on RedHat.
@Ali Zaidi
Sorry for steps.
Hi,
There is confusing information about the db_flash_cache_file parameter. Oracle doc says it should be /dev/fioa1 etc. while some blogs say it should be a file. What is correct? In my case, /dev/fioa1 does not work.
I have RAC though. On two nodes I have two fusion cards (/dev/fioa). Do I need to create file system and specify a file name for db_flash_cache_file?
Also does this work on RH also? What do you have to do to make it work on RH?
Zafar mahmood
zmahmood@austin.rr.com
Hello
I'm too researching the same information Zafar request. Would you Guys post any hint on the steps required to enable Flash Cache on RedHat?
Thanks in advance!
this can not publish for clue... sorry
Post a Comment