on 06-27-2013 9:06 AM
Dear All;
during the installation of SAP ERP 6.0 on Suse Linux I faced the error: ora-00959: tablespace 'psaptemp' does not exist at the phase create database schema.
I am afraid that I do this manually then this might affect the installation. Shall I do it or would you recommend another issue. Note: all the previous installation phased went fine with no issues.
Best Regards
~Amal Aloun
Hi Amal,
Personally I would create it manually and restart the sapinst with continue as it should pick up that the tablespace excists and continue
Best Regards
Marius
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Amal,
Please run the below command:
CREATE TEMPORARY TABLESPACE PSAPTEMP TEMPFILE 'E 😕 oracle/ORC/sapdata3/temp_1/temp.data1' SIZE 500M REUSE AUTOEXTEND ON NEXT 100M MAXSIZE unlimited EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M;
ALTER DATABASE DEFAULT TEMPORARY TABLESPACE PSAPTEMP;
Hope this will help you out.
Thanks
Ajitabh
Dear All;
With your help I was able to fix the error ora-00959
What I did is using the following statement to create PSAPTEMP manually:
create temporary tablespace PSAPTEMP tempfile 'oracle/SID/sapdata1/temp_1/temp.data1' size 5M reuse autoextend off;
I made sure that the location oracle/SID/sapdata1/temp_1 exist so it can be able to create inside it.
i did not have the folder temp_1 so i created it using the comman mkdir temp_1
After that the issue went well
Thanks for all the help.
Best Regards
~Amal Aloun
Did you install your database when sapinst paused and prompted you to do so?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello
Most probably this is a test environment and the system was refreshed recently, and after the refresh the PSAPTEMP was not re-created. (Just guessing)
Check whether the PSAPTEMP is present
select NAME from v$tablespace;
Now check for the PSAPTEMP temp files
select * from v$tempfile;
Check whether there is any directory by the name temp in any of the sapdata file system.
If yes re-create the PSAPTEMP from the SQL.
Eg: ALTER TABLESPACE PSAPTEMP ADD TEMPFILE '/oracle/SID/sapdata1/temp_1/temp1.data' SIZE 5544M REUSE AUTOEXTEND OFF;
Good Luck
RB
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello,
Could You please refer sap note -: 1120872.
15/DEC/05 4 unable to assign default tablespace to user: ...
ORA-00959: tablespace 'PSAPSR3USR' does not exist<<<<<<<<<<<<<<<<<<
Best Regards,
Yong Luo
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.