Skip to Content
0
Former Member
Mar 04, 2009 at 06:55 AM

CREATE DATYABASE FAiling with following error ORA-02180: invalid option for

191 Views

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