July 6, 2008 06:13pm pdt

1. sonicefu 27,850
2. sdstuber 24,325
3. schwertner 11,480
4. jinesh_k... 3,025
5. PlatoCon... 2,400
6. Sqaimes 2,200
7. Dr_Billy 2,000
7. Delphineous 2,000
7. jwinney 2,000
7. sandeep_... 2,000
7. peter991 2,000
7. ravenpl 2,000
7. Fekrat 2,000
7. byalcin 2,000
15. angelIII 1,600

1. sonicefu 27,850
2. sdstuber 24,325
3. schwertner 11,480
4. jinesh_k... 3,025
5. PlatoCon... 2,400
6. Sqaimes 2,200
7. ravenpl 2,000
7. jwinney 2,000
7. peter991 2,000
7. Dr_Billy 2,000
7. Delphineous 2,000
7. Fekrat 2,000
7. sandeep_... 2,000
7. byalcin 2,000
7. asvforce 2,000

02.28.2008 at 02:08AM PST, ID: 23199813

	[x] Attachment Details

[x]

The Solution Rating System

With so many solutions, how can you tell which solutions are most likely to help you and which ones are not? To provide you with a tool to use, we rate our solutions based on various elements that most accurately determine if a solution is a quality solution. To explain what factors affect the solution rating, here are the elements we take into consideration when formulating our solution rating.

The Grade of the Solution
The Zone Rank of the Expert Providing the Solution
The Number of Author and Expert Comments
The Number of Experts Contributing
The Feedback of the Community

Your Input Matters
Because of the way the system is set up, the most important variable in this equation is you. As a member of Experts Exchange, you are able to cast your vote on the quality of the solutions in regard to how complete, accurate, helpful and easy to understand each solution is. When you provide your feedback, each rating is adjusted accordingly. So, if you see a solution that has a poor rating that you think is a good solution, let us know by rating it. As you do, the rating will be adjusted and will become more accurate for other members of our site.

If you have any suggestions that you would like to make for our rating system, please ask a question in the Suggestions Zone of Community Support.

Thank you!

7.0

Host Credentials ERROR Invalid username and or password Oracle 11g

Zones: Oracle 11.x Database, Oracle Database

Tags: Oracle, Enterprise Manager, 11g, Host Credentials, ERROR: Invalid username and/or password

Hi,

This error has been bugging me for sometime now and I can't find a straight forward answer anywhere, can you help?

Oracle 11g on Windows XP SP2 Intel box.

I am trying to export data and when I'm asked for the Host Credentials I get the error
" ERROR Invalid username and or password "

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

I have gone through making sure that the local security policy settings are correct.
I have added domain and local Administrator to the ora_dba Group.
All services relating to Oracle are running.
I can connect via SQL Plus with no issues.
I can connect to EM locally and from my client pc with no issues.

I have also
Created new Windows user called OraAdmin.
OraAdmin is now member of administrators group and Ora_dba group.
Logged onto EM at server and used System user logon.
Data Movement
Export to Export Files
Tables
Host Credentials

Tried
OraAdmin - failed
oracle-11g\OraAdmin - failed
oracle-11g/OraAdmin - failed

Any ideas, please, can anyone help me?

I'll gladly furnish you with any info I can to get past this seemingly simple step!

Regards

naexpert.

Start your free trial to view this solution

Question Stats

Zone: Database

Question Asked By: naexpert

Solution Provided By: Fekrat

Participating Experts: 3

Solution Grade: A

Translate:

Loading Advertisement...

Microsoft

Internet Protocols
Applications

Development
OS

Hardware
Windows Security

Apple

Operating Systems
Hardware

Programming
Networking

Software

Internet

Search Engines
File Sharing
WebTrends / Stats
Spy / Ad Blockers

Web Browsers
New Net Users
Web Development
Chat / IM

Anti Spam
Web Servers
Anti-Virus
Email Clients

Gamers

Tips
Online / MMORPG
Puzzle
Emulators

Action / Adventure
Role Playing
Consoles
Game Programming

Strategy
Sports
Misc
Computer Games

Digital Living

Hardware
New Net Users
New Users

Software
Digital Music
Gaming World

Home Security
Apple
Networking Hardware

Virus & Spyware

Vulnerabilities
IDS
Encryption
Anti-Virus

Operating Systems Security
Software Firewalls
WebApplications
Cell Phones

Operating Systems
Internet
Hardware Firewalls

Hardware

Handhelds / PDAs
Displays / Monitors
Components
Networking Hardware

Peripherals
Laptops/Notebooks
Storage
Servers

Desktops
New Users
Misc
Apple

Software

System Utilities
Industry Specific
Network Management
Photos / Graphics
Page Layout
VMWare
Misc
Web Development

OS
CYGWIN
Voice Recognition
Message Queue
Quality Assurance
Security
Firewalls
MultiMedia Applications

