Should not be ORACLE installation problem, because PLSQL is normal can connect to the database, do not know if the registry or other parts of the problem, please directly! @ ~
CodePudding user response:
Produce the cause of the error and the solution is as follows:1. Background: previously installed oracle9i after using pb9 connection data no problem, but the follow-up and install other oracle database or developing software (such as Form6i or report). As a result, pb9 connect to the database errors.
2. Analysis: if the From or Report, PLSQL are useful, not only PB even in, installed the Oracle products, there is no problem, the problem occurred in PB read operation system has a problem, the Path environment variable Path value PB will be set by the registry Oracle any Client of the Path to the Oracle Client base Path Path, so when you install multiple Oracle products may use multiple Home, they would disrupt the PB to select the correct Client based Path, the Path
3. Solution: check the system Path Path.
My computer - & gt; Property - & gt; Advanced - & gt; The environment variable - & gt; System variables - & gt; The path
The path value: D: \ oracle \ FR \ bin; D: \ oracle \ ora92 \ bin; .
Found that D: \ oracle \ fr \ bin is actually the Form and Report Home path and it was ranked the first, will lead to PB will be subject to the path to find the oracle client so PB will, of course, can't find the mistakes so
Change the Path value to D: \ oracle \ ora92 \ bin; D: \ oracle \ FR \ bin; .
PB test connection database success!
CodePudding user response:
PATCH no problem above, baidu and Google basic search again, I have finished watching the answer about the question, is not a complete and accurate answers,I looked at the effects of essentially, tomorrow to determine the specific reason,
CodePudding user response:
Before is oracle8i, after completely uninstall and reinstall the oracle, oracle is not using the default installation now, the PB error is locating the oracle installation path,CodePudding user response:
I also appear the error solution, how to solve this problem??