Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.
Course Of The Month
2 days, 14 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
Problems installing a new Designer 6i Repository
Posted on 2001-07-19
Following the 'Server Side Installation' chapter in the 'Oracle Designer Installation Guide', when clicking [start] on the Install a Repository Instance dialog box, I answer the prompts but then get an error at Stage CKPRIOVW when the package is trying to create the CK_INSTALLED_ONJECTS_RESOL
When I do a SELECT on USER_TABLES, I see only 1, CK_INSTALLED_OBJECTS, the CK_PRODUCT_ELEMENTS table is not there!!
Has anyone got an idea what I can do to handle this problem - it has stopped me in my tracks!!
Thanks for your help!!
Richard
When I do a SELECT on USER_TABLES, I see only 1, CK_INSTALLED_OBJECTS, the CK_PRODUCT_ELEMENTS table is not there!!
Has anyone got an idea what I can do to handle this problem - it has stopped me in my tracks!!
Thanks for your help!!
Richard
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
2 Comments
The CK_INSTALLED_OBJECTS and CK_PRODUCT_ELEMENTS tables are the first objects created during the install. The following query will show you the objects and installation order (assuming a fresh install and schema):
select
created,
object_name,
object_type
from
user_objects
order by created;
----- output -----
CK_INSTALLED_OBJECTS (table)
CK_PRODUCT_ELEMENTS (table)
PRIME_CK_INSTALLED_OBJECTS
CK_INSTALLED_OBJECTS_RESOL
JR_NUM_LIST (type)
JR_STR_LIST (type)
----- output continues -----
The table you were missing, CK_PRODUCT_ELEMENTS, is installed by the import utility in the very first phase of the installation (after the tablespace selection form). You may (or may not) have noticed a command prompt window pop up. Anyway, the log file for that import session should be located in:
%ORACLE_HOME%\REPADM61\LOG
Check this file for any errors and resolve them.
I'm suspecting that you don't have (or didn't configure) enough storage for the default tablespace of the installing user. This is where the import utility will try to install these tables. If you had setup all the tablespaces that the installation instruction recommend, and set the default tablespace of the installing user to the RAPID_GROW_TABLES tablespace, then this would be the place to start looking. Otherwise, check what the default tablespace for the installing user is (user_users or dba_users). Then check the storage parameters for that tablespace (dba_data_files, dba_tablespaces, and dba_free_space). Plan on having about 2MB free... just for the two tables an the index... not to mention the other objects that will end up in that tablespace during the install process.
If a lack of storage does turn out to be the culprit, you may want to revisit step 5 of the installation instructions. If you not using the recommended configuration, make sure your default tablespace and any other tablespaces you use during the assignment phase of the installation have enough free space in accordance with the information presented in step 5.
One last note... once you resolve the issue, you may want to select the "Remove All Objects" from the "Deinstall" box of the Repository Admin Utility and perform a fresh install... just to be sure the install goes smoothly.
select
created,
object_name,
object_type
from
user_objects
order by created;
----- output -----
CK_INSTALLED_OBJECTS (table)
CK_PRODUCT_ELEMENTS (table)
PRIME_CK_INSTALLED_OBJECTS
CK_INSTALLED_OBJECTS_RESOL
JR_NUM_LIST (type)
JR_STR_LIST (type)
----- output continues -----
The table you were missing, CK_PRODUCT_ELEMENTS, is installed by the import utility in the very first phase of the installation (after the tablespace selection form). You may (or may not) have noticed a command prompt window pop up. Anyway, the log file for that import session should be located in:
%ORACLE_HOME%\REPADM61\LOG
Check this file for any errors and resolve them.
I'm suspecting that you don't have (or didn't configure) enough storage for the default tablespace of the installing user. This is where the import utility will try to install these tables. If you had setup all the tablespaces that the installation instruction recommend, and set the default tablespace of the installing user to the RAPID_GROW_TABLES tablespace, then this would be the place to start looking. Otherwise, check what the default tablespace for the installing user is (user_users or dba_users). Then check the storage parameters for that tablespace (dba_data_files, dba_tablespaces, and dba_free_space). Plan on having about 2MB free... just for the two tables an the index... not to mention the other objects that will end up in that tablespace during the install process.
If a lack of storage does turn out to be the culprit, you may want to revisit step 5 of the installation instructions. If you not using the recommended configuration, make sure your default tablespace and any other tablespaces you use during the assignment phase of the installation have enough free space in accordance with the information presented in step 5.
One last note... once you resolve the issue, you may want to select the "Remove All Objects" from the "Deinstall" box of the Repository Admin Utility and perform a fresh install... just to be sure the install goes smoothly.
My apologies for being so long in replying.
I looked at the ckprereq.log and it had an error "Attempting to create a PERMANENT object in a TEMPORARY tablespace".
I then looked at the repository owner tablespaces and noticed that I had assigned tablespace TEMP to the default tablespace. It was not clear from the instructions what I should use although it did suggest the rapid grow instance data under some circumstances. Accepting this advice, I changed the default tablespace for the repository owner from TEMP to RAPID_GROW_TABLES, removed all repository objects and re-ran the install. This time it ran without incident.
I contacted an associate of mine at HeavyLifters.com (a great group of people) and he suggested using the Oracle DBA_Studio tool for re-configuration - I found it much easier to use than the standard server SQL commands.
Thanks for your help - it definitely pointed me in the right direction.
Regards,
Richard
I looked at the ckprereq.log and it had an error "Attempting to create a PERMANENT object in a TEMPORARY tablespace".
I then looked at the repository owner tablespaces and noticed that I had assigned tablespace TEMP to the default tablespace. It was not clear from the instructions what I should use although it did suggest the rapid grow instance data under some circumstances. Accepting this advice, I changed the default tablespace for the repository owner from TEMP to RAPID_GROW_TABLES, removed all repository objects and re-ran the install. This time it ran without incident.
I contacted an associate of mine at HeavyLifters.com (a great group of people) and he suggested using the Oracle DBA_Studio tool for re-configuration - I found it much easier to use than the standard server SQL commands.
Thanks for your help - it definitely pointed me in the right direction.
Regards,
Richard
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Working with Network Access Control Lists in Oracle 11g (part 2)
Part 1: http://www.e-e.com/A_8429.html
Previously, I introduced the basics of network ACL's including how to create, delete and modify entries to allow and deny access. For many…
Background
In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.
Suggested Courses
Course of the Month2 days, 14 hours left to enroll
Earn Certification
Certified Information Systems Auditor (CISA)
$99.00$89.10
695 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.