 | |
SQLnet logging/tracing
comp.databases.oracle.misc comp.databases.oracle.misc
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
SQLnet logging/tracing -
05-12-2008
, 11:20 AM
#2
| |||
| |||
|
|
Hello, Need some quick help... I have an XP-machine with Oracle 10g, both EE and XE installed as standard "starter databases" with the Installers. Now I wanted to turn on sql-net tracing/logging, so I created two directories C:\oracle\log and C:\oraclexe\log and added the lines below to %ORACLE_HOME%\NETWORK\ADMIN\sqlnet.ora on both installations. LOG_DIRECTORY_CLIENT=c:\oracle\log\ LOG_FILE_CLIENT=client_log TRACE_DIRECTORY_CLIENT=c:\oracle\log\ TRACE_FILE_CLIENT=client_trace TRACE_FILELEN_CLIENT=10000 TRACE_FILENO_CLIENT=5 TRACE_LEVEL_CLIENT=16 TRACE_TIMESTAMP_CLIENT=TRUE TRACE_UNIQUE_CLIENT=TRUE I have rebooted my machine, and ran some SQL-commands from TOAD and the web-interfaces, but nothing ends up in this directory, it is still empty. I am obviously missing something trivial? What else do I need to do? TIA, ------------------------ grz01 |
machine where TOAD is installed and the machine where the web-based
application runs? I expect not.
David Fitzjarrell
#3
| |||
| |||
|
|
Hello, Need some quick help... I have an XP-machine with Oracle 10g, both EE and XE installed as standard "starter databases" with the Installers. Now I wanted to turn on sql-net tracing/logging, so I created two directories C:\oracle\log and C:\oraclexe\log and added the lines below to %ORACLE_HOME%\NETWORK\ADMIN\sqlnet.ora on both installations. LOG_DIRECTORY_CLIENT=c:\oracle\log\ LOG_FILE_CLIENT=client_log TRACE_DIRECTORY_CLIENT=c:\oracle\log\ TRACE_FILE_CLIENT=client_trace TRACE_FILELEN_CLIENT=10000 TRACE_FILENO_CLIENT=5 TRACE_LEVEL_CLIENT=16 TRACE_TIMESTAMP_CLIENT=TRUE TRACE_UNIQUE_CLIENT=TRUE I have rebooted my machine, and ran some SQL-commands from TOAD and the web-interfaces, but nothing ends up in this directory, it is still empty. I am obviously missing something trivial? What else do I need to do? TIA, ------------------------ grz01 |
machine where TOAD is installed and the machine where the web-based
application runs? I expect not.
David Fitzjarrell
#4
| |||
| |||
|
|
Hello, Need some quick help... I have an XP-machine with Oracle 10g, both EE and XE installed as standard "starter databases" with the Installers. Now I wanted to turn on sql-net tracing/logging, so I created two directories C:\oracle\log and C:\oraclexe\log and added the lines below to %ORACLE_HOME%\NETWORK\ADMIN\sqlnet.ora on both installations. LOG_DIRECTORY_CLIENT=c:\oracle\log\ LOG_FILE_CLIENT=client_log TRACE_DIRECTORY_CLIENT=c:\oracle\log\ TRACE_FILE_CLIENT=client_trace TRACE_FILELEN_CLIENT=10000 TRACE_FILENO_CLIENT=5 TRACE_LEVEL_CLIENT=16 TRACE_TIMESTAMP_CLIENT=TRUE TRACE_UNIQUE_CLIENT=TRUE I have rebooted my machine, and ran some SQL-commands from TOAD and the web-interfaces, but nothing ends up in this directory, it is still empty. I am obviously missing something trivial? What else do I need to do? TIA, ------------------------ grz01 |
machine where TOAD is installed and the machine where the web-based
application runs? I expect not.
David Fitzjarrell
#5
| |||
| |||
|
|
Hello, Need some quick help... I have an XP-machine with Oracle 10g, both EE and XE installed as standard "starter databases" with the Installers. Now I wanted to turn on sql-net tracing/logging, so I created two directories C:\oracle\log and C:\oraclexe\log and added the lines below to %ORACLE_HOME%\NETWORK\ADMIN\sqlnet.ora on both installations. LOG_DIRECTORY_CLIENT=c:\oracle\log\ LOG_FILE_CLIENT=client_log TRACE_DIRECTORY_CLIENT=c:\oracle\log\ TRACE_FILE_CLIENT=client_trace TRACE_FILELEN_CLIENT=10000 TRACE_FILENO_CLIENT=5 TRACE_LEVEL_CLIENT=16 TRACE_TIMESTAMP_CLIENT=TRUE TRACE_UNIQUE_CLIENT=TRUE I have rebooted my machine, and ran some SQL-commands from TOAD and the web-interfaces, but nothing ends up in this directory, it is still empty. I am obviously missing something trivial? What else do I need to do? TIA, ------------------------ grz01 |
machine where TOAD is installed and the machine where the web-based
application runs? I expect not.
David Fitzjarrell
#6
| |||
| |||
|
|
On May 12, 11:20 am,grz01<gr... (AT) spray (DOT) se> wrote: Hello, Need some quick help... I have an XP-machine with Oracle 10g, both EE and XE installed as standard "starter databases" with the Installers. Now I wanted to turn on sql-net tracing/logging, so I created two directories C:\oracle\log and C:\oraclexe\log and added the lines below to %ORACLE_HOME%\NETWORK\ADMIN\sqlnet.ora on both installations. LOG_DIRECTORY_CLIENT=c:\oracle\log\ LOG_FILE_CLIENT=client_log TRACE_DIRECTORY_CLIENT=c:\oracle\log\ TRACE_FILE_CLIENT=client_trace TRACE_FILELEN_CLIENT=10000 TRACE_FILENO_CLIENT=5 TRACE_LEVEL_CLIENT=16 TRACE_TIMESTAMP_CLIENT=TRUE TRACE_UNIQUE_CLIENT=TRUE I have rebooted my machine, and ran some SQL-commands from TOAD and the web-interfaces, but nothing ends up in this directory, it is still empty. I am obviously missing something trivial? What else do I need to do? TIA, ------------------------grz01 Did you also apply these changes to the sqlnet.ora files on the machine where TOAD is installed and the machine where the web-based application runs? I expect not. David Fitzjarrell |
Hi David,
I am just running local, so host and client is same machine.
Both TOAD and webinterface
(XE using using http://127.0.0.1:8080/apex,
and EE using http://machinename:1158/em)
requires the TNSListener running,
so I guess sqlnet should still see the traffic...?
/grz01
#7
| |||
| |||
|
|
On May 12, 11:20 am,grz01<gr... (AT) spray (DOT) se> wrote: Hello, Need some quick help... I have an XP-machine with Oracle 10g, both EE and XE installed as standard "starter databases" with the Installers. Now I wanted to turn on sql-net tracing/logging, so I created two directories C:\oracle\log and C:\oraclexe\log and added the lines below to %ORACLE_HOME%\NETWORK\ADMIN\sqlnet.ora on both installations. LOG_DIRECTORY_CLIENT=c:\oracle\log\ LOG_FILE_CLIENT=client_log TRACE_DIRECTORY_CLIENT=c:\oracle\log\ TRACE_FILE_CLIENT=client_trace TRACE_FILELEN_CLIENT=10000 TRACE_FILENO_CLIENT=5 TRACE_LEVEL_CLIENT=16 TRACE_TIMESTAMP_CLIENT=TRUE TRACE_UNIQUE_CLIENT=TRUE I have rebooted my machine, and ran some SQL-commands from TOAD and the web-interfaces, but nothing ends up in this directory, it is still empty. I am obviously missing something trivial? What else do I need to do? TIA, ------------------------grz01 Did you also apply these changes to the sqlnet.ora files on the machine where TOAD is installed and the machine where the web-based application runs? I expect not. David Fitzjarrell |
Hi David,
I am just running local, so host and client is same machine.
Both TOAD and webinterface
(XE using using http://127.0.0.1:8080/apex,
and EE using http://machinename:1158/em)
requires the TNSListener running,
so I guess sqlnet should still see the traffic...?
/grz01
#8
| |||
| |||
|
|
On May 12, 11:20 am,grz01<gr... (AT) spray (DOT) se> wrote: Hello, Need some quick help... I have an XP-machine with Oracle 10g, both EE and XE installed as standard "starter databases" with the Installers. Now I wanted to turn on sql-net tracing/logging, so I created two directories C:\oracle\log and C:\oraclexe\log and added the lines below to %ORACLE_HOME%\NETWORK\ADMIN\sqlnet.ora on both installations. LOG_DIRECTORY_CLIENT=c:\oracle\log\ LOG_FILE_CLIENT=client_log TRACE_DIRECTORY_CLIENT=c:\oracle\log\ TRACE_FILE_CLIENT=client_trace TRACE_FILELEN_CLIENT=10000 TRACE_FILENO_CLIENT=5 TRACE_LEVEL_CLIENT=16 TRACE_TIMESTAMP_CLIENT=TRUE TRACE_UNIQUE_CLIENT=TRUE I have rebooted my machine, and ran some SQL-commands from TOAD and the web-interfaces, but nothing ends up in this directory, it is still empty. I am obviously missing something trivial? What else do I need to do? TIA, ------------------------grz01 Did you also apply these changes to the sqlnet.ora files on the machine where TOAD is installed and the machine where the web-based application runs? I expect not. David Fitzjarrell |
Hi David,
I am just running local, so host and client is same machine.
Both TOAD and webinterface
(XE using using http://127.0.0.1:8080/apex,
and EE using http://machinename:1158/em)
requires the TNSListener running,
so I guess sqlnet should still see the traffic...?
/grz01
#9
| |||
| |||
|
|
On May 12, 11:20 am,grz01<gr... (AT) spray (DOT) se> wrote: Hello, Need some quick help... I have an XP-machine with Oracle 10g, both EE and XE installed as standard "starter databases" with the Installers. Now I wanted to turn on sql-net tracing/logging, so I created two directories C:\oracle\log and C:\oraclexe\log and added the lines below to %ORACLE_HOME%\NETWORK\ADMIN\sqlnet.ora on both installations. LOG_DIRECTORY_CLIENT=c:\oracle\log\ LOG_FILE_CLIENT=client_log TRACE_DIRECTORY_CLIENT=c:\oracle\log\ TRACE_FILE_CLIENT=client_trace TRACE_FILELEN_CLIENT=10000 TRACE_FILENO_CLIENT=5 TRACE_LEVEL_CLIENT=16 TRACE_TIMESTAMP_CLIENT=TRUE TRACE_UNIQUE_CLIENT=TRUE I have rebooted my machine, and ran some SQL-commands from TOAD and the web-interfaces, but nothing ends up in this directory, it is still empty. I am obviously missing something trivial? What else do I need to do? TIA, ------------------------grz01 Did you also apply these changes to the sqlnet.ora files on the machine where TOAD is installed and the machine where the web-based application runs? I expect not. David Fitzjarrell |
Hi David,
I am just running local, so host and client is same machine.
Both TOAD and webinterface
(XE using using http://127.0.0.1:8080/apex,
and EE using http://machinename:1158/em)
requires the TNSListener running,
so I guess sqlnet should still see the traffic...?
/grz01
#10
| |||
| |||
|
|
On May 12, 7:20 pm, "fitzjarr... (AT) cox (DOT) net" <orat... (AT) msn (DOT) com> wrote: On May 12, 11:20 am,grz01<gr... (AT) spray (DOT) se> wrote: Hello, Need some quick help... I have an XP-machine with Oracle 10g, both EE and XE installed as standard "starter databases" with the Installers. Now I wanted to turn on sql-net tracing/logging, so I created two directories C:\oracle\log and C:\oraclexe\log and added the lines below to %ORACLE_HOME%\NETWORK\ADMIN\sqlnet.ora on both installations. LOG_DIRECTORY_CLIENT=c:\oracle\log\ LOG_FILE_CLIENT=client_log TRACE_DIRECTORY_CLIENT=c:\oracle\log\ TRACE_FILE_CLIENT=client_trace TRACE_FILELEN_CLIENT=10000 TRACE_FILENO_CLIENT=5 TRACE_LEVEL_CLIENT=16 TRACE_TIMESTAMP_CLIENT=TRUE TRACE_UNIQUE_CLIENT=TRUE I have rebooted my machine, and ran some SQL-commands from TOAD and the web-interfaces, but nothing ends up in this directory, it is still empty. I am obviously missing something trivial? What else do I need to do? TIA, ------------------------grz01 Did you also apply these changes to the sqlnet.ora files on the machine where TOAD is installed and the machine where the web-based application runs? *I expect not. David Fitzjarrell Hi David, I am just running local, so host and client is same machine. Both TOAD and webinterface (XE using usinghttp://127.0.0.1:8080/apex, and EE usinghttp://machinename:1158/em) requires the TNSListener running, so I guess sqlnet should still see the traffic...? /grz01- Hide quoted text - - Show quoted text - |
where the TOAD executables reside. Same for the web app.
David Fitzjarrell
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.