Downloadable Interactive Quick Reference for Oracle Database 12c available @
http://www.oracle.com/go/?&Src=7875565&Act=4&pcode=WWOU13045613MPP009
Archive for the ‘Uncategorized’ Category
Oracle Database 12c Interactive Quick Reference Guide
Posted by Sriram Sanka on August 8, 2013
Posted in Uncategorized | 5 Comments »
ORA-07445: exception encountered: core dump [kttuser0()+272] [SIGFPE] [Integer divide by zero] [0x8949718] [] []
Posted by Sriram Sanka on February 18, 2013
Today, we were encountered with this internal error on One of our test environment.
On Our Database ,we have 2 temporary table-spaces with a Temporary table space group.
While we are performing Data pump Import (IMPDP) into another machine , The job was failed multiple times with following error on screen ….
Screen Error :Processing object type DATABASE_EXPORT/SCHEMA/TYPE/TYPE_SPEC
ORA-39014: One or more workers have prematurely exited.
ORA-39029: worker 1 with process name “DW01” prematurely terminated
ORA-31672: Worker process DW01 died unexpectedly.When I verified for the cause, on alert log, found an Internal error only after Temporary tablespace creation ..
Alert log Content :
CREATE TEMPORARY TABLESPACE “TEMP_TWO” TEMPFILE ‘/u01/app/oracle/oracle/product/10.2.0/oradata/*****/temp02.dbf’SIZE 844103680 AUTOEXTEND ON NEXT 8192 MAXSIZE 32767M TABLESPACE GROUP TBS_GROUP EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1048576
ORA-1119 signalled during CREATE TEMPORARY TABLESPACE “TEMP_TWO” TEMPFILE ‘/u01/app/oracle/oracle/product/10.2.0/oradata/********/temp02.dbf’ SIZE 844103680 AUTOEXTEND ON NEXT 8192 MAXSIZE 32767M TABLESPACE GROUP TBS_GROUP EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1048576 …
Sun Feb 17 13:18:26 PST 2013
Thread 1 advanced to log sequence 47 (LGWR switch)
Current log# 2 seq# 47 mem# 0: /u01/app/oracle/*****/*****/redo02.log
Sun Feb 17 13:18:32 PST 2013
Errors in file /u01/app/oracle/******/admin/******/bdump/*****_dw01_24538.trc:ORA-07445: exception encountered: core dump [kttuser0()+272] [SIGFPE] [Integer divide by zero] [0x8949718] [] []
Creating the temp tablespaces manually before IMPDP process will avoid such errors.
For More info please read metalink document ID 1259393.1
Posted in Uncategorized | 2 Comments »
Article From Infoworld about Oracle Code flaw
Posted by Sriram Sanka on January 19, 2012
Yesterday, there was an interesting article was posted/published On InfoWorld By Paul Venezia.
http://www.infoworld.com/d/security/fundamental-oracle-flaw-revealed-184163
http://www.infoworld.com/t/data-management/calling-all-oracle-customers-184103?source=fssr
Oracle has published this On Its MOS Bug 12371955 Backup task can cause increased SCN growth rate leading to ORA-600 [2252] errors with Document ID [ID 12371955.8] and Old existing Document 253977.1 will also give some information on it.
for this to be fixed , One should apply the latest CPU patch released on 18-Jan-2012 by Oracle.
Oracle has published an article on MOS yesterday: note 1376995.1 with an associated script “scnhealthcheck.sql” you can find and download in note 1393363.1.which are very helpful.
Posted in Uncategorized | Tagged: infoworld, oracle, oracle customers | Leave a Comment »
New My Oracle Support interface….Soon
Posted by Sriram Sanka on January 19, 2012
On 17-Jan-2012,Oracle Announced,That its going to upgrade (New) My Oracle Support User interface, which Oracle ADF.
For More details Please refer The New My Oracle Support User Interface [ID 1385682.1]
http://www.dba-village.com/village/dvp_news.NewsDetails?NewsIdA=3874
Posted in Uncategorized | Leave a Comment »
“racgmain” Processes
Posted by Sriram Sanka on October 3, 2011
Some good Experience for Me today.Early in the Morning ……
One of Our RAC node filled up with 100% CPU usage.As part of Investigation We found that this was because of racgmain Process.
It was filled-up with more than 250 racgmain process which are consuming CPU a lot.Due this Our System got Very slow.
To avoid this, we should apply latest patch which is > 10.2.0.5 and CRS patch too.There was a temporary workaround for this ..you can see that in Metalink Doc ID 732086.1 and ID 6196746.8
Posted in Oracle Server Administration, Uncategorized | Leave a Comment »
Protected:
Posted by Sriram Sanka on July 29, 2011
Posted in Uncategorized | Enter your password to view comments.
How not to Play With Oracle Dual-Magical Dual
Posted by Sriram Sanka on July 18, 2011
Here is an Interesting topic about FAST DUAL and Full Table Scan on Dual table with some example about how not to play with Oracle Data Dictionary Objects.
http://www.orafaq.com/forum/mv/msg/173068/515910/136607/#msg_515910
Happy reading….
Sriram 🙂
Posted in Uncategorized | 2 Comments »
Read the file
Posted by Sriram Sanka on December 10, 2010
A Master piece from http://laurentschneider.com
An excellent piece of code handy for DBA`s
SQL> SELECT s.sid,
2 s.serial#,
3 pa.value || '\' || LOWER(SYS_CONTEXT('userenv','instance_name')) ||
4 '_ora_' || p.spid || '.trc' AS trace_file
5 FROM v$session s,
6 v$process p,
7 v$parameter pa
8 WHERE pa.name = 'user_dump_dest'
9 AND s.paddr = p.addr
10 AND s.audsid = SYS_CONTEXT('USERENV', 'SESSIONID')
11 /
SID SERIAL#
---------- ----------
TRACE_FILE
--------------------------------------------------------------------------------
147 2101
D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCLE\UDUMP\orcl_ora_1000.trc
SQL>
SQL> sho parameter user_dump_dest
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
user_dump_dest string D:\ORACLE\PRODUCT\10.2.0\ADMIN
\ORCLE\UDUMP
SQL> CREATE DIRECTORY udump_dest AS
2 'D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCLE\UDUMP';
Directory created.
SQL> CREATE OR REPLACE FUNCTION get_tracefile (file_name VARCHAR2)
2 RETURN VARCHAR2
3 IS
4 dest_loc CLOB;
5 src_loc BFILE;
6 ret VARCHAR2 (4000);
7 BEGIN
8 src_loc := BFILENAME ('UDUMP_DEST', file_name);
9 DBMS_LOB.OPEN (src_loc, DBMS_LOB.lob_readonly);
10 DBMS_LOB.createtemporary (dest_loc, TRUE);
11 DBMS_LOB.loadfromfile (dest_loc, src_loc, 4000);
12 ret := DBMS_LOB.SUBSTR (dest_loc, 4000);
13 DBMS_LOB.CLOSE (src_loc);
14 RETURN ret;
15 END;
16 /
Function created.
SQL>
SQL> SELECT get_tracefile (‘orcl_ora_1000.trc’) FROM DUAL;
GET_TRACEFILE(‘ORCL_ORA_1000.TRC’)——————————————————————————–Dump file d:\oracle\product\10.2.0\admin\orcle\udump\orcl_ora_1000.trcFri Dec 10 22:54:36 2010ORACLE V10.2.0.1.0 – Production vsnsta=0vsnsql=14 vsnxtr=3Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 – ProductionWith the Partitioning, OLAP and Data Mining optionsWindows XP Version V5.1 Service Pack 3CPU : 1 – type 586, 1 Physical CoresProcess Affinity : 0x00000000Memory (Avail/Total): Ph:269M/959M, Ph+PgF:1265M/2314M, VA:1606M/2047MInstance name: orcl
Redo thread mounted by this instance: 1
Oracle process number: 20
Windows thread id: 1000, image: ORACLE.EXE (SHAD)………………….
…………………………………..ETC
Posted in Oracle Server Administration, Uncategorized | Leave a Comment »
Not null constraint :–ORA-00932: inconsistent datatypes: expected NUMBER got LONG
Posted by Sriram Sanka on December 9, 2009
SQL> sho user
USER is "SCOTT"
SQL> select constraint_name from user_constraints
2 where search_condition not like '%NOT NULL';
where search_condition not like '%NOT NULL'
*
ERROR at line 2:
ORA-00932: inconsistent datatypes: expected NUMBER got LONG
SQL> create or replace function get_search_condition(p_cons_name in varchar2 ) return varchar2
2 authid current_user
3 is
4 l_search_condition user_constraints.search_condition%type;
5 begin
6 select search_condition into l_search_condition
7 from user_constraints
8 where constraint_name = p_cons_name;
9
10 return l_search_condition;
11 end;
12 /
Function created.
SQL> select constraint_name
2 from user_constraints
3 where get_search_condition(constraint_name) like '%NOT NULL%';
CONSTRAINT_NAME
------------------------------
SYS_C006082
SYS_C006081
SYS_C006080
SYS_C005558
SYS_C005696
SYS_C005695
6 rows selected.
SQL>
Source:- Asktom`s get_search_condition function.
Posted in Uncategorized | 1 Comment »
Not Just Databases 