From oracle-l-bounce@freelists.org Fri Apr 15 15:20:17 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j3FKKHLu017040 for ; Fri, 15 Apr 2005 15:20:17 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j3FKKFem017031 for ; Fri, 15 Apr 2005 15:20:15 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 6CAB218408A; Fri, 15 Apr 2005 14:15:06 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 10203-09; Fri, 15 Apr 2005 14:15:06 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id DAA03184088; Fri, 15 Apr 2005 14:15:05 -0500 (EST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=YkTcHz3ChZ3Yu6KKi2kAe6jbletvPSv/lwZNEkZyBvjcDdjSjsRLonTakwrJnyBziwwNckZ0iSPazXPyvslqSh0skTyxTwYPWUV6UojQkJ9VQdO7tsszj5LMhoV6NOO72Zc38k30NgypX5jfH7/P6b2ZWDEYj3azXdurV08Dg6Q= Message-ID: Date: Fri, 15 Apr 2005 15:13:10 -0400 From: mhthomas To: Paul Drake Subject: Re: RMAN via EM nowork after 10.1.0.4 patch applied Cc: "Oracle-L (oracle-l@freelists.org)" In-Reply-To: <910046b40504151151273fe846@mail.gmail.com> Mime-Version: 1.0 Content-type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit Content-Disposition: inline References: <910046b40504151151273fe846@mail.gmail.com> X-archive-position: 18499 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: qnxodba@gmail.com Precedence: normal Reply-To: qnxodba@gmail.com X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-Spam-Checker-Version: SpamAssassin 2.60 (1.212-2003-09-23-exp) on air891.startdedicated.com X-Spam-Status: No, hits=0.1 required=5.0 tests=AWL autolearn=ham version=2.60 X-Spam-Level: Good point. I don't often use templates. In this case I dbca created an entirely new database, and adjusted the parameters as needed. Do I need to run catpatch on a new dbca database created from scratch after 10.1.0.4 s/w patch? I hope not, because the new 10.1.0.4 db (created from scratch) has got 0 invalid objects and its looking good already. :-) I'm running impdp API for datapump (requires 10.1.0.4) with an 'exclude schema' option. There is actually an 'exclude' command in impdp command line, but no 'exclude' in API metadata_filter, rather you can only 'NOT IN ('schema'...)' with same effect. The problem was EM directory left under db_1 home after 10.1.0.3->10.1.0.4 patch with same name as new dbca database. Hosed my setup. I dropped the EM directory, dropped new database files from ASM and OS, and created again from scratch. Its working now and we closed the TAR. However, the EM analyst said I still needed to run the following on my new dbca database created /after/ 10.1.0.4 patch: -- Note: 10.1.0.4 Patch (only) has a few extra EM steps regarding TZ. These steps are required after new dbca install, as suggested by OEM analyst from Oracle in followup to our TAR 4394490.995. -- TZ=3DEST5EDT; export TZ $ORACLE_HOME/bin/emctl stop dbconsole {already shutdown?, check} $ORACLE_HOME/bin/emctl resetTZ agent -- sqlplus SYSMAN/sysman_password exec mgmt_target.set_agent_tzrgn('pilot.calgb:1830','EST5EDT') commit; exit -- emctl start dbconsole -- Thanks, pd.=20 Regards, Mike Thomas On 4/15/05, Paul Drake wrote: > On 4/14/05, mhthomas wrote: > > Hi all, > > > > Installed 10.1.0.3 S/W for 10g Standard Edition, RAC/ASM. > > Installed 10.1.0.4 patchset. > > Created new dbca database, started dbconsole, attempted backup to > > either disk or tape, same problem, backup job fails to submit in EM: > > > > The job submission has failed for the following reason=3D20 > > ORA-20900: Could not find credential set DBHostCreds for=3D20 > > target type rac_database ORA-06512: at "SYSMAN.MGMT_CREDENTIAL",=3D20 > > line 688 ORA-06512: at "SYSMAN.MGMT_CREDENTIAL", line 1351=3D20 > > ORA-06512: at "SYSMAN.MGMT_JOBS", line 285 ORA-06512:=3D20 > > at "SYSMAN.MGMT_JOBS", line 78 ORA-06512: at line 1 =3D20 > > > > Has anyone seen this yet? I opened a TAR, but its not good to get this > > basic sort of problem when creating a new database after a major > > patchset (in my opinion). > > > > Any help appreciated. :-) > > > > Regards, > > > > Mike Thomas >=20 > Mike, >=20 > Did you use the datafiles included in a template (.dfj) or did you > choose to create the datafiles from scratch? > If you used datafiles from a template, you need to run catpatch > against it after it has been created. > You probably already did that, but just in case. > The view DBA_REGISTRY may provide further info. >=20 > hth. >=20 > Paul > -- http://www.freelists.org/webpage/oracle-l