+ Reply to Thread
Results 1 to 4 of 4

Thread: Multiple Geodatabase in Oracle

  1. #1
    Qaisar Nadeem
    Join Date
    Oct 2011
    Posts
    4
    Points
    0
    Answers Provided
    0


    0

    Default Multiple Geodatabase in Oracle

    Hi,
    I have installed and configured ArcSDE 10 on Oracle 11G, I followed all the instrauctions given in the course exercise (AECTO- ESRI official Course for ArcGIS Server). it includes the following changes in Oracle and in dbtune file,
    • Oracle Memory Configuration
    • Data_Dctionary Key words modfication
    • Vector and Raster Storage parameters

    Now I want to try multiple geodatabase, but I have questions I will raise them according to Scenario;

    1. Single Oracle Instance with multiple database

    in this situation, my questions are

    1.1 > when we create another user who will own the other schema, we need a default Tablespace for that user, do we need a separate Tablespace of we can use the sde tablespace? what is the best practice.?

    1.2 > the guide Guid reads that we need to modify "Data_Dictionary" parameters, whereaswe have already tuned the parameters for SDE user, now how can we modify the same parameters for the other user ? do we need to add these parameter twice, if so is there any example ?

    1.3> the dbtune file that has been modified for vector and raster storage, now when we load data to the other schema, will the ArcSDE follow the same dbtune file ?

    scenario 2.
    2. multiple oracle database
    This scenarion looks simple, as each database will work independently , only thig is that you will have to repeat several tasks such creating same users in each database.
    the only question is about memory
    2.1 > as ESRI has some recomendation for memory allocation to Oracle SGA and PGA, as when we create an Oracle database it also asks for memory allocation, in this case how can we allocate enough memory to each database, if we create let say three databases? there is no detail available in any document.

    Thanks in Advance
    Qaisar

  2. #2
    Qaisar Nadeem
    Join Date
    Oct 2011
    Posts
    4
    Points
    0
    Answers Provided
    0


    0

    Default Re: Multiple Geodatabase in Oracle

    Hi,
    Is there any ESRI Professional to answer ?

  3. #3
    Travis Val
    Join Date
    May 2010
    Posts
    31
    Points
    10
    Answers Provided
    2


    0

    Default Re: Multiple Geodatabase in Oracle

    Quote Originally Posted by qaisar View Post
    1.1 > when we create another user who will own the other schema, we need a default Tablespace for that user, do we need a separate Tablespace of we can use the sde tablespace? what is the best practice.?
    You don't need a separate tablespace, but it would be the best practice.

    Quote Originally Posted by qaisar View Post
    1.2 > the guide Guid reads that we need to modify "Data_Dictionary" parameters, whereaswe have already tuned the parameters for SDE user, now how can we modify the same parameters for the other user ? do we need to add these parameter twice, if so is there any example ?
    1.3> the dbtune file that has been modified for vector and raster storage, now when we load data to the other schema, will the ArcSDE follow the same dbtune file ?
    Each schema geodatabase has its own dbtune table. If you connect to the master (SDE) schema, ArcSDE will read the SDE.DBTune table. If you connect to the Scott schema, ArcSDE will read the Scott.DBTune table. You can copy and modify the dbtune file you used for the master schema, to support workflows you plan on using with the schema geodatabase (Scott). You would them either save that file to SDEHome\etc\sdedbtune.sde (don't forget to same the current one to something else) and create the schema geodatabase, or load the new dbtune file to the schema geodatabase after it is created (using the SDEDBTune command).

    Quote Originally Posted by qaisar View Post
    2.1 > as ESRI has some recomendation for memory allocation to Oracle SGA and PGA, as when we create an Oracle database it also asks for memory allocation, in this case how can we allocate enough memory to each database, if we create let say three databases? there is no detail available in any document.
    If you create multiple database, then you will have to allocate resources for each of them. These are independent, so if you would like to follow the recommendations, you will have to allocate the recommended amount of memory and disk for each database.

    Travis

  4. #4
    Qaisar Nadeem
    Join Date
    Oct 2011
    Posts
    4
    Points
    0
    Answers Provided
    0


    0

    Default Re: Multiple Geodatabase in Oracle

    Thanks tval
    Its great help

    Qaisar

+ Reply to Thread

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts