Simpler Navigation for Servers and Operating Systems
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
General
cancel
Showing results for 
Search instead for 
Did you mean: 

error when upgrade oracle from 8.0.6 to 8.1.7

gefei_1
Frequent Advisor

error when upgrade oracle from 8.0.6 to 8.1.7

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?
sophie
6 REPLIES
Yogeeraj_1
Honored Contributor

Re: error when upgrade oracle from 8.0.6 to 8.1.7

hi

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

revert.

regards
Yogeeraj
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
Steve Steel
Honored Contributor

Re: error when upgrade oracle from 8.0.6 to 8.1.7

Hi

I woulkd advise you to ask Oracle.

see

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


Steve Steel
If you want truly to understand something, try to change it. (Kurt Lewin)
gefei_1
Frequent Advisor

Re: error when upgrade oracle from 8.0.6 to 8.1.7

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?
sophie
Brian Crabtree
Honored Contributor

Re: error when upgrade oracle from 8.0.6 to 8.1.7

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
Exalted Contributor

Re: error when upgrade oracle from 8.0.6 to 8.1.7

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
Steven E Protter
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
T G Manikandan
Honored Contributor

Re: error when upgrade oracle from 8.0.6 to 8.1.7

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.