user2506283 wrote:Use the SQLNET.INBOUND_CONNECT_TIMEOUT parameter to specify the time, in seconds, for a client to connect with the database server and provide the necessary authentication information.
Hi Guys & Gurus,
I would REALLY be very thankful, if someone can help out me from the below mentioned 02 problem.
Our PROD Oracle server is 10g (10.2.0) running on Linux.
There are three files.
1). Listener.log_______________ size: 50 MB
2). Sqlnet.log________________ size: 23 MB
3). Orcl10g.log_______________ size: 945 MB
I deleted these files on Linux system. I found, file [ORCL10g.log] doesn't exist. But space didn't release to Linux system.
So, I killed that process who was locking this file. (ls -ld /proc/*/fd/* 2>&1 | fgrep '(deleted)')
Now, Linux got free space.
Priority-High: Problem 01).
After passing few time, i found Oracle created only 01 file (Listener.log) But didn't create other two files.
I wish Oracle should create these two files as well. I tried a lot but couldn't succeed.
Could you lease mention the steps/guide me to start writing these log files?
Priority-Critical: Problem 02).
Now, I connect HR/HR@orcl10g. I get error ORA-12547: TNS:lost contact. Our all application are not connecting.
Please guide me its PROD system.
Thanks in advanced.
But could you tell me that I killed a process. Is that creating problem? How can i activeate that process?It depend which process you killed. If it's was a lisnner peocess that yes there is issue.