 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussion Groups Database Servers DB2InformixIngresMS SQLOraclePervasive.SQLPostgreSQLProgressSybaseDesktop Databases FileMakerFoxProMS AccessParadoxGeneral General DB TopicsDatabase TheoryRelated Topics Java Development.NET DevelopmentVB DevelopmentMore Topics ... |
Database Forum / Oracle / Oracle Server / May 2005cannot get trace file
HPUX 11i v2 (11.23) Oracle 9.2.0.6.0 (RAC) The problem is when we do: 1 - alter session set sql_trace=true; 2 - run a select statement 3 - alter session set sql_trace=false; we don't get a trace file produced. We checked in user dump, background dump directories but didn't see anything. Do you know? regards Daud > HPUX 11i v2 (11.23) > Oracle 9.2.0.6.0 (RAC) [quoted text clipped - 10 lines] > regards > Daud Filesystem full ? Have you done a search for *.trc files ? Looking on the correct server ? The filesystem is definitely not full. Have done a search for *.trc but did not find it. regards, Daud Oracle Server will store the file in path specified in BACKGROUND_DUMP_DEST. Make sure write access to that path. Check for server log whether it has throwed some error.. Correct me if i am wrong. Cheers, Thiru. WantedToBeDBA WantedToBeDBA {at} gmail {dot} com Sorry i missed something in previous post. If BACKGROUND_DUMP_DEST is not specified, the trace file will be stored in $ORACLE_HOME/admin/db_name/bdump (if Unix) %ORACLE_HOME%\admin\db_name\bdump (if windows) Correct me if i am wrong. Cheers, Thiru. WantedToBeDBA WantedToBeDBA {at} gmail {dot} com > Sorry i missed something in previous post. If BACKGROUND_DUMP_DEST > is not specified, the trace file will be stored in [quoted text clipped - 6 lines] > WantedToBeDBA > WantedToBeDBA {at} gmail {dot} com you are wrong, it will be user_dump_dest to the OP, you are you using RAC - sure you are on the right server? > > Sorry i missed something in previous post. If BACKGROUND_DUMP_DEST > > is not specified, the trace file will be stored in [quoted text clipped - 8 lines] > > you are wrong, it will be user_dump_dest Even if the session is running through a shared server connection? Xho > to the OP, you are you using RAC - sure you are on the right server?  Signature-------------------- http://NewsReader.Com/ -------------------- Usenet Newsgroup Service $9.95/Month 30GB No.. It will be stored in BACKGROUND_DUMP_DEST only for RAC. Check doc http://www.stanford.edu/dept/itss/docs/oracle/9i/rac.920/a96596/appa.htm Cheers, Thiru. WantedToBeDBA WantedToBeDBA {at} gmail {dot} com > No.. It will be stored in BACKGROUND_DUMP_DEST only for RAC. Check doc > [quoted text clipped - 4 lines] > WantedToBeDBA > WantedToBeDBA {at} gmail {dot} com try reading it again or *gasp* even trying it. User errors will go in user_dump_dest as they are user errors or traces try it before you come back again I so sorry for providing the wrong infomation. BACKGROUND_DUMP_DEST is correct. :( Thiru. > The filesystem is definitely not full. Have done a search for *.trc but > did not find it. > > regards, > Daud hi check the value for user and background dump_dest in v$parmeter, just in case. regards tim l > HPUX 11i v2 (11.23) > Oracle 9.2.0.6.0 (RAC) [quoted text clipped - 10 lines] > regards > Daud Given that this is RAC ... how are you determining which instance had the session? The instance with the session determines the server. Then follow the init parameter to the file. SignatureDaniel A. Morgan http://www.psoug.org damorgan@x.washington.edu (replace x with u to respond) Have checked the parameters .. have checked the directories permission on both servers. Have also checked both servers for the trace files. Still not getting it. Will try again today. > HPUX 11i v2 (11.23) > Oracle 9.2.0.6.0 (RAC) [quoted text clipped - 10 lines] > regards > Daud What happens if this user does NOT have "ALTER SESSION" priv GRANTed to it? > > HPUX 11i v2 (11.23) > > Oracle 9.2.0.6.0 (RAC) [quoted text clipped - 12 lines] > > What happens if this user does NOT have "ALTER SESSION" priv GRANTed to it? Then you won't even get past "alter session..." without getting ORA-01031. Regards /Rauf |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2010 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.