mdvreddy.blogspot.com
Oracle Database and Fusion Middleware Administrator Learnings: September 2009
http://mdvreddy.blogspot.com/2009_09_01_archive.html
Oracle Database and Fusion Middleware Administrator Learnings. Friday, September 25, 2009. Default port numbers of various databases. Default port numbers of various databases:. Often we wonder what is the default port number of various databases that we work excessively on since we don’t keep in touch with these stuff often, hence I thought it would be good idea to post that stuff here for quick review when required rather checking here and there. What is the default port number of Oracle Database:.
mdvreddy.blogspot.com
Oracle Database and Fusion Middleware Administrator Learnings: May 2010
http://mdvreddy.blogspot.com/2010_05_01_archive.html
Oracle Database and Fusion Middleware Administrator Learnings. Monday, May 24, 2010. BULK UPDATE IN ORACLE 10G. BULK UPDATE IN ORACLE 10G:. CREATE OR REPLACE PROCEDURE UPDATEA ALL ROWS IS. CURSOR CR IS SELECT OBJECT ID FROM TEST1;. TYPE O I IS TABLE OF TEST1.OBJECT ID%TYPE INDEX BY BINARY INTEGER;. FOR REC IN CR LOOP. OBJ 1(CNT):=REC.OBJECT ID;. FORALL I IN 1.CNT. UPDATE TEST1 SET OBJECT ID2=OBJ 1(I) WHERE OBJECT ID=OBJ 1(I);. Create or replace PROCEDURE update all rows (limit in IN PLS INTEGER) is.
mdvreddy.blogspot.com
Oracle Database and Fusion Middleware Administrator Learnings: June 2009
http://mdvreddy.blogspot.com/2009_06_01_archive.html
Oracle Database and Fusion Middleware Administrator Learnings. Wednesday, June 17, 2009. The different types of joins in oracle database. The different types of joins in oracle database:. Joins are used to produce the single data set output from multiple tables based on requirement to get matched records or mismatched records. These are the joins one can see oracle database and will explain one by one. More yet to come. Have a fun in working in Oracle Technologies- Cheers-. Links to this post. Joins are ...
mdvreddy.blogspot.com
Oracle Database and Fusion Middleware Administrator Learnings: July 2011
http://mdvreddy.blogspot.com/2011_07_01_archive.html
Oracle Database and Fusion Middleware Administrator Learnings. Thursday, July 7, 2011. ORACLE RMAN: HOW TO CONNECT, CONFIGURE AND WORK. Follow the steps to connect, configure and work with RMAN:. When no catelog used (i.e no catalog but control file):. Connect as Sys as sysdba. 1 Create a tablespace. CREATE SMALLFILE TABLESPACE rman tbs DATAFILE ‘D: ORACLE . rman tbs.dbf’ SIZE 100M EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;. 2 CREATE USER rman IDENTIFIED BY rman DEFAULT TABLESPACE rman tbs.
mdvreddy.blogspot.com
Oracle Database and Fusion Middleware Administrator Learnings: April 2009
http://mdvreddy.blogspot.com/2009_04_01_archive.html
Oracle Database and Fusion Middleware Administrator Learnings. Thursday, April 30, 2009. Books I read usually…. Oracle Press Books on Oracle, Linux Administration. Sybex Publications on Oracle, Linux. The Power of Your Subconscious Mind by Joseph Murphy. Seven Habits of Highly Effective People, Stephen F. Covey's. Dr Robert H. Schuller's "Tough Times Never Last, But Tough People Do! The Alchemist by Paulo Coelho. I'm OK, You're OK by Thomas A. Harris. You Can Win - Shiv Khera. Etcfew to name :). Creation...
mdvreddy.blogspot.com
Oracle Database and Fusion Middleware Administrator Learnings: November 2009
http://mdvreddy.blogspot.com/2009_11_01_archive.html
Oracle Database and Fusion Middleware Administrator Learnings. Thursday, November 26, 2009. ORA-29855 error in oracle and solution. We sometime see the error when insufficient privileges are assigned and CTXSYS is not presented in oracle db 10g. ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine. ORA-20000: Oracle Text error:. DRG-10700: preference does not exist: CTXSYS.DEFAULT LEXER. ORA-06512: at "CTXSYS.DRUE", line 160. ORA-06512: at "CTXSYS.TEXTINDEXMETHODS", line 364. The next st...
mdvreddy.blogspot.com
Oracle Database and Fusion Middleware Administrator Learnings: May 2009
http://mdvreddy.blogspot.com/2009_05_01_archive.html
Oracle Database and Fusion Middleware Administrator Learnings. Friday, May 8, 2009. Solution for Unable to extend temp segment by 128 in table space. Solution for Unable to extend temp segment by 128 in table space:. At least once in a time, A DBA or oracle professional might have faced this error in his/her experience. Here are the workarounds and solutions that we feel work and that can be employed. Check the temp table space usage using following query. Select * From v$temp space header;. ALTER DATABA...
mdvreddy.blogspot.com
Oracle Database and Fusion Middleware Administrator Learnings: July 2009
http://mdvreddy.blogspot.com/2009_07_01_archive.html
Oracle Database and Fusion Middleware Administrator Learnings. Wednesday, July 8, 2009. Performance tuning in oracle 10g database. Performance tuning in oracle 10g database:. Current sessions and their activity in oracle 10g:. The following query statement can be used to disaply all the current sessions in current instance/db:. GV$INSTANCE view for RAC database. V$instance for single instance database. Select sid, serial#, username, status, osuser,process, machine, program,type,module, event,. There will...
mdvreddy.blogspot.com
Oracle Database and Fusion Middleware Administrator Learnings: February 2010
http://mdvreddy.blogspot.com/2010_02_01_archive.html
Oracle Database and Fusion Middleware Administrator Learnings. Thursday, February 18, 2010. OrainstRoot.sh and root.sh scripts execution in Oracle. Usage of orainstRoot.sh and root.Sh execution in Oracle 10g Installation:. The first Script that we run is orainstRoot.sh which is located in $ORACLE BASE/oraInventory for example : /u01/opt/app/oracle/oraInventory. The script should be run as root user. The usage of this script is :. Changing groupname of the oraInventory directory to oinstall group. Its bee...
