Error when install ARS 5.1 for Windows

[tuongmai]

Hi all,
I install ARS 5.1 on Windows XP Pro. Database use for ARS is Oracle 9.2 on other Server. When it is in progess creating data, I get following error:

Error ORA-12913: Cannot create dictionary managed tablespace in comment create tablespace artmpspc datafile ‘artmpf_nms-thinhdx’ size 100M reuse temporary

Please help me to solve this problem

Thanks a lot

Thinh

 

[billkronick1]

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.

 

[tuongmai]

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

 

[billkronick1]

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

 

[tuongmai]

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!