RE: Backups failing

From: Sreejith S Nair <Sreejith.Sreekantan_at_ibsplc.com>
Date: Wed, 31 Aug 2011 10:48:14 +0530
Message-ID: <OF33220C31.098358A0-ON652578FD.0015D241-652578FD.001D22C8_at_ibsplc.com>

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:

1. drop user sysman cascade;
2. drop role MGMT_USER;
3. drop user MGMT_VIEW cascade;
4. drop public synonym MGMT_TARGET_BLACKOUTS;
5. drop public synonym SETEMVIEWUSERCONTEXT;
6. drop public synonym MGMT_target_blackouts;
7. drop public synonym mgmt_severity_array;
8. 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."

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Aug 31 2011 - 00:18:14 CDT