1 Reply Latest reply: Nov 24, 2012 3:29 PM by Daniel Redfern RSS

    OIM DB error

    961125
      From the past few days my database is not getting connected through OIM and sqldeveloper, so I checked the enterprise manager of the database and found the following results::


      Database Instance: OIMDB

      Enterprise Manager is not able to connect to the database instance. The state of the components are listed below


      Database Instance

      DOWN ARROW
           
      Host          
      localhost
      Port          
      1521
      SID          
      OIMDB
      Oracle Home          
      d:\app\Karan\product\11.2.0\dbhome_1

           
      Listener

      UP ARROW

           
      Status          
      Up
      Host          
      localhost
      Port          
      1521
      Name          
      LISTENER
      Oracle Home          
      d:\app\Karan\product\11.2.0\dbhome_1
      Location          
      d:\app\Karan\product\11.2.0\dbhome_1\network\admin
      Details          

           
      Agent Connection to Instance

      DOWN ARROW

      Status          
      Failed
      Details          ORA-28547: connection to server failed, probable Oracle Net admin error (DBD ERROR: OCISessionBegin)


      and status of listener are in the following thread,
      database not getting connected from sql developer(Vendor code 20)

      database is working fine only in sqlplus

      Kindly suggest..

      Regards,
      KK

      Edited by: 958122 on Nov 25, 2012 1:35 AM