IS is not coming up

Ram_Pachipulusu · October 22, 2013, 4:33pm

Hi All,

I formatted my pc and installed wM 7.1.2 version. When i am trying to server.bat, getting couple of exceptions. Have attached server.log

Please also observe, when i am running DB component configurator, i am getting below exception. Please help me to get rid of this issues

Error Snippet in DB component configurator:

Executing action
Action : create
Database : Oracle
Component : storage
Component version : latest
URL : jdbc:wm:oracle://localhost:1521;serviceName=xe
User : wmuser

create Database Component: Storage STR

Versions
Version: oracle 26 (7.1SP2Fix1)
```
Scripts create
```

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

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

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

Error: [wm-cjdbc36-0007][Oracle JDBC Driver][Oracle]ORA-06550: line 5, column 39:
PL/SQL: ORA-00942: table or view does not exist
ORA-06550: line 5, column 9:
PL/SQL: SQL Statement ignored
ORA-06550: line 13, column 41:
PL/SQL: ORA-00942: table or view does not exist
ORA-06550: line 13, column 9:
PL/SQL: SQL Statement ignored
ORA-06550: line 21, column 41:
PL/SQL: ORA-00942: table or view does not exist
ORA-06550: line 21, column 9:
PL/SQL: SQL Statement ignored

CREATE STORAGE [26] FAILED
CDC ERROR [wm-cjdbc36-0007][Oracle JDBC Driver][Oracle]ORA-06550: line 5, column 39:
PL/SQL: ORA-00942: table or view does not exist
ORA-06550: line 5, column 9:
PL/SQL: SQL Statement ignored
ORA-06550: line 13, column 41:
PL/SQL: ORA-00942: table or view does not exist
ORA-06550: line 13, column 9:
PL/SQL: SQL Statement ignored
ORA-06550: line 21, column 41:
PL/SQL: ORA-00942: table or view does not exist
ORA-06550: line 21, column 9:
PL/SQL: SQL Statement ignored

Suspending execution…
CDC Error: java.sql.SQLException: [wm-cjdbc36-0007][Oracle JDBC Driver][Oracle]ORA-06550: line 5, column 39:
PL/SQL: ORA-00942: table or view does not exist
ORA-06550: line 5, column 9:
PL/SQL: SQL Statement ignored
ORA-06550: line 13, column 41:
PL/SQL: ORA-00942: table or view does not exist
ORA-06550: line 13, column 9:
PL/SQL: SQL Statement ignored
ORA-06550: line 21, column 41:
PL/SQL: ORA-00942: table or view does not exist
ORA-06550: line 21, column 9:
PL/SQL: SQL Statement ignored

          Summary of installation errors

Error in executing file C:\webMethods7.1.2\common\db/scripts/oracle/storage/25/create/ora_str_c_ddl_tablespaces.sql
SQL error [wm-cjdbc36-0007][Oracle JDBC Driver][Oracle]ORA-06550: line 5, column 39:
PL/SQL: ORA-00942: table or view does not exist
ORA-06550: line 5, column 9:
PL/SQL: SQL Statement ignored
ORA-06550: line 13, column 41:
PL/SQL: ORA-00942: table or view does not exist
ORA-06550: line 13, column 9:
PL/SQL: SQL Statement ignored
ORA-06550: line 21, column 41:
PL/SQL: ORA-00942: table or view does not exist
ORA-06550: line 21, column 9:
PL/SQL: SQL Statement ignored

      Database component configurator summary

Date : Tue Oct 22 20:00:32 IST 2013
Database : Oracle
User : wmuser
Action : create

Following components could not be installed:

Storage 26

server.log (34.9 KB)

Sreenivas_Avanigadda · October 22, 2013, 7:00pm

DB_CREATE_FILE_DEST parameter needs to be set for the Oracle instance on which you are running the scripts.
Ask your DBA to do this.

Thanks,
Sreenivas

Ram_Pachipulusu · October 23, 2013, 8:04am

Hi Srinivas,

Its in my local system. Earlier it worked well but after re-installatioin of webMethods s/w i am facing this issue.

Thanks

Sai3 · October 23, 2013, 12:52pm

Have you dropped DB schema earlier while uninstallation of webMethods?

if yes,

Make you sure you remove tablespace directory & rerun create scripts again

if not,

