This discussion is archived
1 2 Previous Next 16 Replies Latest reply: Oct 1, 2011 2:29 AM by sybrand_b RSS

Network/Log writing process killed .(critical)

891843 Newbie
Currently Being Moderated
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.

$ORACLE_HOME/PROD/10.2.0/NETWORK/log
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.


Ms. Saira
  • 1. Re: Network/Log writing process killed .(critical)
    839439 Pro
    Currently Being Moderated
    user2506283 wrote:
    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.

    $ORACLE_HOME/PROD/10.2.0/NETWORK/log
    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.


    Ms. Saira
    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.

    Set on sqlnet.ora
    SQLNET.INBOUND_CONNECT_TIMEOUT=60

    Set on listener.ora for each listener
    INBOUND_CONNECT_TIMEOUT_[LISTENER_NAME]=60


    --neeraj                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           
  • 2. Re: Network/Log writing process killed --TNS:lost contact (critical)
    891843 Newbie
    Currently Being Moderated
    Tahnk you so much for the prompt reply.

    But could you tell me that I killed a process. Is that creating problem? How can i activeate that process?

    Thx.
  • 3. Re: Network/Log writing process killed --TNS:lost contact (critical)
    839439 Pro
    Currently Being Moderated
    user2506283 wrote:
    Tahnk you so much for the prompt reply.

    But could you tell me that I killed a process. Is that creating problem? How can i activeate that process?

    Thx.
    If possible ,you can bounce the machine to activate the processes.

    Good luck

    --neeraj                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       
  • 4. Re: Network/Log writing process killed --TNS:lost contact (critical)
    sybrand_b Guru
    Currently Being Moderated
    Sigh!


    ---------
    Sybrand Bakker
    Senior Oracle DBA
  • 5. Re: Network/Log writing process killed --TNS:lost contact (critical)
    DBA_1 Explorer
    Currently Being Moderated
    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"

    Thanks
    Rahul Gupta
  • 6. Re: Network/Log writing process killed --TNS:lost contact (critical)
    891843 Newbie
    Currently Being Moderated
    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
    linux-BIMSTR:/etc #


    Could you please comment.


    Thx.
  • 7. Re: Network/Log writing process killed --TNS:lost contact (critical)
    sybrand_b Guru
    Currently Being Moderated
    Please do not post nonsense

    lsnrctl reload $ORACLE_SID

    ??

    Really?

    --------
    Sybrand Bakker
    Senior Oracle DBA
  • 8. Re: Network/Log writing process killed --TNS:lost contact (critical)
    sybrand_b Guru
    Currently Being Moderated
    You have two listeners running.



    ----------
    Sybrand Bakker
    Senior Oracle DBA
  • 9. Re: Network/Log writing process killed --TNS:lost contact (critical)
    891843 Newbie
    Currently Being Moderated
    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

    ORCL10G =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = linux-BIMSTR)( PORT = 1530 ))
    )

    SID_LIST_TDE =
    (SID_LIST =
    (SID_DESC =
    (GLOBAL_DBNAME = ORCL10G)
    (ORACLE_HOME = /opt/oracle/product/10.2.0)
    (SID_NAME = ORCL10G)
    )
    )
    -------------------------------------------------------------------------------------

    LSNRCTL> status

    Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)( PORT=1521 ))
    STATUS of the LISTENER
    Alias 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
    SNMP OFF

    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...
    (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=linux-BIMSTR)(PORT=1521)))
    _____________________________________________________________________

    What you say?
  • 10. Re: Network/Log writing process killed --TNS:lost contact (critical)
    EBSDBA Expert
    Currently Being Moderated
    Hi,
    If you have recent backup of oracle home, Then i would suggest you to restore just the listener.ora and tnsnames.ora as you have deleted them

    Thanks
  • 11. Re: Network/Log writing process killed --TNS:lost contact (critical)
    891843 Newbie
    Currently Being Moderated
    Hi,

    You didn't understand the email chain. I did't delete *.ORA files.
  • 12. Re: Network/Log writing process killed --TNS:lost contact (critical)
    EBSDBA Expert
    Currently Being Moderated
    Hi,

    Ok, You deleted the .log files.

    did you try to bounce the listener and database.

    Thanks
  • 13. Re: Network/Log writing process killed --TNS:lost contact (critical)
    sybrand_b Guru
    Currently Being Moderated
    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

    sid_list_<listener_name>

    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.

    --------
    Sybrand Bakker
    Senior Oracle DBA
  • 14. Re: Network/Log writing process killed --TNS:lost contact (critical)
    891843 Newbie
    Currently Being Moderated
    Yes but only listener.
    Could you see my previous posts. i have two active listener with same name?
1 2 Previous Next

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points