- Fórum
- Protheus/Microsiga/Totvs
- Protheus Lobo-Guará - Release 12.1.23
- Informações Para Upgrade
- INSTALAÇÃO ORACLE 18C EXPRESS e CONF. DBACCESS
Perguntas INSTALAÇÃO ORACLE 18C EXPRESS e CONF. DBACCESS
- juscelino
- Autor do Tópico
- Desconectado
- Membro Júnior
Menos
Mais
- Postagens: 28
- Obrigados Recebidos: 0
3 anos 6 meses atrás #33035
por juscelino
INSTALAÇÃO ORACLE 18C EXPRESS e CONF. DBACCESS foi criado por juscelino
******* MENSAGEM do ARQUIVO ERROR.LOG *******
7.00.170117A-20190212
THREAD ERROR ([5776], JASMASTER_, JAS) 28/04/2021 03:49:42
MIG_CTRL: DB error (Update): -29 File: MIG_CTRL - on FWCUSTOMSEMAPHORE:WRITEVALUES(FWCUSTOMSEMAPHORE.PRW) 15/02/2019 09:10:57 line : 154
[build: 7.00.170117A-20190212]
[environment: LOBO_GUARA_ORACLE]
[thread: 5776]
[dbthread: 12060]
[dbapibuild: 20181212-20190123]
[rpodb: top]
[localfiles: CTREE]
[remark: MPSysToDb - FwIpcWait]
[threadtype: JobThread]
Called from MPSYSSEMAPHOREMIG(MPSYSSEMAPHOREMIG.PRW) 15/02/2019 09:11:02 line : 309
******* MENSAGEM do ARQUIVO DBACCESS.LOG *******
28/04/2021 03:49:42 : Error : 12899 - ORA-12899: value too large for column "LOBOPROTHEUS"."MIG_CTRL"."THREAD_VAL" (actual: 262, maximum: 255)
( From tOracleISAMFile::Update )
Thread ID [14568] User [JASMASTER_] IO [2972] Tables [5] MaxTables [7] Comment [] Status [] SP [ ] Traced [No] InTran [No] DBEnv [ORACLE/XE] DBThread [(SID )] Started [28/04/2021 03:36:41] LastIO [] IP [127.0.0.1:1259] RCV [953720] SND [905760] TCBuild [20141119]
UPDATE MIG_CTRL SET THREAD_VAL = :1,STATUS = :2 WHERE R_E_C_N_O_ = :3
******* MENSAGEM do ARQUIVO DBCONSOLE.LOG *******
Error : 12899 - ORA-12899: value too large for column "LOBOPROTHEUS"."MIG_CTRL"."THREAD_VAL" (actual: 262, maximum: 255)
( From tOracleISAMFile::Update )
Thread ID [14568] User [JASMASTER_] IO [2972] Tables [5] MaxTables [7] Comment [] Status [] SP [ ] Traced [No] InTran [No] DBEnv [ORACLE/XE] DBThread [(SID )] Started [28/04/2021 03:36:41] LastIO [] IP [127.0.0.1:1259] RCV [953720] SND [905760] TCBuild [20141119]
UPDATE MIG_CTRL SET THREAD_VAL = :1,STATUS = :2 WHERE R_E_C_N_O_ = :3
******* ARQUIVOS DE CONFIGURAÇÃO DO AMBIENTE o APPSERVER.INI e DBACCESS.INI *******
*** INFORMAÇÕES da BUILD
* TOTVS - Build 7.00.170117A - Feb 12 2019 - 16:37:29
* Build: 64 bits
* SVN Revision: 22059
* Build Version: 17.3.0.8
******* CONFIGURAÇÃO do MEU DBACCESS.INI *******
[General]
LicenseServer=
LicensePort=0
ByYouProc=0
Port=7890
[MSSQL]
user=sa
password=êÿ“
TableSpace=
IndexSpace=
environments=gfe,PROTHEUS,LOBO_GUARA
[MSSQL/gfe]
user=sa
password=ÑÎÓ4
TableSpace=
IndexSpace=
[MSSQL/PROTHEUS]
user=sa
password=êÿ“
TableSpace=
IndexSpace=
[MSSQL/LOBO_GUARA]
user=sa
password=êÿ“
TableSpace=
IndexSpace=
[ORACLE]
ORACLE_HOME=C:\app\JASMASTER\product\18.0.0\dbhomeXE\BIN
ClientLibrary=C:\app\JASMASTER\product\18.0.0\dbhomeXE\BIN\oci.dll
BindLobFields=1
environments=XE
;memoasblob=1
;ORACLE_HOME=C:\app\JASMASTER\product\18.0.0\dbhomeXE\OCI18
;ClientLibrary=C:\app\JASMASTER\product\18.0.0\dbhomeXE\OCI18\oci.dll
;OCIVersion=18
[ORACLE/XE]
user=LOBOPROTHEUS
password=øÛ
TableSpace=dados
IndexSpace=indices
LogAction=1
memoasblob=1
******* CONFIGURAÇÃO do MEU APPSERVER.INI *******
[LOBO_GUARA_ORACLE]
SourcePath=C:\APLIC\ERPS\TOTVS\PROTHEUS\Lobo_Guara_Oracle\TOTVS_LG\TOTVS_LG\Protheus\apo
RootPath=C:\APLIC\ERPS\TOTVS\PROTHEUS\Lobo_Guara_Oracle\TOTVS_LG\TOTVS_LG\Protheus_data
StartPath=\system\
RpoDb=top
RpoLanguage=Portuguese
RpoVersion=120
Trace=0
TopMemoMega=1
DBAlias=XE
DBServer=localhost
DBDatabase=ORACLE
DBPort=7890
StartSysInDB=1
[TopConnect]
Database=ORACLE
Alias=XE
ProtheusOnly=0
Port=7980
[Drivers]
Active=TCP
[TCP]
TYPE=TCPIP
Port=1259
[General]
InstallPath=C:\TOTVS_LG\Protheus
Segmento=YddTQHWW=VZF=yhu
Serie===AV
MAXSTRINGSIZE=10
[LICENSECLIENT]
server=localhost
port=7777
[service]
Name=TOTVS_PROTHEUS_LG_ORACLE
Displayname=TOTVS | Protheus LG | Oracle
[TCPSERVER]
Enable=0
7.00.170117A-20190212
THREAD ERROR ([5776], JASMASTER_, JAS) 28/04/2021 03:49:42
MIG_CTRL: DB error (Update): -29 File: MIG_CTRL - on FWCUSTOMSEMAPHORE:WRITEVALUES(FWCUSTOMSEMAPHORE.PRW) 15/02/2019 09:10:57 line : 154
[build: 7.00.170117A-20190212]
[environment: LOBO_GUARA_ORACLE]
[thread: 5776]
[dbthread: 12060]
[dbapibuild: 20181212-20190123]
[rpodb: top]
[localfiles: CTREE]
[remark: MPSysToDb - FwIpcWait]
[threadtype: JobThread]
Called from MPSYSSEMAPHOREMIG(MPSYSSEMAPHOREMIG.PRW) 15/02/2019 09:11:02 line : 309
******* MENSAGEM do ARQUIVO DBACCESS.LOG *******
28/04/2021 03:49:42 : Error : 12899 - ORA-12899: value too large for column "LOBOPROTHEUS"."MIG_CTRL"."THREAD_VAL" (actual: 262, maximum: 255)
( From tOracleISAMFile::Update )
Thread ID [14568] User [JASMASTER_] IO [2972] Tables [5] MaxTables [7] Comment [] Status [] SP [ ] Traced [No] InTran [No] DBEnv [ORACLE/XE] DBThread [(SID )] Started [28/04/2021 03:36:41] LastIO [] IP [127.0.0.1:1259] RCV [953720] SND [905760] TCBuild [20141119]
UPDATE MIG_CTRL SET THREAD_VAL = :1,STATUS = :2 WHERE R_E_C_N_O_ = :3
******* MENSAGEM do ARQUIVO DBCONSOLE.LOG *******
Error : 12899 - ORA-12899: value too large for column "LOBOPROTHEUS"."MIG_CTRL"."THREAD_VAL" (actual: 262, maximum: 255)
( From tOracleISAMFile::Update )
Thread ID [14568] User [JASMASTER_] IO [2972] Tables [5] MaxTables [7] Comment [] Status [] SP [ ] Traced [No] InTran [No] DBEnv [ORACLE/XE] DBThread [(SID )] Started [28/04/2021 03:36:41] LastIO [] IP [127.0.0.1:1259] RCV [953720] SND [905760] TCBuild [20141119]
UPDATE MIG_CTRL SET THREAD_VAL = :1,STATUS = :2 WHERE R_E_C_N_O_ = :3
******* ARQUIVOS DE CONFIGURAÇÃO DO AMBIENTE o APPSERVER.INI e DBACCESS.INI *******
*** INFORMAÇÕES da BUILD
* TOTVS - Build 7.00.170117A - Feb 12 2019 - 16:37:29
* Build: 64 bits
* SVN Revision: 22059
* Build Version: 17.3.0.8
******* CONFIGURAÇÃO do MEU DBACCESS.INI *******
[General]
LicenseServer=
LicensePort=0
ByYouProc=0
Port=7890
[MSSQL]
user=sa
password=êÿ“
TableSpace=
IndexSpace=
environments=gfe,PROTHEUS,LOBO_GUARA
[MSSQL/gfe]
user=sa
password=ÑÎÓ4
TableSpace=
IndexSpace=
[MSSQL/PROTHEUS]
user=sa
password=êÿ“
TableSpace=
IndexSpace=
[MSSQL/LOBO_GUARA]
user=sa
password=êÿ“
TableSpace=
IndexSpace=
[ORACLE]
ORACLE_HOME=C:\app\JASMASTER\product\18.0.0\dbhomeXE\BIN
ClientLibrary=C:\app\JASMASTER\product\18.0.0\dbhomeXE\BIN\oci.dll
BindLobFields=1
environments=XE
;memoasblob=1
;ORACLE_HOME=C:\app\JASMASTER\product\18.0.0\dbhomeXE\OCI18
;ClientLibrary=C:\app\JASMASTER\product\18.0.0\dbhomeXE\OCI18\oci.dll
;OCIVersion=18
[ORACLE/XE]
user=LOBOPROTHEUS
password=øÛ
TableSpace=dados
IndexSpace=indices
LogAction=1
memoasblob=1
******* CONFIGURAÇÃO do MEU APPSERVER.INI *******
[LOBO_GUARA_ORACLE]
SourcePath=C:\APLIC\ERPS\TOTVS\PROTHEUS\Lobo_Guara_Oracle\TOTVS_LG\TOTVS_LG\Protheus\apo
RootPath=C:\APLIC\ERPS\TOTVS\PROTHEUS\Lobo_Guara_Oracle\TOTVS_LG\TOTVS_LG\Protheus_data
StartPath=\system\
RpoDb=top
RpoLanguage=Portuguese
RpoVersion=120
Trace=0
TopMemoMega=1
DBAlias=XE
DBServer=localhost
DBDatabase=ORACLE
DBPort=7890
StartSysInDB=1
[TopConnect]
Database=ORACLE
Alias=XE
ProtheusOnly=0
Port=7980
[Drivers]
Active=TCP
[TCP]
TYPE=TCPIP
Port=1259
[General]
InstallPath=C:\TOTVS_LG\Protheus
Segmento=YddTQHWW=VZF=yhu
Serie===AV
MAXSTRINGSIZE=10
[LICENSECLIENT]
server=localhost
port=7777
[service]
Name=TOTVS_PROTHEUS_LG_ORACLE
Displayname=TOTVS | Protheus LG | Oracle
[TCPSERVER]
Enable=0
Por favor Acessar ou Registrar para participar da conversa.
- Fórum
- Protheus/Microsiga/Totvs
- Protheus Lobo-Guará - Release 12.1.23
- Informações Para Upgrade
- INSTALAÇÃO ORACLE 18C EXPRESS e CONF. DBACCESS
Tempo para a criação da página:0.111 segundos