Schema’s still exists in database, it is not necessary to run scripts again. Error even says that table or view exists, i think you have dropped schema earlier

rmg · October 23, 2013, 3:21pm

Hi RP,

Start with the beginning and re-run the db scripts after you made sure that DB side schema/account is clean for re-running the scripts.

HTH,
RMG

Ram_Pachipulusu · October 26, 2013, 9:06am

I did RMG as you specified, still had issue henceforth, i uninstalled and installed software and then it is working fine now.

Thanks all for your valuable inputs.

Thanks

rmg · October 28, 2013, 2:23pm

make sense…always start with fresh mind:D

Mahesh_K_Sreenivas · February 2, 2015, 3:10pm

Dear Experts,

I am running into problems while running the database component configuration for wM 9.7 (free trial). I see below errors; I am using Oracle 11.2g express edition. I have browsed through internet and found that the below items needs to be done at the database

1> setting DB_CREATE_FILE_DEST
2> webMethods scripts require ALTER SESSION permission at the
time of creating database tables

[b]Script(1): \common\db/scripts/oracle/storage/25/create/ora_str_c_ddl_tablespaces.sql

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

Executing script : \common\db/scripts/oracle/storage/25/create/ora_str_c_ddl_tablespaces.sql
Error: [wm-cjdbc36-0007][Oracle JDBC Driver][Oracle]ORA-06550: line 5, column 39:
PL/SQL: ORA-00942: table or view does not exist
ORA-06550: line 5, column 9:
PL/SQL: SQL Statement ignored
ORA-06550: line 13, column 41:
PL/SQL: ORA-00942: table or view does not exist
ORA-06550: line 13, column 9:
PL/SQL: SQL Statement ignored
ORA-06550: line 21, column 41:
PL/SQL: ORA-00942: table or view does not exist
ORA-06550: line 21, column 9:
PL/SQL: SQL Statement ignored

CREATE STORAGE [26] FAILED
CDC ERROR [wm-cjdbc36-0007][Oracle JDBC Driver][Oracle]ORA-06550: line 5, column 39:
PL/SQL: ORA-00942: table or view does not exist
ORA-06550: line 5, column 9:
PL/SQL: SQL Statement ignored
ORA-06550: line 13, column 41:
PL/SQL: ORA-00942: table or view does not exist
ORA-06550: line 13, column 9:
PL/SQL: SQL Statement ignored
ORA-06550: line 21, column 41:
PL/SQL: ORA-00942: table or view does not exist
ORA-06550: line 21, column 9:
PL/SQL: SQL Statement ignored

Suspending execution…
CDC Error: java.sql.SQLException: [wm-cjdbc36-0007][Oracle JDBC Driver][Oracle]ORA-06550: line 5, column 39:
PL/SQL: ORA-00942: table or view does not exist
ORA-06550: line 5, column 9:
PL/SQL: SQL Statement ignored
ORA-06550: line 13, column 41:
PL/SQL: ORA-00942: table or view does not exist
ORA-06550: line 13, column 9:
PL/SQL: SQL Statement ignored
ORA-06550: line 21, column 41:
PL/SQL: ORA-00942: table or view does not exist
ORA-06550: line 21, column 9:
PL/SQL: SQL Statement ignored

Summary of installation errors

Error in executing file \common\db/scripts/oracle/storage/25/create/ora_str_c_ddl_tablespaces.sql
SQL error [wm-cjdbc36-0007][Oracle JDBC Driver][Oracle]ORA-06550: line 5, column 39:
PL/SQL: ORA-00942: table or view does not exist
ORA-06550: line 5, column 9:
PL/SQL: SQL Statement ignored
ORA-06550: line 13, column 41:
PL/SQL: ORA-00942: table or view does not exist
ORA-06550: line 13, column 9:
PL/SQL: SQL Statement ignored
ORA-06550: line 21, column 41:
PL/SQL: ORA-00942: table or view does not exist
ORA-06550: line 21, column 9:
PL/SQL: SQL Statement ignored

Following components could not be installed:

Storage 26
------------------------------------------------------------ [/b]

IS is not coming up

Date : Tue Oct 22 20:00:32 IST 2013 Database : Oracle User : wmuser Action : create

Storage 26

Summary of installation errors

Date : Tue Oct 22 20:00:32 IST 2013
Database : Oracle
User : wmuser
Action : create