RE: Backups failing

From: Sreejith S Nair <Sreejith.Sreekantan_at_ibsplc.com>
Date: Wed, 31 Aug 2011 15:15:37 +0530
Message-ID: <OF3FA625B4.25E457B7-ON652578FD.0034D6F9-652578FD.00359DAC_at_ibsplc.com>



Yes, you can use this on single instance as well...  
--
Cheers
Sreejith
 



From:   Oliver <ofabelo_at_gmail.com>
To:     Sreejith S Nair <Sreejith.Sreekantan_at_ibsplc.com>
Cc:     "Sweetser, Joe" <JSweetser_at_icat.com>, Sreejith Nair 
<sreejithsna_at_gmail.com>, Oracle L <oracle-l_at_freelists.org>, 
oracle-l-bounce_at_freelists.org
Date:   08/31/2011 12:23 PM
Subject:        RE: Backups failing
Sent by:        oracle-l-bounce_at_freelists.org



I have simple instance, it isn't RAC environment. Is it valid too for me 
configuration? thanks beforehand.
El 31/08/2011 06:18, "Sreejith S Nair" <Sreejith.Sreekantan_at_ibsplc.com> 
escribió:

> Here are the manual steps for dropping emca.
> Please test it yourself before executing this.
>
> 1. stop dbconsole , if running and the following process from
ORACLE_HOME
> (from each node)
>
> $ps -ef | grep console
> $ps -ef| grep emwd
> $ps -ef | grep emagent
> $ps -ef |grep java
>
> 2. set env variables
>
>
> SET ORACLE_HOSTNAME=< Hostname of your machine "
> SET ORACLE_HOME=< Location where your database is installed >
> SET ORACLE_SID=< name of your database "
> SET PATH=%ORACLE_HOME%\bin;%PATH%
>
> 3. Logon SQLPLUS as user SYS or SYSTEM, and drop the sysman account and
> management objects:
>
> a. drop user sysman cascade;
> b. drop role MGMT_USER;
> c. drop user MGMT_VIEW cascade;
> d. drop public synonym MGMT_TARGET_BLACKOUTS;
> e. drop public synonym SETEMVIEWUSERCONTEXT;
>
> f. drop public synonym MGMT_target_blackouts;
> g. drop public synonym mgmt_severity_array;
> h. drop public synonym mgmt_guid_obj;
>
>
> + Verify any left over object owned by SYSMAN
> SQL> SELECT owner,TABLE_NAME, synonym_name name FROM dba_synonyms WHERE
> table_owner = 'SYSMAN';
>
> if yo notice any public synonym or any rows returned by the above query
.
>
> SQL> DECLARE
> CURSOR c1 IS
> SELECT owner, synonym_name name
> FROM dba_synonyms
> WHERE table_owner = 'SYSMAN';
> BEGIN
> FOR r1 IN c1 LOOP
> IF r1.owner = 'PUBLIC' THEN
> EXECUTE IMMEDIATE 'DROP PUBLIC SYNONYM '||r1.name;
> ELSE
> EXECUTE IMMEDIATE 'DROP SYNONYM '||r1.owner||'.'||r1.name;
> END IF;
> END LOOP;
> END;
> /
>
> + move or rename config folders on each node :
>
> $rm -rf $ORACLE_HOME/<HOSTNAME_SID>
> $rm -rf $ORACLE_HOME/oc4j/j2ee/OC4J_DBConsole_<hostname>_<sid>
>
>
> You would replace the values in the <> with the correct values.
>
>
> With Regards,
> Sreejith
>
>
>
>
>
>
> From: Oliver <ofabelo_at_gmail.com>
> To: "Sweetser, Joe" <JSweetser_at_icat.com>
> Cc: Oracle L <oracle-l_at_freelists.org>, Sreejith Nair
> <sreejithsna_at_gmail.com>
> Date: 08/30/2011 10:40 PM
> Subject: RE: Backups failing
> Sent by: oracle-l-bounce_at_freelists.org
>
>
>
> Thanks to all. It hangs,so it didn't enter in quiesce mode.
> Can someone paste me the manual steps for dropping EM manually? thanks
> beforehand.
> El 30/08/2011 17:55, "Sweetser, Joe" <JSweetser_at_icat.com> escribió:
>> I agree with Sreejith but would suggest the quiesce state is a little
> more restrictive than just not accepting new connections. From here:
>
http://download.oracle.com/docs/cd/B28359_01/server.111/b28310/start004.htm
>
>> >> Is this: >> Occasionally you might want to put a database in a state that allows
> only DBA transactions, queries, fetches, or PL/SQL statements. Such a
> state is referred to as a quiesced state, in the sense that no ongoing
> non-DBA transactions, queries, fetches, or PL/SQL statements are running

