Tips for Oracle 10g DBA-I

Tips for Oracle 10g DBA-I
--------------------------------
1. If the oracle enterprise manager does not start
solution: services -> start all oracle services listed there
2. To unlock any user account
solution: users->select user(e.g. HR)->edit user->change the password->check unlocked->apply
3. To start sqlplus i
solution: start->oracle 10g-home->application dev->sqlplus->user(hr),passd(hr),host string(orcl)
4. Always use semi-colon(;) for terminting an sql statement
5. For oracle 10g Express installation for Windows machine, use this link:
http://www.oracle.com/technology/software/products/database/xe/htdocs/102xewinsoft.html
6. For oracle 10g Enterprise installation for Windows machine, use this link:
http://www.oracle.com/technology/software/products/database/oracle10g/htdocs/10201winsoft.html

Hit Counter