Re: Straightforward install, but problems!

William F. O'Neill wrote:
> I downloaded Oracle 10g from the Oracle site, and installed same on
my
> laptop ( uses WINXP). Responded with all the Default prompts, and
the
> installation terminated successfully. Same with the Client download.

> However, from day one, I've had problems:
> 1) When accessing OEM from the web, after I log in with SYS/password,
the
> next screen shows a Metrics Collection Error. When I attempt to
'START' the
> DB, I get a ERROR 500 Internal Service Error, and cannot proceed any
> further.

Have not tried accessing OEM from the web so can't help you there. By reading some of the OEM related posts here... I am going to wait a bit on that :>)

> 2) If I attempt to access OEM from client GUI interface, when I
click on my
> database, I get this innocuous mesage: "The Procedure entry point
kpuhhalo
> could not be located in the dynamic link library oci.dll"
> I've spent several hours going thru the Installation documentation,
which I
> also downloaded. Nothing there to even give me a clue what the
solution is
> to either of my problems. Have also spent more hours thna I care to
mention
> on Google and various Oracle sites looking around, and can find
nothing that
> can help me. Some Oracle folks here suggested that I move the Home
> directory to be first in the path. That didn't help. I then looked
to
> ensure that I had oci.dll on my computer, and I do. I also put a
copy of
> this dll in the \winnt\systems32 subdir.
> What bothers me is that the installations went smoothly, and I picked
the
> Default options on everything. Why am I experiencing these problems?
 Am
> completely frustrated, and am about to trash Oracle 10g. Really
can't
> afford to be wasting my time. I'm not a DBA, nor do I have any
desire to
> become one. Am a Senior Powerbuilder Developer, and wanted to
install
> Oracle 10g just to get some familiarity with it.

I use OEM Stand Alone Console on an XP pro. I ran into the same oci.dll error when launching 10g OEM because I have 3 Oracle homes (8i, 9i, 10g) and by choice, I have 9i as default and have it's bin directory listed first in the path. Make sure that you have ORACLE_HOME\bin (e.g. C:\Oracle\Ora10g\bin) directory listed first in the system path not just ORACLE_HOME.

My workaround in my env was to add this line to the beginning of 10g oemapp.bat file in the bin directory,
set PATH=c:\oracle\ora101\bin;%PATH%

Regards
/Rauf Received on Thu Mar 03 2005 - 12:26:53 CST