(No Ratings Yet)
Loading...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 […]
(No Ratings Yet)Loading...Contents 1 To set system password 2 EM Cloud control help 3 EM cloud control process order 4 How to deploy a plugin 5 References To set system password ALTER USER system IDENTIFIED BY password; EM Cloud control help #To stop Oracle Management Service GUI only emctl stop oms # To stop all services emctl […]
(No Ratings Yet)Loading...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 […]
(No Ratings Yet)Loading...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 […]
(No Ratings Yet)Loading...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 […]
(No Ratings Yet)Loading...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
(No Ratings Yet)Loading...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 […]
(No Ratings Yet)Loading...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 […]
(No Ratings Yet)Loading...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 […]
(No Ratings Yet)Loading...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 […]