On Oracle 9i, the system tablespace is created as locally managed. Once this happens, you cannot create dictionary managed tablespaces.
This statement fails during install (from ARSini71.ora):

create tablespace artmpspc datafile 'artmpf' size 15M reuse temporary;

This statement works, whether the system tablespace is locally or dictionary managed:

create temporary tablespace artmpspc tempfile 'artmpf' size 15M reuse;

The statement needs to be changed after files are untar'd during the install. The file exists in the ora_db subdirectory of where ever the customer is installing ARS.

After editing the file, run:

ar_install -s3


This should be resolved in ARS 5.1.2.

Hi billkronick1,

Thanks for your answer but I don't know where is ARSini71.ora and ar_install file?

You mean that we will replace command 'create tablespace artmpspc datafile 'artmpf' size 15M reuse temporary; ' by command 'create temporary tablespace artmpspc tempfile 'artmpf' size 15M reuse;'

Best regards,
Thinh

Hi tuongmai,

The file should already exist on the server's disk (it looks like you are installing the server binaries on Windows). Try this;

Start the arserver install and you will need to edit the arsini71.ora file (after the database settings screen) with this statement:

create temporary tablespace artmpspc tempfile 'artmpf' size 15M reuse;

At this point of the install do not continue by clicking on "Next" yet. You will need to use CTRL-ESC to leave the Setup program and locate one of the install files.   The install files are located a couple of directories below your TEMP directory.  

To identify the TEMP directory,  click on Start/Run and run 'cmd'.  From the DOS prompt type 'SET TEMP' and press
<Enter>.  This will show the full path to your TEMP folder.   Now use Explorer or My Computer to locate this path (or simply use a Search to find the file).  You now need to search the subdirectories for a file called
ARSINI71.ORA (if you find more than one occurrence of this file,  use the one in the most recently created folder).   

Open this file with a text editor such as NOTEPAD.  Replace the following line in the script

create tablespace artmpspc datafile 'artmpf' size 15M reuse temporary;

with the new line

create temporary tablespace artmpspc tempfile 'artmpf' size 15M reuse;


and save the file.  You should now be able to return to the Setup program and continue the install.

Bill

Hi billkronick1,

Thanks for your help. I have already finished installation. But can not find AR System Server service and can not log in AR System.

Please help me!