Wednesday, January 30, 2008

Installing IIS on Windows XP Professional for Oracle 10g DBA-1

Installing IIS on Windows XP Professional for Oracle 10g DBA-1 purpose

If you are running Windows XP Professional on your computer you can install Microsoft's web server, Internet Information Server 5.1 (IIS) in the following way:

1. Open 'Add/Remove Windows Components' found in 'Add/Remove Programs' in the 'Control Panel'.

2. Place a tick in the check box for 'Internet Information Services (IIS)' leaving all the default installation settings as it is.

3. Once IIS is installed on your machine you can view your home page in a web browser by typing 'http://localhost' (you can substitute 'localhost' for the name of your computer) into the address bar of your web browser.

4. If you are not sure of the name of your computer right-click on the 'My Computer' icon on your desktop, select 'Properties' from the shortcut menu, and click on the 'Computer Name' tab.

5. The 'Internet Information Services' console can be found in the 'Administration Tools' in the 'Control Panel' under 'Performance and Maintenance', if you do not have the control panel in Classic View.

7. Double-click on the 'Internet Information Services' icon.

8. Once the 'Internet Information Services' console is open you will see any IIS web services you have running on your machine including the SMTP server and FTP server, if you chose to install them with IIS.

9. To add a new virtual directory right click on 'Default Web Site' and select 'New', followed by 'Virtual Directory', from the drop down list.



Hit Counter

Tuesday, January 29, 2008

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

Add to Technorati Favorites