Hi All,
I am Installing DB scripts in my local mechine, while I am getting error. can you please give me any suggestion.
Actually I run scripts from DataBase component Configuration, in that I selected Create TableSpaces and DataBase User and Admin ID=webmethod7 password=webmethod7 Tblespace Directory=D:\Program Files\webMethods7\common\db\scripts\oracle\tradingnetworks\25\create, finally I clicked Execute button, then it shows some error, Please provide corresponding answer how to over come this problem.
[SIZE=“3”]
- Executing action
- Action : create
- Database : Oracle
- Component : storage
- Component version : latest
- URL : jdbc:wm:oracle://localhost:1521;serviceName=xe
- User : webmethod7
- create Database Component: Storage STR
- Versions
- Version: oracle 26 (7.1SP2Fix1)
-
Scripts create -
Script(1): D:\Program Files\webMethods7\common\db/scripts/oracle/storage/25/create/ora_str_c_ddl_tablespaces.sql -
Script(2): D:\Program Files\webMethods7\common\db/scripts/oracle/storage/25/create/ora_str_c_ddl_user.sql
-
Executing script : D:\Program Files\webMethods7\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 D:\Program Files\webMethods7\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 : Fri Nov 18 15:16:57 GMT 2011
Database : Oracle
User : webmethod7
Action : create
Following components could not be installed: