This discussion is archived
1 2 Previous Next 19 Replies Latest reply: Feb 9, 2013 8:56 PM by yoonas RSS

Reg : Multi-tier DB with OracleXE -

ranit B Expert
Currently Being Moderated
Hi Experts,

Currently, I've an DB setup (Oracle XE 11.2.0.2) in my lappy.
I want to try up few things as in my employer's production DB... multi-tier architecture.

So, can I install another XE (may be with some different name) in my same machine?
Just trying to simulate that multi-tier architecture.

Please give me some pointers/concept regarding this.
Help much appreciated.

Thanks,
Ranit B.
  • 1. Re: Reg : Multi-tier DB with OracleXE -
    Niket Kumar Pro
    Currently Being Moderated
    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......

    what is multi tier architecture... why it require 2 db's ... you can use two schema instead of another database...
  • 2. Re: Reg : Multi-tier DB with OracleXE -
    yoonas Expert
    Currently Being Moderated
    Hi,
    >
    Just trying to simulate that multi-tier architecture.
    >


    http://en.wikipedia.org/wiki/Multitier_architecture
    http://www.linuxjournal.com/article/3508


    Regards
    Yoonas
  • 3. Re: Reg : Multi-tier DB with OracleXE -
    ranit B Expert
    Currently Being Moderated
    Niket Kumar wrote:
    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......
    What if I try installing a different version say Oracle 11.1 (installed currently is 11.2) ??
    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 ??

    I need to test something with DB Links ,still u want me to create 2 schemas ??
  • 4. Re: Reg : Multi-tier DB with OracleXE -
    JohnWatson Guru
    Currently Being Moderated
    Just create your schemas, and a link that loops back:
    db121a orcl$ sqlplus system/oracle
    
    SQL*Plus: Release 12.1.0.0.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 12.1.0.0.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 dual@john.thomas;
    
    D
    -
    X
    
    orcl>
    --
    John Watson
    http://skillbuilders.com
  • 5. Re: Reg : Multi-tier DB with OracleXE -
    Osama_Mustafa Oracle ACE
    Currently Being Moderated
    multi-tier architecture.
    Why you need to install another Database , Create another instance , create another schema.
  • 6. Re: Reg : Multi-tier DB with OracleXE -
    Niket Kumar Pro
    Currently Being Moderated
    two databases doesn't have same name on single machine whether they are of different version.....XE only provides XE name of database.....you need to install enterprise edition for two different instances.....


    and you can make database link to connect to same database as john given a good example....

    Edited by: Niket Kumar on Feb 9, 2013 2:59 PM
  • 7. Re: Reg : Multi-tier DB with OracleXE -
    ranit B Expert
    Currently Being Moderated
    Niket Kumar wrote:
    two databases doesn't have same name on single machine whether they are of different version.....XE only provides XE name of database....
    Doesn't have a same name+ ?
    or u meant Does have a same name+ ??
  • 8. Re: Reg : Multi-tier DB with OracleXE -
    ranit B Expert
    Currently Being Moderated
    Osama_mustafa wrote:
    Why you need to install another Database , Create another instance , create another schema.
    Could you please tell me how to create an Instance in XE ?
  • 9. Re: Reg : Multi-tier DB with OracleXE -
    Niket Kumar Pro
    Currently Being Moderated
    yes....for oracle you are not able to install two databases with same name on single machine....
  • 10. Re: Reg : Multi-tier DB with OracleXE -
    Srini Chavali-Oracle Oracle ACE Director
    Currently Being Moderated
    To install XE - pl see the documentation - http://docs.oracle.com/cd/E17781_01/index.htm

    Only one instance of XE can be created on any physical server - see section 3.2 here - http://docs.oracle.com/cd/E17781_01/install.112/e18802/toc.htm#BABIECJA

    HTH
    Srini
  • 11. Re: Reg : Multi-tier DB with OracleXE -
    Osama_Mustafa Oracle ACE
    Currently Being Moderated
    ranit B wrote:
    Osama_mustafa wrote:
    Why you need to install another Database , Create another instance , create another schema.
    Could you please tell me how to create an Instance in XE ?
    you already create one. Did you check John Solutions
  • 12. Re: Reg : Multi-tier DB with OracleXE -
    ranit B Expert
    Currently Being Moderated
    Thanks Srini... feeling much better now.

    Small snippet from the link you provided :
    >
    To run more than one <u><i>Oracle Database server instance</i></u> or install more than one copy of <u><i>the database software</i></u>,
    >
    What is the difference between both of these?

    Please rectify me if i'm wrong -
    <u><i>Oracle Database server instance</i></u> means the background processes and services (can be seen in services.msc) that run the database and <u><i>the database software</i></u> which stores the actual data.


    Ranit B
    (an Oracle Enthusiast)
  • 13. Re: Reg : Multi-tier DB with OracleXE -
    ranit B Expert
    Currently Being Moderated
    @Osama - I tried John suggested... seems to be fine. Will workout more on it to get more clarity.

    Thanks guys- Niket, Yoonus, John, Osama... Much appreciated.
    (I just love this forum)
  • 14. Re: Reg : Multi-tier DB with OracleXE -
    Srini Chavali-Oracle Oracle ACE Director
    Currently Being Moderated
    The "one Oracle Database server instance" implies the memory processes associated with a database, as you have pointed out.

    http://docs.oracle.com/cd/E11882_01/server.112/e25789/startup.htm#CNCPT601

    The "one copy of the database software" refers to the actual Oracle binaries/software installed.

    In an XE situation, you can have only one of each on a server - i.e. one install of the binaries/software and one database instance associated with that install.

    In a Standard or Enterprise Edition of Oracle, these restrictions are not present - you can have multiple databases associated with an install of Oracle binaries (ORACLE_HOME), and you can also have multiple installations of Oracle binaries (i.e. multiple ORACLE_HOMEs) - these could be the same version or multiple versions (e.g. 9i, 10g, 11g etc)

    HTH
    Srini
1 2 Previous Next

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points