1 2 Previous Next 16 Replies Latest reply: Oct 1, 2011 4:29 AM by sybrand_b RSS

    Network/Log writing process killed .(critical)

    891843
      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
          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
            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
              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
                Sigh!


                ---------
                Sybrand Bakker
                Senior Oracle DBA
                • 5. Re: Network/Log writing process killed --TNS:lost contact (critical)
                  DBA_1
                  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
                    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
                      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
                        You have two listeners running.



                        ----------
                        Sybrand Bakker
                        Senior Oracle DBA
                        • 9. Re: Network/Log writing process killed --TNS:lost contact (critical)
                          891843
                          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
                            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
                              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
                                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
                                  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
                                    Yes but only listener.
                                    Could you see my previous posts. i have two active listener with same name?
                                    1 2 Previous Next