Toad World® Forums

(build 1824) Server-side installation fails


#1

I didn’t test with the previous build.

The server-side instalattion fails with “invalid tablespace type for temporary tablespace” (ORA-10615) error

The log file created is useless

I track the error and found that it occurs with

“create user SQLNAV identified by xpto default tablespace USERS temporary tablespace USERS”

Regards


#2

Hi Filipe,

Did you try to install to Oracle 11g? I found an error with installing to 11g: the combo box to select Temporary Tablespace didn’t appare so I couldn’t specify the temporary tablespace for SQLNAV user and then I got the error like yours.

Let me know if you are using 11g or not. I will raise a CR for this and look for a workaround.

Thanks,
Vincent


#3

Hi
Yes I’m using 11g

Thanks
Regards


#4

Hi Filipe,

We have fixed this for you. You can check it out in next beta or GA release.

At the moment, you can first use Server-side Installation Wizard to remove the installed objects. Make sure SQLNAV user and 3 roles with SQLNAV_% are removed. Then run the script below:

– suppose xpto is the pw you want and temp is one of the temporary tablespaces
create user SQLNAV identified by xpto default tablespace USERS temporary tablespace temp
/

grant connect, resource to sqlnav
/

After this, now you can run the Server-side Installation Wizard again to create all the objects and repository.

Thanks,
Vincent


#5

Great, thanks Vicent

(I had already found out the workaround when I found the reason for the error :-))

Regards
Filipe