Category Archives: Configuration

Asmcmd Pwcopy With PRCD-1163 PRCR-1071 CRS-0245 ASMCMD-9453 Errors

After standby database rebuilt, and trying to copy database password file from primary to standby ASM disk, the below errors occurred: ASMCMD> pwcopy –dbuniquename RACTEST ‘/tmp/orapwractest’ ‘+DATA/RACTEST/orapwractest’ copying /tmp/orapwractest -> +DATA/RACTEST/orapwractest PRCD-1163 : Failed to modify database RACTEST PRCR-1071 : … Continue reading

Posted in ASM, Configuration, DataGuard | Tagged , , , , , , , | Leave a comment

How to Download Oracle Patches From Oracle Support By Using WGET or CURL

1) Set up global variables  : export MOS_USER=jamesh@domain.com export MOS_PASSWORD=”Password123″ export PROXYUSER=”jamesh” export PROXYPASSWD=”Password123″ export USERAGENT=”Mozilla/5.0″ export use_proxy=on export http_proxy=”http://proxy.domain.com:80/” export https_proxy=”https://proxy.domain.com:80/” export COOK=$HOME/$$.cookie 2) The following command to authenticate uses HTTP/HTTPS: $wget –proxy-user=${PROXYUSER} –proxy-password=${PROXYPASSWD} –http-user=${MOS_USER} –http-password=${MOS_PASSWORD} –save-cookies=$COOK –keep-session-cookies –no-check-certificate “https://updates.oracle.com/Orion/Services/download” … Continue reading

Posted in Client, Configuration, Upgrading and Patching | Tagged , , , | Leave a comment

Deinstall 12.1.0.2 Grid Infrastructure Home After Being Upgraded to 12.2.0.1

Grid Infrastructure 12.1.0.2 has been upgraded to 12.2.0.1 successfully. So 12.1.0.2 GI_HOME needs to be de-installed.  There are two ways to uninstall the old GI_HOME ( 12.1.0.2) 1) Detach GI_HOME and Remove the GI_HOME manually: $ export ORACLE_HOME=/u01/app/grid/12.1.0.2 $ $ORACLE_HOME/OPatch/opatch … Continue reading

Posted in 12c new features, Configuration, GI and RAC, Upgrading and Patching | Tagged , , , , , , , | Leave a comment

How to Install and Configure ASMLIb on RHEL Linux 7

Make sure oracleasm packages are installed , go to Red Hat website to download the required ones: $ rpm -qa|grep -i oracleasm kmod-oracleasm-version.el7.x86_64 oracleasm-support-version.el7.x86_64 oracleasmlib-version.el7.x86_64 Check orcaleasm.service is activated: # systemctl is-enabled oracleasm.service enabled Check  oracleasm kernel module is installed: … Continue reading

Posted in ASM, Configuration | Tagged , , , , , , , , , , , | Leave a comment

Ocrconfig Failed With Error PROT-30 PROC-50

Try to add OCR into  new diskgroup ‘+OCR_VOTE’, and get below errors: # ./ocrconfig -add OCR_VOTE PROT-30: The Oracle Cluster Registry location to be added is not usable PROC-50: The Oracle Cluster Registry location to be added is inaccessible on … Continue reading

Posted in CDB/PDB, Configuration, GI and RAC | Tagged , , , , , , , , , | Leave a comment

High CPU Usage By Multiple Processes With “/usr/bin/ssh -o StrictHostKeyChecking=no -o BatchMode=yes -o ConnectTimeout=5 /sbin/ifconfig -a”

for 12.1.0.2 GI/RAC environment, there are a couple of below processes consuming high CPU. $ ps -ef|grep ifconfig root 18941 1 0 06:25 ? 00:00:00 sh -c /bin/su -l grid -c “/usr/bin/ssh -o StrictHostKeyChecking=no -o BatchMode=yes -o ConnectTimeout=5 RACTEST2 /sbin/ifconfig … Continue reading

Posted in Configuration, GI and RAC, Upgrading and Patching | Tagged , , , , | Leave a comment

Temporary Tablespace Group

Create a temporary tablespace, and implicitly add it to a temporary tablespace group. SQL>CREATE BIGFILE TEMPORARY TABLESPACE TEMP01 TEMPFILE ‘+DATA1’ SIZE 100M AUTOEXTEND ON NEXT 100M MAXSIZE 32G EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M TABLESPACE GROUP TEMP_GRP; Add a temporary … Continue reading

Posted in Configuration, SQL Scripts For DBA | Tagged , , , , , , , , | Leave a comment

Drop Temporary Tablespace Hangs With “enq: TS – contention”

After created a new temporary tablespace TEMPNEW as database default temporary tablespace, then try to drop the old temporary tablespace “TEMP”, it hangs up forever. SQL> drop tablespace temp including contents and datafiles; Check session wait event “enq: TS – … Continue reading

Posted in Configuration | Tagged , , | Leave a comment

TFA – Oracle Trace File Analyser Installation

Uninstall TFA 1) Check TFA_HOME. $ grep TFA_HOME= /etc/init.d/init.tfa TFA_HOME=/u01/app/12.2.0.1/grid/tfa/racnode1/tfa_home 2) Uninstall TFA as root user. [root@racnode1 bin]# ./tfactl -h Usage : /u01/app/12.2.0.1/grid/bin/tfactl <command> [options] commands:diagcollect|collection|analyze|ips|run|start|stop|enable|disable|status|print|access|purge|directory|host|receiver|set|toolstatus|uninstall|diagnosetfa For detailed help on each command use: /u01/app/12.2.0.1/grid/bin/tfactl <command> -help [root@racnode1 bin]# /u01/app/12.2.0.1/grid/bin/tfactl uninstall … Continue reading

Posted in 12c new features, Configuration | Tagged , | Leave a comment

Reconfigure OS Parameters After Linux Server Memory Upgrade

One of the Oracle database server ‘s memory is to be upgraded from 48GB to 72GB, so some parameters should be adjusted to take advantage of the newly added memory. 1)  Change ‘memlock’ parameter in /etc/security/limits.conf to 70G, which is … Continue reading

Posted in Configuration, Linux | Tagged , , , , , , , , | Leave a comment