Error when install ARS 5.1 for Windows

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!