Trouble connect/create dataserver schema for oracle with local oracle & progress

H

hanifku

New Member
Hi Chris,

I have following problems, My Solaris 64 bit are installed with Oracle 11g and Progress OpenEdge 10.2B, I am using trial Oracle Data Server and licensed oracle because my company are still considering to buy Oracle data server so I need to take test.

My question is, I am trying to connect to my local Oracle instance from local Progress OpenEdge. When I am trying to connect/create data server schema with a correct ORACLE instance (with correct Username/Password), my Progress crashes and automatically quit. Here is the log:

Here is the log from protrace.log:
PROGRESS stack trace as of Tue Oct 26 10:41:11 2010
Command line arguments are
_progres

Startup parameters:
-pf /Web/progress/dlc10/startup.pf,-cpinternal ISO8859-1,-cpstream ISO8859-1,-cpcoll Basic,-cpcase Basic,-d dmy,-numsep 44,-numdec 46,(end .pf)

(1) ??() +0x84942b from: ??
(2) drexit() +0x3f0 from: /Web/progress/dlc10/bin/_progres
(3) drExitOnTerm() +0x228 from: /Web/progress/dlc10/bin/_progres
(4) _thr_slot_offset() +0x5b0 from: /lib/sparcv9/libc.so.1
(5) sema_post() +0x628 from: /lib/sparcv9/libc.so.1
(6) oradbopnf() +0x650 from: /Web/progress/dlc10/bin/_progres
(7) oradbfilck() +0x1c from: /Web/progress/dlc10/bin/_progres
(8) orafilck() +0x90 from: /Web/progress/dlc10/bin/_progres
(9) orascmanb() +0x114 from: /Web/progress/dlc10/bin/_progres
(10) fdscmanb() +0xd0 from: /Web/progress/dlc10/bin/_progres
(11) scrnci() +0xb4 from: /Web/progress/dlc10/bin/_progres
(12) rnreloc() +0x234c from: /Web/progress/dlc10/bin/_progres
(13) rnproc_entry() +0x28f4 from: /Web/progress/dlc10/bin/_progres
(14) rninterpret() +0x50 from: /Web/progress/dlc10/bin/_progres
(15) umeDispatchEvent() +0x144c from: /Web/progress/dlc10/bin/_progres
(16) wvRunDispatcher() +0xb20 from: /Web/progress/dlc10/bin/_progres
(17) iodispatch() +0xd0 from: /Web/progress/dlc10/bin/_progres
(18) rnrq() +0x150 from: /Web/progress/dlc10/bin/_progres
(19) main() +0x648 from: /Web/progress/dlc10/bin/_progres
(20) _start() +0x17c from: /Web/progress/dlc10/bin/_progres

** ABL Stack Trace **

--> prodict/ora/_ora_lkl.p (prodict/ora/_ora_lkl.r) at line 0
prodict/_dctexec.p (prodict/_dctexec.r) at line 978
Perform_Func prodict/_dictc.p (prodict/_dictc.r) at line 3261
USER-INTERFACE-TRIGGER prodict/_dictc.p (prodict/_dictc.r) at line 5119
prodict/_dictc.p (prodict/_dictc.r) at line 6493
_dict.p (/Web/progress/dlc10/tty/_dict.r) at line 417
_RunTool adeedit/_proedit.p (adeedit/_proedit.r) at line 2870
USER-INTERFACE-TRIGGER adeedit/_proedit.p (adeedit/_proedit.r) at line 3100
adeedit/_proedit.p (adeedit/_proedit.r) at line 12279
_edit.p (/Web/progress/dlc10/tty/_edit.r) at line 408

** Persistent procedures/Classes **
Click to expand...


