Install fails with pre-created database objects if
Page 1 of 1
Install fails with pre-created database objects if
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;;
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
Re: Install fails with pre-created database objects if
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.
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
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum