The Major 13 Differences between Oracle 9i, 10 and 11g
Oracle is a database management scheme which is highly accepted. It is basically used in the basis that it helps in perfectly managing a large amount of data. It is mainly used because it is platform free and usable in any platform. It is dependable and gives many options. There are many types or versions of Oracle.
The following are the major differences between Oracle Internet Directory 9i, 10, 11g:
1. Creation of Instances and management of Processes – in 9i, 10g and older releases storage of information for configuring an instance of Oracle internet Directory is in configuration set with DN of this form; cn=configsetN,cn=osdldapd,cn=subconfigsubentry. In new the new release of 11g the procedure of creation of an instance has changed to this form; cn=componentname,cn=osdldapd,cn=subconfigsubentry
2. Enabling Debugging of the Server – in 10 g and earlier versions debugging could be done by use of debug option after invoking the server or setting oracle debug flag, found in root DSE. In 11g version invoking the server cannot allow you to debug using debugging options.
3. Path names – in Oracle 11g Release of middleware, updatable files are installed under ORACLE_INSTANCEand many product binaries are kept under ORACLE_HOME. Resulting from this, path names of many configuration files as well as log files differ with those in 10 and below Oracle versions.
4. Audit – in 11g release of Oracle, Oracle Internet Directory makes use of an audit framework integrated with the Oracle Fusion Middleware. This is very different with Oracle 10 and 9i.
5. Graphical User Interfaces – Oracle 11g Release lacks Oracle Internet Directory and Oracle Directory Manager Grid Control Plug-ins, which are available in Oracle 10 and 9i. In 11g they are replaced with Oracle Enterprise Manager Fusion Middleware Control and Oracle Directory Services Manager.
6. Command Line Tools – many command lines now require setting of ORACLE_INSTANCE environment variable. In 10g and 9i, if you excluded a connect argument in command line, the command would automatically take the value ORACLE_SID environment variable. In 11g Release version, you must use connect argument in specifying the database. For instance, connect=oiddb.
7. Default Ports – Oracle Identity Management for 11g installer follows specified steps when assigning SSL and non-SSL port during the installation of Oracle Internet Directory. For non-SSL, it tries 3060 first; if it’s not available it tries ports in 3061-3070 range then 13060-13070. In the same way it tries 3131 for SSL port then 3132-3141, then 13131-13141. The case is different for 10g and 9i versions.
8. Configurations attributes’ Locations – configuration information on Oracle Internet Directory is stored in DIT in configuration attributes. In 10g version, many attributes resided in DSE Root and in configset entry while in 11g most of them have moved instance specific configuration entry or DSA configuration entry.
9. Security Features – 11g has new security features such as better password based authentication which mixes cases in passwords, enhances data pump compression and encryption and encryption on table space-level. 11g is well upgraded from 10g and has positive enhancements on advanced technology.
10. Cost – since 11g is an upgraded Oracle version it is cheaper than the latter versions. The cost benefits of an upgraded version have to be properly used to reduce cost of ownership and increase performance and this is delivered by 11g version.
11. Performance and scalability – since 11g Release is an improvement of 10g version, it has improved performance and scalability. New features have been included in 11g for provision of better capabilities to database administrators.
12. Additional Features – some of the new features found in 11g version only are enhanced automatic management of memory, fundamental columns, Optimizer changes, new structure for error diagnosis, facility for redefining charts with view logs online,imperceptible indexes and others. All these features make a major difference between the versions.
13. Viewing of Status Information – with 11g version an upgraded version called OIDCTL is used in viewing of status information. You use the command oidctlstatuswhich displays status of all Oracle Internet Directory Instances. The case is different with 10g version.