One of the requirements for upgrading to Enterprise Manager Cloud Control 13c Release 2, is to apply. Database patch set update 160419 While trying to apply the patch to Oracle GI + DB, it will error out with non existing files (more below…). opatchauto apply 22899531 System initialization log file is /u01/app/grid/12.1.0.1/grid/cfgtoollogs/opatchautodb/systemconfig2016-10-06_02-29-43PM.log. Session log file …
How to recover from an Oracle DB if the disk/file system for archive logs gets full Note: if DB is hung at shutdown i.e. shu immediate, then force a shutdown, like below SQL> shutdown abort; SQL> startup nomount; SQL> alter database mount SQL> exit Get size used for if needed SQL> col name format A50 …
How to recover from an Oracle DB archivelog full error Read More »
To add new disk array / lun sqlplus / as sysasm ALTER DISKGROUP DATA ADD DISK ‘/dev/rdsk/c1d1s0’ REBALANCE POWER 5; # Fastest ALTER DISKGROUP DATA ADD DISK ‘/dev/rdsk/c1d1s0’ REBALANCE POWER 11; To verify SQL> select path,name,header_status from v$asm_disk; To Check where the rebalnce is up to select INST_ID, OPERATION, STATE, POWER, SOFAR, EST_WORK, EST_RATE, EST_MINUTES …
srvctl add network -netnum 2 -subnet 10.10.10.0/255.255.255.0/aggrpub1 -nettype static srvctl add scan -scanname 12cdb1-pub-scan.domain.com -netnum 2 srvctl start scan -netnum 2 srvctl status scan -netnum 2 srvctl add scan_listener -netnum 2 -endpoints TCP:1521 -listener listener2 srvctl start scan_listener -netnum 2 srvctl add vip -node 12cdb1 -address 10.10.10.111/255.255.255.0 -netnum 2 srvctl add vip -node 12cdb2 -address …
Creating, Adding Additional SCAN Addresses in Oracle Database 11g Read More »
Example 1 echo exit | sqlplus / as sysdba @/var/tmp/usera/foo.sh |egrep “COUNT|3|Elapsed:” >>/var/tmp/db_timing.out Example 2 while :; do echo exit | sqlplus / as sysdba @/var/tmp/usera/foo.sh |egrep “COUNT|3|Elapsed:” >>/var/tmp/db_timing.out; sleep 2; done Example 3 while :; do sqlplus eli/eli @/var/tmp/usera/foo.sh >>/var/tmp/db_timing.out ; sleep 2; done
Change pga size, set the pga to at least 32gb >Set to the number of cores show parameter gcs_server – 16; Change DB options to filesystemio_options setall To change listner to SDP crsctl modify resource ora.LISTENER.lsnr -attr “ENDPOINTS=SDP:1521” crsctl modify resource ora.LISTENER_SCAN1.lsnr -attr “ENDPOINTS=SDP:1521” crsctl modify resource ora.LISTENER_SCAN2.lsnr -attr “ENDPOINTS=SDP:1521” crsctl modify resource ora.LISTENER_SCAN3.lsnr -attr …
Changing an Oracle Database from TCP to RDS If your Oracle Database runs on an Infiniband network, you can greatly benefit by switching from TCP to RDS for DB cluster communications First enable RDS svcadm enable svc:/system/rds:default svcs svc:/system/rds:default STATE STIME FMRI online 4:40:52 svc:/system/rds:default For ASM On one node crsctl stop cluster -all On …
How to change an Oracle Database from TCP to RDS on Infiniband Read More »
Process to patch an Oracle 11G/12C RAC Grid infrastructure and or database Note1: Starting with OPatch version 11.2.0.3.14 , 12.1.0.2.12 and higher OCM Is Not bundled with OPatch .OPatch utility may be not look for ocm response file while patching in silent mode . Note2: In older versions the emocmrsp might be located under OPatch …
Patching An Oracle RAC 11g/12c Grid(GI) / Database Read More »
SSD Arrays and using 4k blocks Some SSD arrays will perform badly or not work at all when used for Database files. The example below was used with a Violin Memory Array, but the same is can be any of the new SSD vendors. Note: The solution below will only work on Linux with asmlib …
To re-create a faild 11g databse dbconsole $ emca -deconfig all db -repos drop $ emca -config all db -repos create