Big problem with 8 to 8i upgrade -- please help

From: Erik Diehn <erikd_at_nospamm.cometsystems.com>
Date: Thu, 14 Oct 1999 17:59:42 -0400
Message-ID: <3806524E.D4CA82E1@nospamm.cometsystems.com>

If anyone out there can understand the following, I'd greatly appreciate your input.

I just upgraded from Oracle 8 to Oracle 8iEE on Linux. I couldn't get the migration assistant to start, so I'm trying to do the final part of the upgrade (modifying my existing instance) by hand.

1.) I can't get the 8.1 listener to start. No matter what I do, lsnrctl returns a "permission denied" error.

2.) When I connect to the server manager and try to do a "startup restrict" (or any startup, for that matter), I get:

ORACLE instance started.

Total System Global Area                          5053840 bytes
Fixed Size                                          64912 bytes
Variable Size                                     4505600 bytes
Database Buffers                                   409600 bytes
Redo Buffers                                        73728 bytes

ORA-03113: end-of-file on communication channel

after which the db bombs out.

Does anyone have *any* idea what could be going wrong? Why would I be getting these ORA-03113 errors? The 8.0 listener is running, and I've included a trace from one of my server manager connection attempts below.

Anyone with any help, please reply to this group or directly to me by e-mail.

Thanks,
Erik Diehn
erikd_at_nospamm.cometsystems.com - nospamm  

nsopen: opening transport...
nttcnp: Validnode Table IN use; err 0x0
nttcnp: getting sockname
nttcnr: waiting to accept a connection.

nttvlser: valid node check on incoming node 127.0.0.1 nttvlser: Accepted Entry: 127.0.0.1
nsopen: transport is open
nsnainit: inf->nsinfflg[0]: 0xd inf->nsinfflg[1]: 0xd nsopen: global context check-in (to slot 5) complete nsanswer: deferring connect attempt; at stage 2 nsevdansw: exit
nsevdansw: exit

nscon: doing connect handshake...
nscon: got NSPTCN packet
nscon: recving connect data

nsdo: 1197 bytes from NS buffer

nsevdansw: exit
nsevdansw: exit
nsevdansw: exit
nscon: sending NSPTAC packet

nscon: doing connect handshake...
nscon: nsctxinf[0]=0xd, [1]=0x9
nsconbrok: asking transport to enable NTOBROKEN tnslsnr: connect string inst->lcxd[0]:
(ADDRESS=(PROTOCOL=ipc)(DEV=6)(KEY=ynet))
tnslsnr: connect string inst->lcxd[1]:
(ADDRESS=(PROTOCOL=ipc)(DEV=10)(KEY=PNPKEY))
tnslsnr: connect string inst->lcxd[2]:
(ADDRESS=(PROTOCOL=tcp)(DEV=11)(HOST=209.83.171.238)(PORT=1521))
ntt2err: Read unexpected EOF ERROR on 12 nsprecv: transport read error
nsevdansw: exit

nsprecv: header checksum error
nsprecv: bad packet header (plen=0x2844)
nserror: nsres: id=5, op=68, ns=12592, ns2=0; nt[0]=0, nt[1]=0, nt[2]=0

nstimarmed: no timer allocated

nsclose: closing transport
nsclose: global context check-out (from slot 5) complete
tnslsnr: Deallocating cxd 0x83691c8.

Received on Thu Oct 14 1999 - 16:59:42 CDT