OraFAQ Forum: Networking and Gateways » when is LOG_DIRECTORY_SERVER and LOG_DIRECTORY

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

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

when is LOG_DIRECTORY_SERVER and LOG_DIRECTORY_CLIENT set [message #479877]

Tue, 19 October 2010 22:15

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

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?

Report message to a moderator

Previous Topic:	Network Interfaces
Next Topic:	using single tnsnames.ora file for two different database with different user at different locations

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Nov 23 20:17:04 CST 2024