OEM 13c and Oracle Database Patch Errors

1 Star2 Stars3 Stars4 Stars5 Stars (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 […]

Read More

ASM migrate from one lun to anther lun

1 Star2 Stars3 Stars4 Stars5 Stars (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 […]

Read More

Creating, Adding Additional SCAN Addresses in Oracle Database 11g

1 Star2 Stars3 Stars4 Stars5 Stars (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 […]

Read More

Oracle SQL Database Commend Line Capturing Continues Select

1 Star2 Stars3 Stars4 Stars5 Stars (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

Read More

To change the Oracle SQL listner to SDP

1 Star2 Stars3 Stars4 Stars5 Stars (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 […]

Read More

How to change an Oracle Database from TCP to RDS on Infiniband

1 Star2 Stars3 Stars4 Stars5 Stars (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 […]

Read More