I have few question as listed below, hoping gaining help from the expertise...
1. Do the MRP or should i said the ExpDat.dmp used for other version of Compiere such as the latest version of 252a...?It seem to be work on the 250e version, but not 251h...?
2. I have unzip the compiere 251h, to my c: drive and successfully run the setup through this version. I am sure the Compiere_Home environment are set to the correct path.
I also unzip the cmcps.jar copy the ExpDat.dmp and ExpDat.log into the (Eg:c:\compiere2\data). Unluckily when i execute the RUN_DBRestore.bat, below error message appear...
----------------------------------------------------------------------------------------------------------------------------------------------------
Setting myEnvironment ....
Re-Create Compiere User and import C:\Compiere2\data\ExpDat.dmp
Volume in drive C is ACER
Volume Serial Number is 2629-16F0
Directory of C:\Compiere2\data
01-Feb-05 12:50 PM 37,748,736 ExpDat.dmp
1 File(s) 37,748,736 bytes
0 Dir(s) 8,398,569,472 bytes free
== The import will show warnings. This is OK ==
Press any key to continue . . .
Compiere Database Restore $Revision: 1.4 $
Restoring Compiere DB from C:\Compiere2\data\ExpDat.dmp
-------------------------------------
Re-Create DB user
-------------------------------------
SQL*Plus: Release 9.2.0.1.0 - Production on Tue Mar 1 14:04:31 2005
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to:
Oracle9i Release 9.2.0.1.0 - Production
JServer Release 9.2.0.1.0 - Production
SQL> /*************************************************************************
DOC> * The contents of this file are subject to the Compiere License. You may
DOC> * obtain a copy of the License at http://www.compiere.org/license.html
DOC> * Software is on an "AS IS" basis, WITHOUT WARRANTY OF ANY KIND, either
DOC> * express or implied. See the License for details. Code: Compiere ERP+CPM
DOC> * Copyright (C) 1999-2001 Jorg Janke, ComPiere, Inc. All Rights Reserved.
DOC> *************************************************************************
DOC> * $Id: CreateUser.sql,v 1.4 2004/08/14 21:49:11 jjanke Exp $
DOC> ***
DOC> * Title: Drop User and re-create new
DOC> * Description:
DOC> * Parameter: UserID UserPwd
DOC> * Run as system
DOC> ************************************************************************/
SQL> DROP USER &1 CASCADE
2 /
old 1: DROP USER &1 CASCADE
new 1: DROP USER compiere CASCADE
User dropped.
SQL> CREATE USER &1 IDENTIFIED BY &2
2 DEFAULT TABLESPACE USERS
3 TEMPORARY TABLESPACE TEMP
4 PROFILE DEFAULT
5 ACCOUNT UNLOCK
6 /
old 1: CREATE USER &1 IDENTIFIED BY &2
new 1: CREATE USER compiere IDENTIFIED BY compiere
User created.
SQL> GRANT CONNECT TO &1
2 /
old 1: GRANT CONNECT TO &1
new 1: GRANT CONNECT TO compiere
Grant succeeded.
SQL> GRANT DBA TO &1
2 /
old 1: GRANT DBA TO &1
new 1: GRANT DBA TO compiere
Grant succeeded.
SQL> GRANT RESOURCE TO &1
2 /
old 1: GRANT RESOURCE TO &1
new 1: GRANT RESOURCE TO compiere
Grant succeeded.
SQL> GRANT UNLIMITED TABLESPACE TO &1
2 /
old 1: GRANT UNLIMITED TABLESPACE TO &1
new 1: GRANT UNLIMITED TABLESPACE TO compiere
Grant succeeded.
SQL> ALTER USER &1 DEFAULT ROLE CONNECT, RESOURCE, DBA
2 /
old 1: ALTER USER &1 DEFAULT ROLE CONNECT, RESOURCE, DBA
new 1: ALTER USER compiere DEFAULT ROLE CONNECT, RESOURCE, DBA
User altered.
SQL> GRANT CREATE TABLE TO &1
2 /
old 1: GRANT CREATE TABLE TO &1
new 1: GRANT CREATE TABLE TO compiere
Grant succeeded.
SQL> EXIT
Disconnected from Oracle9i Release 9.2.0.1.0 - Production
JServer Release 9.2.0.1.0 - Production
-------------------------------------
Import ExpDat
-------------------------------------
Import: Release 9.2.0.1.0 - Production on Tue Mar 1 14:05:47 2005
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to: Oracle9i Release 9.2.0.1.0 - Production
JServer Release 9.2.0.1.0 - Production
IMP-00010: not a valid export file, header failed verification
IMP-00000: Import terminated unsuccessfully
-------------------------------------
Check System
Import may show some warnings. This is OK as long as the following does not show
errors
-------------------------------------
SQL*Plus: Release 9.2.0.1.0 - Production on Tue Mar 1 14:05:47 2005
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to:
Oracle9i Release 9.2.0.1.0 - Production
JServer Release 9.2.0.1.0 - Production
DOC> * The contents of this file are subject to the Compiere License. You may
DOC> * obtain a copy of the License at http://www.compiere.org/license.html
DOC> * Software is on an "AS IS" basis, WITHOUT WARRANTY OF ANY KIND, either
DOC> * express or implied. See the License for details. Code: Compiere ERP+CPM
DOC> * Copyright (C) 1999-2001 Jorg Janke, ComPiere, Inc. All Rights Reserved.
DOC> *************************************************************************
DOC> * $Id: AfterImport.sql,v 1.15 2004/10/11 05:14:51 jjanke Exp $
DOC> ***
DOC> * Title: After Import
DOC> * Description:
DOC> * - General Info
DOC> * - Create Context
DOC> * - Check Imported User and list ivalid objects
DOC> * You can ignore import warnings as long as this does not
DOC> * return error messages or records.
DOC> ************************************************************************/
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
PL/SQL procedure successfully completed.
no rows selected
no rows selected
no rows selected
no rows selected
Commit complete.
Disconnected from Oracle9i Release 9.2.0.1.0 - Production
JServer Release 9.2.0.1.0 - Production
Press any key to continue . . .
--> I have doubled check the error a few times but still stuck in the same problem... can you tell me why is this happen, my first diognosis is my database whould have to change into the "compiere", but i had changed it then the upstair error message prompt out....(Why...?...still wondering)
Hoping to hear from you soon....
Thank you very much...
Your Sincerely
gcbin80
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hai,
I have few question as listed below, hoping gaining help from the expertise...
1. Do the MRP or should i said the ExpDat.dmp used for other version of Compiere such as the latest version of 252a...?It seem to be work on the 250e version, but not 251h...?
2. I have unzip the compiere 251h, to my c: drive and successfully run the setup through this version. I am sure the Compiere_Home environment are set to the correct path.
I also unzip the cmcps.jar copy the ExpDat.dmp and ExpDat.log into the (Eg:c:\compiere2\data). Unluckily when i execute the RUN_DBRestore.bat, below error message appear...
----------------------------------------------------------------------------------------------------------------------------------------------------
Setting myEnvironment ....
Re-Create Compiere User and import C:\Compiere2\data\ExpDat.dmp
Volume in drive C is ACER
Volume Serial Number is 2629-16F0
Directory of C:\Compiere2\data
01-Feb-05 12:50 PM 37,748,736 ExpDat.dmp
1 File(s) 37,748,736 bytes
0 Dir(s) 8,398,569,472 bytes free
== The import will show warnings. This is OK ==
Press any key to continue . . .
Compiere Database Restore $Revision: 1.4 $
Restoring Compiere DB from C:\Compiere2\data\ExpDat.dmp
-------------------------------------
Re-Create DB user
-------------------------------------
SQL*Plus: Release 9.2.0.1.0 - Production on Tue Mar 1 14:04:31 2005
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to:
Oracle9i Release 9.2.0.1.0 - Production
JServer Release 9.2.0.1.0 - Production
SQL> /*************************************************************************
DOC> * The contents of this file are subject to the Compiere License. You may
DOC> * obtain a copy of the License at http://www.compiere.org/license.html
DOC> * Software is on an "AS IS" basis, WITHOUT WARRANTY OF ANY KIND, either
DOC> * express or implied. See the License for details. Code: Compiere ERP+CPM
DOC> * Copyright (C) 1999-2001 Jorg Janke, ComPiere, Inc. All Rights Reserved.
DOC> *************************************************************************
DOC> * $Id: CreateUser.sql,v 1.4 2004/08/14 21:49:11 jjanke Exp $
DOC> ***
DOC> * Title: Drop User and re-create new
DOC> * Description:
DOC> * Parameter: UserID UserPwd
DOC> * Run as system
DOC> ************************************************************************/
SQL> DROP USER &1 CASCADE
2 /
old 1: DROP USER &1 CASCADE
new 1: DROP USER compiere CASCADE
User dropped.
SQL> CREATE USER &1 IDENTIFIED BY &2
2 DEFAULT TABLESPACE USERS
3 TEMPORARY TABLESPACE TEMP
4 PROFILE DEFAULT
5 ACCOUNT UNLOCK
6 /
old 1: CREATE USER &1 IDENTIFIED BY &2
new 1: CREATE USER compiere IDENTIFIED BY compiere
User created.
SQL> GRANT CONNECT TO &1
2 /
old 1: GRANT CONNECT TO &1
new 1: GRANT CONNECT TO compiere
Grant succeeded.
SQL> GRANT DBA TO &1
2 /
old 1: GRANT DBA TO &1
new 1: GRANT DBA TO compiere
Grant succeeded.
SQL> GRANT RESOURCE TO &1
2 /
old 1: GRANT RESOURCE TO &1
new 1: GRANT RESOURCE TO compiere
Grant succeeded.
SQL> GRANT UNLIMITED TABLESPACE TO &1
2 /
old 1: GRANT UNLIMITED TABLESPACE TO &1
new 1: GRANT UNLIMITED TABLESPACE TO compiere
Grant succeeded.
SQL> ALTER USER &1 DEFAULT ROLE CONNECT, RESOURCE, DBA
2 /
old 1: ALTER USER &1 DEFAULT ROLE CONNECT, RESOURCE, DBA
new 1: ALTER USER compiere DEFAULT ROLE CONNECT, RESOURCE, DBA
User altered.
SQL> GRANT CREATE TABLE TO &1
2 /
old 1: GRANT CREATE TABLE TO &1
new 1: GRANT CREATE TABLE TO compiere
Grant succeeded.
SQL> EXIT
Disconnected from Oracle9i Release 9.2.0.1.0 - Production
JServer Release 9.2.0.1.0 - Production
-------------------------------------
Import ExpDat
-------------------------------------
Import: Release 9.2.0.1.0 - Production on Tue Mar 1 14:05:47 2005
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to: Oracle9i Release 9.2.0.1.0 - Production
JServer Release 9.2.0.1.0 - Production
IMP-00010: not a valid export file, header failed verification
IMP-00000: Import terminated unsuccessfully
-------------------------------------
Check System
Import may show some warnings. This is OK as long as the following does not show
errors
-------------------------------------
SQL*Plus: Release 9.2.0.1.0 - Production on Tue Mar 1 14:05:47 2005
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to:
Oracle9i Release 9.2.0.1.0 - Production
JServer Release 9.2.0.1.0 - Production
DOC> * The contents of this file are subject to the Compiere License. You may
DOC> * obtain a copy of the License at http://www.compiere.org/license.html
DOC> * Software is on an "AS IS" basis, WITHOUT WARRANTY OF ANY KIND, either
DOC> * express or implied. See the License for details. Code: Compiere ERP+CPM
DOC> * Copyright (C) 1999-2001 Jorg Janke, ComPiere, Inc. All Rights Reserved.
DOC> *************************************************************************
DOC> * $Id: AfterImport.sql,v 1.15 2004/10/11 05:14:51 jjanke Exp $
DOC> ***
DOC> * Title: After Import
DOC> * Description:
DOC> * - General Info
DOC> * - Create Context
DOC> * - Check Imported User and list ivalid objects
DOC> * You can ignore import warnings as long as this does not
DOC> * return error messages or records.
DOC> ************************************************************************/
DBInfo
--------------------------------------------------------------------------------
DB_Name=compiere, Language=AMERICAN_AMERICA.AL32UTF8, Host=WORKGROUP\ACER1 , IP=
192.1.1.253, User=COMPIERE, ID=67, Session=279
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
PL/SQL procedure successfully completed.
no rows selected
no rows selected
no rows selected
no rows selected
Commit complete.
Disconnected from Oracle9i Release 9.2.0.1.0 - Production
JServer Release 9.2.0.1.0 - Production
Press any key to continue . . .
----------------------------------------------------------------------------------------------------------------------------------------------------
--> I have doubled check the error a few times but still stuck in the same problem... can you tell me why is this happen, my first diognosis is my database whould have to change into the "compiere", but i had changed it then the upstair error message prompt out....(Why...?...still wondering)
Hoping to hear from you soon....
Thank you very much...
Your Sincerely
gcbin80
Hai:
For Additional Information... ...
I think the Main Error message is the
IMP-00010: not a valid export file, header failed verification
IMP-00000: Import terminated unsuccessfully.
It is related to the ExpDat.dmp, do i failed to download the full cpmcs.jar.
please give me some idea... i really need help..!
your regards
gcbin80