×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Error when install ARS 5.1 for Windows

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

RE: 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.

RE: Error when install ARS 5.1 for Windows

(OP)
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

RE: Error when install ARS 5.1 for Windows

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

RE: Error when install ARS 5.1 for Windows

(OP)
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!

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close