How to Check Your IP Address

Well, you are using Internet and wish to know your Public IP Address that currently used for you Internet connection. This is specially if you are using dial up connection or using a proxy server to connection to the Internet then ipconfig on windows or ifconfig on linux machine does not show your Public IP Address rather they show your Private IP address like below.

E:\>ipconfig

Windows IP Configuration


Ethernet adapter Local Area Connection:

        Media State . . . . . . . . . . . : Media disconnected

Ethernet adapter Wireless Network Connection:

        Media State . . . . . . . . . . . : Media disconnected

PPP adapter GP-INTERNET:

        Connection-specific DNS Suffix  . :
        IP Address. . . . . . . . . . . . : 10.130.20.120
        Subnet Mask . . . . . . . . . . . : 255.255.255.255
        Default Gateway . . . . . . . . . : 10.130.20.120

If you are not aware about Private and Public IP address then a little discussion about IP Address will help you to understand the thins.

Internet Protocol (IP) Address is a numerical label that is assigned to a device in order to uniquely identify in a network/Internet. In the Internet Protocol Version 4 (IPV4) the designers of TCP/IP defined an IP address as a 32-bit number which limits the address space to 4,294,967,296 (2 to the power 32) possible unique addresses. Out of 4,294,967,296 IP Addresses some addresses are reserved such as private networks (~18 million addresses) or multicast addresses (~270 million addresses).

The addresses which are reserved for private networks are called Private IP Address and rest addresses are called Public IP Address. Following is the range of all IP Address exists in IPV4.

Class	First octet in binary	Range of first octet	Network ID	Host ID	Number of networks	Number of addresses
A	0XXXXXXX	0 - 127	a	b.c.d	27-2 = 126	224-2 = 16,777,214
B	10XXXXXX	128 - 191	a.b	c.d	214 = 16,384	216-2 = 65,534
C	110XXXXX	192 - 223	a.b.c	d	221-1 = 2,097,151	28-2 = 254

From the above list following is the range of Private IP Address,

Class	Start	End	No. of addresses
24-bit Block (/8 prefix, 1 x A)	10.0.0.0	10.255.255.255	16,777,216
20-bit Block (/12 prefix, 16 x B)	172.16.0.0	172.31.255.255	1,048,576
16-bit Block (/16 prefix, 256 x C)	192.168.0.0	192.168.255.255	65,536

So, 10.130.20.120 is my private IP Address and as Private IP addresses are not routed on the Internet and thus their use need not be coordinated with an IP address registry so to communicate with Internet there must have a Public IP address. There are many websites through which you can check your IP Address along with many features. From them, I see AnalyzeMy really helps me which much more information.

About RMAN Compatibility Matrix

About RMAN Environment
If you say about RMAN Environment, then there comes the following components.
1) RMAN executable
2) Recovery catalog database
3) Recovery catalog schema in the recovery catalog database
4) Target database
5) Auxiliary database (used for duplicate, duplicate for standby or tablespace point-in-time recovery)

Each component has a release number. Oracle uses up to 5 digits to indicate a version of the release, but only up to 4 are significant for RMAN compatibility purposes. For example, to check the release number of RMAN executable just issue, rman on command prompt like below.
E:\Documents and Settings\Arju>rman

Recovery Manager: Release 10.2.0.1.0 - Production on Tue Mar 2 16:16:59 2010

Copyright (c) 1982, 2005, Oracle. All rights reserved.


Here we see the version is 10.2.0.1.0

Determine the Recovery Catalog Schema Version

Use SQL*Plus to connect to the recovery catalog database as the catalog owner. For example, enter:

$ sqlplus rman@catdb
Query the rcver catalog table. For example, run this query:

SQL> SELECT * FROM rcver;

VERSION
------------
09.00.01.00
10.02.01.00
11.01.00.03
Note that, if multiple versions are listed, then the last row is the current version, and the rows before it are prior versions. In the preceding example, the current recovery catalog schema version is 11.1 and the previous version was 10.2.

Note that for releases 10.2 and later, the last two digits in the rcver output indicate patch level. For earlier releases, they are always zeros.

RMAN Compatibility Matrix
In general, the rules of RMAN compatibility are as follows:

1) You can create an 8.x or 9.x recovery catalog schema in any Oracle database release 8.1.x (or higher), and a 10.0.1 (or higher) recovery catalog schema in any Oracle database release 9.0.1 (or higher).

