Local / Dictionary Managed DB INFO
For a few days ago, I have encountered a question, I can't help but ask, many people are not allowed to enter. An accidental opportunity, talking about the DBA of a software vendor on the phone, he also encountered the same problem and made an analysis. I can't affirm his analysis is correct, but it is posted to give you a reference. This is a problem, and the other party's analysis: the name of some manufacturers software is involved, please ignore.
Problems: Paul / Vince / Brendan, What is the difference between a database that was initially configured as a data dictionary table space vs .... local database, we are seeing installation errors when attempting to install to a 'data dictionary'
. S table space It was my understanding in the differences was performance not structure The ISSUE we are seeing as as follows:. The database was initially configured as a data dictionary tablespace with 100MB of space available The initialization of the database during the installation of. the base integration server failed by running out of space when trying to create the extent of table 75. The database administrator checked the database after the failure and determined that the database had been filled up to 99MB and the attempt to create the next table after reaching the 99MB point is what caused the failure. The database administrator then increased the size of the tablespace to 300MB and the db_setup.sh script was executed manually with the NOPROMPT parameter on the command line. The initialization of the database failed again. This time the Database Filled to 299MB Before Failing On The Creation of An Extent for a Table. The Database Administrator Ten Changed The Table Space Fr om a data dictionary tablespace to a local tablespace with 300MB of space available. The db_setup.sh was executed manually again with the NOPROMPT parameter on the command line. This time the database was successfully initialized. According to the database administrator, the only difference between THE TYPE OF TABLE SPACES IS in Performance NOT STRUCTURE?
The database flavor in use is ORACLE. The database does not reside on a different host system from the one that Sterling Integrator was installed upon. In the installation guide for Sterling Integrator, there is no mention in the section on setting up an ORACLE database for Sterling Integrator on the type of tablespace that should be created. Is this something we should be concerned about for future installations of Sterling Integrator? Is this something that has already been explored in regard to Sterling Integrator or is examination in the development lab needed to try to determine the cause of the issue Alison DrouillardSterling Integrator (ext.7868) L:? 2 Technical Support Specialist analysis: This questions has to do with how the oracle DB is set up to handle extent managment I would suggest you refer them (and. Yoursels) to this article: http://www.oracle.com/oramag/oracle...tml? O60o8i.htmlit Explains Very Well How Extents Work in Oracle.as for Si Being Created In A DB (That Has Been Creat) ed as a data dictionary table space) what I can say is that, based on how our DBs and tablespaces here in house are configured, we have only used the 'Locally Managed' extent scheme. Currently there is a problem in creating a data dictionary table space if the Data Base 'System' tables are created as Local. Basically the whole DB must be created as a data dictionary style before you can create data dictionary tablespaces. I'm not sure about the converse, but based on Allisons'
