Re: Oracle on Debian/Linux...

From: alan <alanbrown_at_pacbell.net>
Date: Thu, 19 Dec 2002 21:48:15 GMT
Message-ID: <z8rM9.1108$ij6.166@newssvr16.news.prodigy.com>

Thanks again. That one was a simple thing indeed.

However, I'm still having problems. I'm now able to run the dbca. However, while "Creating And Starting Oracle" the database the configuration assistant throws an ORA-03113 error (End of file on communication channel) (while 46% of the way through every time, by the way).

So I went to have a look in my alert log and it told me that I have errorr in my udump/test_db_ora_2572.trc file as follows...

Datafile

'/home/alan/OraHome1/oradata/testdb/drsys01.dbf' ,
'/home/alan/OraHome1/oradata/testdb/example01.dbf' ,
'/home/alan/OraHome1/oradata/testdb/indx01.dbf' ,
'/home/alan/OraHome1/oradata/testdb/odm01.dbf' ,
'/home/alan/OraHome1/oradata/testdb/system01.dbf' ,
'/home/alan/OraHome1/oradata/testdb/tools01.dbf' ,
'/home/alan/OraHome1/oradata/testdb/undotbs01.dbf' ,
'/home/alan/OraHome1/oradata/testdb/users01.dbf' ,
'/home/alan/OraHome1/oradata/testdb/xdb01.dbf'

LOGFILE GROUP 1 ('/home/alan/OraHome1/oradata/testdb/redo01.log') SIZE 102400K,
GROUP 2 ('/home/alan/OraHome1/oradata/testdb/redo02.log') SIZE 102400K, GROUP 3 ('/home/alan/OraHome1/oradata/testdb/redo03.log') SIZE 102400K RESETLOGS
Thu Dec 19 13:06:49 2002
Errors in file /home/alan/OraHome1/admin/testdb/udump/testdb_ora_2629.trc: ORA-07445: exception encountered: core dump [sxorchk()+69] [SIGILL] [unknown code] [0x0] [] []
Thu Dec 19 13:12:32 2002
Shutting down instance (abort)
License high water mark = 3
Instance terminated by USER, pid = 263

Looking in that file wasn't too productive though.

Dump of memory from 0xA8C7E68 to 0xA8C806C

A8C7E60                   00000000 00000000          [........]
A8C7E70 00000000 00000000 00000000 00000000  [................]
        Repeat 30 times
A8C8060 00000000 00000000 00000000           [............]

qmxdplsuga * qmxdplsuga_p [A8C806C, A8C8070) = 00000000

qmpauga * qmpauga_p [A8C8070, A8C8074) = 00000000
qmxtcug * qmxtcuga_p [A8C8074, A8C8078) = 00000000
qsmguga * qsmgu_p [A8C8078, A8C807C) = 00000000

struct _xsawuga * xsawuga_p [A8C807C, A8C8080) = 00000000 struct _xsoquga * xsoquga_p [A8C8080, A8C8084) = 00000000 ub4 ksmugmg2 [A8C8084, A8C8088) = 0000CDCD KSTDUMP: In-memory trace dump
TIME:SEQ# ORAPID SID EVENT OP DATA

19B49728:00000000   149     0 10280   1 0x00000095
1A0B5FD4:00000001     2     0 10280   1 0x00000002
1A482118:00000002     3     0 10280   1 0x00000003
1A5F8E00:00000003     4     0 10280   1 0x00000004
1A61157A:00000004     5     0 10280   1 0x00000005
1A91B3FA:00000005     6     0 10280   1 0x00000006
1AAADB4D:00000006     7     0 10280   1 0x00000007
1ABC513F:00000007     8     0 10280   1 0x00000008
1ACBF55D:00000008     9     0 10280   1 0x00000009
1AD59F9B:00000009    10     0 10280   1 0x0000000A
1AD6FBC8:0000000A    11     0 10280   1 0x0000000B
1BC16A85:0000000B    12     0 10280   1 0x0000000C

KSTDUMP: End of in-memory trace dump
ssexhd: crashing the process...
Shadow_Core_Dump = partial

God knows what that means.

Any thoughts on the matter. This ones a stumper. I did some searching on the web and one hint was that I may be working with too small a swap space. I only have a machine with 128MB of memory and 256MB of swap space. Is that adequate. I know it's far from optimal, but I only need this db for development purposes so I'm not panicing about performance.

thanks

alan

"Klaus Naumann" <knaumann_at_gmx-ag.de> wrote in message news:vWoM9.4$Nl5.3558_at_news.ecrc.de...
> On Thu, 19 Dec 2002 19:44:45 +0100, alan wrote:
>
> Hi,
>
> > Excellent tip sir!
>
> No problem :-)
>
> > I'm now getting a new error. But it may be just a minor thing. I've
> > not had time to look at it and cross reference against the redhat
> > documentation and such. But I'm getting...
>
> This is a X11 related thing.
>
> > Xlib: connection to "0:0" refused by server. Xlib: Client is not
> > authorized to connect to server. java.lang.NoClassDefFoundError
>
> You need to allow connections from the db host to your
> X11 display.
>
> Do a
>
> xhost +dbhostname
>
> on your X11 System (i.e. in a xterm).
>
> Cu, Klaus
>
>
> --
> Klaus Naumann
> Database Administration
> GMX GmbH
> http://www.aqua-webcam.de/
Received on Thu Dec 19 2002 - 15:48:15 CST