on 03-04-2009 6:55 AM
Hello All,
I am doing installation of NW2004 640 with Windows 2K3 and oracle 9207.
Its Failing with the following error message.
==============================================================================
SAPINST.log:-
INFO 2009-03-03 22:30:33
Copying file H:/nw2004/Installation Master IA32/Installation_Master_6.20_6.40_07_07/IM_WINDOWS_I386/SAPINST/NT/COMMON/INSTALL/ORA/TABLESPACES.XML to: TABLESPACES.XML.
INFO 2009-03-03 22:30:33
Creating file C:\Program Files (x86)\sapinst_instdir\NW04\SYSTEM\ABAP\ORA\NUC\DB\TABLESPACES.XML.
INFO 2009-03-03 22:30:33
Working directory changed to C:\Program Files (x86)\sapinst_instdir\NW04\SYSTEM\ABAP\ORA\NUC\DB.
ERROR 2009-03-03 22:30:34
CJS-00084 SQL statement or script failed.<br>DIAGNOSIS: Error message: ORA-02180: invalid option for CREATE TABLESPACE
Disconnected from Oracle9i Enterprise Edition Release 9.2.0.7.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.7.0 - Production
.<br>SOLUTION: See ora_sql_results.log and the Oracle documentation for details.
WARNING 2009-03-03 22:31:16
Installation canceled by user request.
=================================================================================
and the Sql command file which its running is as follows:-
CREATE TABLESPACE PSAP@SCHEMAID@ DATAFILE 'G:\oracle\HRU\sapdata4\psap@schemaid@_1\psap@schemaid@.data1' SIZE 2000M REUSE AUTOEXTEND ON NEXT 20M MAXSIZE 10000M LOGGING ONLINE PERMANENT EXTENT MANAGEMENT LOCAL AUTOALLOCATE SEGMENT SPACE MANAGEMENT AUTO ;
Please help me out for the same.
And i Done the kernel upgrade to the latest level of 640 which is 271.
But still the error is coming.
Please suggest me for same
Thanks in advance.
REgards,
Ramkrishna
Hi Ramakrishina,
Please refer following link.
http://download-west.oracle.com/docs/cd/A87860_01/doc/server.817/a85397/statem4c.htm#2063200
Abhijeet
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Rama Krishna,
Post the logs of ora_sql_results.log file.
Is the latest version of kernel patch is 248 or 271???I am not so clear about this ...just check it out again.
Regards,
Kalyan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Ramkrishna,
INFO 2009-03-03 22:30:33
Copying file H:/nw2004/Installation Master IA32/Installation_Master_6.20_6.40_07_07/IM_WINDOWS_I386/SAPINST/NT/COMMON/INSTALL/ORA/TABLESPACES.XML to: TABLESPACES.XML.
Please make sure that there are
no spaces in the installation directory
. I hope rest of the things are fine like environment variables JAVA_HOME, ORACLE_HOME.
Hope this works.
Manoj Chintawar
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
81 | |
25 | |
12 | |
9 | |
7 | |
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.