1748255 Members
4037 Online
108760 Solutions
New Discussion юеВ

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 5
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