Install fails with pre-created database objects if

View previous topic View next topic Go down

Install fails with pre-created database objects if

Post  giby.varghese@gmail.com on Wed Nov 11, 2009 9:35 pm

The install attempts to recreate the 'TEMP' tablespace using invalid SQL syntax. It
actually should not be attempting to modify it.
1. Create the Remedy Admin database account assigning 'TEMP' for the temporary
tablespace.
CREATE USER "ARADMIN"
IDENTIFIED BY "PASSWORD"
PROFILE "DEFAULT"
TEMPORARY TABLESPACE "TEMP"
DEFAULT TABLESPACE "ARSYS75"
QUOTA UNLIMITED ON "ARSYS75";
GRANT AR75ROLE TO "ARADMIN";
2. Install reports an oracle 'ORA-02237' error in '/var/tmp/arsystem_install_log.txt' while installing
ARS 7.5 in an Oracle environment.
Feb 06 2009 10:16:41.035 AM -
0500),SEVERE,com.bmc.install.product.arsuitekit.platforms.arsystemservers.arserver.ARServerOracleManageDatabaseTask,
LOG EVENT {Description=[[SQLERROR] [DESCRIPTION] Failed to execute SQL statement],Detail=
[[SQLERRORCODE]=2237 [SQLMESSAGE]=ORA-02237: invalid file size
[SQLSTATEMENT]=CREATE TEMPORARY TABLESPACE TEMP TEMPFILE 'null' SIZE nullM REUSE
AUTOEXTEND ON]}
(Feb 06 2009 10:16:41.036 AM -
0500),SEVERE,com.bmc.install.product.arsuitekit.platforms.arsystemservers.arserver.ARServerOracleManageDatabaseTask,
THROWABLE EVENT {Description=[Failed to execute processDBVendorSqlFile ]},
Throwable=[java.sql.SQLException: ORA-02237: invalid file size
oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:133)
oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:115)
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:221)
oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:467)
oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:417)
oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1084)
oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:187)
oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:1215)
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1515)
oracle.jdbc.driver.OracleStatement.executeUpdateInternal(OracleStatement.java:2283)
oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:2226)
oracle.jdbc.driver.OracleStatementWrapper.executeUpdate(OracleStatementWrapper.java:807)
com.bmc.install.utility.jdbc.impl.AbstractDatabaseHelperImpl.executeStatement
(AbstractDatabaseHelperImpl.java:524)
com.bmc.install.utility.jdbc.DatabaseHelper.executeStatement(DatabaseHelper.java:637)
com.bmc.install.utility.jdbc.SQLScriptRunner.executeSQL(SQLScriptRunner.java:280)
com.bmc.install.product.arsuitekit.platforms.arsystemservers.arserver.ARServerManageDatabaseBusinessTask.processDBVendorSqlFile
(ARServerManageDatabaseBusinessTask.java:622)
com.bmc.install.product.arsuitekit.platforms.arsystemservers.arserver.ARServerManageDatabaseBusinessTask.execute
(ARServerManageDatabaseBusinessTask.java:93)
com.bmc.install.task.InstallationTask.run(InstallationTask.java:81)
java.lang.Thread.run(Thread.java:595)]
3. File '/var/tmp/arsystem_create_sql.txt' contains the following sql that references 'null' where it
is attempting to recreate the 'TEMP' tablespace:
CREATE TEMPORARY TABLESPACE TEMP TEMPFILE 'null' SIZE nullM REUSE AUTOEXTEND ON;; COMMIT;; ALTER
USER ARADMIN TEMPORARY TABLESPACE TEMP;; COMMIT;;

giby.varghese@gmail.com

Posts : 107
Points : 222
Reputation : 3
Join date : 2009-11-11

View user profile

Back to top Go down

Re: Install fails with pre-created database objects if

Post  giby.varghese@gmail.com on Wed Nov 11, 2009 9:35 pm

This issue was logged as defect SW00327296 and is fixed in 7.5 patch 2
There are two options as a workaround:
1) If default temporary tablespace is set to a tablespace with any another name it works:
CREATE USER "AR75"
IDENTIFIED BY "PASSWORD"
PROFILE "DEFAULT"
TEMPORARY TABLESPACE "AR75TMPSPC"
DEFAULT TABLESPACE "ARSYS75"
QUOTA UNLIMITED ON "ARSYS75";
GRANT AR75ROLE TO "AR75";
2) If you let the Install create the database user then it will let you select the 'TEMP' tablespace (if it exists) and
not encounter the problem.

giby.varghese@gmail.com

Posts : 107
Points : 222
Reputation : 3
Join date : 2009-11-11

View user profile

Back to top Go down

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum