Technote

(troubleshooting)

ORA-00959: tablespace 'USERS' does not exist when creating a staging server instance

Problem(Abstract)

Your Instance creation fails when you create a staging server with the workspace option enabled and use Oracle as the database.

Symptom The createInstanceANT.err.log contains the following error:

[2008.02.04 10:31:16] BUILD FAILED
file:/usr/WebSphere/CommerceServer60/components/Workspaces/
xml/configureWorkspaces.xml:193: java.sql.SQLException: ORA-00959: tablespace 'USERS' does not exist

at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java(Compiled Code))
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java(Compiled Code))
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java(Compiled Code))
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java(Compiled Code))
at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java(Compiled Code))
at oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java(Compiled Code))
at oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java(Compiled Code))
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java(Compiled Code))
at oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:891)
at com.ibm.commerce.context.content.objects.ContentSchemaUtility.
executeStatements(ContentSchemaUtility.java:510)
at com.ibm.commerce.context.content.objects.ContentSchemaUtility.
createSchema(ContentSchemaUtility.java:460)
at com.ibm.commerce.context.content.ant.tasks.CreateWorkspaceTask.
performTask(CreateWorkspaceTask.java:301)
at com.ibm.commerce.context.content.ant.tasks.CreateWorkspaceTask.
execute(CreateWorkspaceTask.java:172)
at org.apache.tools.ant.Task.perform(Task.java(Inlined Compiled Code))
at org.apache.tools.ant.Target.execute(Target.java(Compiled Code))
at org.apache.tools.ant.Target.performTasks(Target.java:336)
at org.apache.tools.ant.Project.executeTarget(Project.java:1339)
at org.apache.tools.ant.taskdefs.Ant.execute(Ant.java:397)
at org.apache.tools.ant.taskdefs.CallTarget.execute(CallTarget.java:143)
at org.apache.tools.ant.Task.perform(Task.java(Inlined Compiled Code))
at org.apache.tools.ant.Target.execute(Target.java(Compiled Code))
at org.apache.tools.ant.Target.performTasks(Target.java:336)
at org.apache.tools.ant.Project.executeTarget(Project.java:1339)
at org.apache.tools.ant.taskdefs.Ant.execute(Ant.java:397)
at org.apache.tools.ant.taskdefs.CallTarget.execute(CallTarget.java:143)
at org.apache.tools.ant.Task.perform(Task.java(Inlined Compiled Code)) Cause The scripts assume there is a USERS tablespace when the target database is Oracle. Resolving the problem Create the USERS tablespace before creating the instance when using Oracle as the target database to create a staging server instance with the workspace option enabled.  

Document Information

Current web document: http://www.ibm.com/support/docview.wss?uid=swg21294886