Re: Problem after my migration from 8.1.7 to 9.2

cschang <cschang_at_maxinter.net> wrote in news:113cklckst66743_at_corp.supernews.com:

> After I upgrade my 8.1.7 to 9.2.0.1 with the oracle upgrade assistant,
> the new instance has problem to start itself. During the upgrading
> there were three steps showing alert messages. First, about the NCHAR
> issue, which is recommended to resolve before continuing the upgrade. I
> chose to continue. Second. the upgrade result showed that I had an
> ora-28003: password verification for the specified password failed.
> ORA-20001: password same as user.. The third. I skip the installation
> of the Enterprise Manager Configuration Assistant because it took too
> long (one days). The problem is that after I rebooted the machine, I
> cannot use the user, which was granted as full resource and dba role in
> old 8.1.7 schema. (not sys user) to login. The error message at
> sqlplus was ORA-01034: “Oracle not available” and ora-27101: “shared
> memory realm does not exist”. And with SYS user connected, it said that
> “connect to an idle instance”. When I used the Oracle enterprise manager
> with user, there was an error pop-up “ The application requires you have
> been granted the SELECT_CATALOG_ROLE….”. I think I understand what
> could cause this. Maybe it was the old 8.1.7 instance still there and
> the startup got confused. But I do not know where I should do to
> resolve it. Do I need to remove the 8.1.7? or copy something from
> 8.1.7 %home_dir% to 9.2 %home_dir%. I thought the Upgrade Assistant
> was supposed to do all those. I have read the chapter 3 and 4 of the
> Oracle Migration document few times, especially the chapter about after
> migration. However nothing mentioned except to upgrade the NCHAR, which
> I did after the upgrade. I have to manually startup the 9.2. instance.
>
> C Chang
>

sqlplus
/ as sysdba
startup
exit Received on Tue Mar 15 2005 - 09:27:09 CST