Re: Relinking during Oracle install

From: Howard N. Moran <hmoran_at_relay.nswc.navy.mil>
Date: 1995/04/24
Message-ID: <1995Apr24.153123.27143_at_relay.nswc.navy.mil>#1/1


In article <cwhitak.54.00FBB853_at_relay.nswc.navy.mil>, cwhitak_at_relay.nswc.navy.mi l (Cecil Whitaker) says:
>
>Does anyone else choose to relink the Oracle executables when
>installing Oracle for the first time? We just installed Oracle
>7.1.4 on our CDC 4680 machines and are having trouble
>(segmentation fault when executed) with the exp executable that
>was created when the relinking was done. Oracle has been no
>help so far. Anyone with any ideas or hints please email.
>

I work with Cecil and here is some more on the problems we are encountering trying to upgrade a CDC 4680 under EP/IX 2.2.1AC to oracle 7.1.4.

We installed the upgrade and the only problem we know we encountered was that 'exp' would immediately 'segment fault' and core dump when invoked. After conferring with support (CDC/Oracle) the relink with the async net driver was done. Everything seemed fine. 'exp' would at least execute.

THEN...one of the dba team was tinkering with db links and when he tried 'select * from sys.dba_db_links;' got dropped back to unix (he was doing this on the cdc server itself). Further tinkering revealed the following

  1. sqlplus on the upgraded server to the local db
    • any 'select...' attempting to return a date drops out to unix without a data return
    • other datatypes (varchar2, number, long) return fine
    • 'select sysdate from dual;' drops to unix
  2. sqlplus on the upgraded server to a remote 7.0.12 db
    • works ok
  3. sqlplus on a sun client to the upgraded server
    • as in bullet 1 but we get a message about an eof on the comm line and we remain in sqlplus but disconnected from oracle (running this sqlplus against the 7.0.12 db is fine)
  4. runform30 on the sun client against the upgraded server using a form returning dates
    • works fine, returns dates from referenced rows and sysdate (remember, the form is done using sql 'select...'s)
  5. running 'exp' on the upgraded server against the local db to export a tables with dates
    • works fine - creates expdat.dmp which 'imp' can show (didn't try an actual import back into any db)
  6. sqlplus on the server running 7.0.12 (and an older o/s) against the upgraded server
    • see bullet 1 (works fine otherwise)

While we are waiting for support, does anyone out there have any ideas as to why (1) 'exp' failed before relinking with the async, (2) 'exp' relinked with resync works, (3) what our current problem(s) stem from (the resync driver? catch-22), (4) was (1) a symptom or was 'exp' alone in trouble, (5) etc etc

Desperately,
H N Moran
hmoran_at_relay.nswc.navy.mil Received on Mon Apr 24 1995 - 00:00:00 CEST

Original text of this message