Niket Kumar wrote:What if I try installing a different version say Oracle 11.1 (installed currently is 11.2) ??
I think you are not able to install another XE because same database will not work on same machine.......and there is only option for install XE.... you can install enterprise edition and then you can install multiple db's with different name......
why it require 2 db's ... you can use two schema instead of another database...When I'm asking specifically for installing 2 database's, do u think it'll be same as creating 2 schema's ??
db121a orcl$ sqlplus system/oracle SQL*Plus: Release 22.214.171.124.2 Beta on Sat Feb 9 08:55:10 2013 Copyright (c) 1982, 2012, Oracle. All rights reserved. Last Successful login time: Fri Feb 2013 14:08:08 +00:00 Connected to: Oracle Database 12c Enterprise Edition Release 126.96.36.199.2 - 64bit Beta With the Partitioning, OLAP, Data Mining and Real Application Testing options orcl> grant dba to john identified by john; Grant succeeded. orcl> grant dba to thomas identified by thomas; Grant succeeded. orcl> create database link john.thomas connect to thomas identified by thomas using 'orcl'; Database link created. orcl> select * from firstname.lastname@example.org; D - X orcl>