There is a discussion from December 2008 what Linux (SLES vs. Red vHat vs. Oracle Enterprise Linux) to use for running oracle on Linux by Yann Neuhaus. You can read his post here.
After nearly one year i wanted to catch up the article and check if the pros and cons are still valid or if there changed anything.
The past week i had a argumentation with a colleague of mine on the behavior of the parameter undo_retention in 10g.
He stated in 10g undo_retention determines the lower number of seconds oracle keeps the undo records. If there is enough space available an ORA-01555 should not be raised.
I knew there are cases in which undo_retention is set to a ridiculous high value (for instance a week), the undo tablespace has a lot of free space but an ORA-01555 is raised nonetheless. So we took a look at the documentation:
For Oracle 10g Release 1 the documentation states:
UNDO_RETENTIONspecifies (in seconds) the low threshold value of undo retention. The system retains undo for at least the time specified in this parameter and automatically tunes the undo retention period to satisfy the undo requirements of the queries.
But for Oracle 10g Release 2 the documentation says different:
UNDO_RETENTIONspecifies (in seconds) the low threshold value of undo retention. For AUTOEXTEND undo tablespaces, the system retains undo for at least the time specified in this parameter, and automatically tunes the undo retention period to satisfy the undo requirements of the queries. For fixed- size undo tablespaces, the system automatically tunes for the maximum possible undo retention period, based on undo tablespace size and usage history, and ignoresUNDO_RETENTIONunless retention guarantee is enabled.
In Oracle 11g Release 1 and Oracle 11g Release 2 the behavior is the same as for Oracle 10g Release 2.
There are rumors on the release dates of 11.2.0.1.0 for different plattforms. According to my information the release dates are:
I personally expect the release of 11g Release 2 for solaris operating system pretty soon.
Yesterday i did a large import using data pump and the network mode feature. I noticed a table containing a large number of rows were reported by data pump as imported but with only one (1) row.
First i checked my import options, checked for errors in source and target database and even cleaned up everything and restarted the import. Surprise surprise: Same error again.
The environment was:
Extract from the data pump log file:
Processing object type SCHEMA_EXPORT/CLUSTER/CLUSTER Processing object type SCHEMA_EXPORT/CLUSTER/INDEX Processing object type SCHEMA_EXPORT/TABLE/TABLE . . imported "USER"."TABLE_A" 55082451 rows . . imported "USER"."SOME_LARGE_TABLE" 307126916 rows . . imported "USER"."ANOTHER_TABLE" 176936257 rows . . imported "USER"."JUST_ANOTHER_TABLE" 215682029 rows . . imported "USER"."HUGE_TABLE" 1 rows <==== . . imported "USER"."AND_SO_ON" 133356302 rows
So i started to dig a little bit deeper and noticed the source table has approx 62 million rows with a size of 28 GB. To my surprise the target database also reported the table with 28 gb in DBA_SEGMENTS.
So i did a simple:
SQL> select count(1) from user.huge_table;
COUNT(1) ---------- 62485290
Guess what? The table was imported correctly with all rows while data pump reported only one imported row.
I check metalink for related errors but found nothing.
I can only guess if this is a bug or there is some time limit when querying the rows of the just imported tables.
Update: I did some reseach and created a really large table with 1 billion rows the data pump showed:
. . imported "USER"."TABLE_WITH_1_BILLION_ROWS" -1416726547 rows
There might be some kind of counter overflow…. i will investiage this further.
I just found a new public yum server hosted by oracle. This server can be used to install missing packages over the internet. It does not contain any security updates or bug fixes.
The public yum server can be found here.
For larger installation you can run your own yum server.
A few users asked what to do if there is no DNS server available for configuring the SCAN names when installing oracle grid infrastructure.
Most asked if they can use hosts file entries. The short answer is: Nope. The grid infrastructure will install fine but the cluster verification utility will fail.
So my suggestion is as follows: Create your own small DNS server on your rac nodes. This is quite fast and easy and described in this article.
After overwriting the ASM disk header while the disk group was offline we will now put some load on the full running cluster and corrupt the asm disk slightly.
The following post is a summary of my tests with DBFS on a 11g Release 2 RAC.
Since the introduction of LOBs the database was used to store all kinds of files, for instance images, audio files, video files or even text files. Starting with Oracle 11g Release 1 introduced SecureFiles which introduced compression and de-duplication.
Oracle Database Filesystem (DBFS) creates a mountable file system which can be used to access files stored in the database as SecureFile LOBs. DBFS is a shared file system like NFS and consists of a server (the database) and a client. Just like a traditional database connection server and client can be on different systems which communicate over SQLNet. The same applies to DBFS as well.
The following figure illustrates DBFS:
(Source: http://download.oracle.com/docs/cd/E11882_01/appdev.112/e10645/adlob_fs.htm)
Recently i came across a problem i thought was fixed since 10g:
After a fresh installation of oracle 10g when trying to connect to the instance (for instance to create the database for the first time) you get the following error:
oracle@host#:> sqlplus /nolog SQL*Plus: Release 10.2.0.4.0 - Production on Do Oct 8 08:23:18 2009 Copyright (c) 1982, 2007, Oracle. All Rights Reserved. SQL> connect / as sysdba ERROR: ORA-12157: TNS: internal network communication error.
This error is related to the linking phase when installing oracle. In your environment used during installation the variable TMPDIR pointed to a non existing directory. When linking oracle some adapters (like tcp) were not linked correctly. You can verify this with:
oracle@host#:> cd $ORACLE_HOME oracle@host#:~/bin> adapters oracle /u01/app/oracle/product/oracle/bin/adapters: line 70: /u01/app/oracle/product/oracle/temp/naetab18456: no such file or directory /u01/app/oracle/product/oracle/bin/adapters: line 71: /u01/app/oracle/product/oracle/temp/nautab18456: no such file or directory /u01/app/oracle/product/oracle/bin/adapters: line 296: /u01/app/oracle/product/oracle/temp/exec18456: no such file or directory Oracle Net transport protocols linked with oracle are: Oracle Net naming methods linked with oracle are: Oracle Advanced Security options linked with oracle are:
The solution for this is to relink oracle again. Make sure you create the missing $TMPDIR first or change $TMPDIR to point to a existing and writeable directory:
oracle@host#:> cd $ORACLE_HOME/network/lib oracle@host#:> make -f ins_net_client.mk ntcontab.o oracle@host#:> cd $ORACLE_HOME/bin oracle@host#:> genclntsh oracle@host#:> cd $ORACLE_HOME/rdbms/lib oracle@host#:> make -f ins_rdbms.mk install oracle@host#:> cd $ORACLE_HOME/sqlplus/lib oracle@host#:> make -f ins_sqlplus.mk install oracle@host#:> cd $ORACLE_HOME/network/lib oracle@host#:> make -f ins_net_client.mk install oracle@host#:> cd $ORACLE_HOME/network/lib oracle@host#:> make -f ins_net_server.mk install
You can verify it by running “adapters oracle” again:
oracle@host#:> cd $ORACLE_HOME oracle@host#:~/bin> adapters oracle Oracle Net transport protocols linked with oracle are: IPC BEQ TCP/IP SSL SDP/IB RAW Oracle Net naming methods linked with oracle are: Local Naming (tnsnames.ora) Oracle Directory Naming Oracle Host Naming Oracle Advanced Security options linked with oracle are: RC4 40-bit encryption RC4 56-bit encryption RC4 128-bit encryption RC4 256-bit encryption DES40 40-bit encryption DES 56-bit encryption 3DES 112-bit encryption 3DES 168-bit encryption AES 128-bit encryption AES 192-bit encryption AES 256-bit encryption MD5 crypto-checksumming SHA-1 crypto-checksumming Kerberos v5 authentication RADIUS authentication
oracle@host#:> cd $ORACLE_HOME oracle@host#:~/bin> adapters oracle/u01/app/oracle/product/oracle/bin/adapters: line 70:
/u01/app/oracle/product/oracle/temp/naetab18456: no such file or directory/u01/app/oracle/product/oracle/bin/adapters: line 71:
/u01/app/oracle/product/oracle/temp/nautab18456: no such file or directory/u01/app/oracle/product/oracle/bin/adapters: line 296:
/u01/app/oracle/product/oracle/temp/exec18456: no such file or directoryOracle Net transport protocols linked with oracle are:
Oracle Net naming methods linked with oracle are:
Oracle Advanced Security options linked with oracle are:
In this post we will dig a little bit deeper with ASM. We will overwrite the ASM disk header on one disk while the disk group is offline, check the results and repair the LUN again.
dd if=/dev/random bs=8k count=1 of=/dev/sdg1
SQL> alter diskgroup DATA2 mount; alter diskgroup data2 mount * ERROR at line 1: ORA-15032: not all alterations performed ORA-15040: diskgroup is incomplete ORA-15042: ASM disk "0" is missing from group number "2"
