Re: Backups failing
From: Oliver <ofabelo_at_gmail.com>
Date: Wed, 31 Aug 2011 17:01:18 +0100
Message-ID: <CALQkqm8dFqaHPwJXFUsXE3apNLyMj44tScn4hg8c9gikdJAyvA_at_mail.gmail.com>
Uhm when I enter to EM it shows pending status. Suggestions please? I'm "googling"...
El 31/08/2011 13:34, "Oliver" <ofabelo_at_gmail.com> escribió:
> I've fixed it!!!!!!! I can sleep today ... x)
> I've given the next permissions:
>
> grant execute on UTL_FILE to PUBLIC;
> grant execute on DBMS_RANDOM to PUBLIC;
> grant execute on UTL_HTTP to PUBLIC;
> grant execute on UTL_SMTP to PUBLIC;
> grant execute on UTL_TCP to PUBLIC;
>
> The problem was that it can't acces to UTL_SMTP, and a procedure was
> invalid.
> I've created EM now, all ok.
> I'm going to configure backups now ... I hope that it works.
> Thank you very much to the people that has helped me!
> And I'm sorry for my bad english, I'm spanish.
>
> Cheers...
>
> 2011/8/31 Sreejith S Nair <Sreejith.Sreekantan_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*<
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* <http://r1.name/>;
>> > ELSE
>> > EXECUTE IMMEDIATE 'DROP SYNONYM '||r1.owner||'.'||*r1.name*<
http://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* <ofabelo_at_gmail.com>>
>> > To: "Sweetser, Joe" <*JSweetser_at_icat.com* <JSweetser_at_icat.com>>
>> > Cc: Oracle L <*oracle-l_at_freelists.org* <oracle-l_at_freelists.org>>,
>> Sreejith Nair
>> > <*sreejithsna_at_gmail.com* <sreejithsna_at_gmail.com>>
>> > Date: 08/30/2011 10:40 PM
>> > Subject: RE: Backups failing
>> > Sent by: *oracle-l-bounce_at_freelists.org* <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*<
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
>> *<
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*<
sreejithsna_at_gmail.com>
>> ]
>> >> Sent: Tuesday, August 30, 2011 10:42 AM
>> >> To: *ofabelo_at_gmail.com* <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* <ofabelo_at_gmail.com>>
>> >>> To: *sreejithsna_at_gmail.com* <sreejithsna_at_gmail.com>
>> >>> Cc: *JSweetser_at_icat.com* <JSweetser_at_icat.com>, *
oracle-l_at_freelists.org
>> * <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*<
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."
>>
>>
>>
>>
>>
Date: Wed, 31 Aug 2011 17:01:18 +0100
Message-ID: <CALQkqm8dFqaHPwJXFUsXE3apNLyMj44tScn4hg8c9gikdJAyvA_at_mail.gmail.com>
Uhm when I enter to EM it shows pending status. Suggestions please? I'm "googling"...
El 31/08/2011 13:34, "Oliver" <ofabelo_at_gmail.com> escribió:
> I've fixed it!!!!!!! I can sleep today ... x)
> I've given the next permissions:
>
> grant execute on UTL_FILE to PUBLIC;
> grant execute on DBMS_RANDOM to PUBLIC;
> grant execute on UTL_HTTP to PUBLIC;
> grant execute on UTL_SMTP to PUBLIC;
> grant execute on UTL_TCP to PUBLIC;
>
> The problem was that it can't acces to UTL_SMTP, and a procedure was
> invalid.
> I've created EM now, all ok.
> I'm going to configure backups now ... I hope that it works.
> Thank you very much to the people that has helped me!
> And I'm sorry for my bad english, I'm spanish.
>
> Cheers...
>
> 2011/8/31 Sreejith S Nair <Sreejith.Sreekantan_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*<
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* <http://r1.name/>;
>> > ELSE
>> > EXECUTE IMMEDIATE 'DROP SYNONYM '||r1.owner||'.'||*r1.name*<
http://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* <ofabelo_at_gmail.com>>
>> > To: "Sweetser, Joe" <*JSweetser_at_icat.com* <JSweetser_at_icat.com>>
>> > Cc: Oracle L <*oracle-l_at_freelists.org* <oracle-l_at_freelists.org>>,
>> Sreejith Nair
>> > <*sreejithsna_at_gmail.com* <sreejithsna_at_gmail.com>>
>> > Date: 08/30/2011 10:40 PM
>> > Subject: RE: Backups failing
>> > Sent by: *oracle-l-bounce_at_freelists.org* <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*<
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
>> *<
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*<
sreejithsna_at_gmail.com>
>> ]
>> >> Sent: Tuesday, August 30, 2011 10:42 AM
>> >> To: *ofabelo_at_gmail.com* <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* <ofabelo_at_gmail.com>>
>> >>> To: *sreejithsna_at_gmail.com* <sreejithsna_at_gmail.com>
>> >>> Cc: *JSweetser_at_icat.com* <JSweetser_at_icat.com>, *
oracle-l_at_freelists.org
>> * <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*<
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
>>
>> > 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-lReceived on Wed Aug 31 2011 - 11:01:18 CDT