I've installed a PHP driven application in a client's 9i server (Oracle9i Release 188.8.131.52.0 - 64bit Production). Certain queries are having an awful performance (it can use from 15 minutes to hours ...
I installed oracle 9i before 20 days, it was working fine till now but now when i try to login from scott user with correct password it is giving oracle initialization or shut down in progress error ...
Getting this error when executing SQL Server query only when connected via remote Desktop. When running the query from desktop, no problem. Is this a tsnNames issue? Linked server to Oracle 9i ...