cancel
Showing results for 
Search instead for 
Did you mean: 

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

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

former_member220071
Active Participant
0 Kudos
Former Member
0 Kudos

Hello,

Thanks for your reply.

and i had checked the thread and manually added the tablespace but the error is still coming for it.

Thanks and Regards,

Ramkrishna

Answers (2)

Answers (2)

former_member603052
Contributor
0 Kudos

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

Former Member
0 Kudos

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