And here is from dataserv.lg:
[10/10/22@17:10:22.297+0700] P-012297 T-000001 1 ORA -- Executable was compiled on Nov 24 2009 at 17:39:00 (5067)
[10/10/22@17:10:22.297+0700] P-012297 T-000001 1 ORA -- Login to dataserver db as user HANIF. (2689)
[10/10/22@17:10:22.538+0700] P-012297 T-000001 1 ORA -- Using shared library /database/oracle/product/11.2.0/dbhome_1/lib/libclntsh.so (oci 8.1) (14874)
[10/10/22@17:10:22.538+0700] P-012297 T-000001 1 ORA -- ORACLE_HOME set to '/database/oracle/product/11.2.0/dbhome_1' (14875)
[10/10/22@17:10:22.538+0700] P-012297 T-000001 1 ORA -- ORACLE_SID set to 'ccnbcoba' (14877)
[10/10/22@17:10:22.538+0700] P-012297 T-000001 1 ORA -- OCI call OCIInitialize <0>
[10/10/22@17:10:22.549+0700] P-012297 T-000001 1 ORA -- OCI retr OCIInitialize <0> rc = 0 (11095 us)
[10/10/22@17:10:22.549+0700] P-012297 T-000001 1 ORA -- OCI call OCIEnvInit <0>
[10/10/22@17:10:22.550+0700] P-012297 T-000001 1 ORA -- OCI retr OCIEnvInit <0> rc = 0 (375 us)
[10/10/22@17:10:22.550+0700] P-012297 T-000001 1 ORA -- OCI call OCIHandleAlloc <0>
[10/10/22@17:10:22.550+0700] P-012297 T-000001 1 ORA -- OCI retr OCIHandleAlloc <0> rc = 0 (363 us)
[10/10/22@17:10:22.550+0700] P-012297 T-000001 1 ORA -- OCI call OCILogon <0>
[10/10/22@17:10:22.685+0700] P-012297 T-000001 1 ORA -- OCI retr OCILogon <0> rc = 0 (135135 us)
[10/10/22@17:10:22.686+0700] P-012297 T-000001 1 ORA -- OCI call OCIHandleAlloc <0>
[10/10/22@17:10:22.686+0700] P-012297 T-000001 1 ORA -- OCI retr OCIHandleAlloc <0> rc = 0 (111 us)
[10/10/22@17:10:22.686+0700] P-012297 T-000001 1 ORA -- OCI call OCIStmtPrepare <1> sqlcrc = -1
[10/10/22@17:10:22.686+0700] P-012297 T-000001 1 ORA -- ALTER SESSION SET NLS_NUMERIC_CHARACTERS = '.,'
[10/10/22@17:10:22.686+0700] P-012297 T-000001 1 ORA -- OCI retr OCIStmtPrepare <1> rc = 0 (98 us)
[10/10/22@17:10:22.686+0700] P-012297 T-000001 1 ORA -- OCI call OCIStmtExecute <1>
[10/10/22@17:10:22.687+0700] P-012297 T-000001 1 ORA -- OCI retr OCIStmtExecute <1> rc = 0 (932 us)
[10/10/22@17:10:22.687+0700] P-012297 T-000001 1 ORA -- OCI call OCIStmtPrepare <1> sqlcrc = -1
[10/10/22@17:10:22.687+0700] P-012297 T-000001 1 ORA -- ALTER SESSION SET NLS_DATE_FORMAT = 'YYYYMMDDHH24MISS'
[10/10/22@17:10:22.687+0700] P-012297 T-000001 1 ORA -- OCI retr OCIStmtPrepare <1> rc = 0 (91 us)
[10/10/22@17:10:22.687+0700] P-012297 T-000001 1 ORA -- OCI call OCIStmtExecute <1>
[10/10/22@17:10:22.688+0700] P-012297 T-000001 1 ORA -- OCI retr OCIStmtExecute <1> rc = 0 (678 us)
[10/10/22@17:10:22.688+0700] P-012297 T-000001 1 ORA -- OCI call OCIStmtPrepare <1> sqlcrc = -1
[10/10/22@17:10:22.688+0700] P-012297 T-000001 1 ORA -- ALTER SESSION SET TIME_ZONE = '00:00'
[10/10/22@17:10:22.688+0700] P-012297 T-000001 1 ORA -- OCI retr OCIStmtPrepare <1> rc = 0 (77 us)
[10/10/22@17:10:22.688+0700] P-012297 T-000001 1 ORA -- OCI call OCIStmtExecute <1>
[10/10/22@17:10:22.688+0700] P-012297 T-000001 1 ORA -- OCI retr OCIStmtExecute <1> rc = 0 (258 us)
[10/10/22@17:10:22.688+0700] P-012297 T-000001 1 ORA -- OCI call OCIStmtPrepare <1> sqlcrc = -1
[10/10/22@17:10:22.688+0700] P-012297 T-000001 1 ORA -- SELECT VALUE FROM NLS_SESSION_PARAMETERS WHERE PARAMETER = 'NLS_T
[10/10/22@17:10:22.688+0700] P-012297 T-000001 1 ORA -- IMESTAMP_FORMAT'
[10/10/22@17:10:22.688+0700] P-012297 T-000001 1 ORA -- OCI retr OCIStmtPrepare <1> rc = 0 (110 us)
[10/10/22@17:10:22.688+0700] P-012297 T-000001 1 ORA -- OCI call OCIDefineByPos <1>
[10/10/22@17:10:22.688+0700] P-012297 T-000001 1 ORA -- OCI parm OCIDefineByPos <1>
[10/10/22@17:10:22.688+0700] P-012297 T-000001 1 ORA -- type 5 var :1 addr: 0x7fffe954 size 50/0 value: '...'
[10/10/22@17:10:22.689+0700] P-012297 T-000001 1 ORA -- OCI retr OCIDefineByPos <1> rc = 0 (143 us)
[10/10/22@17:10:22.689+0700] P-012297 T-000001 1 ORA -- OCI call OCIStmtExecute <1>
[10/10/22@17:10:22.689+0700] P-012297 T-000001 1 ORA -- OCI retr OCIStmtExecute <1> rc = 0 (912 us)
[10/10/22@17:10:22.690+0700] P-012297 T-000001 1 ORA -- -Dsrv qt_debug: 122879 (0x1dfff Verbose) (6489)
[10/10/22@17:10:22.690+0700] P-012297 T-000001 1 ORA -- Cursor limit: 84 (-c setting) (6490)
[10/10/22@17:10:38.855+0700] P-012297 T-000001 1 ORA -- OCI call OCIHandleAlloc <0>
[10/10/22@17:10:38.855+0700] P-012297 T-000001 1 ORA -- OCI retr OCIHandleAlloc <0> rc = 0 (205 us)
[10/10/22@17:10:38.855+0700] P-012297 T-000001 1 ORA -- OCI call OCIStmtPrepare <2> sqlcrc = 46181
[10/10/22@17:10:38.855+0700] P-012297 T-000001 1 ORA -- SELECT /*+ ROWID(T0) */ USER#,NAME FROM sys.user$ T0
[10/10/22@17:10:38.855+0700] P-012297 T-000001 1 ORA -- OCI retr OCIStmtPrepare <2> rc = 0 (110 us)
[10/10/22@17:10:38.855+0700] P-012297 T-000001 1 ORA -- OCI call OCIStmtExecute-DescribeOnly <2>
[10/10/22@17:10:38.858+0700] P-012297 T-000001 1 ORA -- OCI call OCIErrorGet <0>
[10/10/22@17:10:38.859+0700] P-012297 T-000001 1 ORA -- OCI retr OCIErrorGet <0> rc = 0 (295 us)
[10/10/22@17:10:38.859+0700] P-012297 T-000001 1 ORA -- OCI retr OCIStmtExecute-DescribeOnly <2> rc = -1 (338 us)----------
[10/10/22@17:10:38.859+0700] P-012297 T-000001 1 ORA -- OCI call OCIErrorGet <0>
[10/10/22@17:10:38.859+0700] P-012297 T-000001 1 ORA -- OCI retr OCIErrorGet <0> rc = 0 (96 us)
[10/10/22@17:10:38.859+0700] P-012297 T-000001 1 ORA -- OCI call omru <2>
[10/10/22@17:10:38.859+0700] P-012297 T-000001 1 ORA -- OCI call OCIHandleAlloc <0>
[10/10/22@17:10:38.860+0700] P-012297 T-000001 1 ORA -- OCI retr OCIHandleAlloc <0> rc = 0 (75 us)
[10/10/22@17:10:38.860+0700] P-012297 T-000001 1 ORA -- SYSTEM ERROR: Memory violation. (49)
[10/10/22@17:10:38.860+0700] P-012297 T-000001 1 ORA -- ** Save file named core for analysis by Progress Software Corporation. (439)
Click to expand...

The error is : MEMORY VIOLATION.

And how do I can workaround this? Need suggestion. Thanks
 
You must log in or register to reply here.
Back
Top