Skip to main content

Software  >  WebSphere  >  WebSphere Portal Family  >  

'Unable to initialize Repository: Default' Error caused by ORA-25153: Temporary Tablespace is Empty

 Technote (troubleshooting)
 
Problem(Abstract)
During the attempt to run the IBM® WebSphere® Portal WPSconfig script enable-security-ldap after the completion of a database transfer from CloudScape™ to Oracle®, you see generic errors in ConfigTrace.log and SystemOut.log indicating the task has failed. In addition, SRVE0026E errors appear at startup of Portal after the Database Transfer.
 
Symptom
from SystemOut.log:


........
[date/time] 00000015 ApplicationMg A WSVR0200I: Starting application: icmjcrear
[date/time] 00000015 WebGroup A SRVE0169I: Loading Web Module: icmjcradminwar.
..........
[date/time] 00000015 Datastore$Dat I com.ibm.icm.ci.Datastore$DataSource getInstance Initialized DataStore Environment for repository: Default.
[date/time] 00000015 RepositoryImp I com.ibm.icm.jcr.RepositoryImpl getRepository Loading NodeType cache for repository: Default.
[date/time] 00000015 ServletWrappe E Uncaught init() exception thrown by servlet InitServlet
[date/time] 00000015 WebExtensionP E Error occurred while preparing the servlet for initialization. Check the error logs for details.
[date/time] 00000015 WebExtensionP E SRVE0026E: [Servlet Error]-[javax.servlet.ServletException: Unable to initialize RepositoryFactory due to exception of type: javax.jcr.RepositoryException with message: Unable to initialize Repository: Default..
at com.ibm.icm.jcr.init.InitServlet.init(InitServlet.java:57)
........
---- Begin backtrace for Nested Throwables
javax.jcr.RepositoryException: Unable to initialize RepositoryFactory due to exception of type: javax.jcr.RepositoryException with message: Unable to initialize Repository: Default..
at com.ibm.icm.jcr.RepositoryFactory.init(RepositoryFactory.java:316)
........
Caused by: javax.jcr.RepositoryException: Unable to initialize Repository: Default.
at com.ibm.icm.jcr.RepositoryImpl.getRepository(RepositoryImpl.java:352)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:85)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:58)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java(Compiled Code))
at java.lang.reflect.Method.invoke(Method.java(Compiled Code))
at com.ibm.icm.jcr.RepositoryFactory.init(RepositoryFactory.java:181)
... 23 more

From ConfigTrace.log:

[xmlaccess] EJPXB0020I: The request was processed successfully on the server.
Sat Dec 01 08:34:23 CST 2007
Target started: action-init-accesscontrol

action-init-accesscontrol:
[echo] Calling ContentModelInitializer
Target finished: action-init-accesscontrol
Target finished: action-configure-content-security
Target finished: enable-security-ldap
---- Begin dump of properties ----
........
---- End dump of properties ----

BUILD FAILEDfile:../config/actions/jcr_cfg.xml:1888: Java returned: 1


Total time: 23 minutes 51 seconds

From trace.log with com.ibm.icm.*=all tracing enabled:

.............
[date/time] 00000044 PPreparedStat 3 com.ibm.icm.da.portable.common.sql.PPreparedStatement executeQuery() ==> [SELECT COMP.ITEMTYPEID, COMPATTR.*, VIEWATTR.ATTRIBUTEFLAGS, COMP.COMPONENTTYPEID FROM icmadmin.ICMSTCOMPATTRS COMPATTR, icmadmin.ICMSTCOMPVIEWATTRS VIEWATTR, icmadmin.ICMSTCOMPDEFS COMP WHERE COMPATTR.COMPONENTTYPEID = COMP.COMPONENTTYPEID AND COMPATTR.COMPONENTTYPEID = VIEWATTR.COMPONENTVIEWID AND COMPATTR.ATTRIBUTEGROUP = VIEWATTR.ATTRIBUTEGROUP AND COMPATTR.ATTRIBUTEID = VIEWATTR.ATTRIBUTEID AND COMP.ITEMTYPEID >=1000 ORDER BY COMP.ITEMTYPEID ASC, COMP.COMPONENTTYPEID ASC, COMPATTR.SEQUENCENUM ASC]
[date/time] 00000044 SchemaService W Error retrieving information from the server.
[ErrorCode:7015] During an SQL operation in the library server, an unexpected error. :ORA-25153: Temporary Tablespace is Empty

java.sql.SQLException: ORA-25153: Temporary Tablespace is Empty

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java(Compiled Code))

 
Cause
The cause for the ORA-25153 error is because attempt was made to use space in a temporary tablespace with no files (no datafiles defined).
 
Resolving the problem
Consult with your Oracle Database Administrator (DBA) to determine if there is an issue with the Temporary Tablespace that conflicts with the requirements outlined in the Information Center.

Ensure that users for Oracle are set up correctly according to the Information Center:


http://publib.boulder.ibm.com/infocenter/wpdoc/v6r0/index.jsp?topic=/com.ibm.wp.ent.doc/wpf/setup_oracle.html

including the temporary tablespace. Your Oracle DBA will be able to verify that datafiles exist in the Temporary Tablespace.

If user creation steps cannot be verified, you must drop and recreate the users, and complete the database-transfer task again.

 
Related information
Creating Users in Oracle
 
 
 

Copyright and trademark information
IBM, the IBM logo and ibm.com are trademarks of International Business Machines Corp., registered in many jurisdictions worldwide. Other product and service names might be trademarks of IBM or other companies. A current list of IBM trademarks is available on the Web at "Copyright and trademark information" at www.ibm.com/legal/copytrade.shtml.
Rate this page
Please take a moment to complete this form to help us better serve you.
This material provides me with the information I need.




This material is clear and easy to understand.




Did the information help you to achieve your goal?
What updates, improvements, or related information would you like to see in this document?
Your response will be used to improve our document content. Requests for assistance, if applicable, should be submitted through your normal support channel as we cannot respond from this site.
Input the verification number to submit feedback:
Document information
 Product categories:
 Software
 Organizational Productivity, Portals & Collaboration
 Portals
 WebSphere Portal
 Installation & Configuration
 Operating system(s):
  AIX, HP-UX, Linux, Solaris, Windows
 Software version:
  6.0
 Software edition:
  Enable, Express, Extend
 Reference #:
  1290669
 IBM Group:
 Software Group
 Modified date:
 2009-11-04

Translate My Page
 
 

Rate this page

Help us improve this page. Your response will be used to improve our document content. Requests for assistance, if applicable, should be submitted through your normal support channel as we cannot respond from this site.