Had to change some listener ports from 1521 to 8001 on a RAC environment recently here are the steps taken. 1. Check the listener status [oracle@test0101 20299013]$ srvctl status listener -l LISTENER Listener LISTENER is enabled Listener LISTENER is running on node(s): test0101,test0102 2. Modify the listener [oracle@test0101 20299013]$ srvctl modify listener -l LISTENER -p 8001 3. Bounce […]
A great way to limit CPU on a shared database server is by using instance caging, below are the steps to implement instance caging. 1. Check to see if instance caging is enabled SQL> select name from v$rsrc_plan where is_top_plan = ‘TRUE’ and cpu_managed=’ON’; no rows selected Its not enabled 2. Set the CPU count Set the […]
Just found out about the new oracle tool oratop, not used it live issues yet but it looks a great tool if your on linux and on 11.2.0.3 or > The oracle note on the product is – oratop – Utility for Near Real-time Monitoring of Databases, RAC and Single Instance (Doc ID 1500864.1) Sample […]
I was working on a recovery guide for a RAC cluster I built so I thought I would share the recovery of the DATA diskgroup. The set-up is a 2 node RAC cluster running 11.2.0.3 standard edition ASM with 2 disk groups DATA and FLASH. The OCR and voting disk are in the DATA diskgroup […]
Got the following error when trying to add a target on 12c Grid Control TEST: oracle.sysman.emSDK.core.target.DuplicateEntityException: ORA-20500: TEST:oracle_database:testprd:https://testprd:3872/emd/main/:3:0 ORA-06512: at “SYSMAN.EM_TARGET”, line 3347 ORA-06512: at line 1 – ORA-20500: TEST:oracle_database:testprd:https://testprd:3872/emd/main/:3:0 ORA-06512: at “SYSMAN.EM_TARGET”, line 3347 ORA-06512: at line 1 To fix this we just need to remove the entry from the repository, so connect to […]
Steps to remove a disk from a ASM diskgroup So we have the following disks and the plan is to remove VOLE SQL> select group_number, name, TOTAL_MB, FREE_MB from V$asm_disk_stat; GROUP_NUMBER NAME TOTAL_MB FREE_MB ———— —————————— ———- ———- 0 1019 0 1 VOLA 1019 842 1 VOLB 1019 841 1 VOLC 1019 841 2 VOLD […]
Nice script to tidy up the output of crsctl status resource script #!/usr/bin/ksh # # 11g CRS resource status query script # # Description: # – Returns formatted version of crs_stat -t, in tabular # format, with the complete rsc names and filtering keywords # – The argument, $RSC_KEY, is optional and if passed to […]
The following are the steps I used to install Oracle 12c on Red Hat 6 Download the Software from Technet The 2 zip files needed are linuxamd64_12c_database_1of2.zip & linuxamd64_12c_database_2of2.zip OS Settings Ensure the Hostname is in /etc/hosts [root@dba05tst stage]# cat /etc/hosts |grep dba05tst 172.23.11.222 dba05tst Disable the Firewall Settings [root@dba05tst stage]# service iptables save iptables: […]
Currently I have 2 disk groups DATA and FLASH for my RAC 11GR2 cluster I need to move them to a new storage array so here are the steps taken. 1. Create New Disk Groups FLASH2 & DATA2 Use asmca to create the new disks Create a FLASH2 diskgroup Create a DATA2 diskgroup New disk […]
How to change the default profile limits useful for setting the password life time to stop the password timing out and asking the user to change the password especially when applications are connecting to the DB. SYSTEM@WEBDB1> @qprofileEnter value for 1: DEFAULTold 1: select * from dba_profiles where profile =upper(‘&1’)new 1: select * from dba_profiles […]
