Unix Technical Forum

sqlplus loop

This is a discussion on sqlplus loop within the Oracle Database forums, part of the Database Server Software category; --> Good day, on a openSUSE 10.2, kernel 2.6.18.2-34-default #1 SMP, and Oracle Release 10.2.0.1.0, *after* successful installation and creation ...


Go Back   Unix Technical Forum > Database Server Software > Oracle Database

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 02-26-2008, 06:16 AM
Wolf Grossi
 
Posts: n/a
Default sqlplus loop

Good day,

on a openSUSE 10.2, kernel 2.6.18.2-34-default #1 SMP,
and Oracle Release 10.2.0.1.0, *after* successful installation and
creation of a database,

sqlplus loops.


The package 'orarun' is installed.



A 'strace sqlplus' shows the following (line 1-404 skipped):


---
open("/opt/oracle/product/10.2/db_1/rdbms/mesg/ocid.msb", O_RDONLY) = 9
fcntl64(9, F_SETFD, FD_CLOEXEC) = 0
lseek(9, 0, SEEK_SET) = 0
read(9, "\27\5#\t\23\17## $\20\34\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0"...,
256) = 256
open("/opt/oracle/product/10.2/db_1/rdbms/mesg/ocius.msb", O_RDONLY) = 10
fcntl64(10, F_SETFD, FD_CLOEXEC) = 0
lseek(10, 0, SEEK_SET) = 0
read(10, "\25\23\"\1\23\3\t\t\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0 \0\0\0"...,
256) = 256
lseek(9, 512, SEEK_SET) = 512
read(9, "\337y\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0 \0\0\0"...,
512) = 512
lseek(9, 1024, SEEK_SET) = 1024
read(9, "\23\7\35\7+\0074\7=\7E\7\265\17\335\17A\'\5K\nK\3 77S\27"...,
104) = 104
brk(0x80ae000) = 0x80ae000
times(NULL) = -1843895186
times(NULL) = -1843895186
.... loop ...
---


A similar proplem can be found in technet, however w/o solution.

Thanks for reading.
Any hints are very much appreciated.

Wolf
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old 02-26-2008, 06:16 AM
Wolf Grossi
 
Posts: n/a
Default Re: sqlplus loop - ok

....rebooting the system (was running since jan 2007) solves the prob.
Well known oracle bug since oct 2006.

Wolf
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 03:10 AM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.2.0
www.UnixAdminTalk.com