> in the system.
>> >> But if your emca process is hanging with both drop and recreate, then
> that may not be the issue.
>> >> -joe >> >> -----Original Message----- >> From: Sreejith Nair [mailto:sreejithsna_at_gmail.com] >> Sent: Tuesday, August 30, 2011 10:42 AM >> To: ofabelo_at_gmail.com >> Cc: Sweetser, Joe; Oracle L >> Subject: Re: Backups failing >> >> Quiesce mode means no new connections will be accepted. This is when you
> use emca for dropping. With 11.2 database will not come in quiesce mode
> when dropping em repository and objects.
>> >> However, I am not sure whether dropping em 'manually' will put database
> in quiesce mode for 10g.
>> I have done this ( manual drop ) in 11.2 and database does not go in
> quiesce mode. In my case also. Dropping using emca and Repmanager did
> hang, which is why I went for manual drop.
>> >> Sreejith >> ~Sent from my samsung phone >> >> ------- Original message ------- >>> From: Oliver <ofabelo_at_gmail.com> >>> To: sreejithsna_at_gmail.com >>> Cc: JSweetser_at_icat.com, oracle-l_at_freelists.org >>> Sent: 30/8/'11, 21:36 >>> >>> What is quiesce mode? >>> Can someone paste me the content of that note? thanks. >>> I've executed recreate but it hangs too,so I've executed drop first
> (although it hangs too).
>>> Thanks beforehand. >>> El 30/08/2011 16:18, "Sreejith Nair" <sreejithsna_at_gmail.com> escribió: >> >> >> Confidentiality Note: This message contains information that may be
> confidential and/or privileged. If you are not the intended recipient,
you
> should not use, copy, disclose, distribute or take any action based on
> this message. If you have received this message in error, please advise
> the sender immediately by reply email and delete this message. Although
> ICAT Managers, LLC, Underwriters at Lloyd's, Syndicate 4242, scans
e-mail
> and attachments for viruses, it does not guarantee that either are
> virus-free and accepts no liability for any damage sustained as a result

> of viruses. Thank you.
>
>
>
>
>
>
> DISCLAIMER:
>
> "The information in this e-mail and any attachment is intended only for
> the person to whom it is addressed and may contain confidential and/or
> privileged material. If you have received this e-mail in error, kindly
> contact the sender and destroy all copies of the original communication.

> IBS makes no warranty, express or implied, nor guarantees the accuracy,
> adequacy or completeness of the information contained in this email or
any
> attachment and is not liable for any errors, defects, omissions, viruses

> or for resultant loss or damage, if any, direct or indirect."
>
>
>
>
DISCLAIMER: "The information in this e-mail and any attachment is intended only for the person to whom it is addressed and may contain confidential and/or privileged material. If you have received this e-mail in error, kindly contact the sender and destroy all copies of the original communication. IBS makes no warranty, express or implied, nor guarantees the accuracy, adequacy or completeness of the information contained in this email or any attachment and is not liable for any errors, defects, omissions, viruses or for resultant loss or damage, if any, direct or indirect." -- http://www.freelists.org/webpage/oracle-l
Received on Wed Aug 31 2011 - 04:45:37 CDT

Original text of this message