Skip to main content
ExLibris
  • Subscribe by RSS
  • Ex Libris Knowledge Center

    OCI fails to connect to Oracle

     

    • Product: Aleph
    • Product Version: 20, 21, 22, 23
    • Relevant for Installation Type: Dedicated-Direct, Direct, Local, Total Care

     

    Description 
    Local PHP scripts that use OCI to access Aleph's Oracle database fail with "No connection to Oracle" message. Aleph itself seems fine. 

    Aleph and Oracle were shut down and restarted (-- during shutdown, Oracle seemed to think its listener was not running or wasn't responding), but that didn't help. 

     

    Resolution 
    Campus IT had restarted Apache (not Aleph Apache) using sudo scanner, a user account used for security scanning. Evidently that user doesn't have the correct Oracle environment settings to pass on to Apache, causing the php oci8 database connect error. After restarting Apache (not Aleph Apache), our scripts could connect just fine.

     

     


    • Article last edited: 02-Mar-2016
    • Was this article helpful?