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
Received on Mon Mar 14 2005 - 21:12:37 CST
