Re: Backups failing

From: Oliver <ofabelo_at_gmail.com>
Date: Wed, 31 Aug 2011 13:34:00 +0100
Message-ID: <CALQkqm-K-X0cjd8G4uMNgNJLF1nOBKqJLwYVyAAuUv=un_OUvw_at_mail.gmail.com>

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."
>
>
>
>
>

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

Received on Wed Aug 31 2011 - 07:34:00 CDT