Installation Problem on Windows Plateform

slilas
2005-07-18
2013-05-02
  • slilas
    slilas
    2005-07-18

    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

     
    • slilas
      slilas
      2005-07-18

      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