Simpler Navigation for Servers and Operating Systems - Please Update Your Bookmarks
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
If you have bookmarked forums or discussion boards in Servers and Operating Systems, we suggest you check and update them as needed.
cancel
Showing results for 
Search instead for 
Did you mean: 

trace on Oracle 8.1.6

SOLVED
Go to solution
Vogra
Regular Advisor

trace on Oracle 8.1.6

Hi All,
we cloned production db on lab box. After start we noted that file system of db engine is full. We detected that are trace files on $ORACLE_HOME/network/trace, but in production box are not. What about?
Thanx,
Lima.
We are spirits in the material world
5 REPLIES
Robert-Jan Goossens
Honored Contributor
Solution

Re: trace on Oracle 8.1.6

Hi Lima,

Take a look at next link, it discribes using the parameters in the oracle profile.

http://www.oracledbaexpert.com/oracle/net8Profiling.html

Hope it helps,

Robert-Jan.
Yogeeraj_1
Honored Contributor

Re: trace on Oracle 8.1.6

hi

seems like trace is enabled at INSTANCE level or you are having errors on your database - see your alert.log

hope this helps

regards
Yogeeraj
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
Brian Crabtree
Honored Contributor

Re: trace on Oracle 8.1.6

Most likely, you have tracing turned on in your listener.ora. You can check into this by running the "lsnrctl status" command, which should display all of the information.

Your listener.ora will most likely be in /etc or $ORACLE_HOME/network/admin, and you should see something like "TRACE_LEVEL_LISTENER=". You can change this to "OFF". Once this is done, you need to restart the listener (lsnrctl stop/start or reload) for it to take effect.

If you dont see it in there, look in the sqlnet.ora file (same directories), and see if you have a process trace setup. Just remove this line, and it will be removed dynamiclly for all new processes.

If you are still getting this and the above doesn't work, please post your listener.ora and sqlnet.ora, and describe whether you have a large number of files in $ORACLE_HOME/network/trace or a single file, and what the format of the names are.

Thanks,

Brian
T G Manikandan
Honored Contributor

Re: trace on Oracle 8.1.6

You should have the network tracing enabled on in the $ORACLE_HOME/network/admin/listener.ora file.

Disable them and restart the listener.



Thanks
T G Manikandan
Honored Contributor

Re: trace on Oracle 8.1.6

Also you will need to check up the $ORACLE_HOME/network/admin/sqlnet.ora file

for the value of

TRACE_DIRECTORY

If that points there remove it from there.


Thanks