Re: Simple Question about Host Credetials

From: Hans Forbrich <forbrich_at_yahoo.net>
Date: Wed, 01 Sep 2004 23:00:35 GMT
Message-ID: <nwsZc.85252$X12.38037@edtnps84>

Andrew GIlbert wrote:

> Hi
>
> I know this is a really simple quesition but i have just setup Oracle 10
> for the first time and need to import some data into a database from a
> dump file.
>
> I have gone into the 10i Enterprise Manager and into import from file, it
> asks for Host Credentials, what are these as i have tried both Sys and the
> password and also the administrator username and password for the server
> and this does not work as it say invalid password.
>
> The server is windows 2000.
>
> Thanks
>
> Andy

Stuff like export, import, sql loader - they all run in the equivalent to a DOS box. In order to do so, they need to be able to 'log in' as a Windows user.

In the simplest case, Host credentials is the userid and password for the WINDOWS user that created/owns Oracle. In a real (production) environment, it relates to a user that can run 'batch jobs' in Windows, can execute %ORACLE_HOME%/bin executables, and has access to the database.

HTH
/Hans Received on Wed Sep 01 2004 - 18:00:35 CDT