upgrade Oracle 8.0.5 to 8.1.7 on NT. Registries problem.

[mingichu]

Hi! All expert,

Our current Oracle DB is 8.0.5 on NT, and we are trying to install 8.1.7 enterprise edition to upgrade without uninstalling the current 8.0.5.
Firstly, the installation hung during coping REFCUR.VBP. We got some advise to replace oleaut32.dll from version 2.40.4518 with 2.40.4277, then the installation went well and completed.
Then, we manually update registries (Shouldn't the installation take care of the registries??). But only half of the registries can be mapped and the other half are new registries. The 8.1.7 can not be brought up now. How should we solve it? Do we have to have a fresh install by uninstalling 8.0.5 first? Please advise.
Thanks in advance.

 

[mingichu]

Hi! All experts,

I just checked the listener.log in the new directory. It shows the old sid in service_name:
(CONNECT_DATA=(SERVICE_NAME=OldSid)(CID=(PROGRAM=D:\OracleNew\bin\sqlplus.exe)(HOST=Host)(USER=User))) * (ADDRESS=(PROTOCOL=tcp)(HOST=n.n.n.n)(PORT=2790)) * establish * OldName * 12514

I found Listner.ora. We have both new and old DB info in GLOBAL_DBNAME and SID_NAME, but the same ORACLE_HOME:
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = NewOrac)
(ORACLE_HOME = D:\OracleNew)
(SID_NAME = NewOrac)
)
(SID_DESC =
(GLOBAL_DBNAME = OldOrac)
(ORACLE_HOME = D:\OracleNew)
(SID_NAME = OldSid)
)
)

Is it the reason which caused the problem?
Thanks again!