Home / server / Questions / 511497
Accepted
lilott8
Asked: 2013-05-29 12:22:31 +0800 CST

Oracle SQLConnect: 1033 via UnixODBC

  • 772

Here is the full error:

PHP Fatal error:  Uncaught exception 'PDOException' with message 'SQLSTATE[08004] SQLConnect: 1033 [unixODBC][Oracle][ODBC][Ora]ORA-01033: ORACLE initialization or shutdown in progress\nProcess ID: 0\nSession ID: 0 Serial number: 0\n'

I am using unixODBC to connect to an oracle 11g database. The database is up and functioning as proof by:

select open_mode from v$database;

returns

open_mode
-----------------
read write

The web application of the service is completely functional as well.

and finally, I can run:

isql -v [odbc store] [user] [password]

and query the database just fine that way.

So I am truly at a loss as to why I cannot connect through the ODBC to get what I need. Everything I've read has stated that I should follow a procedure similar to this: link to solve similar problems

Thanks for any input. I'm really at my wits end here.

php

1 Answers

  1. Best Answer

    My suggestion is that, instead of using unixODBC, you check out a native instantclient for 11g (download it from Oracle website) and PHP Oracle Call Interfaces. I've been using these for a long time and so far I've never had any problems with it.

    Here is a guide on how to setup PHP OCI: http://www.php.net/manual/en/oci8.installation.php

    Oracle Instantclient: http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html

    • 0