on 10-11-2010 12:52 PM
When I try to instal I got this error
WARNING[E] 2010-10-11 13:44:25.906
CJS-30109 <html> <head> </head> <body> The Java load in database ITM/ZEUS has already been configured.<br>SOLUTION: Remove the schema and load it with a new load before you run this installation. </body></html>
Where can remove this shema and how to load new load?
Mirko
Hi,
As per error log, Java schema which you are creating already exits in database. If Java Schema already there then why are you installing Java Add-in again ??
You can delete already existing Java Schema as below:
1. Log on as user ora<dbsid>.
2. Start sqlplus and connect to the database. Enter:
sqlplus /nolog
SQLPLUS>connect / as sysdba
3. Enter the following command to delete the database objects of the database schema:
SQLPLUS> drop user SAP<SCHEMA_ID>DB cascade;
4. Enter the following command to get the file name of the corresponding data file in the file system:
SQLPLUS> select file_name from dba_data_files where \
tablespace_name = 'PSAP<SCHEMA_ID>DB';
5. Enter the following command to delete the tablespace of the database schema:
SQLPLUS> drop tablespace PSAP<SCHEMA_ID>DB including contents;
6. Exit sqlplus:
SQLPLUS> exit
7. Delete the data file of tablespace PSAP<SCHEMA_ID>DB from the file system
Thanks
Sunny
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi, i have dropped the schema and tablespace under that particular schema, but when i run the JAVA CI installation again i hit some error "ORA-01017: invalid username.password", i think its because the secstore.properties that is being used is the one generated using the old schema. how will i solve this issue?
User | Count |
---|---|
87 | |
10 | |
10 | |
9 | |
7 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.