Home » RDBMS Server » Server Administration » oracle tracing at stop and start (11G on linux )
oracle tracing at stop and start [message #540189] Fri, 20 January 2012 11:03 Go to next message
evoradba
Messages: 144
Registered: April 2005
Location: Canada
Senior Member
Hello
i need to add some kind of tracing in oracle 11g on linux when oracle starts and stops - as at times oracle takes a long time to start, does anyone have any ideas as what to use?
thank you
Maroa

Report message to a moderator

Re: oracle tracing at stop and start [message #540193 is a reply to message #540189] Fri, 20 January 2012 11:07 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
I would first look into the alert logs.

Report message to a moderator

Re: oracle tracing at stop and start [message #540194 is a reply to message #540189] Fri, 20 January 2012 11:07 Go to previous messageGo to next message
Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Just read the alert.log file, it gives you what Oracle does at the datetime of the beginning and end of each step.

Regards
Michel

Report message to a moderator

Re: oracle tracing at stop and start [message #540195 is a reply to message #540189] Fri, 20 January 2012 11:08 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
Why is Oracle being shutdown frequently?

If you don't shutdown Oracle, then it won't be slow starting up again.

Report message to a moderator

Re: oracle tracing at stop and start [message #540198 is a reply to message #540195] Fri, 20 January 2012 11:26 Go to previous messageGo to next message
evoradba
Messages: 144
Registered: April 2005
Location: Canada
Senior Member
we need to shutdown oracle 3 times a day as this instance is used as a way of "replication" we mount and unmount the disks of this instance on different servers and at times oracle takes a longer time to come up the alert logs dont show errors so i was wondering if there are any kinds of tracing we can use in oracle for the stop and start
thank you
Maria

Report message to a moderator

Re: oracle tracing at stop and start [message #540204 is a reply to message #540198] Fri, 20 January 2012 12:25 Go to previous messageGo to next message
Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Maybe you should read once what I posted.

Regards
Michel

Report message to a moderator

Re: oracle tracing at stop and start [message #540213 is a reply to message #540204] Fri, 20 January 2012 14:45 Go to previous messageGo to next message
evoradba
Messages: 144
Registered: April 2005
Location: Canada
Senior Member
thank i read your posting - i know that after oracle is recycled once the next time is much faster coming up etc - however in this case i just need some tracing to see what oracle does when shutdown down and up to help diagnostic a oracle veritas issue
thanks
Maria

Report message to a moderator

Re: oracle tracing at stop and start [message #540214 is a reply to message #540213] Fri, 20 January 2012 14:50 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
It sounds to me you are doing as below

1) shutdown Immediate
2) replacing whole disk volumes (which contain some Oracle DB)
3) STARTUP -- but the DB that is brought online is a totally different instance (whole new SCN range)

The only thing constant is the ORACLE_HOME tree

Best Wishes!

Report message to a moderator

Re: oracle tracing at stop and start [message #540224 is a reply to message #540214] Fri, 20 January 2012 16:46 Go to previous messageGo to next message
evoradba
Messages: 144
Registered: April 2005
Location: Canada
Senior Member
actually something similar to that - we have 2 different servers each has its own oracle instance then a new set of disks which are mounted on either or server these unique set of disks have a unique oracle instance and this is the one that i want the tracing on it
thanks
Maria

Report message to a moderator

Re: oracle tracing at stop and start [message #540235 is a reply to message #540213] Sat, 21 January 2012 01:02 Go to previous message
Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
evoradba wrote on Fri, 20 January 2012 21:45
thank i read your posting - i know that after oracle is recycled once the next time is much faster coming up etc - however in this case i just need some tracing to see what oracle does when shutdown down and up to help diagnostic a oracle veritas issue
thanks
Maria


So you didn't read my post as it does not mention what you say. It was:

Michel Cadot wrote on Fri, 20 January 2012 18:07
Just read the alert.log file, it gives you what Oracle does at the datetime of the beginning and end of each step.

Regards
Michel

Report message to a moderator

Previous Topic: db_link limit access
Next Topic: About dba_sys_privs
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Jan 12 20:35:21 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.