This content has been marked as final. Show 16 replies
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.
Set on sqlnet.ora
Set on listener.ora for each listener
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.
Pls. Check .
1. ps -ef | grep lsnr --> this will show listener is running
2. If not running ..start is using "lsntct start $ORACLE_SID"
3. If running..Just reaload it..."lsnrctl reload $ORACLE_SID"
Hi Rahul Gupta,
Below are lines. after you suggestion.
1). linux-BIMSTR:/etc # ps -ef | grep lsn
oracle 4803 1 0 2009 ? 00:02:07 /opt/oracle/product/10.2.0/bin/tnslsnr LISTENER -inherit
oracle 27532 1 0 Sep30 ? 00:00:00 /opt/oracle/product/10.2.0/bin/tnslsnr LISTENER -inherit
root 8212 6171 0 09:03 pts/0 00:00:00 grep lsn
Could you please comment.
Hi Sybrand Bakker,
Same name of two Listener, Is it possible with Oracle?
But there is one file of listener.ora and contain one entry. (But still, You may be right because PORT in listener.ora file is different when i issue LSNRCTL Status.)
# listener.ora Network Configuration File: /opt/oracle/product/10.2.0/network/admin/listener.ora
(ADDRESS = (PROTOCOL = TCP)(HOST = linux-BIMSTR)( PORT = 1530 ))
(GLOBAL_DBNAME = ORCL10G)
(ORACLE_HOME = /opt/oracle/product/10.2.0)
(SID_NAME = ORCL10G)
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)( PORT=1521 ))
STATUS of the LISTENER
Version TNSLSNR for Linux: Version 10.2.0.1.0 - Production
Start Date 30-SEP-2011 14:33:59
Uptime 0 days 7 hr. 46 min. 57 sec
Trace Level off
Security ON: Local OS Authentication
Listener Parameter File /opt/oracle/product/10.2.0/network/admin/listener.ora
Listener Log File /opt/oracle/product/10.2.0/network/log/listener.log
Listening Endpoints Summary...
What you say?
What I say is
1 from 10g onwards, Oracle automatically starts a listener called LISTENER running on port 1521. If you configure a listener on port 1521 this will supersede the Oracle one.
If you use a different port, you will have two listeners. You can not have a second listener called LISTENER on port 1521.
2 the listener.ora you posted seems to be incorrect.
The first block is the definition of the listener.
The second -redundant- block defines the instances managed by this listener
the alias should read
so in your case the second block doesn't match the first.
I would replace both ORCL10G and TDE by LISTENER, and reload the listener.
Senior Oracle DBA