eu acho que o script do ExpDat.DMP está com problema…
Na etapa de DBInfo ele dpa um erro em uma variável (falta declrarar). E ai nao faz mais nada.
Setting myEnvironment …
Re-Create Adempiere User and import C:\SISTEMAS\PROD\Adempiere\data\ExpDat.dmp
O volume na unidade C não tem nome.
O número de série do volume é 289D-8B03
Pasta de C:\SISTEMAS\PROD\Adempiere\data
21/01/2009 15:09 21.418.638 ExpDat.dmp
1 arquivo(s) 21.418.638 bytes
0 pasta(s) 141.412.048.896 bytes disponíveis
== The import will show warnings. This is OK ==
Pressione qualquer tecla para continuar. . .
Adempiere Database Restore $Revision: 1.6 $
Restoring Adempiere DB from C:\SISTEMAS\PROD\Adempiere\data\ExpDat.dmp
Re-Create DB user
SQL*Plus: Release 10.2.0.1.0 - Production on Qui Set 23 13:39:12 2010
Copyright © 1982, 2005, Oracle. All rights reserved.
Conectado a:
Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production
SQL> /*************************************************************************
SQL> * The contents of this file are subject to the Adempiere License. You may
SQL> * obtain a copy of the License at adempiere.org/license.html
SQL> * Software is on an “AS IS” basis, WITHOUT WARRANTY OF ANY KIND, either
SQL> * express or implied. See the License for details. Code: Adempiere ERP+CRM
SQL> * Copyright © 1999-2001 Jorg Janke, ComPiere, Inc. All Rights Reserved.
SQL> *************************************************************************
SQL> * $Id: CreateUser.sql,v 1.1 2006/04/21 17:51:58 jjanke Exp $
SQL> ***
SQL> * Title: Drop User and re-create new
SQL> * Description:
SQL> * Parameter: UserID UserPwd
SQL> * Run as system
SQL> ************************************************************************/
SQL> DROP USER &1 CASCADE
2 /
antigo 1: DROP USER &1 CASCADE
novo 1: DROP USER adempiere CASCADE
Usußrio eliminado.
SQL> CREATE USER &1 IDENTIFIED BY &2
2 DEFAULT TABLESPACE USERS
3 TEMPORARY TABLESPACE TEMP
4 PROFILE DEFAULT
5 ACCOUNT UNLOCK
6 /
antigo 1: CREATE USER &1 IDENTIFIED BY &2
novo 1: CREATE USER adempiere IDENTIFIED BY adempiere
Usußrio criado.
SQL> GRANT CONNECT TO &1
2 /
antigo 1: GRANT CONNECT TO &1
novo 1: GRANT CONNECT TO adempiere
ConcessÒo bem-sucedida.
SQL> GRANT DBA TO &1
2 /
antigo 1: GRANT DBA TO &1
novo 1: GRANT DBA TO adempiere
ConcessÒo bem-sucedida.
SQL> GRANT RESOURCE TO &1
2 /
antigo 1: GRANT RESOURCE TO &1
novo 1: GRANT RESOURCE TO adempiere
ConcessÒo bem-sucedida.
SQL> GRANT UNLIMITED TABLESPACE TO &1
2 /
antigo 1: GRANT UNLIMITED TABLESPACE TO &1
novo 1: GRANT UNLIMITED TABLESPACE TO adempiere
ConcessÒo bem-sucedida.
SQL> ALTER USER &1 DEFAULT ROLE CONNECT, RESOURCE, DBA
2 /
antigo 1: ALTER USER &1 DEFAULT ROLE CONNECT, RESOURCE, DBA
novo 1: ALTER USER adempiere DEFAULT ROLE CONNECT, RESOURCE, DBA
Usußrio alterado.
SQL> GRANT CREATE TABLE TO &1
2 /
antigo 1: GRANT CREATE TABLE TO &1
novo 1: GRANT CREATE TABLE TO adempiere
ConcessÒo bem-sucedida.
SQL> EXIT
Desconectado de Oracle Database 10g Express Edition Release 10.2.0.1.0 - Product
ion
Import ExpDat
Import: Release 10.2.0.1.0 - Production on Qui Set 23 13:39:36 2010
Copyright © 1982, 2005, Oracle. All rights reserved.
Conectado a: Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production
IMP-00037: Marcador desconhecido de conjunto de caracteres
IMP-00000: ImportaþÒo encerrada com Ûxito
Check System
Import may show some warnings. This is OK as long as the following does not show
errors
SQL*Plus: Release 10.2.0.1.0 - Production on Qui Set 23 13:39:36 2010
Copyright © 1982, 2005, Oracle. All rights reserved.
Conectado a:
Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production
DBInfo
DB_Name=XE, Language=BRAZILIAN PORTUGUESE_BRAZIL.WE8MSWIN1252, Host=HOME\MCPC01,
IP=192.168.1.100, User=ADEMPIERE, ID=37, Session=92
DBA_Cleanup();
*
ERRO na linha 2:
ORA-06550: linha 2, coluna 2:
PLS-00201: o identificador ‘DBA_CLEANUP’ deve ser declarado
ORA-06550: linha 2, coluna 2:
PL/SQL: Statement ignored
ORA-06550: linha 3, coluna 2:
PLS-00201: o identificador ‘DBA_AFTERIMPORT’ deve ser declarado
ORA-06550: linha 3, coluna 2:
PL/SQL: Statement ignored
Procedimento PL/SQL concluÝdo com sucesso.
nÒo hß linhas selecionadas
nÒo hß linhas selecionadas
nÒo hß linhas selecionadas
nÒo hß linhas selecionadas
Commit concluÝdo.
Desconectado de Oracle Database 10g Express Edition Release 10.2.0.1.0 - Product
ion
Pressione qualquer tecla para continuar. . .
