getting error while configuring MWS

, ,
1

Hi Team,

when i am trying to configure MWS in my local system , i am getting the below error…please suggest me for further actions.

  • Executing action
  • Action : create
  • Database : Oracle
  • Component : storage
  • Component version : latest
  • URL : jdbc:wm:oracle://localhost:1521;serviceName=XE
  • User : system
  • create Database Component: Storage STR
  • Versions
  • Version: oracle 25 (7.0SP2)
  • Scripts create

  •   Script(1): C:\webMethods72\common\db/scripts/oracle/storage/25/create/ora_str_c_ddl_tablespaces.sql

  •   Script(2): C:\webMethods72\common\db/scripts/oracle/storage/25/create/ora_str_c_ddl_user.sql

  • Executing script : C:\webMethods72\common\db/scripts/oracle/storage/25/create/ora_str_c_ddl_tablespaces.sql

Error: [wm-cjdbc36-0007][Oracle JDBC Driver][Oracle]ORA-02097: parameter cannot be modified because specified value is invalid
ORA-01261: Parameter db_create_file_dest destination string cannot be translated
ORA-01263: Name given for file destination directory is invalid
OSD-04018: Unable to access the specified directory or device.
O/S-Error: (OS 2) The system cannot find the file specified.
ORA-06512: at line 10
CREATE STORAGE [25] FAILED
CDC ERROR [wm-cjdbc36-0007][Oracle JDBC Driver][Oracle]ORA-02097: parameter cannot be modified because specified value is invalid
ORA-01261: Parameter db_create_file_dest destination string cannot be translated
ORA-01263: Name given for file destination directory is invalid
OSD-04018: Unable to access the specified directory or device.
O/S-Error: (OS 2) The system cannot find the file specified.
ORA-06512: at line 10
Suspending execution…
CDC Error: java.sql.SQLException: [wm-cjdbc36-0007][Oracle JDBC Driver][Oracle]ORA-02097: parameter cannot be modified because specified value is invalid
ORA-01261: Parameter db_create_file_dest destination string cannot be translated
ORA-01263: Name given for file destination directory is invalid
OSD-04018: Unable to access the specified directory or device.
O/S-Error: (OS 2) The system cannot find the file specified.
ORA-06512: at line 10

          Summary of installation errors

Error in executing file C:\webMethods72\common\db/scripts/oracle/storage/25/create/ora_str_c_ddl_tablespaces.sql
SQL error [wm-cjdbc36-0007][Oracle JDBC Driver][Oracle]ORA-02097: parameter cannot be modified because specified value is invalid
ORA-01261: Parameter db_create_file_dest destination string cannot be translated
ORA-01263: Name given for file destination directory is invalid
OSD-04018: Unable to access the specified directory or device.
O/S-Error: (OS 2) The system cannot find the file specified.
ORA-06512: at line 10

      Database component configurator summary

Date : Fri Oct 09 17:34:17 IST 2009
Database : Oracle
User : system
Action : create

Following components could not be installed:

Storage 25

2

It seems you are not giving some parameter values expected.
Parameter db_create_file_dest destination string cannot be translated.

Are you trying to Create table space? If so check if you are providing the Tablespace directory where it should be created.

1 Like
3

Thanks a lot…now its working fine!!!:slight_smile:

4

Iam also experiencing the same problem…
I have created a new tablespace and then tried to run the sql files from DB configurator by giving the name of tablespace name in the configurator.I got the same exception.
Iam not sure how to proceed.

Thanks in advance

5

Hi All,

While creating a new table space ca you guide where exactly do we need to give the file location Either its in the file
ora_str_c_ddl_tablespaces.sql or some where else ?
Tried updating the file name space by setting the variable and giving its path but still it failed

Could some one guid eme through
Look forward for help

Thanks in advance
Regards
Satyajith

6

Hi,

are you running DB Configurator as an UI or via command line?

For Command Line there is a parameter:

Please check the Installation Guide, Chapter 6 for further informations.

Regards,
Holger

7

Hi
I am running using the UI , Can you please let me know which Instalation guide i should be referring to
cause as i see n number of doucmentation but couldnt find any with names such as sinstallation guide neither in IS nor in MWS but found one with OPTIMIZE but thats not what i am trying to configure.
It would be great if i can get the document name.

If you have the document could you please attach the same here Holger
Could you help me with it

Thanks in advance

8

Hi Satyajith,

the Guide is named 9-5_Installing_webMethods_Products.pdf.

In the UI in the lower section you can check the create tablespace and user option.
You will have to provide system or sys user from DB instance and the tablespace directory,
i.e.
\oraclexe\oradata\XE

Regards,
Holger

9

Thanks Holger It worked out for me .

I was just giving the folder name than the complete path so was in confusion regarding the error being thrown.
Once i had a second person see my screen then i understood where i was doing wrong

10

Hi Satyajith,

glad to hear that you was able to solve it.

Yes, sometimes it eases things when having someone else to take a glance.

Regards,
Holger