rajiboracle.blogspot.com
Easy to Learn Oracle Database and Solve Your Problem. : UDE-00010: multiple job modes requested, schema and tables.
http://rajiboracle.blogspot.com/2014/08/ude-00010-multiple-job-modes-requested.html
Easy to Learn Oracle Database and Solve Your Problem. Thursday, August 14, 2014. UDE-00010: multiple job modes requested, schema and tables. Cause : This error show when you use multiple job in parameter file. Solution and Example: Use only one parameter like SCHEMAS. When Parameter file are like . DUMPFILE=RND TABLE QUERY.dmp. LOGFILE=RND TABLE QUERY.log. TABLES=RND.DEPT,RND.EMP. C: Users rajib.pradhan expdp "'/ as sysdba'" parfile=D: app DATA PUMP.par. When I have remove SCHEMA parameter like. Processi...
rajiboracle.blogspot.com
Easy to Learn Oracle Database and Solve Your Problem. : ACFS-03171: Insufficient contiguous free ASM Diskgroup space
http://rajiboracle.blogspot.com/2016/12/acfs-03171-insufficient-contiguous-free.html
Easy to Learn Oracle Database and Solve Your Problem. Thursday, December 15, 2016. ACFS-03171: Insufficient contiguous free ASM Diskgroup space. 1 Check if there are available space exist in your disk group. 2 Check re balance process are running or not. 1 If disk space are not available reduce the size or add new LUN in your disk group. 2 If re balance process are running wait to complete the process. Erpdcdb01 acfsutil size 300G /backup. Check the ASM alert log. Erpdcdb01 sqlplus "/as sysasm". Disconne...
rajiboracle.blogspot.com
Easy to Learn Oracle Database and Solve Your Problem. : 0481-103 Cannot open a file in the /var/spool/cron/crontabs directory.
http://rajiboracle.blogspot.com/2016/12/0481-103-cannot-open-file-in.html
Easy to Learn Oracle Database and Solve Your Problem. Sunday, December 4, 2016. 0481-103 Cannot open a file in the /var/spool/cron/crontabs directory. Bash-4.3$ crontab -l. 0481-103 Cannot open a file in the /var/spool/cron/crontabs directory. A file or directory in the path name does not exist. Bash-4.3$ su root. Bash-4.3# cd /var/spool/cron/crontabs. Bash-4.3# vi oracle. Bash-4.3# ls -ltr. Rw-r- r- 1 adm cron 2016 Sep 22 2009 adm. Rw-r- r- 1 sys cron 849 Sep 22 2009 sys. Bash-4.3# su oracle. SQL STARTU...
rajiboracle.blogspot.com
Easy to Learn Oracle Database and Solve Your Problem. : August 2016
http://rajiboracle.blogspot.com/2016_08_01_archive.html
Easy to Learn Oracle Database and Solve Your Problem. Sunday, August 28, 2016. How to calculate the SHMALL and SHMMAX Value for Oracle. SHMALL – is the maximum total amount of shared memory pages. SHMMAX – is the maximum size in bytes of a single shared memory segment. Calculate SHMALL as follows in case of 15GB RAM:. TOTAL RAM IN BYTES / PAGE SIZE. 1024 3 / 4096" bc. The calculation of SHMMAX, is as follows in case of 15GB RAM:. HALF OF TOTAL RAM IN BYTES. 1024 3 / 2" bc. Sun Aug 28 15:36:51 2016. 4 Sra...
rajiboracle.blogspot.com
Easy to Learn Oracle Database and Solve Your Problem. : September 2016
http://rajiboracle.blogspot.com/2016_09_01_archive.html
Easy to Learn Oracle Database and Solve Your Problem. Thursday, September 29, 2016. ORA-03113: end-of-file on communication channel (ORA-19809: limit exceeded for recovery files). Cause: Archive log location are full. Total System Global Area 2137886720 bytes. Fixed Size 2177456 bytes. Variable Size 1342178896 bytes. Database Buffers 788529152 bytes. Redo Buffers 5001216 bytes. ORA-03113: end-of-file on communication channel. Session ID: 127 Serial number: 3. ARC0: STARTING ARCH PROCESSES COMPLETE. Root@...
rajiboracle.blogspot.com
Easy to Learn Oracle Database and Solve Your Problem. : October 2016
http://rajiboracle.blogspot.com/2016_10_01_archive.html
Easy to Learn Oracle Database and Solve Your Problem. Sunday, October 30, 2016. Multiplexing redo log files. Oracle@DB ]$ sqlplus "/as sysdba". SQL*Plus: Release 11.2.0.4.0 Production on Sun Oct 30 17:59:02 2016. Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production. With the Partitioning, Automatic Storage Management, Oracle Label Security, OLAP,. Data Mining, Oracle Database Vault and Real Application Testing options. SQL SELECT GROUP#,TYPE, MEMBER FROM GV$LOGFILE;. SQL SELECT GR...
rajiboracle.blogspot.com
Easy to Learn Oracle Database and Solve Your Problem. : How to find device information of ASM Disks.
http://rajiboracle.blogspot.com/2016/10/how-to-find-device-information-of-asm.html
Easy to Learn Oracle Database and Solve Your Problem. Sunday, October 23, 2016. How to find device information of ASM Disks. 1 Find out the asm Disk list using oralceasm listdisks. 2 Find the device mapping information using oracleasm querydisk. 3 Find out the device using ls -l. Root@sbdbdr01 ]# oracleasm listdisks. DB ORCL DATA ASM 01. DB ORCL DATA ASM 02. DB ORCL DATA ASM 03. DB ORCL DATA ASM 04. DB ORCL DATA ASM 05. DB ORCL FRA ASM 01. DB ORCL FRA ASM 02. DB ORCL FRA ASM 03. DB ORCL FRA ASM 04. SQL S...
rajiboracle.blogspot.com
Easy to Learn Oracle Database and Solve Your Problem. : ORA-03113: end-of-file on communication channel (ORA-19809: limit exceeded for recovery files)
http://rajiboracle.blogspot.com/2016/09/ora-03113-end-of-file-on-communication.html
Easy to Learn Oracle Database and Solve Your Problem. Thursday, September 29, 2016. ORA-03113: end-of-file on communication channel (ORA-19809: limit exceeded for recovery files). Cause: Archive log location are full. Total System Global Area 2137886720 bytes. Fixed Size 2177456 bytes. Variable Size 1342178896 bytes. Database Buffers 788529152 bytes. Redo Buffers 5001216 bytes. ORA-03113: end-of-file on communication channel. Session ID: 127 Serial number: 3. ARC0: STARTING ARCH PROCESSES COMPLETE. Cause...
rajiboracle.blogspot.com
Easy to Learn Oracle Database and Solve Your Problem. : Enable/Disable Automatic Startup Oracle HAS
http://rajiboracle.blogspot.com/2016/10/enabledisable-automatic-startup-oracle.html
Easy to Learn Oracle Database and Solve Your Problem. Wednesday, October 19, 2016. Enable/Disable Automatic Startup Oracle HAS. Grid@OEL564ASMN1 ]$ crsctl check has. CRS-4638: Oracle High Availability Services is online. Grid@OEL564ASMN1 ]$ crsctl config has. CRS-4622: Oracle High Availability Services autostart is enabled. Grid@OEL564ASMN1 ]$ crsctl disable has. CRS-4621: Oracle High Availability Services autostart is disabled. Grid@OEL564ASMN1 ]$ crsctl config has. Grid@OEL564ASMN1 ]$ crsctl enable has.