Home » RDBMS Server » Networking and Gateways » when is LOG_DIRECTORY_SERVER and LOG_DIRECTORY_CLIENT set (Oracle Database 10g Enterprise Edition 10.2.0.4.0, Microsoft Windows IA (32-bit))
when is LOG_DIRECTORY_SERVER and LOG_DIRECTORY_CLIENT set [message #479877] Tue, 19 October 2010 22:15 Go to next message
kytemanaic
Messages: 55
Registered: February 2009
Member
I was trying to learn and verify some documentation issues

the client and server is on laptop.

from http://download.oracle.com/docs/cd/B19306_01/network.102/b14212/troublestng.htm#sthref1633

this is how we set

LOG_DIRECTORY_CLIENT
LOG_DIRECTORY_SERVER

from http://download.oracle.com/docs/cd/B19306_01/network.102/b14212/connect.htm#sthref1517

this is how we test

Quote:


Testing Configuration on the Database Server



whether the loop back test pass or fail I still could not see both the log_directory_client and log_directory_server set, i.e files are either not modified or is not in the directory.

for log_directory_server, it is even worst I don't even see a single file

from http://download.oracle.com/docs/cd/B19306_01/network.102/b14212/connect.htm#sthref1530, this is how we test the connection from the client.
conn TOMKYTE@'(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = KYTEHOST)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = KYTE) ) )'

this is my sql.ora settings
SQLNET.AUTHENTICATION_SERVICES= (NTS)

NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)

LOG_FILE_CLIENT = log_client

LOG_DIRECTORY_CLIENT = C:\ora102\NETWORK\log_client

LOG_DIRECTORY_SERVER = C:\ora102\NETWORK\log_server




May I know how do we verify the above settings?


thanks

[Updated on: Wed, 20 October 2010 01:01] by Moderator

Report message to a moderator

Re: when is LOG_DIRECTORY_SERVER and LOG_DIRECTORY_CLIENT set [message #481111 is a reply to message #479877] Sat, 30 October 2010 23:37 Go to previous message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
kytemanaic wrote on Tue, 19 October 2010 23:15

this is my sql.ora settings

You do mean sqlnet.ora right?

Do the directories C:\ora102\NETWORK\log_client and C:\ora102\NETWORK\log_server actually exist? For Windoze, believe it or not, case is important for naming this path in the file.

Did you reload and/or restart the listener after you made your changes?
Previous Topic: Network Interfaces
Next Topic: using single tnsnames.ora file for two different database with different user at different locations
Goto Forum:
  


Current Time: Sun May 22 12:33:03 CDT 2022