Hello Anand, The installer says missing tempfile Did you running installer with pre-created tablespace or you want installer to create tablespace.
If you let the installer takes care of the tablespace part, you wouldnt hit into this error. Also during Database panel, select new temp tablespace. I would do below 01. Drop tablespace, Role, user created on your Linux Db 02. Drop directory structure from /opt/bmc .../etc/arsystem 03. Run the installer again and let the installer create tablespace and temp tablespace. If you would want to run againest existing pre-created tablespace, you can refer 7.6.04 Install Document Page 38 ++++ To use a previously created tablespace in BMC Remedy AR System 1 In a SQL*Plus window, create the tablespace. For example: create tablespace arsys datafile 'c:\qa\data\QATST\data\arsys.dbf' size 500M reuse; 2 Create a user. For example: create user aradmin identified by AR#Admin# default tablespace arsys temporary tablespace temp quota unlimited on arsys; 3 Create a role for the user you created in step 2 above. For example: create role ARole_arsys not identified; 4 Set the privileges for the role. For example: grant alter session, create cluster, create database link, create sequence, create session, create synonym, create table, create view, create procedure, create trigger, query rewrite to ARole_arsys; 5 Grant the role to the user. For example: grant ARole_arsys to aradmin; ++++++ Hope this helps. Regards/Vaibhav On Thu, Dec 13, 2012 at 1:42 PM, Anantha Jeyaprakash < [email protected]> wrote: > LOG EVENT {Description=[[SQLERROR] [DESCRIPTION] Failed to execute SQL > statement],Detail=[[SQLERRORCODE]=2199 [SQLMESSAGE]=ORA-02199: missing > DATAFILE/TEMPFILE clause [SQLSTATEMENT]=CREATE TEMPORARY TABLESPACE > ARTMPSPC]} _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
