This content has been marked as final. Show 8 replies
You need to drop your TEMP tablespace to get the repository creation assistant to work. Hit the same problem yesterday evening.
I will try this out
How did you know that the TEMP tablespace was the problem ??, the logs
do you mean drop and recreate TEMP ?
I could see problems with TEMP in the xterm window that launched runInstaller, and the following errors where in the rcu.log files in $MIDDLEWARE_HOME/oms11g/sysman/log/schemamanager/m_061410_0728_PM/m_061410_0728_PM.CREATE
Caused by: oracle.sysman.assistants.common.dbutil.SQLFatalErrorException: java.sql.SQLException: ORA-01543: tablespace 'TEMP' already exists
... 3 more
Caused by: java.sql.SQLException: ORA-01543: tablespace 'TEMP' already exists
I created a TEMP3 and dropped TEMP, TEMP1 and TEMP2 (db had tablespace groups). When I hit retry, all configuration assistants completed successfully.
Drop and do not recreate as described above.
I have two temporary tablespaces.. TEMP and TEMPTS1.. where TEMPTS1 is default temporary tablespace.. i cannot drop the default tablespace right???
I hit the same problem.
What operating system are you using?
I raised an SR, and Oracle Support said that the problem was I was using an uncertified combination (Windows Server 2003 (64-bit) and OMS 11g) and that that was the cause of the problem. Not sure what I'll do now. It is certified for 32-bit, but I don't think we have a suitable machine available.
You could do this:
ALTER DATABASE DEFAULT TEMPORARY TABLESPACE tempts1;
DROP TABLESPACE temp INCLUDING CONTENTS AND DATAFILES;