error when upgrade oracle from 8.0.6 to 8.1.7

[gefei_1]

I have originally installed oracle 8.0.6 for hpux(32bit). Then I try to upgrade oracle to version 8.1.7(64bit). I have installed the oracle 8.1.7 software successfully. But when I execute 'oracle migration tool' odma, I am told 'tns: lost contact'. I find during the upgration, database processes are running at first, but after a while, they are stopped. I doubt if the error 'tns: lost contact' has some relation to the status of database processes. Could anyone help to explain what is the problem?

[Yogeeraj_1]

hi

did you set your ORACLE_HOME and ORACLE_SID before starting the upgrade?

revert.

regards
Yogeeraj

[Steve Steel]

Hi

I woulkd advise you to ask Oracle.

see

http://forums.itrc.hp.com/cm/QuestionAnswer/1,,0x9bccd06ed8c8d4118fef0090279cd0f9,00.html


Steve Steel

[gefei_1]

I have tried the method suggested by Steve to install PHSS_22478. But the error still occurs. Then I find in the sqlnet.log file, says:
Fatal NI connect error 12547, connecting to:
(DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/u01_sd/home/dba/oracle/product/8.
1.7/bin/oracle)(ARGV0=oraclesd2)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCO
L=beq)))')(DETACH=NO))(CONNECT_DATA=(CID=(PROGRAM=)(HOST=uxbfmc01)(USER=oracle))
))

VERSION INFORMATION:
TNS for HPUX: Version 8.1.7.0.0 - Development
Oracle Bequeath NT Protocol Adapter for HPUX: Version 8.1.7.0.0 - Develo
pment
Time: 11-MAR-2003 20:50:44
Tracing not turned on.
Tns error struct:
nr err code: 0
ns main err code: 12547
TNS-12547: TNS:lost contact
ns secondary err code: 12560
nt main err code: 517
TNS-00517: Lost contact
nt secondary err code: 32
nt OS err code: 0

Do I need to change the ORACLE parameters before upgrade? Does anyone have some other suggestion?

[Brian Crabtree]

1. Just to make sure, you installed the binaries into two separate Oracle homes, correct?

2. Verify that the listener is running correctly, and that your listener.ora is correct. I would suggest placing the listener.ora and tnsnames.ora into /etc, as this is on the default search path.

3. Configure your enviroment to the 8.1.7 binaries, and run:
- tnsping
where is the Oracle SID you are trying to connect to.

4. If this fails, look for a "DEFAULT_DOMAIN" entry in $ORACLE_HOME/network/admin/sqlnet.ora. Unless you have configured this in 8.0.6, remove this line, and try again.

If this still isn't working, post back with your sqlnet.ora, listener.ora, and tnsnames.ora (I would suggest replacing hostnames, and only listing the one SID you are trying to connect to with the tnsnames.ora).

Brian

[Steven E. Protter]

This could be because you haven't followed the 32 bit to 64 bit oracle migration process.

Attached is a doc.

Though this looks like maybe tnsnames.ora issues. Post the results of tnsping for your instances, with the different ORACLE_SID and ORACLE_HOME values.


SEP

[T G Manikandan]

make sure that the listener.ora and tnsnames.ora files are present in the current 8.1.7 $ORACLE_HOME/network/admin.

Also check your variables
$ORACLE_HOME
$ORACLE_HOME/bin
are set to the latest version.