2) The version of an auxiliary database instance must be equal to the version of the RMAN client.

3) Any release of Oracle database can restore backup sets and copies created by any prior release back to Oracle8i.

4) The RMAN executable version should be the same as the target database. There are some exceptions regarding this rule.

5) The RMAN catalog schema version must be greater than or equal to the RMAN executable.

6) The RMAN catalog is backwards compatible with target databases from earlier releases.

7) While backing up an Oracle Database 10g or later database with the Oracle9i RMAN client, you cannot include a control file that was created using COMPATIBLE=10.0.0 in a datafile backup set. The workaround is to turn control file autobackup ON.

RMAN Compatibility table is shown below.

Target/Auxiliary Database	RMAN Executable	Catalog Database	Catalog Schema
8.0.6	8.0.6	>=8.1.7	>=8.0.6
8.1.7	8.0.6.1	>=8.1.7	>=8.1.7
8.1.7	8.1.7	>=8.1.7	>=RMAN executable
8.1.7.4	8.1.7.4	>=8.1.7	8.1.7.4
8.1.7.4	8.1.7.4	>=8.1.7	>=9.0.1.4
9.0.1	9.0.1	>=8.1.7	>= RMAN executable
9.2.0	>=9.0.1.3 and <= Target database	>=8.1.7	>= RMAN executable
10.1.0	>=9.0.1.3 and <= Target database	>=9.0.1	>= RMAN executable
10.2.0	>=9.0.1.3 and <= target database executable	>=9.0.1	>= RMAN executable
11.1.0	>=9.0.1.3 and <= target database executable	>=9.0.1	>= RMAN executable
11.2.0	>=9.0.1.3 and <= target database executable	>=9.0.1	>= RMAN executable

From above table you can easily conclude about the compatibility about different components of RMAN.

Note that when compatibility matrix is broken the following error message may be generated.
- RMAN-06186: PL/SQL package string.string version string in string database is too old
- RMAN-06429: string database is not compatible with this version of RMAN

Related Documents
RMAN-06091 no channel allocated for maintenance (of an appropriate type)
RMAN-06429: TARGET database is not compatible with this version of RMAN
How to take RMAN backup on a remote disk/ location
RMAN-00554,RMAN-04005,ORA-0103 when remote connection by rman
Set Date format inside RMAN environment
How to skip a tablespace for restore operation
How to debug Backup, Restore Session in RMAN
Restore operation fails with RMAN-11003 ORA-01511 ORA-01516
Recover database after only lose of all controlfiles
RMAN-04014: startup failed: ORA-07446: sdnfy: bad value
How to restore an Spfile from autobackup older than 7 days
RMAN-06172: no autobackup found
Creating a Duplicate Database on a Remote Host -Part1
Database Duplication Fails Missing Log RMAN-06053 RMAN-06025
How to perform Database Point in time Recovery DBPITR

How to open an odt file

ODT indicates Open Document Format. It is an open standard text document created with Writer, the OpenOffice.org and StarOffice word processor; formatted using the OASIS OpenDocument XML-based standard. From OpenOffice.org, file extensions of text comes with .odt format, spreadsheet comes with .ods format and presentation comes with .odp format.

Microsoft Word by default can't open odt files. Open Document text files can be opened and edited with any OpenOffice-compatible program which are specified below.

1) OpenOffice.org Writer: You can download OpenOffice Write from the link OpenOffice.

2) Sun Microsystems Writer (included with StarOffice).

3) AbiSource AbiWord.

4) IBM Lotus Notes 8 or later.

5) On MAC OS with Apple TextEdit as well as with NeoOffice Writer.

6) On Unix OS with KOffice KWord.

7) Microsoft Word with OpenXML/ODF Translator Add-in.

Though Microsoft Word can't open odt file directly but with plugins you can open it.
If you want to open through Microsoft Word, download the ODF plugin from Sun ODF Plugin. Now you will be able to open odf files whether you use Microsoft Office 2003 or Office 2007.

8) If you don't have time to install any software or don't have administrative privilege and you have Internet connection then you can try any online converter tool such as Zamzar or Media Convert to open an odt file.

9) You can also upload odt file to Google Docs and from google docs you will be able to read the file.

10) Zoho Writer is another option to open odt file.