Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Problem after my migration from 8.1.7 to 9.2

Re: Problem after my migration from 8.1.7 to 9.2

From: Thierry PLASSART <thierry.plassart_at_wanadoo.fr>
Date: Tue, 15 Mar 2005 21:22:34 +0100
Message-ID: <423743ea$0$1209$8fcfb975@news.wanadoo.fr>


Hi,

there's an other point regarding accounts: assuming we have an account in 8.1.7 with connect and resource grants and 'select any table', you'll have to add in 9.2 the 'select any dictionnary'. That should be usefull for querying sys tables (to have execution plans...)

T PLASSART "cschang" <cschang_at_maxinter.net> a écrit dans le message de 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
Received on Tue Mar 15 2005 - 14:22:34 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US