Host Credentials of Your Oracle: Hmmm…

June 29th, 2007 by it gossips | Filed under Uncategorized.

When my Oracle Server was down yesterday, I’ve found the same problem when trying Oracle for the first time. What’s the problem? It’s host credentials. When opening Enterprise Manager, one of the database is unavailable and needed to be opened. But, when trying to startup it, I must enter the username and password that have the “log on as batch job” access. Someone who has “log on as batch job” access can startup the database. Wait a minute, here’s the step by step to add a account who has special access.Enter your Control Panel by clicking Start buttonChoose Administrative ToolsAnd then Local Security PolicyThere’re some options (), open Local PoliciesClick User Rights AssignmentFind this policy: Log on as Batch JobRight click it, PropertiesAdd User or Group. Add the username who will “log on as batch job” accessMake sure username you’ve entered is shown in the list. OK.Actually, what’s host credentials? It’s username and password for Windows user who creates and owns Oracle Database. In the reality, it connects with user who could run “batch job”, executes %ORACLE_HOME%/bin and has an access to the database.Okey, getting headache when troubleshooting Oracle? Just enjoy it!Special thanks for Kohar “the Master”Read more at: Knowledge to Share (http://studiawan.blogspot.com/2007/06/host-credentials-of-your-oracle-hmmm.html)