Development
Database
Office / Productivity
Business Management
OS/2 Apps
Server Software
Internet / Email

ITPro

OS
Storage
Encryption
Operating Systems Security
Apple Hardware
Laptops & Notebooks
Servers
Networking Hardware
Peripherals

Devices
Displays / Monitors
WebTrends / Stats
Search Engines
Firewalls
WebApplications
IDS
Vulnerabilities
Email Clients

File Sharing
Spy / Ad Blockers
Web Browsers
Web Servers
Networking
Anti-Virus
Chat / IM
Anti Spam

Developer

Web Servers
Web Browsers
Game Programming
Dev Tools
Industry Specific
Office / Productivity

Database
CYGWIN
Web Development
Search Engines
File Sharing
WebTrends / Stats

Programming
Content Management
Application Servers
Protocols

Storage

Removable Backup Media
Storage Technology
Servers

Grid
Remote Access
Backup / Restore

Misc
Hard Drives

Miscellaneous
Security
Development
Linux
VMWare

MainFrame OS
Unix
Apple
OS / 2
AS / 400

BeOS
Microsoft
VMS / OpenVMS

Database

Oracle
Miscellaneous
MySQL
Software
Sybase
Contact Management
PostgreSQL
Data Manipulation
Clarion
InterSystems Cache

Siebel
MUMPS
OLAP
SQLBase
SAS
GIS & GPS
4GL
Berkeley DB
DB2
Informix

Interbase / Firebird
FoxPro
Reporting
LDAP
Filemaker Pro
MS SQL Server
dBase
MS Access

Security

Misc
Web Browsers
Software Firewalls
Operating Systems Security
File Sharing

Spy / Ad Blockers
Vulnerabilities
WebApplications
IDS
Anti-Virus

Encryption
Anti Spam
Email Clients
VPN
Chat / IM

Programming

Editors IDEs
Installation
Handhelds / PDAs
Multimedia Programming
System / Kernel

Algorithms
Game
Signal Processing
Project Management
Open Source

Database
Misc
Languages
Processor Platforms
Theory

Web Development

Scripting
Blogs
Web Servers
Software
Search Engines
Web Graphics
Images

Internet Marketing
Images and Photos
Components
Document Imaging
Web Languages/Standards
Illustration
WebApplications

Fonts
WebTrends / Stats
Authoring
Digital Camera Software
Miscellaneous

Networking

Protocols
Apple Networking
Network Management
Message Queue
Application Servers
Content Management
File Servers
Email Servers
Misc
Java Editors & IDEs

Wireless
Networking Hardware
Backup / Restore
System Utilities
ISPs & Hosting
Web Servers
Storage Technology
Removable Backup Media
Servers
Broadband

Grid
OS / 2
Novell Netware
Unix Networking
Windows Networking
Security
Telecommunications
Operating Systems
Linux Networking

Other

Community Advisor
Lounge
Community Support
New Net Users

Philosophy / Religion
Math / Science
Miscellaneous
URLs

Expert Lounge
Politics
Puzzles / Riddles

Community Support

Suggestions
New to EE
New Topics
Community Advisor

CleanUp
Announcements
General

Feedback
Input
EE Bugs

02.28.2008 at 02:26AM PST, ID: 21002466

Fekrat:

Try using the computer administrator account will that work??

02.28.2008 at 02:28AM PST, ID: 21002471

naexpert:

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

02.28.2008 at 02:33AM PST, ID: 21002499

Docteur_Z:

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

02.28.2008 at 02:34AM PST, ID: 21002501

Docteur_Z:

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

02.28.2008 at 02:36AM PST, ID: 21002509

naexpert:

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.

02.28.2008 at 02:44AM PST, ID: 21002540

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.

02.28.2008 at 02:48AM PST, ID: 21002557

Rank: Genius

schwertner:

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

02.28.2008 at 02:50AM PST, ID: 21002561

Fekrat:

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

Try this and tell me what you get.

02.28.2008 at 02:54AM PST, ID: 21002575

naexpert:

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.

02.28.2008 at 02:56AM PST, ID: 21002584

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.

02.28.2008 at 03:00AM PST, ID: 21002600

Fekrat:

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.

02.28.2008 at 03:00AM PST, ID: 21002601

Fekrat:

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

02.28.2008 at 03:03AM PST, ID: 21002607

naexpert:

Hi Fekrat,

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

02.28.2008 at 03:05AM PST, ID: 21002612

naexpert:

Hi Fekrat,

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

Administrator
<domain name>\Administrator
SUPPORT_388945a0

02.28.2008 at 03:08AM PST, ID: 21002624

Fekrat:

Try adding the Ora_dbagroup to the list and see what will happen.

Accepted Solution

02.28.2008 at 03:16AM PST, ID: 21002659

Docteur_Z:

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 ?

02.28.2008 at 03:26AM PST, ID: 21002697

naexpert:

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)

20080236-EE-VQP-29 / EE_QW_2_20070628