Host Credentials ERROR Invalid username and or password Oracle 11g

I have tried the following syntax for Username:
<domain name>\Administrator
<domain name.local>\Administrator
<domain name>/Administrator
<Local host name>\<domain name>\Administrator

Did you tried "/" or "/ as sysdba" ?

Did you tried "/" or "/ as sysdba" ?

I'm confused.

you mention sysdba, thats an Oracle 'user', I thought Host Credentials meant the OS admin user OR do you mean log in to EM as sysdba?

Regartd

naexpert.

Hi,

I tried the following with no succes

EM
Logged on as: sys
Connect as: sysdba

Validation Error
Role Error - Export and Import are not supported on 10g databases for users logged in with the SYSDBA role. Logout and login using a different role before trying again.

It is not possible to EXPORT data on Oracle 11g.
Clasic Oracle export is depricated on 11g and only clasical IMPORT is supported (sofar).
Also iSQL*Plus is depricated and doesn't exist.

Instead CLASICAL OLD GOOD export/Import use DATA PUMP export!!!!

Create directory (making the needed changes!!!!!):

connect sys/passw@some_instance as sysdba

create directory pump as 'c:\oraclehome\product\10.2.0\db_1\m\pump';

 Now physically create the directory '/u01/app/oracle/product/10.2.0/m/o10f/data_pump'
using MidNight Commander or whatever you use.

Create a PARAMETER FILE (expsch.par e.g.):

USERID='sys/manager@o10f as sysdba'
DIRECTORY=PUMP
DUMPFILE=010f_pump.dmp
LOGFILE=expsch.log
SCHEMAS=icwuser,lscontacts,lscontainer,lsdocuments,lsidmap,lsmedical,lssystem,lsuser
CONTENT=all

Now invoke the DATA PUMP EXPORT (Shema Level, FULL DATABASE is also possible!!!!)

% expdp parfile=expsch.par

Good Luck!

Joseph Schwertner
PunchedCard Dinosaur and Monster

What i meant was to access through the following:
username: Administrator
password: ******

Try this and tell me what you get.

Hi Joesph,
One thing I didn't mention is that I'm pretty new to Oracle 11g, just trying to set up a test system to see if our data software can connect etc.

I think some knowledge of Oracle and its working are required on my part but I just don't have the time. The error I mention is not just for Export, it's anytime I have to enter 'Host Credentials' Maybe I have misslead people by desribing specific task as Export Data, sorry for that.

Fact remains, Host Credentials remains a mistery as to why when I use them, I have the above described error message.......

Regards

naexpert.

Hi Fekrat

As mentioned in my explanation I tried all these possible combinations for Username and all failed.

Administrator
<domain name>\Administrator
<domain name.local>\Administrator
<domain name>/Administrator
<Local host name>\<domain name>\Administrator

Thanks for your reply.

Go to Control Panel --> Administrative Tools --> Local Security Policy --> Local Policies --> User Rights Assignment --> Log on as a Batch Job --> Click on Add User or Group --> Add all User that you want to use for the Host Credentials.

If possible post a list of all users that are added to the "log on as a batch job"

Hi Fekrat,

Have already done that on the server, still get this error.

Hi Fekrat,

List of users in 'Log on a a batch job'

Administrator
<domain name>\Administrator
SUPPORT_388945a0

I didn't understand you were exporting thru EM.
I don't know if it's possible to log with OS admin to EM - try it...

Why not trying export as system ?

Hi Fekrat,

You are a genius, it worked!

I added the ora_dba group to the 'log on as a batch job' and I can now get past the Host Credentials screen. The funny part is it does not work with Administrator but it does now work with another windows user I set up which i named 'OraAdmin' which has administrative rights to the server and is a member of the ora_dba group.

Thanks for everyones input on this, very much appreciated.

Regards

naexpert (Not An Expert)

I have added both Administrator and ora_group in the logon as batch, and the Administrator account works.