#9 just hangs in oracle9.2i
i can connect to oracle9.2i but then it just hangs:
elvis{23}% gqlplus
SQL*Plus: Release 9.2.0.1.0 - Production on Fri Nov 15
08:25:12 2002
Copyright (c) 1982, 2002, Oracle Corporation. All rights
reserved.
Enter user-name: gis
Enter password:
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, Oracle Label Security, OLAP and
Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production
<nothing happens/>
when i try to make the file i get:
gcc -Wall -pedantic -D_REENTRANT -O2 gqlplus.c -o
gqlplus -lreadline -lcurses
gqlplus.c: In function `main':
gqlplus.c:1444: warning: assignment from incompatible
pointer type
gqlplus.c: At top level:
gqlplus.c:27: warning: `rcsid' defined but not used
ld: fatal: symbol `_init' is multiply-defined:
(file /usr/local/lib/gcc-lib/sparc-sun-
solaris2.8/2.95.3/crti.o and file /usr/local/lib/libreadline.so);
ld: fatal: symbol `_start' is multiply-defined:
(file /usr/local/lib/gcc-lib/sparc-sun-
solaris2.8/2.95.3/crt1.o and file /usr/local/lib/libreadline.so);
ld: fatal: symbol `_fini' is multiply-defined:
(file /usr/local/lib/gcc-lib/sparc-sun-
solaris2.8/2.95.3/crti.o and file /usr/local/lib/libreadline.so);
ld: fatal: symbol `_lib_version' is multiply-defined:
(file /usr/ccs/lib/values-Xa.o and
file /usr/local/lib/libreadline.so);
ld: fatal: File processing errors. No output written to gqlplus
collect2: ld returned 1 exit status
make: *** [all] Error 1
any clues would be most helpful
i love this tool
Logged In: YES
user_id=640895
Does it really hang, or do you just need to wait for the
prompt? On my linux box, it can take up to 45 seconds before
the prompt appears...
Logged In: YES
user_id=640895
Found something else: gqlplus doesn't have the 45-second
delay when it's started like this:
$ gqlplus /nolog
SQL> connect x/y@z
Connected.
SQL>
Logged In: NO
Works for me, but it did take ~ 45 seconds. Not ideal, but
workable.
Logged In: NO
I'm also noticing this on 9.2.0.6.0
Actually, it works about once every three times. I
haven't found a pattern yet.