DevTech101

DevTech101

OracleDB

OEM 13c and Oracle Database Patch Errors

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 …

OEM 13c and Oracle Database Patch Errors Read More »

Oracle Enterprise Manager, ASM Tips and Tricks

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 …

Oracle Enterprise Manager, ASM Tips and Tricks Read More »

How to recover from an Oracle DB archivelog full error

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 »

ASM migrate from one lun to anther lun

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 …

ASM migrate from one lun to anther lun Read More »

Creating, Adding Additional SCAN Addresses in Oracle Database 11g

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 »

Oracle SQL Database Commend Line Capturing Continues Select

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

To change the Oracle SQL listner to SDP

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 …

To change the Oracle SQL listner to SDP Read More »

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

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 »

Patching An Oracle RAC 11g/12c Grid(GI) / Database

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 »