Error when install ARS 5.1 for Windows
Error when install ARS 5.1 for Windows
(OP)
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
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
RE: Error when install ARS 5.1 for Windows
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.
RE: Error when install ARS 5.1 for Windows
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
RE: Error when install ARS 5.1 for Windows
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
RE: Error when install ARS 5.1 for Windows
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!