First , great module ! As I have seeen from the screenshots and flash demo is very promising. Thanks
I have Installation Problem on Windows Plateform
especially with the database import . Even i use Oracle 10g release : 10.1.0.2
Here is the steps that I have followed :
- Download : Kompiere Libero Manufacturing Solution
- Create new fresh Oracle Database : Database Name : Kompiere , User : sysdba pass : compiere Oracle release : 10.1.0.2
- Install : Kompiere Manufacturing : RUN_setup.bat ( fill the paramaters, test OK , save.....) At this point, everything works fine
- Data Folders : there is ExpDat.dmp + ExpDat.log
- I tried the followings with no sucuss :
- I run RUN_DBRestore.bat - with ExpDat.dmp , the import doesnt seem to work
- I changed the name of expdat.dmp to compiere.dmp and execute RUN_ImportCompiere.bat , with no luck
Here is the log from the command line in both case
Setting myEnvironment ....
Re-Create Compiere User and import C:\erp\data\ExpDat.dmp
Volume in drive C has no label.
Volume Serial Number is 1479-3785
Directory of C:\erp\data
06/14/2005 09:45 PM 28,139,520 ExpDat.dmp
1 File(s) 28,139,520 bytes
0 Dir(s) 30,643,077,120 bytes free
== The import will show warnings. This is OK ==
Press any key to continue . . .
Compiere Database Restore $Revision: 1.5 $
Restoring Compiere DB from C:\erp\data\ExpDat.dmp
-------------------------------------
Re-Create DB user
-------------------------------------
...............
...............
................
................
-------------------------------------
Import ExpDat
-------------------------------------
Import: Release 10.1.0.2.0 - Production on Sun Jul 17 22:56:33 2005
Copyright (c) 1982, 2004, Oracle. All rights reserved.
Connected to: Oracle Database 10g Release 10.1.0.2.0 - Production
Export file created by EXPORT:V10.01.00 via conventional path
Warning: the objects were exported by COMPIERE, not by you
import done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
import server uses US7ASCII character set (possible charset conversion)
export client uses US7ASCII character set (possible charset conversion)
IMP-00034: Warning: FromUser "SYSTEM" not found in export file
Import terminated successfully with warnings.
-------------------------------------
Create SQLJ
-------------------------------------
'create' is not recognized as an internal or external command,
operable program or batch file.
-------------------------------------
Check System
Import may show some warnings. This is OK as long as the following does not show errors
-------------------------------------
SQL*Plus: Release 10.1.0.2.0 - Production on Sun Jul 17 22:57:13 2005
Copyright (c) 1982, 2004, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Release 10.1.0.2.0 - Production
DBA_Cleanup();
*
ERROR at line 2:
ORA-06550: line 2, column 2:
PLS-00201: identifier 'DBA_CLEANUP' must be declared
ORA-06550: line 2, column 2:
PL/SQL: Statement ignored
ORA-06550: line 3, column 2:
PLS-00201: identifier 'DBA_AFTERIMPORT' must be declared
ORA-06550: line 3, column 2:
PL/SQL: Statement ignored
Any help please
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hi
First , great module ! As I have seeen from the screenshots and flash demo is very promising. Thanks
I have Installation Problem on Windows Plateform
especially with the database import . Even i use Oracle 10g release : 10.1.0.2
Here is the steps that I have followed :
- Download : Kompiere Libero Manufacturing Solution
- Create new fresh Oracle Database : Database Name : Kompiere , User : sysdba pass : compiere Oracle release : 10.1.0.2
- Install : Kompiere Manufacturing : RUN_setup.bat ( fill the paramaters, test OK , save.....) At this point, everything works fine
- Data Folders : there is ExpDat.dmp + ExpDat.log
- I tried the followings with no sucuss :
- I run RUN_DBRestore.bat - with ExpDat.dmp , the import doesnt seem to work
- I changed the name of expdat.dmp to compiere.dmp and execute RUN_ImportCompiere.bat , with no luck
Here is the log from the command line in both case
Setting myEnvironment ....
Re-Create Compiere User and import C:\erp\data\ExpDat.dmp
Volume in drive C has no label.
Volume Serial Number is 1479-3785
Directory of C:\erp\data
06/14/2005 09:45 PM 28,139,520 ExpDat.dmp
1 File(s) 28,139,520 bytes
0 Dir(s) 30,643,077,120 bytes free
== The import will show warnings. This is OK ==
Press any key to continue . . .
Compiere Database Restore $Revision: 1.5 $
Restoring Compiere DB from C:\erp\data\ExpDat.dmp
-------------------------------------
Re-Create DB user
-------------------------------------
...............
...............
................
................
-------------------------------------
Import ExpDat
-------------------------------------
Import: Release 10.1.0.2.0 - Production on Sun Jul 17 22:56:33 2005
Copyright (c) 1982, 2004, Oracle. All rights reserved.
Connected to: Oracle Database 10g Release 10.1.0.2.0 - Production
Export file created by EXPORT:V10.01.00 via conventional path
Warning: the objects were exported by COMPIERE, not by you
import done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
import server uses US7ASCII character set (possible charset conversion)
export client uses US7ASCII character set (possible charset conversion)
IMP-00034: Warning: FromUser "SYSTEM" not found in export file
Import terminated successfully with warnings.
-------------------------------------
Create SQLJ
-------------------------------------
'create' is not recognized as an internal or external command,
operable program or batch file.
-------------------------------------
Check System
Import may show some warnings. This is OK as long as the following does not show errors
-------------------------------------
SQL*Plus: Release 10.1.0.2.0 - Production on Sun Jul 17 22:57:13 2005
Copyright (c) 1982, 2004, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Release 10.1.0.2.0 - Production
DBInfo
--------------------------------------------------------------------------------
DB_Name=kompiere, Language=AMERICAN_AMERICA.US7ASCII, Host=WORKGROUP\CABE0, IP=192
.190.10.2, User=SYSTEM, ID=5, Session=207
DBA_Cleanup();
*
ERROR at line 2:
ORA-06550: line 2, column 2:
PLS-00201: identifier 'DBA_CLEANUP' must be declared
ORA-06550: line 2, column 2:
PL/SQL: Statement ignored
ORA-06550: line 3, column 2:
PLS-00201: identifier 'DBA_AFTERIMPORT' must be declared
ORA-06550: line 3, column 2:
PL/SQL: Statement ignored
Any help please
OK found the source of problem,
During the setup process , the compiere database user has to be "Compiere " in order the import work
I Have spent 3 days on this, but loves Compiere
great software