Getting OpenDBFile2 error is Unable to communicate with database driver process (99).

 1 Replies
 0 Subscribed to this topic
 27 Subscribed to this forum
Sort:
Author
Messages
simmons2112
New Member
Posts: 1
New Member
    Our hardware dept. was messing with DNS settings and now the environment won't start.  I get

    OpenDBFile2 error is Unable to communicate with database driver process (99).
      Additional information is 1167.

    I know it's a database communication issue but when I got to start the listener I get:  lsnrctl:  File cannot be found

    In $ORACLE_HOME/bin, lsnrctl is not present like it is on our other app server.

    Am I looking in the wrong place?

    Lawson is taking forever to get back to me.

    Thanks in advance.
    Tomwise
    Advanced Member
    Posts: 32
    Advanced Member
      the command to start the default listerner is:

      lsnrctl start

      The files it looks at are in $ORACLE_HOME/network/admin

      There should be a listerner.ora and tnsnames.ora file located in that directory (unless you're not using a tnsnames.ora file and using a names server).

      If the files are there and your listener starts (could already be running) type

      tnsping service_name and see what it returns.

      e.g.

      LAW9PROD>tnsping law9prod.world

      TNS Ping Utility for IBM/AIX RISC System/6000: Version 10.2.0.1.0 - Production o
      n 19-OCT-2011 14:46:29

      Copyright (c) 1997, 2005, Oracle. All rights reserved.

      Used parameter files:
      /oracle/app/oracle/product/10.2.0/network/admin/sqlnet.ora


      Used TNSNAMES adapter to resolve the alias
      Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)
      (HOST = 10.0.64.118)(PORT = 1526))) (CONNECT_DATA = (SID = law9)))
      OK (20 msec)
      LAW9PROD>

      It should return your database connection and ip address.