Thursday, 6 March 2014

Installing Oracle Database 10g on Windows


Installing Oracle Database 10g on Windows

In this tutorial, you learn how to install Oracle Database 10g on Windows.
This tutorial covers the following topics:
Overview
Installing Oracle Database 10g on Windows
Post Installation Tasks
Testing Your Installation
Summary
Using the Oracle Universal Installer, you install the Oracle Database 10g software and create a database.
To install the Oracle software, you must use the Oracle Universal installer.

1.
For this installation you need either the DVDs or a downloaded version of the DVDs. In this tutorial, you install from the downloaded version. From the directory where the DVD files were unzipped, double-click setup.exe.

2.
The Oracle Universal Installer starts.

3.
You will perform a basic installation with a starter database. Enter orcl for the Global Database Name and oracle for the Database Password and Confirm Password. Then click Next.

4.
The installer now verifies that the system meets all the minimum requirements for installing and configuring the chosen product. Please correct any reported errors (warnings are OK) before continuing. When the check successfully completes (with or without warnings), click Next.

5.
If you received any warnings, you can proceed. Click Yes.

6.
Review the Summary window to verify what is to be installed. Then, click Install.

7.
The progress window appears.

8.
The Configuration Assistants window appears.

9.
Your database is now being created.

10.
When the database has been created, you can unlock the users you want to use. Click Password Management.

11.
Unlock SH, OE and HR users by clicking on the check mark in the Lock Account? column. Enter the same name as the user in the New Password and Confirm Password fields. For example, to unlock SH user, enter SH in the New Password and Confirm Password fields. Then, click OK.

12.
Click OK again.

13.
Click Exit.

14.
Click Yes to confirm exit.

For additional functionality within DB Control, functionality such as starting and stopping the database, an operating system user must belong to the ORA_DBA group. An existing user can be used or a new user can be created. This topic shows you how to create the operating system user oracle and make the user part of the ORA_DBA group:
Note: The following steps outlined were done in a Windows XP environment. The steps will be slightly different in a Windows NT or 2000 environment.
1.
 Click Start > Settings > Control Panel. Select Administrative Tools.

2.
Select Computer Management.

3.
Select Local Users and Groups.

4.
In the right hand panel, right click Users. Select New User ...

5.
In the New User window enter:
User name: oracle
Description: Oracle Administration User
Password: <a secure password>
Confirm: <a secure password>
For this example the password oracle is used.
Deselect User must change password at next logon
Click Create.

6.
Another New User window appears. Click Close to close the window.

7.
Double-click Groups.

8.
Double click ora_dba.

9.
In the ora_dba Properties screen, click Add.

10.
In the Select Users screen, click Advanced.

11.
Click Find Now.

12.
Shift-select BATCH and the oracle user from the list at the bottom of the window. Then click OK.

13.
Click OK.

14.
Click OK.

15.
Close the Computer Management window.

16.
You also need to add the oracle to the Security Policy Log on as a batch job. Double-click on Local Security Policy.

17.
Double-click on Log on as a batch job.
18.
Click Add User or Group ...
19.
Click Advanced...
20.
Click Find Now.
21.
Select oracle from the list and click OK.
22.
Click OK.
23.
Click OK again.
24.
Close the Local Security Policy window.
25.
Close the Administrative Tools window.
To test that your installation completed successfully, perform the following:
1.
When you click exit from the previous section, a browser opens and the Database Control URL is already launched. If this does not happen, open a browser and enter the following URL:
http://<hostname>:1158/em
Enter system as the User Name and oracle as the Password and click Login.
2.
The Licensing window appears. Scroll to the bottom and click I agree.
3.
The Database Control Home Page appears. Your Installation was successful.
In this tutorial, you learned how to install and test the Oracle Database 10g installation on windows.



Thursday, 6 February 2014

Outlook Anywhere Configuration for Outlook 2010

Outlook Anywhere Configuration for Outlook 2010

Using Outlook Anywhere (known as RPC over HTTP in previous versions of Outlook) allows Outlook 2010 to access the Exchange Server over the Internet. This procedure configures Outlook 2010 for use from any location. No VPN connection is necessary. It is suitable for use with a laptop or other off-campus computer when Outlook Web Access is not sufficient.
  1. Go to Control Panel and then click the Mail icon.
  2. Click Add. 

  3. Give the profile a name and then OK.
  4. Select Manually configure server settings or additional server types on the bottom and click Next

  5. Select Microsoft Exchange or compatible server and click Next.
  6. Enter the following information.

    • Server: Enter your Exchange Server name:  mail.em.ucla.edu   *NOTE: if on Exchange 2007 you will need to enter your exchange server em11.ad.ucla.edu, em12.ad.ucla.edu... (depending where your mailbox is located, if you dont know which mail server you are on, type EM11.AD.UCLA.EDU and it will resolve to the correct one).
    • Select Use Cached Exchange Mode (Stores a local copy of your mailbox on your computer which causes your Outlook to load quicker).
    • User Name: Your EM login or Display Name

  7. Click on More Settings.
  8. Click on the Connection tab.
  9. Under Outlook Anywhere, check the box for Connect to Mircrosoft Exchange using HTTP and click on Exchange Proxy Settings...
  10. Enter the following information and click OK.

    • Under Connection Settings:
      • Enter mail.em.ucla.edu in the field for https://.  *Note: If one Exchange 2007, you would use em.ucla.edu
      • check the box for On fast networks, connect using HTTP first, then connect using TCP/IP
      • check the box for On slow networks, connect using HTTP first, then connect using TCP/IP
    • Under Proxy authentication settings: select Basic Authentication.


  11. Click Next on the following screen.
  12. After clicking Next in Step 11, you will be asked for the first time your username and password. Enter your EM logon credentials and click OK.

    • User Name: Enter ad\EM Login
    • Password: Enter your EM password

  13. Click Finish on the next screen.

  14. Click OK to close the Mail icon properties.


Was this answer helpful?